 REFERENCES hzrdi.parsed_source(id)
 ON DELETE CASCADE;
 
+-- idata.hazard_curve_progress to idata.lt_realization FK
+ALTER TABLE idata.hazard_curve_progress
+ADD CONSTRAINT idata_hazard_curve_progress_lt_realization_fk
+FOREIGN KEY (lt_realization_id)
+REFERENCES idata.lt_realization(id)
+ON DELETE CASCADE;
+
 -- idata.site_data to uiapi.hazard_calculation FK
 ALTER TABLE idata.site_data
 ADD CONSTRAINT idata_site_data_hazard_calculation_fk

REFERENCES uiapi.hazard_calculation(id)
ON DELETE CASCADE;

-- idata.lt_realization to uiapi.site_data FK
ALTER TABLE idata.lt_realization
ADD CONSTRAINT idata_lt_realization_site_data_fk
FOREIGN KEY (site_data_id)
REFERENCES idata.site_data(id)
ON DELETE RESTRICT;

-- idata.source_progress to idata.lt_realization FK
ALTER TABLE idata.source_progress
ADD CONSTRAINT idata_source_progress_lt_realization_fk

CREATE TABLE idata.lt_realization (
    id SERIAL PRIMARY KEY,
    hazard_calculation_id INTEGER NOT NULL,
    ordinal INTEGER NOT NULL,
    sm_lt_path VARCHAR NOT NULL,
    gsim_lt_path VARCHAR NOT NULL,
