Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Sidebar
model:organization
Table of Contents
Table organization
Remarks
This table contains information about the organizations which used Sigmah.
Schema
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| id_organization | integer | X | X | This is the primary key of the table. | |
| logo | text | This is the relative path of the logo of the organization. | |||
| name | text | X | This is the name of the NGO. | ||
| id_root_org_unit | integer | X | partner(partnerid) | This is a foreign key to the table partner. It corresponds to the main organizational unit (or also the headquarter) of this NGO. |
Diagram
model/organization.txt · Last modified: 2016/01/11 21:38 (external edit)
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Share Alike 4.0 International
