WaMDaM_v1.05 [WaMDaM_DBWrench_Schema_v1.05.xml]
The ScenarioMapping is a bridge table that allows associating many Mapping records with many scenarios. This table allows to map out the duplicate topology, metadata, and data between scenarios. This Table allows coping the entire data and structure for a scenario or or many times without duplicating any of that data
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| ScenarioMappingID | Integer |
| Primary key identifier | |||
| ScenarioID | Integer | Foreign key identifier for a Scenario |
|
||||
| MappingID | Integer | Foreign key identifier for a Mapping record |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_ScenarioMapping_Scenarios | NetScen.Scenarios | NetScen.ScenarioMappings | ScenarioID | ScenarioID |
| fk_ScenarioMappings_Mappings | NetScen.Mappings | NetScen.ScenarioMappings | MappingID | MappingID |
(none)
| Diagram Name |
| 01_WaMDaM |
| 02_WaMDaM_WCVs |