dbo.modules (Modules) - Dataedo repository 7

Dataedo repository 7

- Dataedo repository 7
  - Modules
  - Tables

Documentation	Dataedo repository 7
Schema	dbo
Name	modules
Title	Modules
Module	Schema and Metadata
Type	Metadata
Status	Active

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

Columns

		Name	Data type	Attributes	References	Description	Type	Status
	1	module_id	int	Identity		Row id	Metadata	Active
Row id Identity Type: Metadata Status: Active
	2	database_id	int		dbo.databases (Documentations)	Documentation module is part of	Metadata	Active
Documentation module is part of References: dbo.databases (Documentations) Type: Metadata Status: Active
	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.	Documentation	Active
Posiotion of module in a list. By default null. Value assigned for all when sorted. If null then ordered by title. Type: Documentation Status: Active
	4	title	nvarchar(250)			Module name/title	Documentation	Active
Module name/title Type: Documentation Status: Active
	5	description	nvarchar(MAX)			Module introduction to be included in documentation	Documentation	Active
Module introduction to be included in documentation Type: Documentation Status: Active
	6	description_plain	nvarchar(MAX)			Holds description in plain text only, withouth HTML tags	Documentation	Active
Holds description in plain text only, withouth HTML tags Type: Documentation Status: Active
	7	description_search	nvarchar(MAX)			Holds description in plain text and lower case. Column used for searching.	Documentation	Active
Holds description in plain text and lower case. Column used for searching. Type: Documentation Status: Active
	8	erd_link_style	nvarchar(25)	Default: N'STRAIGHT'		Default link ERD style. See erd_links.link_style for details.	Documentation	Active
Default link ERD style. See erd_links.link_style for details. Default: N'STRAIGHT' Type: Documentation Status: Active
	9	erd_show_types	bit	Default: 0		Flag indicating if entities in ERD include data types. 1 - show, 0 - don't show. Default is 0.	Documentation	Active
Flag indicating if entities in ERD include data types. 1 - show, 0 - don't show. Default is 0. Default: 0 Type: Documentation Status: Active
	10	display_documentation_name_mode	nvarchar(25)	Default: N'EXTERNAL_ENTITIES_ONLY'		Flag deifning whether documentation title should be shown for entities: EXTERNAL_ENTITIES_ONLY - show only for the ones from external documentations, default behaviour when null ALL_ENTITIES - show for all entities NO_ENTITIES - show for no entities	Documentation	Active
Flag deifning whether documentation title should be shown for entities: EXTERNAL_ENTITIES_ONLY - show only for the ones from external documentations, default behaviour when null ALL_ENTITIES - show for all entities NO_ENTITIES - show for no entities Default: N'EXTERNAL_ENTITIES_ONLY' Type: Documentation Status: Active
	11	field1	nvarchar(MAX)			Custom field 1	Documentation	Active
Custom field 1 Type: Documentation Status: Active
	12	field2	nvarchar(MAX)			Custom field 2	Documentation	Active
Custom field 2 Type: Documentation Status: Active
	13	field3	nvarchar(MAX)			Custom field 3	Documentation	Active
Custom field 3 Type: Documentation Status: Active
	14	field4	nvarchar(MAX)			Custom field 4	Documentation	Active
Custom field 4 Type: Documentation Status: Active
	15	field5	nvarchar(MAX)			Custom field 5	Documentation	Active
Custom field 5 Type: Documentation Status: Active
	16	field6	nvarchar(MAX)			Custom field 6	Documentation	Active
Custom field 6 Type: Documentation Status: Active
	17	field7	nvarchar(MAX)			Custom field 7	Documentation	Active
Custom field 7 Type: Documentation Status: Active
	18	field8	nvarchar(MAX)			Custom field 8	Documentation	Active
Custom field 8 Type: Documentation Status: Active
	19	field9	nvarchar(MAX)			Custom field 9	Documentation	Active
Custom field 9 Type: Documentation Status: Active
	20	field10	nvarchar(MAX)			Custom field 10	Documentation	Active
Custom field 10 Type: Documentation Status: Active
	21	field11	nvarchar(MAX)			Custom field 11	Documentation	Active
Custom field 11 Type: Documentation Status: Active
	22	field12	nvarchar(MAX)			Custom field 12	Documentation	Active
Custom field 12 Type: Documentation Status: Active
	23	field13	nvarchar(MAX)			Custom field 13	Documentation	Active
Custom field 13 Type: Documentation Status: Active
	24	field14	nvarchar(MAX)			Custom field 14	Documentation	Active
Custom field 14 Type: Documentation Status: Active
	25	field15	nvarchar(MAX)			Custom field 15	Documentation	Active
Custom field 15 Type: Documentation Status: Active
	26	field16	nvarchar(MAX)			Custom field 16	Documentation	Active
Custom field 16 Type: Documentation Status: Active
	27	field17	nvarchar(MAX)			Custom field 17	Documentation	Active
Custom field 17 Type: Documentation Status: Active
	28	field18	nvarchar(MAX)			Custom field 18	Documentation	Active
Custom field 18 Type: Documentation Status: Active
	29	field19	nvarchar(MAX)			Custom field 19	Documentation	Active
Custom field 19 Type: Documentation Status: Active
	30	field20	nvarchar(MAX)			Custom field 20	Documentation	Active
Custom field 20 Type: Documentation Status: Active
	31	field21	nvarchar(MAX)			Custom field 21	Documentation	Active
Custom field 21 Type: Documentation Status: Active
	32	field22	nvarchar(MAX)			Custom field 22	Documentation	Active
Custom field 22 Type: Documentation Status: Active
	33	field23	nvarchar(MAX)			Custom field 23	Documentation	Active
Custom field 23 Type: Documentation Status: Active
	34	field24	nvarchar(MAX)			Custom field 24	Documentation	Active
Custom field 24 Type: Documentation Status: Active
	35	field25	nvarchar(MAX)			Custom field 25	Documentation	Active
Custom field 25 Type: Documentation Status: Active
	36	field26	nvarchar(MAX)			Custom field 26	Documentation	Active
Custom field 26 Type: Documentation Status: Active
	37	field27	nvarchar(MAX)			Custom field 27	Documentation	Active
Custom field 27 Type: Documentation Status: Active
	38	field28	nvarchar(MAX)			Custom field 28	Documentation	Active
Custom field 28 Type: Documentation Status: Active
	39	field29	nvarchar(MAX)			Custom field 29	Documentation	Active
Custom field 29 Type: Documentation Status: Active
	40	field30	nvarchar(MAX)			Custom field 30	Documentation	Active
Custom field 30 Type: Documentation Status: Active
	41	field31	nvarchar(MAX)			Custom field 31	Documentation	Active
Custom field 31 Type: Documentation Status: Active
	42	field32	nvarchar(MAX)			Custom field 32	Documentation	Active
Custom field 32 Type: Documentation Status: Active
	43	field33	nvarchar(MAX)			Custom field 33	Documentation	Active
Custom field 33 Type: Documentation Status: Active
	44	field34	nvarchar(MAX)			Custom field 34	Documentation	Active
Custom field 34 Type: Documentation Status: Active
	45	field35	nvarchar(MAX)			Custom field 35	Documentation	Active
Custom field 35 Type: Documentation Status: Active
	46	field36	nvarchar(MAX)			Custom field 36	Documentation	Active
Custom field 36 Type: Documentation Status: Active
	47	field37	nvarchar(MAX)			Custom field 37	Documentation	Active
Custom field 37 Type: Documentation Status: Active
	48	field38	nvarchar(MAX)			Custom field 38	Documentation	Active
Custom field 38 Type: Documentation Status: Active
	49	field39	nvarchar(MAX)			Custom field 39	Documentation	Active
Custom field 39 Type: Documentation Status: Active
	50	field40	nvarchar(MAX)			Custom field 40	Documentation	Active
Custom field 40 Type: Documentation Status: Active
	51	creation_date	datetime	Default: getdate()		Standard row creation timestamp	Metadata	Active
Standard row creation timestamp Default: getdate() Type: Metadata Status: Active
	52	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
	53	last_modification_date	datetime	Default: getdate()		Standard row last update timestamp	Metadata	Active
Standard row last update timestamp Default: getdate() Type: Metadata Status: Active
	54	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
	55	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.modules (Modules)	dbo.databases (Documentations)	dbo.modules.database_id = dbo.databases.database_id	FK_modules_database
dbo.modules.database_id = dbo.databases.database_id Name: FK_modules_database
dbo.erd_links (ERD Links)	dbo.modules (Modules)	dbo.erd_links.module_id = dbo.modules.module_id	FK_erd_links_modules
dbo.erd_links.module_id = dbo.modules.module_id Name: FK_erd_links_modules
dbo.erd_nodes (ERD Nodes)	dbo.modules (Modules)	dbo.erd_nodes.module_id = dbo.modules.module_id	FK_erd_nodes_modules
dbo.erd_nodes.module_id = dbo.modules.module_id Name: FK_erd_nodes_modules
dbo.erd_nodes_columns (ERD Nodes Columns)	dbo.modules (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 Name: FK_erd_nodes_columns_modules
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.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

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
-- ============================================= -- Author: Piotr Kononow -- Create date: 2014-06-18 -- Description: Updates last_modification_date, modified_by columns on insert or update -- ============================================= create TRIGGER [trg_modules_Modify] ON [modules] AFTER INSERT,UPDATE AS BEGIN UPDATE [modules] SET last_modification_date = GETDATE(), modified_by = suser_sname() WHERE module_id IN (SELECT DISTINCT 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_modules_Modify] ON [modules] AFTER INSERT,UPDATE AS BEGIN UPDATE [modules] SET last_modification_date = GETDATE(), modified_by = suser_sname() WHERE module_id IN (SELECT DISTINCT module_id FROM Inserted) END

Uses

Name
dbo.modules (Modules)
dbo.databases (Documentations)
dbo.trg_modules_Modify
dbo.modules (Modules)

Used by

Name
dbo.modules (Modules)
dbo.trg_modules_Modify
dbo.erd_links (ERD Links)
dbo.erd_nodes (ERD Nodes)
dbo.erd_nodes_columns (ERD Nodes Columns)
dbo.procedures_modules (Procedures-modules)
dbo.tables_modules (Tables-modules)

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