dbo.erd_nodes (ERD Nodes)
Documentation | Dataedo repository 7 |
Schema | dbo |
Name | erd_nodes |
Title | ERD Nodes |
Module | ERDs |
Type | Metadata |
Status | Active |
Represents entity (table or view) in a specific ERD. Each node is linked to a table/view in tables table with table_id column.
ERD is identified by module_id column.
Holds information about node position and color.
Columns
Key | Name | Data type | Null | Attributes | References | Description | Type | Status | ||
---|---|---|---|---|---|---|---|---|---|---|
1 | node_id | int | Identity | Row id | Metadata | Active | ||||
Row id Identity Type: Metadata Status: Active |
||||||||||
2 | module_id | int | dbo.modules (Modules) | Identifier of ERD. Ref: modules table | Metadata | Active | ||||
Identifier of ERD. Ref: modules table References: dbo.modules (Modules) Type: Metadata Status: Active |
||||||||||
3 | table_id | int | dbo.tables (Tables and Views) | Reference to table/view that is represented on diagram. Ref: tables table | Metadata | Active | ||||
Reference to table/view that is represented on diagram. Ref: tables table References: dbo.tables (Tables and Views) Type: Metadata Status: Active |
||||||||||
4 | pos_x | int | X position on diagram. 0 is the center of a diagram. Can be negative | N/A | Active | |||||
X position on diagram. 0 is the center of a diagram. Can be negative Type: N/A Status: Active |
||||||||||
5 | pos_y | int | Y position on diagram. 0 is the center of a diagram. Can be negative | N/A | Active | |||||
Y position on diagram. 0 is the center of a diagram. Can be negative Type: N/A Status: Active |
||||||||||
6 | color | char(7) | Box color, e.g. #4CAF50 | Documentation | Active | |||||
Box color, e.g. #4CAF50 Type: Documentation Status: Active |
||||||||||
7 | width | int | Box width | Documentation | Active | |||||
Box width Type: Documentation Status: Active |
||||||||||
8 | height | int | Box height. Currently not used | N/A | Cancelled | |||||
Box height. Currently not used Type: N/A Status: Cancelled |
||||||||||
9 | creation_date | datetime | Default: getdate() | Standard row creation timestamp | Metadata | Active | ||||
Standard row creation timestamp Default: getdate() Type: Metadata Status: Active |
||||||||||
10 | 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 |
||||||||||
11 | last_modification_date | datetime | Default: getdate() | Standard row last update timestamp | Metadata | Active | ||||
Standard row last update timestamp Default: getdate() Type: Metadata Status: Active |
||||||||||
12 | 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 |
||||||||||
13 | source_id | int | For internal use only | Internal | Active | |||||
For internal use only Type: Internal Status: Active |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
dbo.erd_nodes (ERD Nodes) | dbo.modules (Modules) | dbo.erd_nodes.module_id = dbo.modules.module_id | FK_erd_nodes_modules | |
dbo.erd_nodes.module_id = dbo.modules.module_id Name: FK_erd_nodes_modules |
||||
dbo.erd_nodes (ERD Nodes) | dbo.tables (Tables and Views) | dbo.erd_nodes.table_id = dbo.tables.table_id | FK_erd_nodes_tables | |
dbo.erd_nodes.table_id = dbo.tables.table_id Name: FK_erd_nodes_tables |
||||
dbo.erd_nodes_columns (ERD Nodes Columns) | dbo.erd_nodes (ERD Nodes) | dbo.erd_nodes_columns.node_id = dbo.erd_nodes.node_id | FK_erd_nodes_columns_erd_nodes | |
dbo.erd_nodes_columns.node_id = dbo.erd_nodes.node_id Name: FK_erd_nodes_columns_erd_nodes |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_erd_nodes | node_id | Table primary key | |
Table primary key | |||
UK_erd_nodes_table | module_id, table_id | Each table can be added to the diagram only once | |
Each table can be added to the diagram only once |
Triggers
Key name | When | Description | |
---|---|---|---|
trg_erd_nodes_descriptions_Modify | After Insert, Update |
Uses
Name |
---|
dbo.erd_nodes (ERD Nodes)
|
dbo.trg_erd_nodes_descriptions_Modify
|
dbo.erd_nodes (ERD Nodes)
|
Used by
Name |
---|
dbo.erd_nodes (ERD Nodes)
|
dbo.trg_erd_nodes_descriptions_Modify
|
Exported: 2018-12-06 15:15, Last imported: 2018-11-21 15:07