r_consolid

where case_number = "01-RC-018072"

✎ View and edit SQL

0 records

CREATE TABLE "r_consolid" (
   [case_number] TEXT REFERENCES [r_master]([case_number]),
   [consolidation_date] TEXT,
   [consol_id] INTEGER,
   [key_consol_case_reg] INTEGER,
   [key_consol_case_type] TEXT,
   [key_consol_case_docket] INTEGER,
   [key_consol_case_suffix] TEXT,
   [sub_consol_case_reg] TEXT,
   [sub_consol_case_type] TEXT,
   [sub_consol_case_docket] TEXT,
   [sub_consol_case_suffix] TEXT,
   [consolidation_type] TEXT,
   [consolidation_code] TEXT,
   [consolidation_stage] TEXT,
   [date_severed] TEXT,
   [severance_id] TEXT,
   [severance_type] TEXT,
   [severance_code] INTEGER,
   [severance_stage] INTEGER
);