dbo.erd_links (ERD Links)
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
Key | Name | Data type | Null | 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 | Description | |
---|---|---|---|
trg_erd_links_descriptions_Modify | After Insert, Update |
Uses
Name |
---|
dbo.erd_links (ERD Links)
|
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