D_THERMOELECTRIC - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: D_THERMOELECTRIC

Additional Metadata for thermoelectric water supply uses.

Columns

PKNameData TypeNULLAutoDefaultCommentFK

ORGANIZATION_IDInteger A unique identifier assigned to the organization. Identifiers would be managed centrally by ????

REPORT_IDInteger A unique identifier assigned to the report by the reporting organization.

ALLOCATION_IDInteger Unique identifier for the allocation

WATER_USER_IDInteger A unique identifier for the water user

BENEFICIAL_USE_IDInteger Owner for the use type (i.e. state abbreviation)

DETAIL_SEQ_NOInteger
GENERATOR_TYPEVarChar(20) The type of generator used to create electricity.
POWER_CAPACITYVarChar(20) The amount of power capacity in megawatt-hours.

Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_D_THERMOELECTRIC_D_CONSUMPTIVE_USEDataValues.D_CONSUMPTIVE_USEDataValues.D_THERMOELECTRICORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, WATER_USER_ID, BENEFICIAL_USE_IDORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, WATER_USER_ID, BENEFICIAL_USE_ID

Triggers

(none)


Used in Diagrams

Diagram Name
WaDE_Schema