dbo.triggers_changes - Dataedo repository 7

Dataedo repository 7

- Dataedo repository 7
  - Modules
  - Tables

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

Schema changes detected in triggers 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	trigger_id	int		dbo.triggers (Triggers)	Uptaded trigger id	Metadata	Active
Uptaded trigger id References: dbo.triggers (Triggers) Type: Metadata Status: Active
	4	database_id	int		dbo.databases (Documentations)	Uptaded trigger documentation id	Metadata	Active
Uptaded trigger documentation id References: dbo.databases (Documentations) Type: Metadata Status: Active
	5	table_id	int		dbo.tables (Tables and Views)	Uptaded trigger table id	Metadata	Active
Uptaded trigger table id References: dbo.tables (Tables and Views) Type: Metadata Status: Active
	6	name	nvarchar(250)			Uptaded trigger name	Schema	Active
Uptaded trigger name Type: Schema Status: Active
	7	type	nvarchar(100)			Uptaded trigger type	Schema	Active
Uptaded trigger type Type: Schema Status: Active
	8	before	bit			Is updated trigger fired before operation (1 - yes) - after update	Schema	Active
Is updated trigger fired before operation (1 - yes) - after update Type: Schema Status: Active
	9	after	bit			Is updated trigger fired after operation (1 - yes) - after update	Schema	Active
Is updated trigger fired after operation (1 - yes) - after update Type: Schema Status: Active
	10	instead_of	bit			Is updated trigger fired instead of operation (1 - yes) - after update	Schema	Active
Is updated trigger fired instead of operation (1 - yes) - after update Type: Schema Status: Active
	11	on_insert	bit			Is updated trigger fired on insert operation (1 - yes) - after update	Schema	Active
Is updated trigger fired on insert operation (1 - yes) - after update Type: Schema Status: Active
	12	on_update	bit			Is updated trigger fired on update operation (1 - yes) - after update	Schema	Active
Is updated trigger fired on update operation (1 - yes) - after update Type: Schema Status: Active
	13	on_delete	bit			Is updated trigger fired on delete operation (1 - yes) - after update	Schema	Active
Is updated trigger fired on delete operation (1 - yes) - after update Type: Schema Status: Active
	14	disabled	bit			Is updated trigger disabled in DBMS (1 - yes) - after update	Schema	Active
Is updated trigger disabled in DBMS (1 - yes) - after update Type: Schema Status: Active
	15	definition	nvarchar(MAX)			Uptaded trigger definition script - after update	Schema	Active
Uptaded trigger definition script - after update Type: Schema Status: Active
	16	before_before	bit			Is updated trigger fired before operation (1 - yes) - before update	Schema	Active
Is updated trigger fired before operation (1 - yes) - before update Type: Schema Status: Active
	17	before_after	bit			Is updated trigger fired after operation (1 - yes) - before update	Schema	Active
Is updated trigger fired after operation (1 - yes) - before update Type: Schema Status: Active
	18	before_instead_of	bit			Is updated trigger fired instead of operation (1 - yes) - before update	Schema	Active
Is updated trigger fired instead of operation (1 - yes) - before update Type: Schema Status: Active
	19	before_on_insert	bit			Is updated trigger fired on insert operation (1 - yes) - before update	Schema	Active
Is updated trigger fired on insert operation (1 - yes) - before update Type: Schema Status: Active
	20	before_on_update	bit			Is updated trigger fired on update operation (1 - yes) - before update	Schema	Active
Is updated trigger fired on update operation (1 - yes) - before update Type: Schema Status: Active
	21	before_on_delete	bit			Is updated trigger fired on delete operation (1 - yes) - before update	Schema	Active
Is updated trigger fired on delete operation (1 - yes) - before update Type: Schema Status: Active
	22	before_disabled	bit			Is updated trigger disabled (1 - yes) - before update	Schema	Active
Is updated trigger disabled (1 - yes) - before update Type: Schema Status: Active
	23	before_definition	nvarchar(MAX)			Uptaded trigger definition script - before update	Schema	Active
Uptaded trigger definition script - before update Type: Schema Status: Active
	24	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
	25	valid_from	datetime			Timestamp when this change was detected	Metadata	Active
Timestamp when this change was detected Type: Metadata Status: Active
	26	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
	27	creation_date	datetime	Default: getdate()		Standard row creation timestamp	Metadata	Active
Standard row creation timestamp Default: getdate() Type: Metadata Status: Active
	28	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
	29	description	nvarchar(MAX)			Change user comments	Documentation	Active
Change user comments Type: Documentation Status: Active
	30	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
	31	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.triggers_changes	dbo.databases (Documentations)	dbo.triggers_changes.database_id = dbo.databases.database_id	fk_triggers_changes_databases
dbo.triggers_changes.database_id = dbo.databases.database_id Name: fk_triggers_changes_databases
dbo.triggers_changes	dbo.schema_updates (Imports/Updates)	dbo.triggers_changes.update_id = dbo.schema_updates.update_id	fk_triggers_changes_schema_updates
dbo.triggers_changes.update_id = dbo.schema_updates.update_id Name: fk_triggers_changes_schema_updates
dbo.triggers_changes	dbo.tables (Tables and Views)	dbo.triggers_changes.table_id = dbo.tables.table_id	fk_triggers_changes_tables
dbo.triggers_changes.table_id = dbo.tables.table_id Name: fk_triggers_changes_tables
dbo.triggers_changes	dbo.triggers (Triggers)	dbo.triggers_changes.trigger_id = dbo.triggers.trigger_id	fk_triggers_changes_triggers
dbo.triggers_changes.trigger_id = dbo.triggers.trigger_id Name: fk_triggers_changes_triggers

Unique keys

	Key name	Columns	Description
	PK_triggers_changes2	id

Uses

Name
dbo.triggers_changes
dbo.databases (Documentations)
dbo.schema_updates (Imports/Updates)
dbo.tables (Tables and Views)
dbo.triggers (Triggers)

Used by

Name
dbo.triggers_changes
dbo.trg_triggers_change_track_insert
dbo.trg_triggers_change_track_update

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