D_DIVERSION_USE - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: D_DIVERSION_USE

Beneficial use for which the water is used.

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

DIVERSION_IDInteger Unique identifier for the diversion within this allocation.

DETAIL_SEQ_NOInteger

BENEFICIAL_USE_IDInteger

Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_D_DIVERSION_USE_D_DIVERSION_FLOWDataValues.D_DIVERSION_FLOWDataValues.D_DIVERSION_USEORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, DIVERSION_ID, DETAIL_SEQ_NOORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, DIVERSION_ID, DETAIL_SEQ_NO

Triggers

(none)


Used in Diagrams

Diagram Name
WaDE_Schema