dbo.dependencies (Dependencies)
Documentation | Dataedo repository 7 |
Schema | dbo |
Name | dependencies |
Title | Dependencies |
Module | Dependencies |
Type | Schema |
Status | Active |
Object dependencies imported from source database.
It links two objects of various types - tables, views, procedures, functions and triggers. There is referencing object and referenced object. Referencing object depends on referenced object.
Because those objects may not be imported to repository or exist in other databases foreign and primary keys are not used. A combination of fields is used to identify object: server, database, schema, name and type.
Please note that unlike most of other tables, rows in this one are not related to any specific documentation/database.
Columns
Key | Name | Data type | Null | Attributes | References | Description | Type | Status | ||
---|---|---|---|---|---|---|---|---|---|---|
1 | dependency_id | int | Identity | Row id | Metadata | Active | ||||
Row id Identity Type: Metadata Status: Active |
||||||||||
2 | referencing_server | nvarchar(250) | Referencing object server name | Schema | Active | |||||
Referencing object server name Type: Schema Status: Active |
||||||||||
3 | referencing_database | nvarchar(250) | Referencing object database name | Schema | Active | |||||
Referencing object database name Type: Schema Status: Active |
||||||||||
4 | referencing_schema | nvarchar(250) | Referencing object schema name | Schema | Active | |||||
Referencing object schema name Type: Schema Status: Active |
||||||||||
5 | referencing_name | nvarchar(250) | Referencing object name | Schema | Active | |||||
Referencing object name Type: Schema Status: Active |
||||||||||
6 | referencing_type | nvarchar(50) | Referencing object type: TABLE, VIEW, PROCEDURE, FUNCTION, TRIGGER | Schema | Active | |||||
Referencing object type: TABLE, VIEW, PROCEDURE, FUNCTION, TRIGGER Type: Schema Status: Active |
||||||||||
7 | referenced_server | nvarchar(250) | Referenced object server name | Schema | Active | |||||
Referenced object server name Type: Schema Status: Active |
||||||||||
8 | referenced_database | nvarchar(250) | Referenced object database name | Schema | Active | |||||
Referenced object database name Type: Schema Status: Active |
||||||||||
9 | referenced_schema | nvarchar(250) | Referenced object schema name | Schema | Active | |||||
Referenced object schema name Type: Schema Status: Active |
||||||||||
10 | referenced_name | nvarchar(250) | Referenced object name | Schema | Active | |||||
Referenced object name Type: Schema Status: Active |
||||||||||
11 | referenced_type | nvarchar(50) | Referenced object type: TABLE, VIEW, PROCEDURE, FUNCTION, TRIGGER | Schema | Active | |||||
Referenced object type: TABLE, VIEW, PROCEDURE, FUNCTION, TRIGGER Type: Schema Status: Active |
||||||||||
12 | source | nvarchar(50) | Default: 'DBMS' | Source of the row: 'DBMS' for imported from database, 'USER' for manual defined by user in Dataedo repository | Metadata | Active | ||||
Source of the row: 'DBMS' for imported from database, 'USER' for manual defined by user in Dataedo repository Default: 'DBMS' Type: Metadata Status: Active |
||||||||||
13 | status | char(1) | Default: 'A' | Dependency status: A - active, D - deleted. Currently not used. | Metadata | Cancelled | ||||
Dependency status: A - active, D - deleted. Currently not used. Default: 'A' Type: Metadata Status: Cancelled |
||||||||||
14 | is_caller_dependent | char(1) | Field imported from DBMS | Schema | Active | |||||
Field imported from DBMS Type: Schema Status: Active |
||||||||||
15 | is_ambiguous | char(1) | Field imported from DBMS | Schema | Active | |||||
Field imported from DBMS Type: Schema Status: Active |
||||||||||
16 | dependency_type | nvarchar(10) | Dependency type imported from DBMS | Schema | Active | |||||
Dependency type imported from DBMS Type: Schema Status: Active |
||||||||||
17 | creation_date | datetime | Default: getdate() | Standard row creation timestamp | Metadata | Active | ||||
Standard row creation timestamp Default: getdate() Type: Metadata Status: Active |
||||||||||
18 | 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 |
||||||||||
19 | last_modification_date | datetime | Default: getdate() | Standard row last update timestamp | Metadata | Active | ||||
Standard row last update timestamp Default: getdate() Type: Metadata Status: Active |
||||||||||
20 | 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 |
||||||||||
21 | source_id | int | For internal use only | Internal | Active | |||||
For internal use only Type: Internal Status: Active |
||||||||||
22 | temp_sync_status | bit | Default: 0 | For internal use only | Internal | Active | ||||
For internal use only Default: 0 Type: Internal Status: Active |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_dependencies | dependency_id | Table primary key | |
Table primary key |
Triggers
Key name | When | Description | |
---|---|---|---|
trg_dependencies_Modify | After Insert, Update |
Uses
Name |
---|
dbo.trg_dependencies_Modify
|
dbo.dependencies (Dependencies)
|
Used by
Name |
---|
dbo.dependencies (Dependencies)
|
dbo.trg_dependencies_Modify
|
Exported: 2018-12-06 15:15, Last imported: 2018-11-21 15:07