WaMDaM_v1.05 [WaMDaM_DBWrench_Schema_v1.05.xml]
A scenario organizes different topologies or connections of Instances in a Master Network and different metadata or data values for the attributes that describe those Instances. A Scenario concept helps users represent different modeling alternatives that simulate socio-economic changes in water resources networks and their data
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| ScenarioID | Integer |
| Primary key identifier | |||
| ScenarioName | VarChar(255) | a text for the name of the scenario e.g., Base Case, or Future Changes | |||||
| ScenarioStartDate | VarChar(255) |
| Start date or time (of any format) of the scenario time extent (e.g., 1966) | ||||
| ScenarioEndDate | DateTime |
| End date or time (of any format) of the scenario time extent (e.g., 2000) | ||||
| TimeStepValue | Integer |
| Time step of the scenario (e.g, 1) | ||||
| TimeStepUnitCV | VarChar(255) |
| CV term refers to the unit of the time step value of the scenario |
|
|||
| MasterNetworkID | Integer | Foreign key identifier for a MasterNetwork |
|
||||
| Description | Text |
| A text that describes the scenario |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_Scenarios_CV_Units | CVs.CV_Units | NetScen.Scenarios | Name | TimeStepUnitCV |
| fk_Scenarios_MasterNetworks | NetScen.MasterNetworks | NetScen.Scenarios | MasterNetworkID | MasterNetworkID |
(none)
| Diagram Name |
| 01_WaMDaM |
| 02_WaMDaM_WCVs |