dbo.columns_changes - Dataedo repository 7

Dataedo repository 7

- Dataedo repository 7
  - Modules
  - Tables

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

Schema changes detected in table/view columns 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	column_id	int		dbo.columns (Columns)	Updated column id	Metadata	Active
Updated column id References: dbo.columns (Columns) Type: Metadata Status: Active
	4	table_id	int		dbo.tables (Tables and Views)	Uptaded column table id	Metadata	Active
Uptaded column table id References: dbo.tables (Tables and Views) Type: Metadata Status: Active
	5	database_id	int		dbo.databases (Documentations)	Updated column documentation id	Metadata	Active
Updated column documentation id References: dbo.databases (Documentations) Type: Metadata Status: Active
	6	table_schema	nvarchar(250)			Updated coulumn table schema name - after update	Schema	Active
Updated coulumn table schema name - after update Type: Schema Status: Active
	7	table_name	nvarchar(250)			Updated coulumn table name - after update	Schema	Active
Updated coulumn table name - after update Type: Schema Status: Active
	8	column_name	nvarchar(250)			Updated coulumn name - after update	Schema	Active
Updated coulumn name - after update Type: Schema Status: Active
	9	ordinal_position	int			Updated coulumn ordinal position - after update	Schema	Active
Updated coulumn ordinal position - after update Type: Schema Status: Active
	10	datatype	nvarchar(250)			Updated coulumn data type - after update	Schema	Active
Updated coulumn data type - after update Type: Schema Status: Active
	11	data_length	nvarchar(50)			Updated coulumn data length - after update	Schema	Active
Updated coulumn data length - after update Type: Schema Status: Active
	12	nullable	bit			Updated coulumn nullability - after update	Schema	Active
Updated coulumn nullability - after update Type: Schema Status: Active
	13	default_value	nvarchar(MAX)			Updated coulumn default value - after update	Schema	Active
Updated coulumn default value - after update Type: Schema Status: Active
	14	is_identity	bit			Updated coulumn identity flag - after update	Schema	Active
Updated coulumn identity flag - after update Type: Schema Status: Active
	15	is_computed	bit			Updated coulumn computed flag - after update	Schema	Active
Updated coulumn computed flag - after update Type: Schema Status: Active
	16	computed_formula	nvarchar(MAX)			Updated coulumn computed formula - after update	Schema	Active
Updated coulumn computed formula - after update Type: Schema Status: Active
	17	before_column_name	nvarchar(250)			Updated coulumn name - before update	Schema	Active
Updated coulumn name - before update Type: Schema Status: Active
	18	before_ordinal_position	int			Updated coulumn ordinal position - before update	Schema	Active
Updated coulumn ordinal position - before update Type: Schema Status: Active
	19	before_datatype	nvarchar(250)			Updated coulumn data type - before update	Schema	Active
Updated coulumn data type - before update Type: Schema Status: Active
	20	before_data_length	nvarchar(50)			Updated coulumn data length - before update	Schema	Active
Updated coulumn data length - before update Type: Schema Status: Active
	21	before_nullable	bit			Updated coulumn nullability - before update	Schema	Active
Updated coulumn nullability - before update Type: Schema Status: Active
	22	before_default_value	nvarchar(MAX)			Updated coulumn default value - before update	Schema	Active
Updated coulumn default value - before update Type: Schema Status: Active
	23	before_is_identity	bit			Updated coulumn identity flag - before update	Schema	Active
Updated coulumn identity flag - before update Type: Schema Status: Active
	24	before_is_computed	bit			Updated coulumn computed flag - before update	Schema	Active
Updated coulumn computed flag - before update Type: Schema Status: Active
	25	before_computed_formula	nvarchar(MAX)			Updated coulumn computed formula - before update	Schema	Active
Updated coulumn computed formula - before update Type: Schema Status: Active
	26	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
	27	valid_from	datetime			Timestamp when this change was detected	Metadata	Active
Timestamp when this change was detected Type: Metadata Status: Active
	28	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
	29	creation_date	datetime	Default: getdate()		Standard row creation timestamp	Metadata	Active
Standard row creation timestamp Default: getdate() Type: Metadata Status: Active
	30	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
	31	description	nvarchar(MAX)			Change user comments	Documentation	Active
Change user comments Type: Documentation Status: Active
	32	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
	33	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.columns_changes	dbo.columns (Columns)	dbo.columns_changes.column_id = dbo.columns.column_id	fk_columns_changes_columns
dbo.columns_changes.column_id = dbo.columns.column_id Name: fk_columns_changes_columns
dbo.columns_changes	dbo.databases (Documentations)	dbo.columns_changes.database_id = dbo.databases.database_id	fk_columns_changes_databases
dbo.columns_changes.database_id = dbo.databases.database_id Name: fk_columns_changes_databases
dbo.columns_changes	dbo.schema_updates (Imports/Updates)	dbo.columns_changes.update_id = dbo.schema_updates.update_id	fk_columns_changes_schema_updates
dbo.columns_changes.update_id = dbo.schema_updates.update_id Name: fk_columns_changes_schema_updates
dbo.columns_changes	dbo.tables (Tables and Views)	dbo.columns_changes.table_id = dbo.tables.table_id	fk_columns_changes_tables
dbo.columns_changes.table_id = dbo.tables.table_id Name: fk_columns_changes_tables

Unique keys

	Key name	Columns	Description
	PK_columns_changes	id

Uses

Name
dbo.columns_changes
dbo.columns (Columns)
dbo.databases (Documentations)
dbo.schema_updates (Imports/Updates)
dbo.tables (Tables and Views)

Used by

Name
dbo.columns_changes
dbo.trg_columns_change_track_insert
dbo.trg_columns_change_track_update

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