dbo.parameters_changes - Dataedo repository 7

Dataedo repository 7

- Dataedo repository 7
  - Modules
  - Tables

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

Schema changes detected in procedures/function paramters 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	database_id	int		dbo.databases (Documentations)	Uptaded parameter documentation id	Metadata	Active
Uptaded parameter documentation id References: dbo.databases (Documentations) Type: Metadata Status: Active
	4	parameter_id	int		dbo.parameters (Parameters)	Uptaded parameter id	Metadata	Active
Uptaded parameter id References: dbo.parameters (Parameters) Type: Metadata Status: Active
	5	procedure_id	int		dbo.procedures (Procedures and Functions)	Uptaded parameter procedure/function id	Metadata	Active
Uptaded parameter procedure/function id References: dbo.procedures (Procedures and Functions) Type: Metadata Status: Active
	6	ordinal_position	int			Updated parameter ordinal position - after update	Schema	Active
Updated parameter ordinal position - after update Type: Schema Status: Active
	7	parameter_mode	nvarchar(10)			Updated parameter mode IN, OUT, INOUT - after update	Schema	Active
Updated parameter mode IN, OUT, INOUT - after update Type: Schema Status: Active
	8	name	nvarchar(250)			Updated parameter name - after update	Schema	Active
Updated parameter name - after update Type: Schema Status: Active
	9	datatype	nvarchar(250)			Updated parameter data type - after update	Schema	Active
Updated parameter data type - after update Type: Schema Status: Active
	10	data_length	nvarchar(20)			Updated parameter data length - after update	Schema	Active
Updated parameter data length - after update Type: Schema Status: Active
	11	before_ordinal_position	int			Updated parameter ordinal position - before update	Schema	Active
Updated parameter ordinal position - before update Type: Schema Status: Active
	12	before_parameter_mode	nvarchar(10)			Updated parameter mode IN, OUT, INOUT - before update	Schema	Active
Updated parameter mode IN, OUT, INOUT - before update Type: Schema Status: Active
	13	before_datatype	nvarchar(250)			Updated parameter data type - before update	Schema	Active
Updated parameter data type - before update Type: Schema Status: Active
	14	before_data_length	nvarchar(20)			Updated parameter data length - before update	Schema	Active
Updated parameter data length - 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	valid_from	datetime			Timestamp when this change was detected	Metadata	Active
Timestamp when this change was detected Type: Metadata Status: Active
	17	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
	18	creation_date	datetime	Default: getdate()		Standard row creation timestamp	Metadata	Active
Standard row creation timestamp Default: getdate() Type: Metadata Status: Active
	19	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
	20	description	nvarchar(MAX)			Change user comments	Documentation	Active
Change user comments Type: Documentation Status: Active
	21	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
	22	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.parameters_changes	dbo.databases (Documentations)	dbo.parameters_changes.database_id = dbo.databases.database_id	fk_parameters_changes_databases
dbo.parameters_changes.database_id = dbo.databases.database_id Name: fk_parameters_changes_databases
dbo.parameters_changes	dbo.parameters (Parameters)	dbo.parameters_changes.parameter_id = dbo.parameters.parameter_id	fk_parameters_changes_parameters
dbo.parameters_changes.parameter_id = dbo.parameters.parameter_id Name: fk_parameters_changes_parameters
dbo.parameters_changes	dbo.procedures (Procedures and Functions)	dbo.parameters_changes.procedure_id = dbo.procedures.procedure_id	fk_parameters_changes_procedures
dbo.parameters_changes.procedure_id = dbo.procedures.procedure_id Name: fk_parameters_changes_procedures
dbo.parameters_changes	dbo.schema_updates (Imports/Updates)	dbo.parameters_changes.update_id = dbo.schema_updates.update_id	fk_parameters_changes_schema_updates
dbo.parameters_changes.update_id = dbo.schema_updates.update_id Name: fk_parameters_changes_schema_updates

Unique keys

	Key name	Columns	Description
	PK_parameters_changes	id

Uses

Name
dbo.parameters_changes
dbo.databases (Documentations)
dbo.parameters (Parameters)
dbo.procedures (Procedures and Functions)
dbo.schema_updates (Imports/Updates)

Used by

Name
dbo.parameters_changes
dbo.trg_parameters_change_track_insert
dbo.trg_parameters_change_track_update

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