Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Sidebar
model:adminentity
Table of Contents
Table adminentity
Remarks
An adminentity corresponds to an administrative entity. These entities are created in order to split a country in administratrive areas. It could be use to localizing a site within an administrative area and on what an indicator is about.
This table has coords in order to know where it is localised and its area.
Schema
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| adminentityid | integer | X | X | This is the primary key of the table. | |
| x1 | double precision | The first abscissa of the area coords. | |||
| x2 | double precision | The second abscissa of the area coords. | |||
| y1 | double precision | The first ordinate of the area coords. | |||
| y2 | double precision | The second ordinate of the area coords. | |||
| code | character varying(15) | This is a short name for the administrative entity. | |||
| name | character varying(50) | X | This is an human readable name for the administrative entity. | ||
| soundex | character varying(50) | This is the soundex corresponding to the name of the administrative entity. | |||
| adminlevelid | integer | X | adminlevel(adminlevelid) | This is a foreign key to the table adminlevel. | |
| adminentityparentid | integer | X | adminentity(adminentityid) | This is a foreign key to the table adminentity. It corresponds to the administrative entity which is its parent. |
Diagram
model/adminentity.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
