dbo.tables_modules (Tables-modules) - Dataedo repository 7

Dataedo repository 7

- Dataedo repository 7
  - Modules
  - Tables

Documentation	Dataedo repository 7
Schema	dbo
Name	tables_modules
Title	Tables-modules
Module	Schema and Metadata
Type	Metadata
Status	Active

Many-to-many relationship of tables and modules.

Columns

		Key	Name	Data type	Null	Attributes	References	Description	Type	Status
	1		table_module_id	int		Identity		Row id	Metadata	Active
Row id Identity Type: Metadata Status: Active
	2		table_id	int			dbo.tables (Tables and Views)	Ref: tables	Metadata	Active
Ref: tables References: dbo.tables (Tables and Views) Type: Metadata Status: Active
	3		module_id	int			dbo.modules (Modules)	Ref: modules	Metadata	Active
Ref: modules References: dbo.modules (Modules) Type: Metadata Status: Active
	4		creation_date	datetime		Default: getdate()		Standard row creation timestamp	Metadata	Active
Standard row creation timestamp Default: getdate() Type: Metadata Status: Active
	5		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
	6		last_modification_date	datetime		Default: getdate()		Standard row last update timestamp	Metadata	Active
Standard row last update timestamp Default: getdate() Type: Metadata Status: Active
	7		modified_by	nvarchar(1024)		Default: suser_sname()		Dataedo username that last updated row	Metadata	Active
Dataedo username that last updated row Default: suser_sname() Type: Metadata Status: Active
	8		source_id	int				For internal use only	Internal	Active
For internal use only Type: Internal Status: Active

Relations

Foreign table		Primary table	Join	Title / Name / Description
dbo.tables_modules (Tables-modules)		dbo.modules (Modules)	dbo.tables_modules.module_id = dbo.modules.module_id	FK_tables_modules_module
dbo.tables_modules.module_id = dbo.modules.module_id Name: FK_tables_modules_module
dbo.tables_modules (Tables-modules)		dbo.tables (Tables and Views)	dbo.tables_modules.table_id = dbo.tables.table_id	FK_tables_modules_tables
dbo.tables_modules.table_id = dbo.tables.table_id Name: FK_tables_modules_tables

Unique keys

	Key name	Columns	Description
	PK_tables_modules	table_module_id	Table primary key
Table primary key
	UK_tables_modules	table_id, module_id	Table-module combination must be unique
Table-module combination must be unique

Triggers

	Key name	When	Description
	trg_tables_modules_Modify	After Insert, Update	Standard insert/update trigger setting last_modification_date, modified by columns
-- ============================================= -- Author: Piotr Kononow -- Create date: 2014-06-18 -- Description: Updates last_modification_date, modified_by columns on insert or update -- ============================================= create TRIGGER [trg_tables_modules_Modify] ON [tables_modules] AFTER INSERT, UPDATE AS BEGIN UPDATE [tables_modules] SET last_modification_date = GETDATE(), modified_by = suser_sname() WHERE table_module_id IN (SELECT DISTINCT table_module_id FROM Inserted) END
Standard insert/update trigger setting last_modification_date, modified by columns
-- ============================================= -- Author: Piotr Kononow -- Create date: 2014-06-18 -- Description: Updates last_modification_date, modified_by columns on insert or update -- ============================================= create TRIGGER [trg_tables_modules_Modify] ON [tables_modules] AFTER INSERT, UPDATE AS BEGIN UPDATE [tables_modules] SET last_modification_date = GETDATE(), modified_by = suser_sname() WHERE table_module_id IN (SELECT DISTINCT table_module_id FROM Inserted) END

Uses

Name
dbo.tables_modules (Tables-modules)
dbo.modules (Modules)
dbo.tables (Tables and Views)
dbo.trg_tables_modules_Modify
dbo.tables_modules (Tables-modules)

Used by

Name
dbo.tables_modules (Tables-modules)
dbo.trg_tables_modules_Modify

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