gps_location
EntityType Dependent
Logical Entity Name gps_location
Default Table Name gps_location
Definition
Note

gps_location Attributes
Attribute/Logical Rolename Domain Datatype NULL Definition
geo_db_site(PK)(FK) CHAR(16) NO
geo_db_id(PK)(FK) UNSIGNEDINT NO
geo_position_id(PK)(FK) UNSIGNEDINT NO
ordering_sequence(PK) UNSIGNEDINT NO
latitude DOUBLE NO
longitude DOUBLE NO
elevation DOUBLE NO
datum_db_site(FK) CHAR(16) NO
datum_db_id(FK) UNSIGNEDINT NO
datum_type_code(FK) UNSIGNEDINT NO
precision_db_site(FK) CHAR(16) NO
precision_db_id(FK) UNSIGNEDINT NO
precision_type_code(FK) UNSIGNEDINT NO
elevation_db_site(FK) CHAR(16) NO
elevation_db_id(FK) UNSIGNEDINT NO
elevation_type_code(FK) UNSIGNEDINT NO
gmt_last_updated DATETIME(19:29) YES
last_upd_db_site(FK) CHAR(16) YES
last_upd_db_id(FK) UNSIGNEDINT YES
rstat_type_code(FK) SHORT YES

gps_location Keys
Key Name Key Type Keys
PK__gps_location__36D11DD4 PrimaryKey geo_db_site,geo_db_id,geo_position_id,ordering_sequence

gps_location Relationships
Parent Entity Child Entity Type Foreign Keys
row_status_type gps_location Non-Identifying rstat_type_code
geo_position gps_location Identifying geo_db_site,geo_db_id,geo_position_id
gps_datum_type gps_location Non-Identifying datum_db_site,datum_db_id,datum_type_code
gps_precision_type gps_location Non-Identifying precision_db_site,precision_db_id,precision_type_code
gps_elevation_type gps_location Non-Identifying elevation_db_site,elevation_db_id,elevation_type_code
site_database gps_location Non-Identifying last_upd_db_site,last_upd_db_id