dbo.databases (Documentations) - Schema and Metadata

Dataedo repository 7

- Dataedo repository 7
  - Modules
  - Tables

Documentation	Dataedo repository 7
Schema	dbo
Name	databases
Title	Documentations
Module	Schema and Metadata
Type	Schema
Status	Active

Holds Dataedo documentations and their connection details.

Columns

		Name	Data type	Attributes	Description	Type	Status
	1	database_id	int	Identity	Row id	Metadata	Active
Row id Identity Type: Metadata Status: Active
	2	guid	uniqueidentifier	Default: newsequentialid()	Unique documentation identifier, unique across repositories	Metadata	Active
Unique documentation identifier, unique across repositories Default: newsequentialid() Type: Metadata Status: Active
	3	title (Documentation title)	nvarchar(250)		Documentation title	Documentation	Active
Documentation title Type: Documentation Status: Active
	4	description	nvarchar(MAX)		Documentation text	Documentation	Active
Documentation text Type: Documentation Status: Active
	5	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
	6	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
	7	type	nvarchar(100)		Type of documentation: - for DBMS its the type: ORACLE, SQLSERVER, etc. - MANUAL for manual documentations - BUSINESS_GLOSSARY for business glossary	Connection	Active
Type of documentation: - for DBMS its the type: ORACLE, SQLSERVER, etc. - MANUAL for manual documentations - BUSINESS_GLOSSARY for business glossary Type: Connection Status: Active
	8	name (Database name)	nvarchar(1024)		Database/schema name	Connection	Active
Database/schema name Type: Connection Status: Active
	9	host	nvarchar(1024)		Host name/address	Connection	Active
Host name/address Type: Connection Status: Active
	10	service_name	nvarchar(100)		Service name for Oracle connection	Connection	Active
Service name for Oracle connection Type: Connection Status: Active
	11	network_alias	nvarchar(100)		Network alias for Oracle TNS connection	Connection	Active
Network alias for Oracle TNS connection Type: Connection Status: Active
	12	port	int		Port for Oracle connection	Connection	Active
Port for Oracle connection Type: Connection Status: Active
	13	windows_authentication	bit		Used for SQL Servrer: 1 if Windows authentication, 0 for SQL Server authentication	Connection	Active
Used for SQL Servrer: 1 if Windows authentication, 0 for SQL Server authentication Type: Connection Status: Active
	14	different_schema	bit		Used for Oracle: 1 if user selected schema different than user, 0 otherwise	Connection	Active
Used for Oracle: 1 if user selected schema different than user, 0 otherwise Type: Connection Status: Active
	15	multiple_schemas	bit		Used for Oracle: 1 if multiple schemas were selected	Connection	Active
Used for Oracle: 1 if multiple schemas were selected Type: Connection Status: Active
	16	connection_type	nvarchar(100)		Used for Oracle: connection type: BASIC for host/port/service name, TNS for network alias	Connection	Active
Used for Oracle: connection type: BASIC for host/port/service name, TNS for network alias Type: Connection Status: Active
	17	user	nvarchar(1024)		Username used to connect to database	Connection	Active
Username used to connect to database Type: Connection Status: Active
	18	password	nvarchar(1024)		Encrypted password, null if not saved	Connection	Active
Encrypted password, null if not saved Type: Connection Status: Active
	19	dbms_version	nvarchar(500)		DBMS version as returned by DBMS at the time of last connection	Connection	Active
DBMS version as returned by DBMS at the time of last connection Type: Connection Status: Active
	20	filter	nvarchar(MAX)		Import filter definiton saved in XML format	Internal	Active
Import filter definiton saved in XML format Type: Internal Status: Active
	21	field1	nvarchar(MAX)		Custom field 1	Documentation	Active
Custom field 1 Type: Documentation Status: Active
	22	field2	nvarchar(MAX)		Custom field 2	Documentation	Active
Custom field 2 Type: Documentation Status: Active
	23	field3	nvarchar(MAX)		Custom field 3	Documentation	Active
Custom field 3 Type: Documentation Status: Active
	24	field4	nvarchar(MAX)		Custom field 4	Documentation	Active
Custom field 4 Type: Documentation Status: Active
	25	field5	nvarchar(MAX)		Custom field 5	Documentation	Active
Custom field 5 Type: Documentation Status: Active
	26	field6	nvarchar(MAX)		Custom field 6	Documentation	Active
Custom field 6 Type: Documentation Status: Active
	27	field7	nvarchar(MAX)		Custom field 7	Documentation	Active
Custom field 7 Type: Documentation Status: Active
	28	field8	nvarchar(MAX)		Custom field 8	Documentation	Active
Custom field 8 Type: Documentation Status: Active
	29	field9	nvarchar(MAX)		Custom field 9	Documentation	Active
Custom field 9 Type: Documentation Status: Active
	30	field10	nvarchar(MAX)		Custom field 10	Documentation	Active
Custom field 10 Type: Documentation Status: Active
	31	field11	nvarchar(MAX)		Custom field 11	Documentation	Active
Custom field 11 Type: Documentation Status: Active
	32	field12	nvarchar(MAX)		Custom field 12	Documentation	Active
Custom field 12 Type: Documentation Status: Active
	33	field13	nvarchar(MAX)		Custom field 13	Documentation	Active
Custom field 13 Type: Documentation Status: Active
	34	field14	nvarchar(MAX)		Custom field 14	Documentation	Active
Custom field 14 Type: Documentation Status: Active
	35	field15	nvarchar(MAX)		Custom field 15	Documentation	Active
Custom field 15 Type: Documentation Status: Active
	36	field16	nvarchar(MAX)		Custom field 16	Documentation	Active
Custom field 16 Type: Documentation Status: Active
	37	field17	nvarchar(MAX)		Custom field 17	Documentation	Active
Custom field 17 Type: Documentation Status: Active
	38	field18	nvarchar(MAX)		Custom field 18	Documentation	Active
Custom field 18 Type: Documentation Status: Active
	39	field19	nvarchar(MAX)		Custom field 19	Documentation	Active
Custom field 19 Type: Documentation Status: Active
	40	field20	nvarchar(MAX)		Custom field 20	Documentation	Active
Custom field 20 Type: Documentation Status: Active
	41	field21	nvarchar(MAX)		Custom field 21	Documentation	Active
Custom field 21 Type: Documentation Status: Active
	42	field22	nvarchar(MAX)		Custom field 22	Documentation	Active
Custom field 22 Type: Documentation Status: Active
	43	field23	nvarchar(MAX)		Custom field 23	Documentation	Active
Custom field 23 Type: Documentation Status: Active
	44	field24	nvarchar(MAX)		Custom field 24	Documentation	Active
Custom field 24 Type: Documentation Status: Active
	45	field25	nvarchar(MAX)		Custom field 25	Documentation	Active
Custom field 25 Type: Documentation Status: Active
	46	field26	nvarchar(MAX)		Custom field 26	Documentation	Active
Custom field 26 Type: Documentation Status: Active
	47	field27	nvarchar(MAX)		Custom field 27	Documentation	Active
Custom field 27 Type: Documentation Status: Active
	48	field28	nvarchar(MAX)		Custom field 28	Documentation	Active
Custom field 28 Type: Documentation Status: Active
	49	field29	nvarchar(MAX)		Custom field 29	Documentation	Active
Custom field 29 Type: Documentation Status: Active
	50	field30	nvarchar(MAX)		Custom field 30	Documentation	Active
Custom field 30 Type: Documentation Status: Active
	51	field31	nvarchar(MAX)		Custom field 31	Documentation	Active
Custom field 31 Type: Documentation Status: Active
	52	field32	nvarchar(MAX)		Custom field 32	Documentation	Active
Custom field 32 Type: Documentation Status: Active
	53	field33	nvarchar(MAX)		Custom field 33	Documentation	Active
Custom field 33 Type: Documentation Status: Active
	54	field34	nvarchar(MAX)		Custom field 34	Documentation	Active
Custom field 34 Type: Documentation Status: Active
	55	field35	nvarchar(MAX)		Custom field 35	Documentation	Active
Custom field 35 Type: Documentation Status: Active
	56	field36	nvarchar(MAX)		Custom field 36	Documentation	Active
Custom field 36 Type: Documentation Status: Active
	57	field37	nvarchar(MAX)		Custom field 37	Documentation	Active
Custom field 37 Type: Documentation Status: Active
	58	field38	nvarchar(MAX)		Custom field 38	Documentation	Active
Custom field 38 Type: Documentation Status: Active
	59	field39	nvarchar(MAX)		Custom field 39	Documentation	Active
Custom field 39 Type: Documentation Status: Active
	60	field40	nvarchar(MAX)		Custom field 40	Documentation	Active
Custom field 40 Type: Documentation Status: Active
	61	creation_date	datetime	Default: getdate()	Standard row creation timestamp	Metadata	Active
Standard row creation timestamp Default: getdate() Type: Metadata Status: Active
	62	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
	63	last_modification_date	datetime	Default: getdate()	Standard row last update timestamp	Metadata	Active
Standard row last update timestamp Default: getdate() Type: Metadata Status: Active
	64	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
	65	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.columns_changes	dbo.databases (Documentations)	dbo.columns_changes.database_id = dbo.databases.database_id	fk_columns_changes_databases
dbo.columns_changes.database_id = dbo.databases.database_id Name: fk_columns_changes_databases
dbo.dependencies_descriptions (Dependencies descriptions)	dbo.databases (Documentations)	dbo.dependencies_descriptions.database_id = dbo.databases.database_id	FK_dependencies_desrciptions_databases
dbo.dependencies_descriptions.database_id = dbo.databases.database_id Name: FK_dependencies_desrciptions_databases
dbo.documentation_custom_fields	dbo.databases (Documentations)	dbo.documentation_custom_fields.database_id = dbo.databases.database_id	FK_documentation_custom_fields_databases
dbo.documentation_custom_fields.database_id = dbo.databases.database_id Name: FK_documentation_custom_fields_databases
dbo.ignored_objects (Ignored objects)	dbo.databases (Documentations)	dbo.ignored_objects.database_id = dbo.databases.database_id	FK_ignored_objects_databases
dbo.ignored_objects.database_id = dbo.databases.database_id Name: FK_ignored_objects_databases
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.parameters_changes	dbo.databases (Documentations)	dbo.parameters_changes.database_id = dbo.databases.database_id	fk_parameters_changes_databases
dbo.parameters_changes.database_id = dbo.databases.database_id Name: fk_parameters_changes_databases
dbo.procedures (Procedures and Functions)	dbo.databases (Documentations)	dbo.procedures.database_id = dbo.databases.database_id	FK_procedures_database
dbo.procedures.database_id = dbo.databases.database_id Name: FK_procedures_database
dbo.procedures_changes	dbo.databases (Documentations)	dbo.procedures_changes.database_id = dbo.databases.database_id	fk_procedures_changes_databases
dbo.procedures_changes.database_id = dbo.databases.database_id Name: fk_procedures_changes_databases
dbo.schema_updates (Imports/Updates)	dbo.databases (Documentations)	dbo.schema_updates.database_id = dbo.databases.database_id	fk_schema_updates_databases
dbo.schema_updates.database_id = dbo.databases.database_id Name: fk_schema_updates_databases
dbo.tables_changes	dbo.databases (Documentations)	dbo.tables_changes.database_id = dbo.databases.database_id	fk_tables_changes_databases
dbo.tables_changes.database_id = dbo.databases.database_id Name: fk_tables_changes_databases
dbo.tables_relations_changes	dbo.databases (Documentations)	dbo.tables_relations_changes.database_id = dbo.databases.database_id	fk_tables_relations_changes_databases
dbo.tables_relations_changes.database_id = dbo.databases.database_id Name: fk_tables_relations_changes_databases
dbo.triggers_changes	dbo.databases (Documentations)	dbo.triggers_changes.database_id = dbo.databases.database_id	fk_triggers_changes_databases
dbo.triggers_changes.database_id = dbo.databases.database_id Name: fk_triggers_changes_databases
dbo.unique_constraints_changes	dbo.databases (Documentations)	dbo.unique_constraints_changes.database_id = dbo.databases.database_id	fk_unique_constraints_changes_databases
dbo.unique_constraints_changes.database_id = dbo.databases.database_id Name: fk_unique_constraints_changes_databases

Unique keys

	Key name	Columns	Description
	PK_databases	database_id	Table primary key
Table primary key

Triggers

	Key name	When	Description
	trg_databases_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_databases_Modify] ON [databases] AFTER INSERT,UPDATE AS BEGIN UPDATE [databases] SET last_modification_date = GETDATE(), modified_by = suser_sname() WHERE database_id IN (SELECT DISTINCT database_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_databases_Modify] ON [databases] AFTER INSERT,UPDATE AS BEGIN UPDATE [databases] SET last_modification_date = GETDATE(), modified_by = suser_sname() WHERE database_id IN (SELECT DISTINCT database_id FROM Inserted) END

Uses

Name
dbo.trg_databases_Modify
dbo.databases (Documentations)

Used by

Name
dbo.databases (Documentations)
dbo.trg_databases_Modify
dbo.columns_changes
dbo.dependencies_descriptions (Dependencies descriptions)
dbo.documentation_custom_fields
dbo.ignored_objects (Ignored objects)
dbo.modules (Modules)
dbo.parameters_changes
dbo.procedures (Procedures and Functions)
dbo.procedures_changes
dbo.schema_updates (Imports/Updates)
dbo.tables_changes
dbo.tables_relations_changes
dbo.triggers_changes
dbo.unique_constraints_changes

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