CREATE TABLE ohs_action_signoffs (
    id SERIAL,
    item_id INTEGER NOT NULL,
    item_type VARCHAR(20) NOT NULL,
    user_id INTEGER NOT NULL,
    signature TEXT DEFAULT NULL,
    document_id INTEGER DEFAULT NULL,
    signed_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    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_action_signoffs_item_idx ON ohs_action_signoffs(item_id);
