r_formal1

where case_number = "01-RC-018058"

✎ View and edit SQL

0 records

CREATE TABLE "r_formal1" (
   [case_number] TEXT REFERENCES [r_master]([case_number]),
   [rf1_date] TEXT,
   [date_last_action] TEXT,
   [consol_code] TEXT,
   [code_date_hearing_close] TEXT,
   [date_hearing_close] TEXT,
   [control] INTEGER,
   [update_control] INTEGER,
   [date_dec_issued] TEXT,
   [unit] TEXT,
   [type_dec] TEXT,
   [type_specl_elect] TEXT,
   [date_waiver] TEXT,
   [date_req_review] TEXT,
   [party_filing] TEXT,
   [date_ruling_reg] TEXT,
   [ruling_control] TEXT,
   [date_board_dec_req] TEXT,
   [board_dec] TEXT,
   [type_board_dec] TEXT,
   [board_unit] TEXT,
   [volume_number] TEXT,
   [issue_number] TEXT,
   [board_members_5] TEXT,
   [chips_amended_code] TEXT,
   FOREIGN KEY([unit]) REFERENCES [l_unit_codes]([code])
);