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. |