dbo.procedures_modules (Procedures-modules)
Documentation | Dataedo repository 7 |
Schema | dbo |
Name | procedures_modules |
Title | Procedures-modules |
Module | Schema and Metadata |
Type | Metadata |
Status | Active |
Many-to-many relationship of procedures and modules.
Columns
Key | Name | Data type | Null | Attributes | References | Description | Type | Status | ||
---|---|---|---|---|---|---|---|---|---|---|
1 | procedure_module_id | int | Identity | Row id | Metadata | Active | ||||
Row id Identity Type: Metadata Status: Active |
||||||||||
2 | procedure_id | int | dbo.procedures (Procedures and Functions) | Ref: procedures | Metadata | Active | ||||
Ref: procedures References: dbo.procedures (Procedures and Functions) 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.procedures_modules (Procedures-modules) | dbo.modules (Modules) | dbo.procedures_modules.module_id = dbo.modules.module_id | FK_procedures_modules_module | |
dbo.procedures_modules.module_id = dbo.modules.module_id Name: FK_procedures_modules_module |
||||
dbo.procedures_modules (Procedures-modules) | dbo.procedures (Procedures and Functions) | dbo.procedures_modules.procedure_id = dbo.procedures.procedure_id | FK_procedures_modules_procedure | |
dbo.procedures_modules.procedure_id = dbo.procedures.procedure_id Name: 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 | module_id, procedure_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)
|
dbo.trg_procedures_modules_Modify
|
dbo.procedures_modules (Procedures-modules)
|
Used by
Name |
---|
dbo.procedures_modules (Procedures-modules)
|
dbo.trg_procedures_modules_Modify
|
Exported: 2018-12-06 15:15, Last imported: 2018-11-21 15:07