CREATE TABLE fases (
    id                  bigint NOT NULL,
    descricao           VARCHAR2(100) NOT NULL,
    situacao            SMALLINT DEFAULT 1 NOT NULL,
    descricao_detalhada VARCHAR2(500),
    cor_id              bigint
);

ALTER TABLE fases
    ADD CHECK ( situacao IN ( 0, 1 ) );

CREATE INDEX fases_descricao ON
    fases (
        descricao
    ASC );