Table of Contents

Table phase

Remarks

A project is formed by several phases. A phase is created with a model which defines how the configuration of the phase.

Schema

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.

Diagram