dodil/erp-brick-timesheets

DODIL ERP brick: timesheets

src/brick_timesheets/migrations/00004_odoo_migration/up.sql

-- 00004_odoo_migration - slice B item 3: the Odoo slice (TS-22): a run (loaded -> reconciled -> signed | discarded) and the map of Odoo ids to our keys. Additive only.

CREATE TABLE IF NOT EXISTS ts_migration_map (
    odoo_db     VARCHAR NOT NULL,
    odoo_model  VARCHAR NOT NULL,
    odoo_id     VARCHAR NOT NULL,
    ours        VARCHAR,
    run_id      VARCHAR,
    created_at  TIMESTAMP,
    updated_at  TIMESTAMP,
    PRIMARY KEY (odoo_db, odoo_model, odoo_id)
);

CREATE TABLE IF NOT EXISTS ts_migration_run (
    run_id          VARCHAR NOT NULL,
    odoo_db         VARCHAR,
    cutover_date    DATE,
    company_code    VARCHAR,
    status          VARCHAR,
    doors_json      VARCHAR,
    checks_json     VARCHAR,
    summary_json    VARCHAR,
    loaded_by       VARCHAR,
    signed_by       VARCHAR,
    signed_sub      VARCHAR,
    signed_on       DATE,
    discarded_by    VARCHAR,
    discard_reason  VARCHAR,
    created_at      TIMESTAMP,
    updated_at      TIMESTAMP,
    PRIMARY KEY (run_id)
);