Table: dbo.databases (Documentations)

Schema dbo
Name databases
Title Documentations
Module Schema and Metadata

Holds Dataedo documentations and their connection details.

Columns
PK Name Data type Null Attributes Description
1 database_id int Identity / Auto increment column Row ID.
Row ID.
Identity / Auto increment column
2 title (Documentation title) nvarchar(250) Documentation title.
Documentation title.
3 type (DBMS) nvarchar(100) DBMS type: ORACLE, SQLSERVER, etc.
DBMS type: ORACLE, SQLSERVER, etc.
4 name (Database name) nvarchar(1024) Database/schema name.
Database/schema name.
5 user nvarchar(1024) Username used to connect to database.
Username used to connect to database.
6 password nvarchar(1024) Encrypted password, null if not saved.
Encrypted password, null if not saved.
7 windows_authentication bit 1 if Windows authentication for SQL Server
1 if Windows authentication for SQL Server
8 different_schema bit 1 if user selected schema different than user (Oracle only), 0 otherwise
1 if user selected schema different than user (Oracle only), 0 otherwise
9 connection_type nvarchar(100) Oracle connection type: BASIC for host/port/service name, TNS for network alias
Oracle connection type: BASIC for host/port/service name, TNS for network alias
10 host nvarchar(1024) Host name/address.
Host name/address.
11 port int Port for Oracle connection.
Port for Oracle connection.
12 service_name nvarchar(100) Service name for Oracle connection.
Service name for Oracle connection.
13 network_alias nvarchar(100) Network alias for Oracle TNS connection.
Network alias for Oracle TNS connection.
14 description nvarchar(MAX) Documentation/database introduction to be included in documentation.
Documentation/database introduction to be included in documentation.
15 creation_date datetime Default: getdate() Standard row creation timestamp.
Standard row creation timestamp.
Default: getdate()
16 created_by nvarchar(100) Default: NULL Database/Dataedo username that created row.
Database/Dataedo username that created row.
Default: NULL
17 last_modification_date datetime Default: getdate() Standard row last update timestamp.
Standard row last update timestamp.
Default: getdate()
18 modified_by nvarchar(100) Default: NULL Database/Dataedo username that last updated row.
Database/Dataedo username that last updated row.
Default: NULL
19 description_search nvarchar(MAX) Column used for searching, holds description as plain text. Description column contains HTML tags and images that would interfere with searching.
Column used for searching, holds description as plain text. Description column contains HTML tags and images that would interfere with searching.
20 filter nvarchar(MAX) Import filter definiton saved in XML format.
Import filter definiton saved in XML format.
Relations
Foreign table Primary table Join Title / Name / Description
dbo.dependencies_descriptions dbo.databases dbo.dependencies_descriptions.database_id = dbo.databases.database_id FK_dependencies_desrciptions_databases
dbo.dependencies_descriptions.database_id = dbo.databases.database_id
FK_dependencies_desrciptions_databases
dbo.ignored_objects dbo.databases dbo.ignored_objects.database_id = dbo.databases.database_id FK_ignored_objects_databases
dbo.ignored_objects.database_id = dbo.databases.database_id
FK_ignored_objects_databases
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.procedures dbo.databases dbo.procedures.database_id = dbo.databases.database_id FK_procedures_database
dbo.procedures.database_id = dbo.databases.database_id
FK_procedures_database
dbo.tables dbo.databases dbo.tables.database_id = dbo.databases.database_id FK_tables_database
dbo.tables.database_id = dbo.databases.database_id
FK_tables_database
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.
Standard insert/update trigger setting last_modification_date, modified by columns.
Used by
Name
dbo.databases (Documentations)
Exported: 2017-05-15 08:09, Last imported: 2017-04-06 15:30