dbo.custom_fields_values (Custom fields Index)
Documentation | Dataedo repository 7 |
Schema | dbo |
Name | custom_fields_values |
Title | Custom fields Index |
Module | Custom fields |
Type | Metadata |
Status | Active |
This is an indexing table to efficiently create a dropdown for open lists (lists that user can add values to in each cell).
Values
This index table holds value in each cell in each row of each open list custom field.
Cell idendifier
To identify specific cell that this value refers to you need to use following columns:
- custom_field_id
- object_type - type of the object that value was entered for e.g. COLUMN
- object_id - id of this object
Populating table
Dataedo writes rows to this table:
- Each time you edit object
- When type of custom field is changed to open list
Listing distinct values
If you want to list all values used in the repository you can do it with this query:
SELECT DISTINCT [value]
FROM dbo.custom_fields_values
where custom_field_id = 4
Columns
Key | Name | Data type | Null | Attributes | References | Description | Type | Status | ||
---|---|---|---|---|---|---|---|---|---|---|
1 | id | int | Identity | Row id | Metadata | Active | ||||
Row id Identity Type: Metadata Status: Active |
||||||||||
2 | custom_field_id | int | dbo.custom_fields (Custom fields) | Custom field | Metadata | Active | ||||
Custom field References: dbo.custom_fields (Custom fields) Type: Metadata Status: Active |
||||||||||
3 | object_type | nvarchar(100) | Code of object type: TABLE, VIEW, PROCEDURE, FUNCTION, COLUMN, PARAMETER, KEY, RELATION, TRIGGER, MODULE, DATABASE | Metadata | Active | |||||
Code of object type: TABLE, VIEW, PROCEDURE, FUNCTION, COLUMN, PARAMETER, KEY, RELATION, TRIGGER, MODULE, DATABASE Type: Metadata Status: Active |
||||||||||
4 | object_id | int | Id of the relevant object type (table, column, etc.) | Metadata | Active | |||||
Id of the relevant object type (table, column, etc.) Type: Metadata Status: Active |
||||||||||
5 | value | nvarchar(100) | Value of the cell | Metadata | Active | |||||
Value of the cell Type: Metadata Status: Active |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
dbo.custom_fields_values (Custom fields Index) | dbo.custom_fields (Custom fields) | dbo.custom_fields_values.custom_field_id = dbo.custom_fields.custom_field_id | FK_custom_fields_values_custom_fields | |
dbo.custom_fields_values.custom_field_id = dbo.custom_fields.custom_field_id Name: FK_custom_fields_values_custom_fields |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
PK_custom_fields_values | id | Table primary key | |
Table primary key | |||
Cell identifier | custom_field_id, object_type, object_id | Cell identifier | |
Cell identifier |
Uses
Name |
---|
dbo.custom_fields_values (Custom fields Index)
|
Exported: 2018-12-06 15:15, Last imported: 2018-11-21 15:07