dodil/erp-brick-time-off

DODIL ERP brick: time off

src/brick_time_off/migrations/00003_sickness/up.sql

-- 00003_sickness - slice B item 2: sickness spells (TOF-07/08) and the evidence behind them (fit notes). Additive only.

CREATE TABLE IF NOT EXISTS tof_sickness (
    absence_id          VARCHAR NOT NULL,
    person_id           BIGINT,
    company_code        VARCHAR,
    first_day           DATE,
    expected_return     DATE,
    last_day_off        DATE,
    unit                VARCHAR,
    status              VARCHAR,
    revision            INTEGER,
    reason_detail       VARCHAR,
    self_certified      BOOLEAN,
    evidence_ok         BOOLEAN,
    recorded_by         VARCHAR,
    recorded_sub        VARCHAR,
    person_email        VARCHAR,
    person_sub          VARCHAR,
    approver_person_id  BIGINT,
    approver_email      VARCHAR,
    approver_sub        VARCHAR,
    confirmed_by        VARCHAR,
    confirmed_sub       VARCHAR,
    void_reason         VARCHAR,
    qualifying_days     INTEGER,
    piw                 BOOLEAN,
    linked_to           VARCHAR,
    linked_group        VARCHAR,
    changed_at          TIMESTAMP,
    created_at          TIMESTAMP,
    updated_at          TIMESTAMP,
    PRIMARY KEY (absence_id)
);

CREATE TABLE IF NOT EXISTS tof_evidence (
    object_key    VARCHAR NOT NULL,
    absence_ref   VARCHAR,
    kind          VARCHAR,
    covers_from   DATE,
    covers_to     DATE,
    sha256        VARCHAR,
    content_type  VARCHAR,
    size_bytes    INTEGER,
    uploaded_by   VARCHAR,
    uploaded_sub  VARCHAR,
    uploaded_at   TIMESTAMP,
    retain_until  DATE,
    created_at    TIMESTAMP,
    updated_at    TIMESTAMP,
    PRIMARY KEY (object_key)
);