Table listing
Here is the list of all tables created in the database.
Clic on a table name for more informations.
Sidebar
model:org_unit_model
Table of Contents
Table org\_unit\_model
Remarks
An org unit model is a model of organizational unit. An organizational unit belongs to a model created before it. A model can be used by an infinite number of organizational units.
Schema
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| org_unit_model_id | integer | X | X | This is the primary key of the table. | |
| can_contain_projects | bool | X | It indicates if the organizational units created with this model can contain projects. | ||
| has_budget | bool | It indicates if an organizational unit has a budget. | |||
| name | character varying(8192) | X | This is a human readable name for the org_unit_model. | ||
| status | character varying(255) | X | This is the state of the org unit model. It corresponds to a Java enumeration (DRAFT, READY, USED or UNAVAILABLE). | ||
| title | character varying(8192) | X | It is the type (also a short name) of the organizational unit. | ||
| id_organization | integer | organization(id_organization) | This is a foreign key to the table organization. The organizational unit belongs to the organization related. |
Diagram
model/org_unit_model.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
