WaDE [WaDE_Schema_0.25.xml]
Header for the Geospatial Information related to the 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. |
|
|||
| WFS_ID | Integer | |||||
WFS_DATACATEGORY | VarChar(20) |
| |||||
WFS_DATATYPE | VarChar(20) |
| A reference to what type of summary or detailed data are represented by the web feature service. | ||||
WFS_ADDRESS | VarChar(50) |
| The web feature service URL address. | ||||
WFS_FEATURE_ID_FIELD | VarChar(20) |
| The column or field that contains a unique identifier for the features in the web feature service. |
(none)
Name | Parent Table | Child Table | Parent Columns | Child Columns |
fk_GEOSPATIAL_REF_REPORT | Metadata.REPORT | Metadata.GEOSPATIAL_REF | ORGANIZATION_ID, REPORT_ID | ORGANIZATION_ID, REPORT_ID |
(none)
Diagram Name |
WaDE_Schema |