ALTER TABLE VBR.DOCUMENT_RECEIPT
  DROP CONSTRAINT DOCRCP_PK;

ALTER TABLE VBR.DOCUMENT_RECEIPT ADD (
  CONSTRAINT DOCRCP_PK
  PRIMARY KEY
  (DOCUMENT_RECEIPT_ID)
  ENABLE VALIDATE);
ALTER TABLE VBR.DOCUMENT_TYPE
  DROP CONSTRAINT DOCTYP_PK;

ALTER TABLE VBR.DOCUMENT_TYPE ADD (
  CONSTRAINT DOCTYP_PK
  PRIMARY KEY
  (DOCUMENT_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE VBR.DOCUMENT
  DROP CONSTRAINT DOC_PK;

ALTER TABLE VBR.DOCUMENT ADD (
  CONSTRAINT DOC_PK
  PRIMARY KEY
  (DOCUMENT_ID)
  ENABLE VALIDATE);
ALTER TABLE VBR.DOCUMENT
  DROP CONSTRAINT HANDBOOK_PRODUCT_TYPE_FK;


ALTER TABLE VBR.DOCUMENT ADD (
  CONSTRAINT HANDBOOK_PRODUCT_TYPE_FK 
  FOREIGN KEY (DOCUMENT_TYPE_ID) 
  REFERENCES VBR.DOCUMENT_TYPE (DOCUMENT_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE VBR.DOCUMENT
  DROP CONSTRAINT RELATIONSHIP116;


ALTER TABLE VBR.DOCUMENT ADD (
  CONSTRAINT RELATIONSHIP116 
  FOREIGN KEY (FILE_ID) 
  REFERENCES ADRFILE.FILES (FILE_ID)
  ENABLE VALIDATE);
ALTER TABLE VBR.VET_HEALTH_BENEFIT_PLAN
  DROP CONSTRAINT RELATIONSHIP117;


ALTER TABLE VBR.VET_HEALTH_BENEFIT_PLAN ADD (
  CONSTRAINT RELATIONSHIP117 
  FOREIGN KEY (DOCUMENT_RECEIPT_ID) 
  REFERENCES VBR.DOCUMENT_RECEIPT (DOCUMENT_RECEIPT_ID)
  ENABLE VALIDATE);
ALTER TABLE VBR.DOCUMENT
  DROP CONSTRAINT RELATIONSHIP89;


ALTER TABLE VBR.DOCUMENT ADD (
  CONSTRAINT RELATIONSHIP89 
  FOREIGN KEY (DOCUMENT_RECEIPT_ID) 
  REFERENCES VBR.DOCUMENT_RECEIPT (DOCUMENT_RECEIPT_ID)
  ENABLE VALIDATE);
ALTER TABLE VBR.DOCUMENT_RECEIPT
  DROP CONSTRAINT RELATIONSHIP96;


ALTER TABLE VBR.DOCUMENT_RECEIPT ADD (
  CONSTRAINT RELATIONSHIP96 
  FOREIGN KEY (VETERAN_IDENTIFIER_TYPE_ID) 
  REFERENCES VBR.VETERAN_IDENTIFIER_TYPE (VETERAN_IDENTIFIER_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE VBR.DOCUMENT_RECEIPT MODIFY 
  DOCUMENT_RECEIPT_ID NULL;

ALTER TABLE VBR.DOCUMENT_RECEIPT MODIFY 
  DOCUMENT_RECEIPT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT_RECEIPT MODIFY 
  VETERAN_ID NULL;

ALTER TABLE VBR.DOCUMENT_RECEIPT MODIFY 
  VETERAN_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT_RECEIPT MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE VBR.DOCUMENT_RECEIPT MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT_RECEIPT MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE VBR.DOCUMENT_RECEIPT MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT_RECEIPT MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE VBR.DOCUMENT_RECEIPT MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT_RECEIPT MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE VBR.DOCUMENT_RECEIPT MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT_RECEIPT MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE VBR.DOCUMENT_RECEIPT MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.VET_HEALTH_BENEFIT_PLAN MODIFY 
  VET_BENEFIT_PLAN_ID NULL;

ALTER TABLE VBR.VET_HEALTH_BENEFIT_PLAN MODIFY 
  VET_BENEFIT_PLAN_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.VET_HEALTH_BENEFIT_PLAN MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE VBR.VET_HEALTH_BENEFIT_PLAN MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.VET_HEALTH_BENEFIT_PLAN MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE VBR.VET_HEALTH_BENEFIT_PLAN MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.VET_HEALTH_BENEFIT_PLAN MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE VBR.VET_HEALTH_BENEFIT_PLAN MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.VET_HEALTH_BENEFIT_PLAN MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE VBR.VET_HEALTH_BENEFIT_PLAN MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.VET_HEALTH_BENEFIT_PLAN MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE VBR.VET_HEALTH_BENEFIT_PLAN MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.VETERAN_IDENTIFIER_TYPE MODIFY 
  VETERAN_IDENTIFIER_TYPE_ID NULL;

ALTER TABLE VBR.VETERAN_IDENTIFIER_TYPE MODIFY 
  VETERAN_IDENTIFIER_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.VETERAN_IDENTIFIER_TYPE MODIFY 
  NAME NULL;

ALTER TABLE VBR.VETERAN_IDENTIFIER_TYPE MODIFY 
  NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.VETERAN_IDENTIFIER_TYPE MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE VBR.VETERAN_IDENTIFIER_TYPE MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.VETERAN_IDENTIFIER_TYPE MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE VBR.VETERAN_IDENTIFIER_TYPE MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.VETERAN_IDENTIFIER_TYPE MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE VBR.VETERAN_IDENTIFIER_TYPE MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.VETERAN_IDENTIFIER_TYPE MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE VBR.VETERAN_IDENTIFIER_TYPE MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.VETERAN_IDENTIFIER_TYPE MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE VBR.VETERAN_IDENTIFIER_TYPE MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT MODIFY 
  DOCUMENT_ID NULL;

ALTER TABLE VBR.DOCUMENT MODIFY 
  DOCUMENT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT MODIFY 
  DOCUMENT_TYPE_ID NULL;

ALTER TABLE VBR.DOCUMENT MODIFY 
  DOCUMENT_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE VBR.DOCUMENT MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE VBR.DOCUMENT MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE VBR.DOCUMENT MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE VBR.DOCUMENT MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE VBR.DOCUMENT MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT_TYPE MODIFY 
  DOCUMENT_TYPE_ID NULL;

ALTER TABLE VBR.DOCUMENT_TYPE MODIFY 
  DOCUMENT_TYPE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT_TYPE MODIFY 
  NAME NULL;

ALTER TABLE VBR.DOCUMENT_TYPE MODIFY 
  NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT_TYPE MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE VBR.DOCUMENT_TYPE MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT_TYPE MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE VBR.DOCUMENT_TYPE MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT_TYPE MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE VBR.DOCUMENT_TYPE MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT_TYPE MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE VBR.DOCUMENT_TYPE MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.DOCUMENT_TYPE MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE VBR.DOCUMENT_TYPE MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE VBR.VETERAN_IDENTIFIER_TYPE
  DROP CONSTRAINT VETIDTYP_PK;

ALTER TABLE VBR.VETERAN_IDENTIFIER_TYPE ADD (
  CONSTRAINT VETIDTYP_PK
  PRIMARY KEY
  (VETERAN_IDENTIFIER_TYPE_ID)
  ENABLE VALIDATE);
ALTER TABLE VBR.VET_HEALTH_BENEFIT_PLAN
  DROP CONSTRAINT VHBP_PK;

ALTER TABLE VBR.VET_HEALTH_BENEFIT_PLAN ADD (
  CONSTRAINT VHBP_PK
  PRIMARY KEY
  (VET_BENEFIT_PLAN_ID)
  ENABLE VALIDATE);
