Table: dbo.erd_nodes_columns (ERD Nodes Columns)

Schema dbo
Name erd_nodes_columns
Title ERD Nodes Columns
Module ERDs

Holds information about visible table/view columns on an ERD - if a column is in this table then it is visible on a diagram.

ERD is identified by module_id column. Column_id references columns table.

Columns
PK Name Data type Null Attributes Description
1 node_column_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 node_id int Ref: erd_nodes table.
Ref: erd_nodes table.
4 column_id int Ref: columns table.
Ref: columns table.
Relations
Foreign table Primary table Join Title / Name / Description
dbo.erd_nodes_columns dbo.columns dbo.erd_nodes_columns.column_id = dbo.columns.column_id FK_erd_nodes_columns_columns
dbo.erd_nodes_columns.column_id = dbo.columns.column_id
FK_erd_nodes_columns_columns
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
dbo.erd_nodes_columns dbo.modules dbo.erd_nodes_columns.module_id = dbo.modules.module_id FK_erd_nodes_columns_modules
dbo.erd_nodes_columns.module_id = dbo.modules.module_id
FK_erd_nodes_columns_modules
Unique keys
Key name Columns Description
PK_erd_nodes_columns node_column_id
Uses
Name
dbo.erd_nodes_columns (ERD Nodes Columns)
Exported: 2017-05-15 08:09, Last imported: 2017-04-06 15:30