WaDE [WaDE_Schema_0.25.xml]
Defines the amount of water attributed to the entire allocation. If an allocation has diversions associated with it, then report this information for each diversion.
| 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 | |||||
| AMOUNT_VOLUME | VarChar(20) |
| The amount of water allocated for this allocation or diversion. | ||||
| UNIT_VOLUME | VarChar(20) |
| |||||
| AMOUNT_RATE | VarChar(20) |
| |||||
| UNIT_RATE | VarChar(20) |
| |||||
| SOURCE_TYPE | VarChar(20) |
| Water Source: Ground, Surface, Reuse, Total | ||||
| FRESH_SALINE_IND | VarChar(50) |
| |||||
| ALLOCATION_START | VarChar(20) |
| Starting date for the availability estimate, allocation, diversion, or use. Report as MM/DD. | ||||
| ALLOCATION_END | VarChar(20) |
| Ending date for the availability estimate, allocation, diversion, or use. Report as MM/DD. | ||||
| SOURCE_NAME | VarChar(20) |
| Name of the Aquifer for groundwater sources or river basin for surface water sources. |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_D_ALLOCATION_FLOW_DETAIL_ALLOCATION | DataValues.DETAIL_ALLOCATION | DataValues.D_ALLOCATION_FLOW | ORGANIZATION_ID, REPORT_ID, ALLOCATION_ID | ORGANIZATION_ID, REPORT_ID, ALLOCATION_ID |
(none)
| Diagram Name |
| WaDE_Schema |