ALTER TABLE ohs_jsas
    ADD COLUMN prepared_by INTEGER,
    ADD COLUMN team_member_ids JSON;

CREATE TABLE ohs_jsa_reviewers (
    id SERIAL,
    jsa_id INTEGER NOT NULL,
    user_id INTEGER NOT NULL,
    reviewed_at TIMESTAMP DEFAULT NULL,
    tenant_id INTEGER DEFAULT NULL,
    branch_id INTEGER DEFAULT NULL,
    isDeleted BOOLEAN NOT NULL DEFAULT FALSE,
    updatedAt TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (id)
);
CREATE INDEX ohs_jsa_reviewers_jsa_idx ON ohs_jsa_reviewers (jsa_id);
