Table: dbo.procedures_modules (Procedures-modules)

Schema dbo
Name procedures_modules
Title Procedures-modules
Module Schema and Metadata

Many-to-many relationship of procedures and modules.

Columns
PK Name Data type Null Attributes Description
1 procedure_module_id int Identity / Auto increment column Row ID.
Row ID.
Identity / Auto increment column
2 procedure_id int Ref: procedures.
Ref: procedures.
3 module_id int Ref: modules.
Ref: modules.
4 creation_date datetime Default: getdate() Standard row creation timestamp.
Standard row creation timestamp.
Default: getdate()
5 created_by nvarchar(100) Default: NULL Database/Dataedo username that created row.
Database/Dataedo username that created row.
Default: NULL
6 last_modification_date datetime Default: getdate() Standard row last update timestamp.
Standard row last update timestamp.
Default: getdate()
7 modified_by nvarchar(100) Default: NULL Database/Dataedo username that last updated row.
Database/Dataedo username that last updated row.
Default: NULL
Relations
Foreign table Primary table Join Title / Name / Description
dbo.procedures_modules dbo.modules dbo.procedures_modules.module_id = dbo.modules.module_id FK_procedures_modules_module
dbo.procedures_modules.module_id = dbo.modules.module_id
FK_procedures_modules_module
dbo.procedures_modules dbo.procedures dbo.procedures_modules.procedure_id = dbo.procedures.procedure_id FK_procedures_modules_procedure
dbo.procedures_modules.procedure_id = dbo.procedures.procedure_id
FK_procedures_modules_procedure
Unique keys
Key name Columns Description
PK_procedures_modules procedure_module_id Table primary key.
Table primary key.
UK_procedures_modules procedure_id, module_id Procedure-module combination must be unique.
Procedure-module combination must be unique.
Triggers
Key name When Description
trg_procedures_modules_Modify After Insert, Update Standard insert/update trigger setting last_modification_date, modified by columns
Standard insert/update trigger setting last_modification_date, modified by columns
Uses
Name
dbo.procedures_modules (Procedures-modules)
Exported: 2017-05-15 08:09, Last imported: 2017-04-06 15:30