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.
A project is formed by several phases. A phase is created with a model which defines how the configuration of the phase.
Name | Type | Not Null | Primary Key | Foreign Key | Remarks |
:——— | :——— | :————- | :—————- | :—————- | :———— |
id_phase | bigint | X | X | This is the primary key of the table. | |
end_date | timestamp(0) | This is the date the phase should be ended. | |||
start_date | timestamp(0) | This is the date the phase should be started. | |||
id_phase_model | bigint | X | phase\_model(id_phase_model) | This is a foreign key to the table phase_model. | |
id_project | integer | X | project(databaseid) | This is a foreign key to the table project. |