WaDE [WaDE_Schema_0.25.xml]
The Unit for which the Allocation or Estimate is being reported
| 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. |
|
|||
|
| REPORT_UNIT_ID | Integer | |||||
| REPRTING_UNIT_NAME | VarChar(20) | Name of the reporting unit | |||||
| REPORTING_UNIT_TYPE | VarChar(20) |
| |||||
| STATE | VarChar(50) |
| Code representing the two-digit abbreviation for the state. | ||||
| COUNTRY_FIPS | VarChar(20) |
| County FIPS code (including the state FIPS code) representing the county. | ||||
| HUC | VarChar(50) |
| 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. |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_REPORTING_UNIT_REPORT | Metadata.REPORT | DataValues.REPORTING_UNIT | ORGANIZATION_ID, REPORT_ID | ORGANIZATION_ID, REPORT_ID |
(none)
| Diagram Name |
| WaDE_Schema |