dbo.erd_links (ERD Links) - Dataedo repository 7

Dataedo repository 7

- Dataedo repository 7
  - Modules
  - Tables

Documentation	Dataedo repository 7
Schema	dbo
Name	erd_links
Title	ERD Links
Module	ERDs
Type	Metadata
Status	Active

Represents relationships between entities in a specific ERD. Every ERD relationship references a relation defined beteween tables/views in a Dataedo repository.

This relation is either an imported foreign key defined in source database or a user-defined one in Dataedo repository through ERD or Relations tab.

Each relationship is linked to table/view relations in tables_relations table with relation_id column. ERD is identified by module_id column.

Holds information about link style, link visibility and label visibility.

Columns

		Name	Data type	Attributes	References	Description	Type	Status
	1	link_id	int	Identity		Row id	Metadata	Active
Row id Identity Type: Metadata Status: Active
	2	module_id	int		dbo.modules (Modules)	Identifier of module/diagram	Metadata	Active
Identifier of module/diagram References: dbo.modules (Modules) Type: Metadata Status: Active
	3	relation_id	int		dbo.tables_relations (Table relationships)	Reference to relation that is represented on diagram	Metadata	Active
Reference to relation that is represented on diagram References: dbo.tables_relations (Table relationships) Type: Metadata Status: Active
	4	show_label	bit	Default: 0		If 1 then relationship title is displayed on ERD. Default value is 0	Metadata	Active
If 1 then relationship title is displayed on ERD. Default value is 0 Default: 0 Type: Metadata Status: Active
	5	show_join_condition	bit	Default: 0		If 1 then shows relationship join condition on ERD. Default value is 0	Metadata	Active
If 1 then shows relationship join condition on ERD. Default value is 0 Default: 0 Type: Metadata Status: Active
	6	link_style	nvarchar(25)	Default: 'STRAIGHT'		'STRAIGHT' for a straight link style and 'ORTHOGONAL' for orthogonal one. The former is default.	Metadata	Active
'STRAIGHT' for a straight link style and 'ORTHOGONAL' for orthogonal one. The former is default. Default: 'STRAIGHT' Type: Metadata Status: Active
	7	hidden	bit	Default: 0		If 1 then relationship is hidden from ERD. Default value is 0	Metadata	Active
If 1 then relationship is hidden from ERD. Default value is 0 Default: 0 Type: Metadata Status: Active
	8	creation_date	datetime	Default: getdate()		Standard row creation timestamp	Metadata	Active
Standard row creation timestamp Default: getdate() Type: Metadata Status: Active
	9	created_by	nvarchar(1024)	Default: suser_sname()		Dataedo username that created row	Metadata	Active
Dataedo username that created row Default: suser_sname() Type: Metadata Status: Active
	10	last_modification_date	datetime	Default: getdate()		Standard row last update timestamp	Metadata	Active
Standard row last update timestamp Default: getdate() Type: Metadata Status: Active
	11	modified_by	nvarchar(1024)	Default: suser_sname()		Dataedo username that last updated row	Metadata	Active
Dataedo username that last updated row Default: suser_sname() Type: Metadata Status: Active
	12	source_id	int			For internal use only	Internal	Active
For internal use only Type: Internal Status: Active
	13	label_pos_x	int			Not used	N/A	Cancelled
Not used Type: N/A Status: Cancelled
	14	label_pos_y	int			Not used	N/A	Cancelled
Not used Type: N/A Status: Cancelled

Relations

Foreign table	Primary table	Join	Title / Name / Description
dbo.erd_links (ERD Links)	dbo.modules (Modules)	dbo.erd_links.module_id = dbo.modules.module_id	FK_erd_links_modules
dbo.erd_links.module_id = dbo.modules.module_id Name: FK_erd_links_modules
dbo.erd_links (ERD Links)	dbo.tables_relations (Table relationships)	dbo.erd_links.relation_id = dbo.tables_relations.table_relation_id	FK_erd_links_tables_relations
dbo.erd_links.relation_id = dbo.tables_relations.table_relation_id Name: FK_erd_links_tables_relations

Unique keys

	Key name	Columns	Description
	PK_erd_links	link_id	Table primary key
Table primary key
	UK_erd_links_relation	module_id, relation_id	Each relation can be added to the diagram only once
Each relation can be added to the diagram only once

Triggers

	Key name	When
	trg_erd_links_descriptions_Modify	After Insert, Update
-- ============================================= -- Author: Łukasz Gil -- Create date: 2017-09-22 -- Description: Updates last_modification_date, modified_by erd_links on insert or update -- ============================================= CREATE TRIGGER [trg_erd_links_descriptions_Modify] ON [erd_links] AFTER INSERT,UPDATE AS BEGIN UPDATE [erd_links] SET last_modification_date = GETDATE(), modified_by = suser_sname() WHERE link_id IN (SELECT DISTINCT link_id FROM Inserted) END
-- ============================================= -- Author: Łukasz Gil -- Create date: 2017-09-22 -- Description: Updates last_modification_date, modified_by erd_links on insert or update -- ============================================= CREATE TRIGGER [trg_erd_links_descriptions_Modify] ON [erd_links] AFTER INSERT,UPDATE AS BEGIN UPDATE [erd_links] SET last_modification_date = GETDATE(), modified_by = suser_sname() WHERE link_id IN (SELECT DISTINCT link_id FROM Inserted) END

Key name

When

Description

trg_erd_links_descriptions_Modify

After Insert, Update

Uses

Name
dbo.erd_links (ERD Links)
dbo.modules (Modules)
dbo.tables_relations (Table relationships)
dbo.trg_erd_links_descriptions_Modify
dbo.erd_links (ERD Links)

Used by

Name
dbo.erd_links (ERD Links)
dbo.trg_erd_links_descriptions_Modify

Exported: 2018-12-06 15:15, Last imported: 2018-11-21 15:07