dbo.unique_constraints_columns_changes
Documentation | Dataedo repository 7 |
Schema | dbo |
Name | unique_constraints_columns_changes |
Module | Schema Change Tracking |
Type | Change Tracking |
Status | Active |
Schema changes detected in table primary/unique keys columns 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 | unique_constraint_column_id | int | dbo.unique_constraints_columns (Unique keys' columns) | Uptaded primary/unique key-column id | Metadata | Active | ||||
Uptaded primary/unique key-column id References: dbo.unique_constraints_columns (Unique keys' columns) Type: Metadata Status: Active |
||||||||||
4 | unique_constraint_id | int | dbo.unique_constraints (Unique keys) | Uptaded primary/unique key id | Metadata | Active | ||||
Uptaded primary/unique key id References: dbo.unique_constraints (Unique keys) Type: Metadata Status: Active |
||||||||||
5 | column_id | int | dbo.columns (Columns) | Uptaded primary/unique key column id - after update | Metadata | Active | ||||
Uptaded primary/unique key column id - after update References: dbo.columns (Columns) Type: Metadata Status: Active |
||||||||||
6 | column_name | nvarchar(250) | Uptaded primary/unique key column name - after update | Schema | Active | |||||
Uptaded primary/unique key column name - after update Type: Schema Status: Active |
||||||||||
7 | ordinal_position | int | Uptaded primary/unique key column ordinal position - after update | Schema | Active | |||||
Uptaded primary/unique key column ordinal position - after update Type: Schema Status: Active |
||||||||||
8 | before_column_id | int | dbo.columns (Columns) | Uptaded primary/unique key column id - before update | Metadata | Active | ||||
Uptaded primary/unique key column id - before update References: dbo.columns (Columns) Type: Metadata Status: Active |
||||||||||
9 | before_column_name | nvarchar(250) | Uptaded primary/unique key column name - before update | Schema | Active | |||||
Uptaded primary/unique key column name - before update Type: Schema Status: Active |
||||||||||
10 | before_ordinal_position | int | Uptaded primary/unique key column ordinal position - before update | Schema | Active | |||||
Uptaded primary/unique key column ordinal position - before update Type: Schema Status: Active |
||||||||||
11 | 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 |
||||||||||
12 | valid_from | datetime | Timestamp when this change was detected | Metadata | Active | |||||
Timestamp when this change was detected Type: Metadata Status: Active |
||||||||||
13 | 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 |
||||||||||
14 | creation_date | datetime | Default: getdate() | Standard row creation timestamp | Metadata | Active | ||||
Standard row creation timestamp Default: getdate() Type: Metadata Status: Active |
||||||||||
15 | 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 |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
dbo.unique_constraints_columns_changes | dbo.columns (Columns) | dbo.unique_constraints_columns_changes.column_id = dbo.columns.column_id | fk_unique_constraints_columns_changes_columns | |
dbo.unique_constraints_columns_changes.column_id = dbo.columns.column_id Name: fk_unique_constraints_columns_changes_columns |
||||
dbo.unique_constraints_columns_changes | dbo.columns (Columns) | dbo.unique_constraints_columns_changes.before_column_id = dbo.columns.column_id | fk_unique_constraints_columns_changes_columns | |
dbo.unique_constraints_columns_changes.before_column_id = dbo.columns.column_id Name: fk_unique_constraints_columns_changes_columns |
||||
dbo.unique_constraints_columns_changes | dbo.schema_updates (Imports/Updates) | dbo.unique_constraints_columns_changes.update_id = dbo.schema_updates.update_id | fk_unique_constraints_columns_changes_schema_updates | |
dbo.unique_constraints_columns_changes.update_id = dbo.schema_updates.update_id Name: fk_unique_constraints_columns_changes_schema_updates |
||||
dbo.unique_constraints_columns_changes | dbo.unique_constraints (Unique keys) | dbo.unique_constraints_columns_changes.unique_constraint_id = dbo.unique_constraints.unique_constraint_id | fk_unique_constraints_columns_changes_unique_constraints | |
dbo.unique_constraints_columns_changes.unique_constraint_id = dbo.unique_constraints.unique_constraint_id Name: fk_unique_constraints_columns_changes_unique_constraints |
||||
dbo.unique_constraints_columns_changes | dbo.unique_constraints_columns (Unique keys' columns) | dbo.unique_constraints_columns_changes.unique_constraint_column_id = dbo.unique_constraints_columns.unique_constraint_column_id | fk_unique_constraints_columns_changes_unique_constraints_columns | |
dbo.unique_constraints_columns_changes.unique_constraint_column_id = dbo.unique_constraints_columns.unique_constraint_column_id Name: fk_unique_constraints_columns_changes_unique_constraints_columns |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_unique_constraints_columns_changes | id |
Uses
Name |
---|
dbo.unique_constraints_columns_changes
|
Used by
Name |
---|
dbo.unique_constraints_columns_changes
|
Exported: 2018-12-06 15:15, Last imported: 2018-11-21 15:11