NetScen - Schema
HomeTablesSchemasDiagramsForeign KeysIndexes

Schema: NetScen

Tables

Table NameComment
ConnectionsCreates the connectivity between node instances through links and specifies a flow direction by referencing the start and end node instances the link connects.
InstanceCategoriesOrganizes instances under a group as in their original data source (e.g., riverine instances)
InstancesInstance 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.
MappingsIt is the central table in WaM-DaM which maps out data values to their attributes, metadata, and organizing structure (i.e., MasterNetworks, Scenarios, ObjectTypes, Instances, and Dataset). Therefore the Mapping table is often used to query data from WaMDaM database.
MasterNetworksA Master Network is a specific implementation of a Dataset (or model), its Instances, and data values within a spatial location (e.g., Bear River Watershed, Utah). Master Networks help researchers to organize and then search groups of Instances that belong to a Dataset (or model)in space. For example, a Dataset for a WEAP model can be used to create separate WEAP model for the Bear River and the Weber River watersheds in Utah.
ScenarioMappingsThe 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
ScenariosA 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

Procedures

(none)

Views

(none)

Sequences

(none)