Table: dbo.tables_relations_columns (Tables relations' columns)

Schema dbo
Name tables_relations_columns
Title Tables relations' columns
Module Schema and Metadata

Stores foreign keys columns. Each row represents one column pair: column_fk_id and column_pk_id.

Columns
PK Name Data type Null Attributes Description
1 table_relation_column_id int Identity / Auto increment column Row ID.
Row ID.
Identity / Auto increment column
2 table_relation_id int Link to table relation row.
Link to table relation row.
3 column_fk_id int Foreign table column ID.
Foreign table column ID.
4 column_pk_id int Primary table column ID.
Primary table column ID.
5 ordinal_position int Column position in relation.
Column position in relation.
6 status char(1) Default: 'A' 'D' if relation column was deleted from DBMS, 'A' otherwise
'D' if relation column was deleted from DBMS, 'A' otherwise
Default: 'A'
7 creation_date datetime Default: getdate() Standard row creation timestamp.
Standard row creation timestamp.
Default: getdate()
8 created_by nvarchar(100) Default: NULL Database/Dataedo username that created row.
Database/Dataedo username that created row.
Default: NULL
9 last_modification_date datetime Default: getdate() Standard row last update timestamp.
Standard row last update timestamp.
Default: getdate()
10 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.tables_relations_columns dbo.columns dbo.tables_relations_columns.column_fk_id = dbo.columns.column_id FK_tables_relations_columns_column_fk
dbo.tables_relations_columns.column_fk_id = dbo.columns.column_id
FK_tables_relations_columns_column_fk
dbo.tables_relations_columns dbo.columns dbo.tables_relations_columns.column_pk_id = dbo.columns.column_id FK_tables_relations_columns_column_pk
dbo.tables_relations_columns.column_pk_id = dbo.columns.column_id
FK_tables_relations_columns_column_pk
dbo.tables_relations_columns dbo.tables_relations dbo.tables_relations_columns.table_relation_id = dbo.tables_relations.table_relation_id FK_tables_relations_columns_relation
dbo.tables_relations_columns.table_relation_id = dbo.tables_relations.table_relation_id
FK_tables_relations_columns_relation
Unique keys
Key name Columns Description
PK_tables_relations_columns table_relation_column_id Table primary key.
Table primary key.
Triggers
Key name When Description
trg_tables_relations_cols_Modify After Insert, Update Standard insert/update trigger setting last_modification_date, modified by columns
Standard insert/update trigger setting last_modification_date, modified by columns
Uses
Name
dbo.tables_relations_columns (Tables relations' columns)
Exported: 2017-05-15 08:09, Last imported: 2017-04-06 15:30