dbo.tables_relations_changes
Documentation | Dataedo repository 7 |
Schema | dbo |
Name | tables_relations_changes |
Module | Schema Change Tracking |
Type | Change Tracking |
Status | Active |
Schema changes detected in table relationships detected at import time.
Columns
Key | Name | Data type | Null | Attributes | References | Description | Type | Status | ||
---|---|---|---|---|---|---|---|---|---|---|
1 | id | int | Identity | Row id | Metadata | Active | ||||
Row id Identity Type: Metadata Status: Active |
||||||||||
2 | update_id | int | dbo.schema_updates (Imports/Updates) | Id of the schema import/update from source database | Metadata | Active | ||||
Id of the schema import/update from source database References: dbo.schema_updates (Imports/Updates) Type: Metadata Status: Active |
||||||||||
3 | table_relation_id | int | dbo.tables_relations (Table relationships) | Uptaded relationship id | Metadata | Active | ||||
Uptaded relationship id References: dbo.tables_relations (Table relationships) Type: Metadata Status: Active |
||||||||||
4 | database_id | int | dbo.databases (Documentations) | Uptaded relationship documentation id | Metadata | Active | ||||
Uptaded relationship documentation id References: dbo.databases (Documentations) Type: Metadata Status: Active |
||||||||||
5 | pk_table_id | int | dbo.tables (Tables and Views) | Uptaded relationship primary key table id | Metadata | Active | ||||
Uptaded relationship primary key table id References: dbo.tables (Tables and Views) Type: Metadata Status: Active |
||||||||||
6 | fk_table_id | int | dbo.tables (Tables and Views) | Uptaded relationship foreign key table id | Metadata | Active | ||||
Uptaded relationship foreign key table id References: dbo.tables (Tables and Views) Type: Metadata Status: Active |
||||||||||
7 | pk_table_schema | nvarchar(250) | Uptaded relationship primary key table schema - after update | Schema | Active | |||||
Uptaded relationship primary key table schema - after update Type: Schema Status: Active |
||||||||||
8 | fk_table_schema | nvarchar(250) | Uptaded relationship foreign key table schema - after update | Schema | Active | |||||
Uptaded relationship foreign key table schema - after update Type: Schema Status: Active |
||||||||||
9 | pk_table_name | nvarchar(250) | Uptaded relationship primary key table name - after update | Schema | Active | |||||
Uptaded relationship primary key table name - after update Type: Schema Status: Active |
||||||||||
10 | fk_table_name | nvarchar(250) | Uptaded relationship foreign key table name - after update | Schema | Active | |||||
Uptaded relationship foreign key table name - after update Type: Schema Status: Active |
||||||||||
11 | name | nvarchar(250) | Uptaded relationship name - after update | Schema | Active | |||||
Uptaded relationship name - after update Type: Schema Status: Active |
||||||||||
12 | update_rule | nvarchar(100) | Uptaded relationship/foreign key update rule defined in DBMS - after update | Schema | Active | |||||
Uptaded relationship/foreign key update rule defined in DBMS - after update Type: Schema Status: Active |
||||||||||
13 | delete_rule | nvarchar(100) | Uptaded relationship/foreign key delete rule defined in DBMS - after update | Schema | Active | |||||
Uptaded relationship/foreign key delete rule defined in DBMS - after update Type: Schema Status: Active |
||||||||||
14 | disabled | bit | Is updated relationship disabled in DBMS (1 - yes) - after update | Schema | Active | |||||
Is updated relationship disabled in DBMS (1 - yes) - after update Type: Schema Status: Active |
||||||||||
15 | fk_type | nvarchar(15) | Uptaded relationship foreign key table cardinality - after update | Schema | Active | |||||
Uptaded relationship foreign key table cardinality - after update Type: Schema Status: Active |
||||||||||
16 | pk_type | nvarchar(15) | Uptaded relationship primary key table cardinality - after update | Schema | Active | |||||
Uptaded relationship primary key table cardinality - after update Type: Schema Status: Active |
||||||||||
17 | before_pk_table_schema | nvarchar(250) | Uptaded relationship primary key table schema - before update | Schema | Active | |||||
Uptaded relationship primary key table schema - before update Type: Schema Status: Active |
||||||||||
18 | before_fk_table_schema | nvarchar(250) | Uptaded relationship foreign key table schema - before update | Schema | Active | |||||
Uptaded relationship foreign key table schema - before update Type: Schema Status: Active |
||||||||||
19 | before_pk_table_name | nvarchar(250) | Uptaded relationship primary key table name - before update | Schema | Active | |||||
Uptaded relationship primary key table name - before update Type: Schema Status: Active |
||||||||||
20 | before_fk_table_name | nvarchar(250) | Uptaded relationship foreign key table name - before update | Schema | Active | |||||
Uptaded relationship foreign key table name - before update Type: Schema Status: Active |
||||||||||
21 | before_name | nvarchar(250) | Uptaded relationship name - before update | Schema | Active | |||||
Uptaded relationship name - before update Type: Schema Status: Active |
||||||||||
22 | before_update_rule | nvarchar(100) | Uptaded relationship/foreign key update rule defined in DBMS - before update | Schema | Active | |||||
Uptaded relationship/foreign key update rule defined in DBMS - before update Type: Schema Status: Active |
||||||||||
23 | before_delete_rule | nvarchar(100) | Uptaded relationship/foreign key delete rule defined in DBMS - before update | Schema | Active | |||||
Uptaded relationship/foreign key delete rule defined in DBMS - before update Type: Schema Status: Active |
||||||||||
24 | before_disabled | bit | Is updated relationship disabled in DBMS (1 - yes) - before update | Schema | Active | |||||
Is updated relationship disabled in DBMS (1 - yes) - before update Type: Schema Status: Active |
||||||||||
25 | before_fk_type | nvarchar(15) | Uptaded relationship foreign key table cardinality - before update | Schema | Active | |||||
Uptaded relationship foreign key table cardinality - before update Type: Schema Status: Active |
||||||||||
26 | before_pk_type | nvarchar(15) | Uptaded relationship primary key table cardinality - before update | Schema | Active | |||||
Uptaded relationship primary key table cardinality - before update Type: Schema Status: Active |
||||||||||
27 | operation | nvarchar(50) | Update type: ADDED - object was added, UPDATED - object was updated, DELETED - object was deleted | Metadata | Active | |||||
Update type: ADDED - object was added, UPDATED - object was updated, DELETED - object was deleted Type: Metadata Status: Active |
||||||||||
28 | valid_from | datetime | Timestamp when this change was detected | Metadata | Active | |||||
Timestamp when this change was detected Type: Metadata Status: Active |
||||||||||
29 | valid_to | datetime | Timestamp when this change ends it's period of validity and new change of this object was detected | Metadata | Active | |||||
Timestamp when this change ends it's period of validity and new change of this object was detected Type: Metadata Status: Active |
||||||||||
30 | creation_date | datetime | Default: getdate() | Standard row creation timestamp | Metadata | Active | ||||
Standard row creation timestamp Default: getdate() Type: Metadata Status: Active |
||||||||||
31 | created_by | nvarchar(1024) | Default: suser_sname() | Dataedo username that created row | Metadata | Active | ||||
Dataedo username that created row Default: suser_sname() Type: Metadata Status: Active |
||||||||||
32 | description | nvarchar(MAX) | Change user comments | Documentation | Active | |||||
Change user comments Type: Documentation Status: Active |
||||||||||
33 | description_date | datetime | Date and time comment field was entered/last updated | Metadata | Active | |||||
Date and time comment field was entered/last updated Type: Metadata Status: Active |
||||||||||
34 | description_by | nvarchar(1024) | Username that entered/last updated comment field | Metadata | Active | |||||
Username that entered/last updated comment field Type: Metadata Status: Active |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
dbo.tables_relations_changes | dbo.databases (Documentations) | dbo.tables_relations_changes.database_id = dbo.databases.database_id | fk_tables_relations_changes_databases | |
dbo.tables_relations_changes.database_id = dbo.databases.database_id Name: fk_tables_relations_changes_databases |
||||
dbo.tables_relations_changes | dbo.schema_updates (Imports/Updates) | dbo.tables_relations_changes.update_id = dbo.schema_updates.update_id | fk_tables_relations_changes_schema_updates | |
dbo.tables_relations_changes.update_id = dbo.schema_updates.update_id Name: fk_tables_relations_changes_schema_updates |
||||
dbo.tables_relations_changes | dbo.tables (Tables and Views) | dbo.tables_relations_changes.pk_table_id = dbo.tables.table_id | fk_tables_relations_changes_tables | |
dbo.tables_relations_changes.pk_table_id = dbo.tables.table_id Name: fk_tables_relations_changes_tables |
||||
dbo.tables_relations_changes | dbo.tables (Tables and Views) | dbo.tables_relations_changes.fk_table_id = dbo.tables.table_id | fk_tables_relations_changes_tables | |
dbo.tables_relations_changes.fk_table_id = dbo.tables.table_id Name: fk_tables_relations_changes_tables |
||||
dbo.tables_relations_changes | dbo.tables_relations (Table relationships) | dbo.tables_relations_changes.table_relation_id = dbo.tables_relations.table_relation_id | fk_tables_relations_changes_tables_relations | |
dbo.tables_relations_changes.table_relation_id = dbo.tables_relations.table_relation_id Name: fk_tables_relations_changes_tables_relations |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_tables_relations_changes | id |
Uses
Used by
Name |
---|
dbo.tables_relations_changes
|
Exported: 2018-12-06 15:15, Last imported: 2018-11-21 15:11