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:orgunitpermission

Table orgunitpermission

Remarks

This table was used for giving permissions on a organizational unit for a user. But this table is now obsolete.

Schema

Name Type Not Null Primary Key Foreign Key Remarks
:———:———:————-:—————-:—————-:————
id integer X X This is the primary key of the table.
editall bool X It indicates if the user can edit all informations in the organizational unit.
viewall bool X It indicates if the user can view all informations in the organizational unit.
unit_id integer X partner(partnerid) This is a foreign key to the table partner.
user_userid integer X userlogin(userid) This is a foreign key to the table userlogin.

Diagram

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