Table: dbo.erd_nodes (ERD Nodes)

Schema dbo
Name erd_nodes
Title ERD Nodes
Module ERDs

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
PK Name Data type Null Attributes Description
1 node_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 table_id int Reference to table/view that is represented on diagram. Ref: tables table.
Reference to table/view that is represented on diagram. Ref: tables table.
4 pos_x int X position on diagram. 0 is the center of a diagram. Can be negative.
X position on diagram. 0 is the center of a diagram. Can be negative.
5 pos_y int Y position on diagram. 0 is the center of a diagram. Can be negative.
Y position on diagram. 0 is the center of a diagram. Can be negative.
6 color char(7) Box color. Eg. #4CAF50
Box color. Eg. #4CAF50
7 width int Box width.
Box width.
8 height int Box height. Currently not used.
Box height. Currently not used.
9 creation_date datetime Default: getdate() Standard row creation timestamp.
Standard row creation timestamp.
Default: getdate()
10 created_by nvarchar(100) Default: NULL Database/Dataedo username that created row.
Database/Dataedo username that created row.
Default: NULL
11 last_modification_date datetime Default: getdate() Standard row last update timestamp.
Standard row last update timestamp.
Default: getdate()
12 modified_by nvarchar(100) Default: NULL Database/Dataedo username that last updated row.
Database/Dataedo username that last updated row.
Default: NULL
Relations
Foreign table Primary table Join Title / Name / Description
dbo.erd_nodes dbo.modules dbo.erd_nodes.module_id = dbo.modules.module_id FK_erd_nodes_modules
dbo.erd_nodes.module_id = dbo.modules.module_id
FK_erd_nodes_modules
dbo.erd_nodes dbo.tables dbo.erd_nodes.table_id = dbo.tables.table_id FK_erd_nodes_tables
dbo.erd_nodes.table_id = dbo.tables.table_id
FK_erd_nodes_tables
dbo.erd_nodes_columns dbo.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
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
Uses
Name
dbo.erd_nodes (ERD Nodes)
Used by
Name
dbo.erd_nodes (ERD Nodes)
Exported: 2017-05-15 08:09, Last imported: 2017-04-06 15:30