WaDE [WaDE_Schema_0.25.xml]
Additional Metadata for irrigation water supply uses
| 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 |
|
||||
|
| IRRIGATION_SEQ | Integer | |||||
| IRRIGATION_METHOD | VarChar(50) |
| Name of the method used to irrigate (i.e. sprinkler, flood, microirrigation, etc.) | ||||
| ACRES_IRRIGATED | VarChar(50) |
| Number of acres irrigated using this method. | ||||
| CROP_TYPE | VarChar(20) |
|
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_S_ALLOCATION_IRRIGATION_SUMMARY_ALLOCATION | DataValues.SUMMARY_ALLOCATION | DataValues.S_ALLOCATION_IRRIGATION | ORGANIZATION_ID, REPORT_UNIT_ID, REPORT_ID, SUMMARY_SEQ | ORGANIZATION_ID, REPORT_UNIT_ID, REPORT_ID, SUMMARY_SEQ |
(none)
| Diagram Name |
| WaDE_Schema |