CREATE index ON "CircuitCivilDefendant" (case_id);
CREATE index ON "CircuitCivilHearing" (case_id);
CREATE index ON "CircuitCivilPlaintiff" (case_id);
CREATE index ON "CircuitCivilPleading" (case_id);
CREATE index ON "CircuitCivilService" (case_id);

CREATE index ON "DistrictCivilDefendant" (case_id);
CREATE index ON "DistrictCivilHearing" (case_id);
CREATE index ON "DistrictCivilPlaintiff" (case_id);
CREATE index ON "DistrictCivilReport" (case_id);
CREATE index ON "DistrictCivilService" (case_id);

CREATE index ON "CircuitCriminalHearing" (case_id);
CREATE index ON "CircuitCriminalPleading" (case_id);
CREATE index ON "CircuitCriminalService" (case_id);

CREATE index ON "DistrictCriminalService" (case_id);
CREATE index ON "DistrictCriminalHearing" (case_id);