User Tools

Site Tools


Sidebar

Table listing

Here is the list of all tables created in the database.

Clic on a table name for more informations.

model:locationadminlink

Table locationadminlink

Remarks

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.

Schema

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.

Diagram

model/locationadminlink.txt · Last modified: 2016/01/11 21:38 (external edit)