Table: dbo.modules (Modules)

Schema dbo
Name modules
Title Modules
Module Schema and Metadata

Database modules defined with Dataedo. Modules exist solely in Dataedo documentation repository and are used for logical grouping of database objects.

Columns
PK Name Data type Null Attributes Description
1 module_id int Identity / Auto increment column Row ID.
Row ID.
Identity / Auto increment column
2 database_id int Documentation module is part of. Ref. databases.
Documentation module is part of. Ref. databases.
3 ordinal_position int Posiotion of module in a list. By default null. Value assigned for all when sorted. If null then ordered by title.
Posiotion of module in a list. By default null. Value assigned for all when sorted. If null then ordered by title.
4 title nvarchar(250) Module name/title.
Module name/title.
5 description nvarchar(MAX) Module introduction to be included in documentation.
Module introduction to be included in documentation.
6 creation_date datetime Default: getdate() Stanadard row creation timestamp.
Stanadard row creation timestamp.
Default: getdate()
7 created_by nvarchar(100) Default: NULL Database/Dataedo username that created row.
Database/Dataedo username that created row.
Default: NULL
8 last_modification_date datetime Default: getdate() Stanadard row last update timestamp.
Stanadard row last update timestamp.
Default: getdate()
9 modified_by nvarchar(100) Default: NULL Database/Dataedo username that last updated row.
Database/Dataedo username that last updated row.
Default: NULL
10 description_search nvarchar(MAX) Column used for searching, holds description as plain text. Description column contains HTML tags and images that would interfere searching.
Column used for searching, holds description as plain text. Description column contains HTML tags and images that would interfere searching.
11 erd_link_style nvarchar(25) Default: N'STRAIGHT' Default link ERD style. See erd_links.link_style for details.
Default link ERD style. See erd_links.link_style for details.
Default: N'STRAIGHT'
12 erd_show_types bit Default: 0 Flag indicating if entities in ERD include data types. 1 - show, 0 - don't show. Default is 0.
Flag indicating if entities in ERD include data types. 1 - show, 0 - don't show. Default is 0.
Default: 0
Relations
Foreign table Primary table Join Title / Name / Description
dbo.modules dbo.databases dbo.modules.database_id = dbo.databases.database_id FK_modules_database
dbo.modules.database_id = dbo.databases.database_id
FK_modules_database
dbo.erd_links dbo.modules dbo.erd_links.module_id = dbo.modules.module_id FK_erd_links_modules
dbo.erd_links.module_id = dbo.modules.module_id
FK_erd_links_modules
dbo.erd_nodes dbo.modules dbo.erd_nodes.module_id = dbo.modules.module_id FK_erd_nodes_modules
dbo.erd_nodes.module_id = dbo.modules.module_id
FK_erd_nodes_modules
dbo.erd_nodes_columns dbo.modules dbo.erd_nodes_columns.module_id = dbo.modules.module_id FK_erd_nodes_columns_modules
dbo.erd_nodes_columns.module_id = dbo.modules.module_id
FK_erd_nodes_columns_modules
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.tables_modules dbo.modules dbo.tables_modules.module_id = dbo.modules.module_id FK_tables_modules_module
dbo.tables_modules.module_id = dbo.modules.module_id
FK_tables_modules_module
Unique keys
Key name Columns Description
PK_modules module_id Table primary key.
Table primary key.
Triggers
Key name When Description
trg_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.modules (Modules)
Used by
Name
dbo.modules (Modules)
Exported: 2017-05-15 08:09, Last imported: 2017-04-06 15:30