GEOSPATIAL_REF - Table
HomeTablesSchemasDiagramsForeign KeysIndexes

Table: GEOSPATIAL_REF

Header for the Geospatial Information related to the report.

Columns

PKNameData TypeNULLAutoDefaultCommentFK

ORGANIZATION_IDInteger A unique identifier assigned to the organization. Identifiers would be managed centrally by ????

REPORT_IDInteger A unique identifier assigned to the report by the reporting organization.

WFS_IDInteger
WFS_DATACATEGORYVarChar(20)

WFS_DATATYPEVarChar(20)

A reference to what type of summary or detailed data are represented by the web feature service.
WFS_ADDRESSVarChar(50)

The web feature service URL address.
WFS_FEATURE_ID_FIELDVarChar(20)

The column or field that contains a unique identifier for the features in the web feature service.

Indexes

(none)


Foreign Keys

NameParent TableChild TableParent ColumnsChild Columns
fk_GEOSPATIAL_REF_REPORTMetadata.REPORTMetadata.GEOSPATIAL_REFORGANIZATION_ID, REPORT_IDORGANIZATION_ID, REPORT_ID

Triggers

(none)


Used in Diagrams

Diagram Name
WaDE_Schema