dbo.erd_nodes_columns (ERD Nodes Columns)
Documentation | Dataedo repository 7 |
Schema | dbo |
Name | erd_nodes_columns |
Title | ERD Nodes Columns |
Module | ERDs |
Type | Metadata |
Status | Active |
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
Key | Name | Data type | Null | Attributes | References | Description | Type | Status | ||
---|---|---|---|---|---|---|---|---|---|---|
1 | node_column_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 | node_id | int | dbo.erd_nodes (ERD Nodes) | Ref: erd_nodes table | Metadata | Active | ||||
Ref: erd_nodes table References: dbo.erd_nodes (ERD Nodes) Type: Metadata Status: Active |
||||||||||
4 | column_id | int | dbo.columns (Columns) | Ref: columns table | Metadata | Active | ||||
Ref: columns table References: dbo.columns (Columns) Type: Metadata Status: Active |
||||||||||
5 | 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_columns (ERD Nodes Columns) | dbo.columns (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 Name: FK_erd_nodes_columns_columns |
||||
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 |
||||
dbo.erd_nodes_columns (ERD Nodes Columns) | dbo.modules (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 Name: FK_erd_nodes_columns_modules |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_erd_nodes_columns | node_column_id | Table primary key | |
Table primary key |
Uses
Name |
---|
dbo.erd_nodes_columns (ERD Nodes Columns)
|
Exported: 2018-12-06 15:15, Last imported: 2018-11-21 15:07