r_transfer_history

CREATE TABLE "r_transfer_history" (
   [r_case_number] TEXT REFERENCES [r_case]([r_case_number]),
   [history_date] TEXT,
   [sequence] INTEGER,
   [date_data_received] TEXT,
   [request_date] TEXT,
   [reason_transfer] TEXT REFERENCES [l_r_reason_transfer]([reason_transfer]),
   [transfer_type] TEXT REFERENCES [l_r_transfer_type]([transfer_type]),
   [transfer_order_date] TEXT,
   [new_case_number] TEXT REFERENCES [r_case]([r_case_number]),
   [former_case_number] TEXT,
   [sent_date] TEXT,
   [received_date] TEXT
);
CREATE INDEX [idx_r_transfer_history_new_case_number]
    ON [r_transfer_history] ([new_case_number]);
CREATE INDEX [idx_r_transfer_history_transfer_type]
    ON [r_transfer_history] ([transfer_type]);
CREATE INDEX [idx_r_transfer_history_reason_transfer]
    ON [r_transfer_history] ([reason_transfer]);
CREATE INDEX [idx_r_transfer_history_r_case_number]
    ON [r_transfer_history] ([r_case_number]);