WaDE2.0 [WaDE2.01.xml]
| PK | Name | Data Type | NULL | Auto | Default | Comment | FK |
|
| PODSitePOUSiteFactID | Integer | |||||
| PODSiteID | BigInt |
| Primary internal key unique identifier for POD site records from the site table. |
|
|||
| POUSiteID | BigInt |
| Primary internal key unique identifier for POU site records from the site table. |
|
|||
| StartDate | Date | Start date when the water right can legally access the assigned water. Format of MM/DD. | |||||
| EndDate | Date | End date when the water right no longer can legally access the assigned water. Format of MM/DD. |
(none)
| Name | Parent Table | Child Table | Parent Columns | Child Columns |
| fk_PODSite_POUSite_fact_Sites_dim_POD | Core.Sites_dim | Core.PODSite_POUSite_fact | SiteID | PODSiteID |
| fk_PODSite_POUSite_fact_Sites_dim_POU | Core.Sites_dim | Core.PODSite_POUSite_fact | SiteID | POUSiteID |
(none)
| Diagram Name |
| 2_SiteSpecificAmounts |