dbo.tables_changes - Dataedo repository 7

Dataedo repository 7

- Dataedo repository 7
  - Modules
  - Tables

Documentation	Dataedo repository 7
Schema	dbo
Name	tables_changes
Module	Schema Change Tracking
Type	Change Tracking
Status	Active

Schema changes detected in tables/views detected at import time.

Columns

		Name	Data type	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_id	int		dbo.tables (Tables and Views)	Uptaded table/view id	Metadata	Active
Uptaded table/view id References: dbo.tables (Tables and Views) Type: Metadata Status: Active
	4	database_id	int		dbo.databases (Documentations)	Uptaded table/view documentation id	Metadata	Active
Uptaded table/view documentation id References: dbo.databases (Documentations) Type: Metadata Status: Active
	5	schema	nvarchar(250)			Uptaded table/view schema - after update	Schema	Active
Uptaded table/view schema - after update Type: Schema Status: Active
	6	name	nvarchar(250)			Uptaded table/view name - after update	Schema	Active
Uptaded table/view name - after update Type: Schema Status: Active
	7	object_type	nvarchar(100)			Uptaded table/view object type: TABLE/VIEW - after update	Schema	Active
Uptaded table/view object type: TABLE/VIEW - after update Type: Schema Status: Active
	8	subtype	nvarchar(100)			Uptaded table/view type - after update	Schema	Active
Uptaded table/view type - after update Type: Schema Status: Active
	9	definition	nvarchar(MAX)			Uptaded view definition script - after update	Schema	Active
Uptaded view definition script - after update Type: Schema Status: Active
	10	before_schema	nvarchar(250)			Uptaded table/view schema - before update	Schema	Active
Uptaded table/view schema - before update Type: Schema Status: Active
	11	before_name	nvarchar(250)			Uptaded table/view name - before update	Schema	Active
Uptaded table/view name - before update Type: Schema Status: Active
	12	before_object_type	nvarchar(100)			Uptaded table/view object type: TABLE/VIEW - before update	Schema	Active
Uptaded table/view object type: TABLE/VIEW - before update Type: Schema Status: Active
	13	before_subtype	nvarchar(100)			Uptaded table/view type - before update	Schema	Active
Uptaded table/view type - before update Type: Schema Status: Active
	14	before_definition	nvarchar(MAX)			Uptaded view definition script - before update	Schema	Active
Uptaded view definition script - before update Type: Schema Status: Active
	15	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
	16	dbms_last_modification_date	datetime			Timestamp when table/view was last updated in DBMS before import	Metadata	Active
Timestamp when table/view was last updated in DBMS before import Type: Metadata Status: Active
	17	valid_from	datetime			Timestamp when this change was detected	Metadata	Active
Timestamp when this change was detected Type: Metadata Status: Active
	18	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
	19	creation_date	datetime	Default: getdate()		Standard row creation timestamp	Metadata	Active
Standard row creation timestamp Default: getdate() Type: Metadata Status: Active
	20	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
	21	description	nvarchar(MAX)			Change user comments	Documentation	Active
Change user comments Type: Documentation Status: Active
	22	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
	23	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_changes	dbo.databases (Documentations)	dbo.tables_changes.database_id = dbo.databases.database_id	fk_tables_changes_databases
dbo.tables_changes.database_id = dbo.databases.database_id Name: fk_tables_changes_databases
dbo.tables_changes	dbo.schema_updates (Imports/Updates)	dbo.tables_changes.update_id = dbo.schema_updates.update_id	fk_tables_changes_schema_updates
dbo.tables_changes.update_id = dbo.schema_updates.update_id Name: fk_tables_changes_schema_updates
dbo.tables_changes	dbo.tables (Tables and Views)	dbo.tables_changes.table_id = dbo.tables.table_id	fk_tables_changes_tables
dbo.tables_changes.table_id = dbo.tables.table_id Name: fk_tables_changes_tables

Unique keys

	Key name	Columns	Description
	PK_tables_changes	id

Uses

Name
dbo.tables_changes
dbo.databases (Documentations)
dbo.schema_updates (Imports/Updates)
dbo.tables (Tables and Views)

Used by

Name
dbo.tables_changes
dbo.trg_tables_change_track_insert
dbo.trg_tables_change_track_update

Exported: 2018-12-06 15:15, Last imported: 2018-11-21 15:11