WaDE [WaDE_Schema_0.25.xml]
The amount and location of water returned
| 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 |
|
|||
|
| RETURN_FLOW_ID | Integer | Unique identifier for the return flow. | ||||
| RETURN_FLOW_NAME | VarChar(20) |
| Name for the return flow. | ||||
| STATE | VarChar(20) |
| Code representing the two-digit abbreviation for the state. | ||||
| REPORTING_UNIT_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) |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_DETAIL_RETURN_FLOW_DETAIL_ALLOCATION | DataValues.DETAIL_ALLOCATION | DataValues.DETAIL_RETURN_FLOW | ORGANIZATION_ID, REPORT_ID, ALLOCATION_ID | ORGANIZATION_ID, REPORT_ID, ALLOCATION_ID |
(none)
| Diagram Name |
| WaDE_Schema |