WaMDaM_v1.05 [WaMDaM_DBWrench_Schema_v1.05.xml]
An Object Type is the building element of a dataset that modelers customize its attributes to represent a distinct water system component (e.g., reservoir or a river) in their models (data structures). An Object Type may represent physical and existing water components or to represent conceptual objects like representing water gains and losses in a river though a virtual node object at a point on a river.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| ObjectTypeID | Integer |
| Primary key identifier | |||
| ObjectType | VarChar(255) | Object Type name as used in the data structure like WEAP (e.g., Reservoir) | |||||
| ObjectTypeCV | VarChar(255) |
| CV Term for a universal ObjectType |
|
|||
| ObjectTypologyCV | VarChar(50) | Typology of the Object Type instance as either Node, Link, or Network |
|
||||
| Layout | Text |
| The object icon (shape and color) in case it is used in a user interface | ||||
| Description | Text |
| Full text description of the Object type | ||||
| ObjectCategoryID | Integer |
| Foreign key identifier for an ObjectCategory |
|
|||
| ResourceTypeID | Integer | Foreign key identifier for a Dataset which the ObjectType belongs to |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_ObjectTypes_CV_ObjectTopology | CVs.CV_ObjectTypology | ResourceStruct.ObjectTypes | Name | ObjectTypologyCV |
| fk_ObjectTypes_CV_ObjectTypes | CVs.CV_ObjectType | ResourceStruct.ObjectTypes | Name | ObjectTypeCV |
| fk_ObjectTypes_Datasets | ResourceStruct.ResourceTypes | ResourceStruct.ObjectTypes | ResourceTypeID | ResourceTypeID |
| fk_ObjectTypes_ObjectCategory | ResourceStruct.ObjectCategories | ResourceStruct.ObjectTypes | ObjectCategoryID | ObjectCategoryID |
(none)
| Diagram Name |
| 01_WaMDaM |
| 02_WaMDaM_WCVs |