WaMDaM_v1.05 [WaMDaM_DBWrench_Schema_v1.05.xml]
This table is similar to Text Free table but this one enforces controlled vocabulary on text data values to help users consistently define static descriptive text data values across instances. For example, a user can choose the owner type of a reservoir from a user predefined list like Federal, State, Local, and Private.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| CategoricalValueID | Integer |
| Primary key identifier | |||
| CategoricalValue | VarChar(500) | A character value that describe an instance of a system componenet | |||||
| CategoricalValueCV | VarChar(255) |
| Foreign key identifier a controlled text value |
|
|||
| ValuesMapperID | Integer | Foreign key identifier for a DataValuesMapper record |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_CategoricalValues_ValuesMapper | DataValues.ValuesMapper | DataValues.CategoricalValues | ValuesMapperID | ValuesMapperID |
| fk_DescriptorValues_CV_DescriptorValues | CVs.CV_Categorical | DataValues.CategoricalValues | Term | CategoricalValueCV |
(none)
| Diagram Name |
| 01_WaMDaM |
| 02_WaMDaM_WCVs |