This table is an extension of the table Project. These tables are not merged in order to not touch to the ActivityInfo datamodel.
| Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
| :——— | :——— | :————- | :—————- | :—————- | :———— |
| databaseid | integer | X | X | This is the primary key of the table and also a foreign key on the table Project which is its parent table. | |
| datedeleted | timestamp(0) | This is the date of the removal of the project. | |||
| fullname | character varying(500) | This is the name of the project. | |||
| lastschemaupdate | timestamp(0) | X | This is the date of the last update on a field of the project | ||
| name | character varying(16) | X | This column corresponds to the short name of the project. | ||
| startdate | date | It corresponds to the date of the start of the project. | |||
| countryid | integer | X | country(countryid) | ||
| owneruserid | integer | X | userlogin(userid) |