dodil/erp-brick-time-off

DODIL ERP brick: time off

src/brick_time_off/migrations/00004_closures_and_adjustments/up.sql

-- 00004_closures_and_adjustments - slice B item 4: company closure days (TOF-13) and manual adjustments with a second person (TOF-12). Additive only.

CREATE TABLE IF NOT EXISTS tof_closure_day (
    company_code     VARCHAR NOT NULL,
    closure_date     DATE NOT NULL,
    name             VARCHAR,
    leave_type_code  VARCHAR,
    published_by     VARCHAR,
    published_sub    VARCHAR,
    published_at     TIMESTAMP,
    created_at       TIMESTAMP,
    updated_at       TIMESTAMP,
    PRIMARY KEY (company_code, closure_date)
);

CREATE TABLE IF NOT EXISTS tof_adjustment (
    adjustment_id    VARCHAR NOT NULL,
    person_id        BIGINT,
    company_code     VARCHAR,
    leave_type_code  VARCHAR,
    leave_year       INTEGER,
    quantity         NUMERIC(19,4),
    unit             VARCHAR,
    on_date          DATE,
    reason           VARCHAR,
    proposed_by      VARCHAR,
    proposed_sub     VARCHAR,
    status           VARCHAR,
    decided_by       VARCHAR,
    decided_sub      VARCHAR,
    decided_at       TIMESTAMP,
    decision_reason  VARCHAR,
    created_at       TIMESTAMP,
    updated_at       TIMESTAMP,
    PRIMARY KEY (adjustment_id)
);