WaDE [WaDE_Schema_0.25.xml]
Header for the water summary or water detail report.
| 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_DATE | DateTime |
| Date on which the report was created. | ||||
| REPRTING_YEAR | VarChar(10) |
| Reporting year (calendar year) for which the report represents. | ||||
| REPORT_NAME | VarChar(50) |
| Name of the report | ||||
| REPORT_LINK | VarChar(50) |
| Link to the PDF or web page for the narrative report that contains the information. | ||||
| YEAR_TYPE | VarChar(20) |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_REPORT_ORGANIZATION | Metadata.ORGANIZATION | Metadata.REPORT | ORGANIZATION_ID | ORGANIZATION_ID |
(none)
| Diagram Name |
| WaDE_Schema |