Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Sidebar
model:partner
Table of Contents
Table partner
Remarks
A partner is another word for organizational unit (concise to org unit in several columns or tables in the database). It corresponds to a headquarter or a center of the NGO related.
Schema
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| partnerid | integer | X | X | This is the primary key of the table. | |
| calendarid | integer | This is a hidden foreign key to the table personalcalendar. It corresponds to a calendar which have events visible to all users wich belongs to the NGO related. | |||
| deleted | timestamp(0) | This is the date the organizational unit was deleted. | |||
| fullname | character varying(64) | This is a human readable name for the organizational unit. | |||
| name | character varying(16) | X | This is a short name for the organizational unit. | ||
| planned_budget | double precision | It corrersponds to the planned budget that will be given to this organizational unit. | |||
| received_budget | double precision | It corresponds to the received budget for the organizational unit. | |||
| spend_budget | double precision | It corresponds to the spent budget for the organizational unit. | |||
| location_locationid | integer | location(locationid) | This is a foreign key to the table location. It corresponds to the location of this organizational unit. | ||
| office_country_id | integer | country(countryid) | This is a foreign key to the table country. It corresponds to the country of the location of the organizational unit. | ||
| id_org_unit_model | integer | org\_unit\_model(org_unit_model_id) | This is a foreign key to the table org_unit_model. it corresponds to the model of the organizational unit. | ||
| organization_id_organization | integer | organization(id_organization) | This is a foreign key to the table organization. | ||
| parent_partnerid | integer | X | partner(partnerid) | This is a foreign key to the table partner. Indeed, an organizational unit can be managed by other organizational units. |
Diagram
model/partner.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
