Table: dbo.tables (Tables and Views)

Schema dbo
Name tables
Title Tables and Views
Module Schema and Metadata

Database tables and views.

 

Tables and views are distinguished by object_type column with 'TABLE' and 'VIEW' values.

Columns
PK Name Data type Null Attributes Description
1 table_id int Identity / Auto increment column Row ID.
Row ID.
Identity / Auto increment column
2 database_id int Documentation which object is part of. Ref: databases.
Documentation which object is part of. Ref: databases.
3 schema nvarchar(250) DBMS schema name.
DBMS schema name.
4 name nvarchar(250) Object DBMS name.
Object DBMS name.
5 title nvarchar(250) Alternative object title defined with Dataedo.
Alternative object title defined with Dataedo.
6 description nvarchar(MAX) Table/view description defined with Dataedo.
Table/view description defined with Dataedo.
7 object_type nvarchar(100) Database object type. 'TABLE' for tables, 'VIEW' for views.
Database object type. 'TABLE' for tables, 'VIEW' for views.
8 definition nvarchar(MAX) View script imported from DBMS. Empty for tables.
View script imported from DBMS. Empty for tables.
9 status char(1) Default: 'A' 'D' if table/view was deleted from DBMS, 'A' otherwise
'D' if table/view was deleted from DBMS, 'A' otherwise
Default: 'A'
10 dbms_creation_date datetime Time table/view was created in DBMS.
Time table/view was created in DBMS.
11 dbms_last_modification_date datetime Time table/view was last updated in DBMS.
Time table/view was last updated in DBMS.
12 synchronization_date datetime Time of last object update/import from DBMS.
Time of last object update/import from DBMS.
13 synchronized_by nvarchar(100) Login of user that last updated/imported the object from DBMS.
Login of user that last updated/imported the object from DBMS.
14 creation_date datetime Default: getdate() Standard row creation timestamp.
Standard row creation timestamp.
Default: getdate()
15 created_by nvarchar(100) Default: NULL Database/Dataedo username that created row.
Database/Dataedo username that created row.
Default: NULL
16 last_modification_date datetime Default: getdate() Standard row last update timestamp.
Standard row last update timestamp.
Default: getdate()
17 modified_by nvarchar(100) Default: NULL Database/Dataedo username that last updated row.
Database/Dataedo username that last updated row.
Default: NULL
18 exists_in_DBMS bit A flag which denotes if an object exists in DBMS. Used during update.
A flag which denotes if an object exists in DBMS. Used during update.
19 description_search nvarchar(MAX) Column used for searching, holds description as plain text. Description column contains HTML tags and images that would interfere with searching.
Column used for searching, holds description as plain text. Description column contains HTML tags and images that would interfere with searching.
Relations
Foreign table Primary table Join Title / Name / Description
dbo.tables dbo.databases dbo.tables.database_id = dbo.databases.database_id FK_tables_database
dbo.tables.database_id = dbo.databases.database_id
FK_tables_database
dbo.tables dbo.tables dbo.tables.table_id = dbo.tables.table_id FK_tables_tables
dbo.tables.table_id = dbo.tables.table_id
FK_tables_tables
dbo.tables dbo.tables dbo.tables.table_id = dbo.tables.table_id FK_tables_tables
dbo.tables.table_id = dbo.tables.table_id
FK_tables_tables
dbo.columns dbo.tables dbo.columns.table_id = dbo.tables.table_id FK_column_table
dbo.columns.table_id = dbo.tables.table_id
FK_column_table
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.tables_modules dbo.tables dbo.tables_modules.table_id = dbo.tables.table_id FK_tables_modules_tables
dbo.tables_modules.table_id = dbo.tables.table_id
FK_tables_modules_tables
dbo.tables_relations dbo.tables dbo.tables_relations.fk_table_id = dbo.tables.table_id Foreign table
FK_tables_relations_table_fk
dbo.tables_relations.fk_table_id = dbo.tables.table_id
Foreign table
FK_tables_relations_table_fk
dbo.tables_relations dbo.tables dbo.tables_relations.pk_table_id = dbo.tables.table_id Primary table
FK_tables_relations_table_pk
dbo.tables_relations.pk_table_id = dbo.tables.table_id
Primary table
FK_tables_relations_table_pk
dbo.triggers dbo.tables dbo.triggers.table_id = dbo.tables.table_id FK_triggers_table
dbo.triggers.table_id = dbo.tables.table_id
FK_triggers_table
dbo.unique_constraints dbo.tables dbo.unique_constraints.table_id = dbo.tables.table_id FK_unique_constraints_tables
dbo.unique_constraints.table_id = dbo.tables.table_id
FK_unique_constraints_tables
Unique keys
Key name Columns Description
PK_tables table_id Table primary key.
Table primary key.
Triggers
Key name When Description
trg_tables_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 (Tables and Views)
dbo.tables (Tables and Views)
Used by
Name
dbo.tables (Tables and Views)
dbo.tables (Tables and Views)
Exported: 2017-05-15 08:09, Last imported: 2017-04-06 15:30