dbo.procedures_changes - Dataedo repository 7

Dataedo repository 7

- Dataedo repository 7
  - Modules
  - Tables

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

Schema changes detected in procedures/function 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	procedure_id	int		dbo.procedures (Procedures and Functions)	Uptaded procedure/function id	Metadata	Active
Uptaded procedure/function id References: dbo.procedures (Procedures and Functions) Type: Metadata Status: Active
	4	database_id	int		dbo.databases (Documentations)	Uptaded procedure/function documentation id	Metadata	Active
Uptaded procedure/function documentation id References: dbo.databases (Documentations) Type: Metadata Status: Active
	5	schema	nvarchar(250)			Uptaded procedure/function schema	Schema	Active
Uptaded procedure/function schema Type: Schema Status: Active
	6	name	nvarchar(250)			Uptaded procedure/function name	Schema	Active
Uptaded procedure/function name Type: Schema Status: Active
	7	object_type	nvarchar(100)			Uptaded procedure/function object type: PROCEDURE/FUNCTION - after update	Schema	Active
Uptaded procedure/function object type: PROCEDURE/FUNCTION - after update Type: Schema Status: Active
	8	subtype	nvarchar(100)			Uptaded procedure/function type - after update	Schema	Active
Uptaded procedure/function type - after update Type: Schema Status: Active
	9	function_type	nvarchar(100)			Uptaded function type - after update	Schema	Active
Uptaded function type - after update Type: Schema Status: Active
	10	definition	nvarchar(MAX)			Uptaded procedure/function definition script - after update	Schema	Active
Uptaded procedure/function definition script - after update Type: Schema Status: Active
	11	before_object_type	nvarchar(100)			Uptaded procedure/function object type: PROCEDURE/FUNCTION - before update	Schema	Active
Uptaded procedure/function object type: PROCEDURE/FUNCTION - before update Type: Schema Status: Active
	12	before_subtype	nvarchar(100)			Uptaded procedure/function type - before update	Schema	Active
Uptaded procedure/function type - before update Type: Schema Status: Active
	13	before_function_type	nvarchar(100)			Uptaded function type - before update	Schema	Active
Uptaded function type - before update Type: Schema Status: Active
	14	before_definition	nvarchar(MAX)			Uptaded procedure/function definition script - before update	Schema	Active
Uptaded procedure/function 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 procedure/function was last updated in DBMS before import	Metadata	Active
Timestamp when procedure/function 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.procedures_changes	dbo.databases (Documentations)	dbo.procedures_changes.database_id = dbo.databases.database_id	fk_procedures_changes_databases
dbo.procedures_changes.database_id = dbo.databases.database_id Name: fk_procedures_changes_databases
dbo.procedures_changes	dbo.procedures (Procedures and Functions)	dbo.procedures_changes.procedure_id = dbo.procedures.procedure_id	fk_procedures_changes_procedures
dbo.procedures_changes.procedure_id = dbo.procedures.procedure_id Name: fk_procedures_changes_procedures
dbo.procedures_changes	dbo.schema_updates (Imports/Updates)	dbo.procedures_changes.update_id = dbo.schema_updates.update_id	fk_procedures_changes_schema_updates
dbo.procedures_changes.update_id = dbo.schema_updates.update_id Name: fk_procedures_changes_schema_updates

Unique keys

	Key name	Columns	Description
	PK_procedures_changes	id

Uses

Name
dbo.procedures_changes
dbo.databases (Documentations)
dbo.procedures (Procedures and Functions)
dbo.schema_updates (Imports/Updates)

Used by

Name
dbo.procedures_changes
dbo.trg_parameters_change_track_update
dbo.trg_procedures_change_track_insert
dbo.trg_procedures_change_track_update

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