WaMDaM_v1.05 [WaMDaM_DBWrench_Schema_v1.05.xml]
A ResourceType Structure is a particular configuration and arrangement of Object Types and their Attributes in a dataset (e.g., model) for a specific domain (e.g., water supply, wastewater collection, storm water).
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| ResourceTypeID | Integer |
| Primary key identifier | |||
| ResourceType | VarChar(255) | Full text name of the Resource type that represents a model or a dataset that groups many system components (e.g., Water Evaluation and Planning system) | |||||
| ResourceTypeAcronym | VarChar(255) | Text name acronym like WEAP, WASH | |||||
| ResourceTypeCV | VarChar(255) |
| The human readable version of the vocabulary term. May be the same as the term. |
|
|||
| MethodID | Integer | Foreigh key identifier for a method the resource types uses (e.g., WEAP simulation method) |
|
||||
| Description | Text |
| Full text description of the resource type |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_ResourceTypes_CV_ResourceTypes | CVs.CV_ResourceType | ResourceStruct.ResourceTypes | Name | ResourceTypeCV |
| fk_ResourceTypes_Methods | Metadata.Methods | ResourceStruct.ResourceTypes | MethodID | MethodID |
(none)
| Diagram Name |
| 01_WaMDaM |
| 02_WaMDaM_WCVs |