CREATE UNIQUE INDEX idx_assignment_no ON assignments(assignment_no);
CREATE INDEX idx_assignment_details_assignment_id ON assignment_details(assignment_id);


CREATE INDEX idx_assignment_status ON assignments(assignment_status_id, deleted);
CREATE INDEX idx_assignment_details_assignment_id ON assignment_details(assignment_id);

CREATE INDEX idx_completed ON assignments(assignment_status_id, deleted, submit_date);