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) NUMERIC(10, 0) NO
geo_position_id(PK)(FK) NUMERIC(10, 0) NO
ordering_sequence(PK) NUMERIC(10, 0) NO
latitude FLOAT NO
longitude FLOAT NO
elevation FLOAT YES
datum_db_site(FK) CHAR(16) NO
datum_db_id(FK) NUMERIC(10, 0) NO
datum_type_code(FK) NUMERIC(10, 0) NO
precision_db_site(FK) CHAR(16) NO
precision_db_id(FK) NUMERIC(10, 0) NO
precision_type_code(FK) NUMERIC(10, 0) NO
elevation_db_site(FK) CHAR(16) NO
elevation_db_id(FK) NUMERIC(10, 0) NO
elevation_type_code(FK) NUMERIC(10, 0) NO
gmt_last_updated TIMESTAMP/DATE YES
last_upd_db_site(FK) CHAR(16) YES
last_upd_db_id(FK) NUMERIC(10, 0) YES
rstat_type_code(FK) NUMERIC(5, 0) YES

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

gps_location Relationships
Parent Entity Child Entity Type Foreign Keys
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
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_location Attachments
Name Datatype Value Override Default Value Description