houston-be/db/migration/000007_add_rca_input_schema.up.sql

CREATE TABLE IF NOT EXISTS rca_input (
    id SERIAL PRIMARY KEY,
    incident_id integer NOT NULL REFERENCES incident(id),
    document_type character varying(100),
    identifier_keys text[] DEFAULT '{}'::text[],
    provider_name character varying(100),
    is_active boolean DEFAULT true,
    created_at timestamp without time zone,
    updated_at timestamp without time zone
);