--------------------------------------------------------
--  File created - Friday-September-13-2019   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table RBLINKEDPROTOCOLS
--------------------------------------------------------

  CREATE TABLE "RBLINKEDPROTOCOLS" 
   (	"SUMMARIZED_RECBIO_PROTID" NUMBER(9,0), 
	"RECBIO_PROTID" NUMBER(9,0), 
	"TO_SUMMARIZE" NUMBER(1,0), 
	"REPLICATE_NUMBER_FIELDCOL" VARCHAR2(12)
   ) ;

   COMMENT ON COLUMN "RBLINKEDPROTOCOLS"."SUMMARIZED_RECBIO_PROTID" IS 'Summary protocol id';
   COMMENT ON COLUMN "RBLINKEDPROTOCOLS"."RECBIO_PROTID" IS 'Associated raw protocol id';
   COMMENT ON COLUMN "RBLINKEDPROTOCOLS"."TO_SUMMARIZE" IS 'Active flag';
   COMMENT ON COLUMN "RBLINKEDPROTOCOLS"."REPLICATE_NUMBER_FIELDCOL" IS 'Column to store replication count';
/
--------------------------------------------------------
--  DDL for Index SYS_C0017487
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0017487" ON "RBLINKEDPROTOCOLS" ("SUMMARIZED_RECBIO_PROTID") 
  ;
/
--------------------------------------------------------
--  DDL for Index XAK1RBLINKEDPROTOCOLS
--------------------------------------------------------

  CREATE UNIQUE INDEX "XAK1RBLINKEDPROTOCOLS" ON "RBLINKEDPROTOCOLS" ("RECBIO_PROTID") 
  ;
/
--------------------------------------------------------
--  Constraints for Table RBLINKEDPROTOCOLS
--------------------------------------------------------

  ALTER TABLE "RBLINKEDPROTOCOLS" ADD CONSTRAINT "UK_PROTID" UNIQUE ("RECBIO_PROTID")
  USING INDEX (CREATE UNIQUE INDEX "XAK1RBLINKEDPROTOCOLS" ON "RBLINKEDPROTOCOLS" ("RECBIO_PROTID") 
  )  ENABLE;
  ALTER TABLE "RBLINKEDPROTOCOLS" ADD PRIMARY KEY ("SUMMARIZED_RECBIO_PROTID")
  USING INDEX  ENABLE;
  ALTER TABLE "RBLINKEDPROTOCOLS" MODIFY ("RECBIO_PROTID" NOT NULL ENABLE);
  ALTER TABLE "RBLINKEDPROTOCOLS" MODIFY ("SUMMARIZED_RECBIO_PROTID" NOT NULL ENABLE);
/
--------------------------------------------------------
--  Ref Constraints for Table RBLINKEDPROTOCOLS
--------------------------------------------------------

  ALTER TABLE "RBLINKEDPROTOCOLS" ADD CONSTRAINT "FK_PROTID" FOREIGN KEY ("RECBIO_PROTID")
	  REFERENCES "PROTOCOL" ("PROTID") ENABLE;
  ALTER TABLE "RBLINKEDPROTOCOLS" ADD CONSTRAINT "FK_SUMARIZED_PROTID" FOREIGN KEY ("SUMMARIZED_RECBIO_PROTID")
	  REFERENCES "PROTOCOL" ("PROTID") ENABLE;
/

--------------------------------------------------------
--  File created - Friday-September-13-2019   
--------------------------------------------------------
--------------------------------------------------------
--  DDL for Table RBLINKEDVARIABLES
--------------------------------------------------------

  CREATE TABLE "RBLINKEDVARIABLES" 
   (	"RECBIO_PROTID" NUMBER(9,0), 
	"FIELDCOL" VARCHAR2(12), 
	"TO_SUMMARIZE" NUMBER(1,0), 
	"SUMMARY_FIELDCOL" VARCHAR2(12)
   ) ;

   COMMENT ON COLUMN "RBLINKEDVARIABLES"."RECBIO_PROTID" IS 'Raw Protocol ID';
   COMMENT ON COLUMN "RBLINKEDVARIABLES"."FIELDCOL" IS 'Column to summarize (source)';
   COMMENT ON COLUMN "RBLINKEDVARIABLES"."TO_SUMMARIZE" IS 'Summarize flag';
   COMMENT ON COLUMN "RBLINKEDVARIABLES"."SUMMARY_FIELDCOL" IS 'Summarized column destination';
/
--------------------------------------------------------
--  DDL for Index SYS_C0017486
--------------------------------------------------------

  CREATE UNIQUE INDEX "SYS_C0017486" ON "RBLINKEDVARIABLES" ("RECBIO_PROTID", "FIELDCOL") 
  ;
/
--------------------------------------------------------
--  DDL for Index XIE1RBLINKEDVARIABLES
--------------------------------------------------------

  CREATE INDEX "XIE1RBLINKEDVARIABLES" ON "RBLINKEDVARIABLES" ("RECBIO_PROTID") 
  ;
/
--------------------------------------------------------
--  Constraints for Table RBLINKEDVARIABLES
--------------------------------------------------------

  ALTER TABLE "RBLINKEDVARIABLES" ADD PRIMARY KEY ("RECBIO_PROTID", "FIELDCOL")
  USING INDEX  ENABLE;
  ALTER TABLE "RBLINKEDVARIABLES" MODIFY ("FIELDCOL" NOT NULL ENABLE);
  ALTER TABLE "RBLINKEDVARIABLES" MODIFY ("RECBIO_PROTID" NOT NULL ENABLE);
/
--------------------------------------------------------
--  Ref Constraints for Table RBLINKEDVARIABLES
--------------------------------------------------------

  ALTER TABLE "RBLINKEDVARIABLES" ADD CONSTRAINT "FK_VAR_PROTID" FOREIGN KEY ("RECBIO_PROTID")
	  REFERENCES "RBLINKEDPROTOCOLS" ("RECBIO_PROTID") ENABLE;
/