custom_field_KEY | int (4) | NOT NULL | |
row_KEY | int (4) | NOT NULL | Contains the key of the record that "owns" this value, like the client or vendor. Will match the related value in the Custom_Value_X table (ex. Custom_Value_Client.client_KEY). Set initially through normal means, but is also maintained via database triggers. The triggers exist to support restoring client data into the database. |
custom_value | nvarchar (200) | NOT NULL | |
custom_value_KEY | int (4) | NOT NULL | Primary key for this table and FK to the custom value being referenced. |
custom_grouping_KEY | int (4) | | Link to the custom grouping record if this is for a list field. ["BR"]If value is for a grouping field then the grouping key will match (logically) the value in custom_value; ["BR"]null in this column will be an empty string in custom_value. ["BR"]The grouping key will be null if this is for a non-grouping field, and there will be no relationship between ["BR"]custom_grouping_KEY and custom_value. |