

Network:
  NetworkID
  NetworkName

Sites:
  SiteCode
  SiteName
  SiteID
  NetworkNam


SeriesCatalog:
  SiteCode
  SiteName
  VariableID
  BeginDateTime
  EndDateTime
  ValueCount

Variables:
  VariableID
  NetworkID
  VariableCode
  VariableName



Two sql lines showing examples as how those tables/views are used:

CheckAvailabilitySQL="SELECT DISTINCT SiteCode,SiteName,VariableID,BeginDateTime,EndDateTime,ValueCount FROM SeriesCatalog WHERE (VariableID IN (SELECT VariableID FROM Variables WHERE (networkId = @networkId) AND (VariableCode = @variableCode)))"
QueryVariables_SQLQUERY_NETWORK_VARIABLES  = "SELECT distinct VariableCode, VariableName FROM Variables WHERE VariableCode IS NOT NULL AND VariableName IS NOT NULL AND networkId =@networkId ORDER BY VariableName"
  
