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 table was used for giving permissions on a organizational unit for a user. But this table is now obsolete.
| 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. |