WaDE [WaDE_Schema_0.25.xml]
Description of the location for the diverted water.
| 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. | ||||
| DIVERSION_NAME | VarChar(20) |
| Name for the diversion. | ||||
| STATE | VarChar(20) |
| Code representing the two-digit abbreviation for the state. | ||||
| REPORTING_UINT_ID | Integer |
| A unique identifier assigned to the reporting unit by the reporting organization. | ||||
| COUNTY_FIPS | VarChar(20) |
| County FIPS code (including the state FIPS code) representing the county. | ||||
| HUC | VarChar(20) |
| Code representing the USGS Hydrologic Unit (or HUC) at the most detailed level that the assignment can be made (6-digit being the lowest level of resolution allowed). Leading 0's should be included. | ||||
| WFS_FETURE_REF | VarChar(20) |
| Web Feature Service feature reference for the point of diversion |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_DETAIL_DIVERSION_DETAIL_ALLOCATION | DataValues.DETAIL_ALLOCATION | DataValues.DETAIL_DIVERSION | ORGANIZATION_ID, REPORT_ID, ALLOCATION_ID | ORGANIZATION_ID, REPORT_ID, ALLOCATION_ID |
(none)
| Diagram Name |
| WaDE_Schema |