WaMDaM_v1.05 [WaMDaM_DBWrench_Schema_v1.05.xml]
Instance is a particular realization or implementation of an Object Type as node or link for a Dataset in a specific location (e.g., Hyrum reservoir in Cache Valley, Utah). The Instance concept helps modelers to replicate a distinct Object Type to represent specific water system components in their models with particular data values.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| InstanceID | Integer |
| Primary key identifier | |||
| InstanceName | VarChar(255) | A text name for the Instance | |||||
| InstanceNameCV | VarChar(255) |
| CV term for a universal instance name |
|
|||
| Longitude_x | Float |
| Longitude of the instance using the same spatail reference of the network | ||||
| Latitude_y | Float |
| Latitude of the instance using the same spatail reference of the network | ||||
| Description | Text |
| A text description of the organization | ||||
| InstanceCategoryID | Integer |
| Foreign key identifier for the instance category |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_Instances_CV_InstanceName | CVs.CV_InstanceName | NetScen.Instances | Name | InstanceNameCV |
| fk_Instances_InstanceCategories | NetScen.InstanceCategories | NetScen.Instances | InstanceCategoryID | InstanceCategoryID |
(none)
| Diagram Name |
| 01_WaMDaM |
| 02_WaMDaM_WCVs |