dbo.documentation_custom_fields
Documentation | Dataedo repository 7 |
Schema | dbo |
Name | documentation_custom_fields |
Module | Custom fields |
Type | Metadata |
Status | Active |
Table holds mapping of custom fields to extended properties (SQL Server/Azure SQL). Custom field can be mapped to different extended property in each database.
Columns
Key | Name | Data type | Null | Attributes | References | Description | Type | Status | ||
---|---|---|---|---|---|---|---|---|---|---|
1 | documentation_custom_field_id | int | Identity | Row id | Metadata | Active | ||||
Row id Identity Type: Metadata Status: Active |
||||||||||
2 | custom_field_id | int | dbo.custom_fields (Custom fields) | Ref: custom_fields | Metadata | Active | ||||
Ref: custom_fields References: dbo.custom_fields (Custom fields) Type: Metadata Status: Active |
||||||||||
3 | database_id | int | dbo.databases (Documentations) | Ref: databases | Metadata | Active | ||||
Ref: databases References: dbo.databases (Documentations) Type: Metadata Status: Active |
||||||||||
4 | extended_property | nvarchar(128) | Name of the extended property | Metadata | Active | |||||
Name of the extended property Type: Metadata Status: Active |
||||||||||
5 | creation_date | datetime | Default: getdate() | Standard row creation timestamp | Metadata | Active | ||||
Standard row creation timestamp Default: getdate() Type: Metadata Status: Active |
||||||||||
6 | 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 |
||||||||||
7 | last_modification_date | datetime | Default: getdate() | Standard row last update timestamp | Metadata | Active | ||||
Standard row last update timestamp Default: getdate() Type: Metadata Status: Active |
||||||||||
8 | 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 |
||||||||||
9 | 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.documentation_custom_fields | dbo.custom_fields (Custom fields) | dbo.documentation_custom_fields.custom_field_id = dbo.custom_fields.custom_field_id | FK_documentation_custom_fields_custom_fields | |
dbo.documentation_custom_fields.custom_field_id = dbo.custom_fields.custom_field_id Name: FK_documentation_custom_fields_custom_fields |
||||
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 |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_documentation_custom_fields | documentation_custom_field_id | Table primary key | |
Table primary key | |||
UK_documentation_custom_fields | custom_field_id, database_id | Field can be mapped only once per connection | |
Field can be mapped only once per connection |
Triggers
Key name | When | Description | |
---|---|---|---|
trg_documentation_custom_fields_Modify | After Insert, Update |
Uses
Name |
---|
dbo.documentation_custom_fields
|
dbo.trg_documentation_custom_fields_Modify
|
dbo.documentation_custom_fields
|
Used by
Name |
---|
dbo.documentation_custom_fields
|
dbo.trg_documentation_custom_fields_Modify
|
Exported: 2018-12-06 15:15, Last imported: 2018-11-21 15:07