Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Sidebar
model:location
Table of Contents
Table location
Remarks
A location corresponds to a site in Sigmah. An indicator needs a site in order to have a value. A site corresponds to a place in the world. These informations are set with the Google Maps panel and has some geographical coordinates.
Schema
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| locationid | integer | X | X | This is the primary key of the table. | |
| axe | character varying(50) | This column corresponds to the name of the nearest road or a waterway. | |||
| datecreated | timestamp(0) | This is the date of the creation of the location. | |||
| dateedited | timestamp(0) | This is the date of the last update of the location. | |||
| locationguid | character varying(36) | This is the Guid of the location. This column is not used in Sigmah. | |||
| name | character varying(50) | X | It corresponds to an human-readable name for the location. | ||
| x | double precision | This column is the abscissa of the geographical coordinates on Google Maps. | |||
| y | double precision | This column is the ordinate of the geographical coordinates on Google Maps. | |||
| locationtypeid | integer | X | locationtype(locationtypeid) | This is a foreign key to the table locationtype. |
Diagram
model/location.txt · Last modified: 2016/01/11 21:38 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
