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 |
|
||||
| DETAIL_SEQ_NO | Integer |
|
|||||
| ACTUAL_SEQ_NO | Integer | ||||||
| AMOUNT_VOLUME | Float |
| The actual amount of water diverted at this diversion for the reporting period. | ||||
| UNIT_VOLUME | Float |
| |||||
| VALUE_TYPE_VOLUME | Float |
| |||||
| 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_ALLOCATION_ACTUAL_D_ALLOCATION_FLOW | DataValues.D_ALLOCATION_FLOW | DataValues.D_ALLOCATION_ACTUAL | ORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, DETAIL_SEQ_NO | ORGANIZATION_ID, REPORT_ID, ALLOCATION_ID, DETAIL_SEQ_NO |
(none)
| Diagram Name |
| WaDE_Schema |