WaDE [WaDE_Schema_0.25.xml]
Detailed, site specific information on water allocations, diversions, use, and return flows.
| 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 | ||||
| ALLOCATION_OWNER | VarChar(50) |
| Name of the entity with the allocation | ||||
| APPLICATION_DATE | DateTime |
| The date on which the water right was applied for. | ||||
| PRIORITY_DATE | DateTime |
| The priority date for the water right. | ||||
| LEGAL_STATUS | VarChar(50) |
| The legal status of the water right (i.e. is it a proven right, perfected, or being adjudicated, etc.) | ||||
| END_DATE | DateTime |
| For temporary water rights, the end date for the water right. |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_DETAIL_ALLOCATION_REPORT | Metadata.REPORT | DataValues.DETAIL_ALLOCATION | ORGANIZATION_ID, REPORT_ID | ORGANIZATION_ID, REPORT_ID |
(none)
| Diagram Name |
| WaDE_Schema |