WaDE [WaDE_Schema_0.25.xml]
The actual amount of water diverted at this diversion for the reporting period.
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| ORGANIZATION_ID | Integer | A unique identifier assigned to the organization. Identifiers would be managed centrally by ???? |
|
|||
|
| REPORT_ID | Integer | A unique identifier assigned to the report by the reporting organization. |
|
|||
|
| ALLOCATION_ID | Integer | Unique identifier for the allocation |
|
|||
|
| DIVERSION_ID | Integer | Unique identifier for the diversion within this allocation. |
|
|||
|
| DETAIL_SEQ_NO | Integer |
|
||||
|
| ACTUAL_SEQ_NO | Integer | |||||
| AMOUNT_VOLUME | Float |
| |||||
| UNIT_VOLUME | Float |
| |||||
| VALUE_TYPE_VOLUME | Float |
| Indicator on how the actual amount was determined (i.e. calculated, measured, estimated, or reported). | ||||
| METHOD_ID_VOLUME | Float |
| |||||
| AMOUNT_RATE | Float |
| |||||
| UNIT_RATE | Float |
| |||||
| VALUE_TYPE_RATE | Float |
| |||||
| METHOD_ID_RATE | Float |
| |||||
| START_DATE | DateTime |
| Starting date for the availability estimate, allocation, diversion, or use. Report as MM/DD. | ||||
| END_DATE | DateTime |
| Ending date for the availability estimate, allocation, diversion, or use. Report as MM/DD. |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_D_DIVERSION_ACTUAL_D_DIVERSION_FLOW | DataValues.D_DIVERSION_FLOW | DataValues.D_DIVERSION_ACTUAL | ORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, DIVERSION_ID, DETAIL_SEQ_NO | ORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, DIVERSION_ID, DETAIL_SEQ_NO |
(none)
| Diagram Name |
| WaDE_Schema |