Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Sidebar
model:adminlevel
Table of Contents
Table adminlevel
Remarks
An adminlevel corresponds to a hierarchy of locationtype related to a country.
Schema
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| adminlevelid | integer | X | X | This is the primary key of the table. | |
| allowadd | bool | X | This column indicates if the current entry can have some children or if it is a leaf node in computer science language. | ||
| name | character varying(30) | X | This is the human-readable name of the adminlevel. | ||
| countryid | integer | X | country(countryid) | This is a foreign key to the table country. | |
| parentid | integer | X | adminlevel(adminlevelid) | It corresponds to the parent of the adminlevel in the hierarchical tree. |
Diagram
model/adminlevel.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
