WaDE [WaDE_Schema_0.25.xml]
Metric measuring relative availability of water within this 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 |
|
||||
|
| ROW_SEQ | Integer | |||||
| METRIC_ID | Integer | Name of the metric |
|
||||
| METRIC_VALUE | VarChar(255) |
| Value of the metric for this reporting unit. Higher numbers should indicate more availability. | ||||
| METRIC_SCALE | VarChar(255) |
| Highest allowed value for the metric (i.e. '10' on a scale of 1-10) | ||||
| REVERSE_SCALE_IND | VarChar(255) |
| This should be marked with a 'Y' if the scale is reversed (i.e. higher numbers indicate less avaialbility) | ||||
| METHOD_ID | Integer | The name of the method used. | |||||
| START_DATE | DateTime |
| Starting date for the availability estimate, allocation, diversion, or use. Report as MM/DD. | ||||
| END_DATE | DateTime |
| Ending date for the availability estimate, allocation, diversion, or use. Report as MM/DD. |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_S_AVAILABILITY_METRIC_METRICS | Metadata.METRICS | DataValues.S_AVAILABILITY_METRIC | METRIC_ID | METRIC_ID |
| fk_S_AVAILABILITY_METRIC_SUMMARY_AVAILABILITY | DataValues.SUMMARY_AVAILABILITY | DataValues.S_AVAILABILITY_METRIC | ORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID, SUMMARY_SEQ | ORGANIZATION_ID, REPORT_ID, REPORT_UNIT_ID, SUMMARY_SEQ |
(none)
| Diagram Name |
| WaDE_Schema |