Table: dbo.dependencies_descriptions (Dependencies descriptions)

Schema dbo
Name dependencies_descriptions
Title Dependencies descriptions
Module Dependencies

Descriptions of dependencies elements provided in Dataedo repository.

 

In contrast with dependencies, dependency descriptions are related to a specific documentation/database. Same dependency may have different descriptions if dependency is between objects in two different databases.

Columns
PK Name Data type Null Attributes Description
1 dependency_descriptions_id int Identity / Auto increment column Row ID.
Row ID.
Identity / Auto increment column
2 database_id int Documentation which description is part of. Ref: databases.
Documentation which description is part of. Ref: databases.
3 referencing_server nvarchar(250) Referencing object server name.
Referencing object server name.
4 referencing_database nvarchar(250) Referencing object database name.
Referencing object database name.
5 referencing_schema nvarchar(250) Referencing object schema name.
Referencing object schema name.
6 referencing_name nvarchar(250) Referencing object name.
Referencing object name.
7 referencing_type nvarchar(50) Referencing object type.
Referencing object type.
8 referenced_server nvarchar(250) Referenced object server name.
Referenced object server name.
9 referenced_database nvarchar(250) Referenced object database name.
Referenced object database name.
10 referenced_schema nvarchar(250) Referenced object schema name.
Referenced object schema name.
11 referenced_name nvarchar(250) Referenced object name.
Referenced object name.
12 referenced_type nvarchar(50) Referenced object type.
Referenced object type.
13 description nvarchar(MAX) Description provided by user in repository.
Description provided by user in repository.
14 ordinal_position_uses int Position used in sorting elements on dependencies list in a tree in uses tab.
Position used in sorting elements on dependencies list in a tree in uses tab.
15 ordinal_position_used_by int Position used in sorting elements on dependencies list in a tree in used by tab.
Position used in sorting elements on dependencies list in a tree in used by tab.
16 creation_date datetime Default: getdate() Standard row creation timestamp.
Standard row creation timestamp.
Default: getdate()
17 created_by nvarchar(100) Default: NULL Database/Dataedo username that created row.
Database/Dataedo username that created row.
Default: NULL
18 last_modification_date datetime Default: getdate() Standard row last update timestamp.
Standard row last update timestamp.
Default: getdate()
19 modified_by nvarchar(100) Default: NULL Database/Dataedo username that last updated row.
Database/Dataedo username that last updated row.
Default: NULL
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
Unique keys
Key name Columns Description
PK_dependencies_desrciptions dependency_descriptions_id Table primary key.
Table primary key.
Uses
Name
dbo.dependencies_descriptions (Dependencies descriptions)
Exported: 2017-05-15 08:09, Last imported: 2017-04-06 15:30