dodil/erp-brick-time-off

DODIL ERP brick: time off

src/brick_time_off/migrations/00006_family_leave/up.sql

-- 00006_family_leave - slice B item 6: the statutory facts of a family leave (TOF-09). Additive only.

CREATE TABLE IF NOT EXISTS tof_family_leave (
    request_id            VARCHAR NOT NULL,
    person_id             BIGINT,
    company_code          VARCHAR,
    leave_type_code       VARCHAR,
    ewc                   DATE,
    evidence_received_on  DATE,
    weeks                 INTEGER,
    recorded_by           VARCHAR,
    recorded_sub          VARCHAR,
    created_at            TIMESTAMP,
    updated_at            TIMESTAMP,
    PRIMARY KEY (request_id)
);