   modifiedby userid,
   modified   TIMESTAMP,
 
-  CONSTRAINT PK_allowed_drugs PRIMARY KEY (id)
+  CONSTRAINT PK_drug_regimens PRIMARY KEY (id)
 );
 
 DROP TABLE IF EXISTS wnprc_compliance.drug_regimens_to_allowed_procedures;

DROP TABLE IF EXISTS wnprc_compliance.protocol_revisions;
CREATE TABLE wnprc_compliance.protocol_revisions (
  id TEXT,

  principal_investigator_id TEXT NOT NULL,
  spi_primary_id            TEXT NOT NULL,

  CONSTRAINT PK_surgery_info PRIMARY KEY (surgery_id)
);

DROP TABLE IF EXISTS wnprc_compliance.allowed_surgeries_to_drug_regimens;
CREATE TABLE wnprc_compliance.allowed_surgeries_to_drug_regimens (
  surgery_id TEXT,
  drug_regimen_id TEXT,
