Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Here is the list of all tables created in the database.
Clic on a table name for more informations.
This is an association table between the table AdminEntity and the table Location. A location can belong to several administraive entities and an administrative entity can have several locations.
The primary key of the table is formed by both columns of the table.
Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
:——— | :——— | :————- | :—————- | :—————- | :———— |
locationid | integer | X | X | location(locationid) | This is a foreign key to the table Location. |
adminentityid | integer | X | X | adminentity(adminentityid) | This is a foreign key to the table adminentity. |