MasterNetworks - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: MasterNetworks

A 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.

Columns

PKNameData TypeNULLAutoDefaultCommentFK

MasterNetworkIDInteger

Primary key identifier
MasterNetworkNameVarChar(255) Text name for the Master Network
SpatialReferenceNameCVVarChar(255) CV Term for a Spatial Reference system that describes the latitude and longitude coordinates

VerticalDatumCVVarChar(255) CV Term for a Vertical Datum that references where the elevation reported for the network nodes and links

DescriptionText

Text description of the MasterNetwork

Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_MasterNetworks_CV_SpatialReferenceCVs.CV_SpatialReferenceNetScen.MasterNetworksNameSpatialReferenceNameCV
fk_MasterNetworks_CV_VerticalDatumCVs.CV_ElevationDatumNetScen.MasterNetworksNameVerticalDatumCV

Triggers

(none)


Used in Diagrams

Diagram Name
01_WaMDaM
02_WaMDaM_WCVs