Table descriptions

locations - stores the location names and their hierachy

  • loc_uuid references itself

location_details - provides additional details on the locations with reference to another entity

  • links another UUID (person, camp, etc) to the location and how they are related

landmark_location - stores landmarks and its relations

  • Stores uuid, other details
  • stores landmark type

gis_location - Base table for basic GIS coordinates store

  • Stores gis_uuid
  • Mapping between gis_uuid,location_id and entity poc_uuid
  • Stores coordinates, projections
  • API: to store coordinates in table, use the following under mod/gis/gis_fns.inc

shn_gis_dbinsert($uuid,$loc_id,$gis,$xcoord,$ycoord,$projection) gis_wiki

  • Stores Wikimaps details
  • Maps wiki_uuid to gis_uuid

Relationships

Constraints / Data Integrity conditions


Navigation
QR Code
QR Code sql:location (generated for current page)