Table: dbo.erd_links (ERD Links)

Schema dbo
Name erd_links
Title ERD Links
Module ERDs

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
PK Name Data type Null Attributes Description
1 link_id int Identity / Auto increment column Row ID
Row ID
Identity / Auto increment column
2 module_id int Identifier of ERD. Ref: modules table.
Identifier of ERD. Ref: modules table.
3 relation_id int Reference to relation that is represented on diagram. Ref: tables_relations table.
Reference to relation that is represented on diagram. Ref: tables_relations table.
4 label_pos_x int
5 label_pos_y int
6 show_label bit Default: 0 If 1 then relationship label is displayed in ERD. Default value is 0.
If 1 then relationship label is displayed in ERD. Default value is 0.
Default: 0
7 creation_date datetime Default: getdate() Standard row creation timestamp
Standard row creation timestamp
Default: getdate()
8 created_by nvarchar(100) Default: NULL Database/Dataedo username that created row.
Database/Dataedo username that created row.
Default: NULL
9 last_modification_date datetime Default: getdate() Standard row last update timestamp.
Standard row last update timestamp.
Default: getdate()
10 modified_by nvarchar(100) Default: NULL Database/Dataedo username that last updated row.
Database/Dataedo username that last updated row.
Default: NULL
11 hidden bit Default: 0 If 1 then relationship is hidden in ERD. Default value is 0.
If 1 then relationship is hidden in ERD. Default value is 0.
Default: 0
12 link_style nvarchar(25) Default: 'STRAIGHT' 'STRAIGHT' for a straight link style and 'ORTHOGONAL' for orthogonal one. The former is default.
'STRAIGHT' for a straight link style and 'ORTHOGONAL' for orthogonal one. The former is default.
Default: 'STRAIGHT'
13 show_join_condition bit Default: 0
Default: 0
Relations
Foreign table Primary table Join Title / Name / Description
dbo.erd_links dbo.modules dbo.erd_links.module_id = dbo.modules.module_id FK_erd_links_modules
dbo.erd_links.module_id = dbo.modules.module_id
FK_erd_links_modules
dbo.erd_links dbo.tables_relations 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
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
Uses
Name
dbo.erd_links (ERD Links)
Exported: 2017-05-15 08:09, Last imported: 2017-04-06 15:30