dbo.databases (Documentations)
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
Key | Name | Data type | Null | Attributes | References | 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. | |
Standard insert/update trigger setting last_modification_date, modified by columns. |
Uses
Name |
---|
dbo.trg_databases_Modify
|
dbo.databases (Documentations)
|
Used by
Name |
---|
dbo.databases (Documentations)
|
dbo.trg_databases_Modify
|
Exported: 2018-12-06 15:15, Last imported: 2018-11-21 15:07