dbo.dependencies_descriptions (Dependencies descriptions)
Documentation | Dataedo repository 7 |
Schema | dbo |
Name | dependencies_descriptions |
Title | Dependencies descriptions |
Module | Dependencies |
Type | Deprecated |
Status | Cancelled |
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
Key | Name | Data type | Null | Attributes | References | Description | Type | Status | ||
---|---|---|---|---|---|---|---|---|---|---|
1 | dependency_descriptions_id | int | Identity | Row id | Metadata | Cancelled | ||||
Row id Identity Type: Metadata Status: Cancelled |
||||||||||
2 | database_id | int | dbo.databases (Documentations) | Documentation which description is part of | Metadata | Cancelled | ||||
Documentation which description is part of References: dbo.databases (Documentations) Type: Metadata Status: Cancelled |
||||||||||
3 | referencing_server | nvarchar(250) | Referencing object server name | Schema | Cancelled | |||||
Referencing object server name Type: Schema Status: Cancelled |
||||||||||
4 | referencing_database | nvarchar(250) | Referencing object database name | Schema | Cancelled | |||||
Referencing object database name Type: Schema Status: Cancelled |
||||||||||
5 | referencing_schema | nvarchar(250) | Referencing object schema name | Schema | Cancelled | |||||
Referencing object schema name Type: Schema Status: Cancelled |
||||||||||
6 | referencing_name | nvarchar(250) | Referencing object name | Schema | Cancelled | |||||
Referencing object name Type: Schema Status: Cancelled |
||||||||||
7 | referencing_type | nvarchar(50) | Referencing object type | Schema | Cancelled | |||||
Referencing object type Type: Schema Status: Cancelled |
||||||||||
8 | referenced_server | nvarchar(250) | Referenced object server name | Schema | Cancelled | |||||
Referenced object server name Type: Schema Status: Cancelled |
||||||||||
9 | referenced_database | nvarchar(250) | Referenced object database name | Schema | Cancelled | |||||
Referenced object database name Type: Schema Status: Cancelled |
||||||||||
10 | referenced_schema | nvarchar(250) | Referenced object schema name | Schema | Cancelled | |||||
Referenced object schema name Type: Schema Status: Cancelled |
||||||||||
11 | referenced_name | nvarchar(250) | Referenced object name | Schema | Cancelled | |||||
Referenced object name Type: Schema Status: Cancelled |
||||||||||
12 | referenced_type | nvarchar(50) | Referenced object type | Schema | Cancelled | |||||
Referenced object type Type: Schema Status: Cancelled |
||||||||||
13 | description | nvarchar(MAX) | Description provided by user in repository | Documentation | Cancelled | |||||
Description provided by user in repository Type: Documentation Status: Cancelled |
||||||||||
14 | ordinal_position_uses | int | Position used in sorting elements on dependencies list in a tree in uses tab | Metadata | Cancelled | |||||
Position used in sorting elements on dependencies list in a tree in uses tab Type: Metadata Status: Cancelled |
||||||||||
15 | ordinal_position_used_by | int | Position used in sorting elements on dependencies list in a tree in used by tab | Metadata | Cancelled | |||||
Position used in sorting elements on dependencies list in a tree in used by tab Type: Metadata Status: Cancelled |
||||||||||
16 | creation_date | datetime | Default: getdate() | Standard row creation timestamp | Metadata | Cancelled | ||||
Standard row creation timestamp Default: getdate() Type: Metadata Status: Cancelled |
||||||||||
17 | created_by | nvarchar(1024) | Default: suser_sname() | Dataedo username that created row | Metadata | Cancelled | ||||
Dataedo username that created row Default: suser_sname() Type: Metadata Status: Cancelled |
||||||||||
18 | last_modification_date | datetime | Default: getdate() | Standard row last update timestamp | Metadata | Cancelled | ||||
Standard row last update timestamp Default: getdate() Type: Metadata Status: Cancelled |
||||||||||
19 | modified_by | nvarchar(1024) | Default: suser_sname() | Dataedo username that last updated row | Metadata | Cancelled | ||||
Dataedo username that last updated row Default: suser_sname() Type: Metadata Status: Cancelled |
||||||||||
20 | source_id | int | For internal use only | Internal | Cancelled | |||||
For internal use only Type: Internal Status: Cancelled |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
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 |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_dependencies_desrciptions | dependency_descriptions_id | Table primary key | |
Table primary key |
Triggers
Key name | When | Description | |
---|---|---|---|
trg_dependencies_descriptions_Modify | After Insert, Update |
Uses
Name |
---|
dbo.dependencies_descriptions (Dependencies descriptions)
|
dbo.trg_dependencies_descriptions_Modify
|
dbo.dependencies_descriptions (Dependencies descriptions)
|
Used by
Name |
---|
dbo.dependencies_descriptions (Dependencies descriptions)
|
dbo.trg_dependencies_descriptions_Modify
|
Exported: 2018-12-06 15:15, Last imported: 2018-11-21 15:07