WaDE [WaDE_Schema_0.25.xml]
Summary of regulatory status for the reporting unit.
| 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 |
|
||||
|
| SUMMARY_SEQ | Integer | |||||
| REGULATORY_TYPE | VarChar(20) |
| A Description of the restriction on water use in the reporting unit. | ||||
| REGULATORY_STATUS | VarChar(20) |
| Descrption of the regulatory status in the reporting unit (i.e. open, closed, partial, etc.) | ||||
| OVERSIGHT_AGENCY | VarChar(20) |
| Name of the special management district or oversight committee/basin group. | ||||
| REGULATORY_DESCRIPTION | Text |
| Description of the regulatory restriction. | ||||
| WFS_FEATURE_REF | VarChar(50) |
| Web Feature Service feature reference for the regulatory summary |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_SUMMARY_REGULATORY_REPORTING_UNIT | DataValues.REPORTING_UNIT | DataValues.SUMMARY_REGULATORY | ORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID | ORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID |
(none)
| Diagram Name |
| WaDE_Schema |