ALTER TABLE BENS.TAXONOMY_VERSION
  DROP CONSTRAINT TXNVER_TXN_FK;


ALTER TABLE BENS.TAXONOMY_VERSION ADD (
  CONSTRAINT TXNVER_TXN_FK 
  FOREIGN KEY (TAXONOMY_ID) 
  REFERENCES BENS.TAXONOMY (TAXONOMY_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.TAXONOMY_VERSION MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE BENS.TAXONOMY_VERSION MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.TAXONOMY_VERSION MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE BENS.TAXONOMY_VERSION MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.TAXONOMY_VERSION MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE BENS.TAXONOMY_VERSION MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.TAXONOMY_VERSION MODIFY 
  TAXONOMY_VERSION_ID NULL;

ALTER TABLE BENS.TAXONOMY_VERSION MODIFY 
  TAXONOMY_VERSION_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.TAXONOMY_VERSION MODIFY 
  TAXONOMY_ID NULL;

ALTER TABLE BENS.TAXONOMY_VERSION MODIFY 
  TAXONOMY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.TAXONOMY
  DROP CONSTRAINT TXN_ORG_FK;


ALTER TABLE BENS.TAXONOMY ADD (
  CONSTRAINT TXN_ORG_FK 
  FOREIGN KEY (SPONSOR_ID) 
  REFERENCES BENS.ORGANIZATION (ORGANIZATION_ID)
  ON DELETE SET NULL
  ENABLE VALIDATE);
ALTER TABLE BENS.TAXONOMY MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE BENS.TAXONOMY MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.TAXONOMY MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE BENS.TAXONOMY MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.TAXONOMY MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE BENS.TAXONOMY MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.TAXONOMY MODIFY 
  TAXONOMY_ID NULL;

ALTER TABLE BENS.TAXONOMY MODIFY 
  TAXONOMY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.TAXONOMY MODIFY 
  TAXONOMY_NAME NULL;

ALTER TABLE BENS.TAXONOMY MODIFY 
  TAXONOMY_NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.TAXONOMY MODIFY 
  SPONSOR_ID NULL;

ALTER TABLE BENS.TAXONOMY MODIFY 
  SPONSOR_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.REGISTRANT
  DROP CONSTRAINT REG_ACTST_FK;


ALTER TABLE BENS.REGISTRANT ADD (
  CONSTRAINT REG_ACTST_FK 
  FOREIGN KEY (ACTIVATION_STATE_ID) 
  REFERENCES BENS.ACTIVATION_STATE (ACTIVATION_STATE_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.REGISTRANT
  DROP CONSTRAINT REG_ORG_FK;


ALTER TABLE BENS.REGISTRANT ADD (
  CONSTRAINT REG_ORG_FK 
  FOREIGN KEY (ORGANIZATION_ID) 
  REFERENCES BENS.ORGANIZATION (ORGANIZATION_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.REGISTRANT MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE BENS.REGISTRANT MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.REGISTRANT MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE BENS.REGISTRANT MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.REGISTRANT MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE BENS.REGISTRANT MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.REGISTRANT MODIFY 
  REGISTRANT_ID NULL;

ALTER TABLE BENS.REGISTRANT MODIFY 
  REGISTRANT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.REGISTRANT MODIFY 
  ACTIVATION_STATE_ID NULL;

ALTER TABLE BENS.REGISTRANT MODIFY 
  ACTIVATION_STATE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.REGISTRANT MODIFY 
  ORGANIZATION_ID NULL;

ALTER TABLE BENS.REGISTRANT MODIFY 
  ORGANIZATION_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.ORGANIZATION_COMMENT
  DROP CONSTRAINT ORGCOM_ORG_FK;


ALTER TABLE BENS.ORGANIZATION_COMMENT ADD (
  CONSTRAINT ORGCOM_ORG_FK 
  FOREIGN KEY (ORGANIZATION_ID) 
  REFERENCES BENS.ORGANIZATION (ORGANIZATION_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.ORGANIZATION_COMMENT MODIFY 
  ORGANIZATION_ID NULL;

ALTER TABLE BENS.ORGANIZATION_COMMENT MODIFY 
  ORGANIZATION_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.ORGANIZATION_COMMENT MODIFY 
  ORGANIZATION_COMMENT_ID NULL;

ALTER TABLE BENS.ORGANIZATION_COMMENT MODIFY 
  ORGANIZATION_COMMENT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.ORGANIZATION_COMMENT MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE BENS.ORGANIZATION_COMMENT MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.ORGANIZATION_COMMENT MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE BENS.ORGANIZATION_COMMENT MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.ORGANIZATION_COMMENT MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE BENS.ORGANIZATION_COMMENT MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.ORGANIZATION MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE BENS.ORGANIZATION MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.ORGANIZATION MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE BENS.ORGANIZATION MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.ORGANIZATION MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE BENS.ORGANIZATION MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.ORGANIZATION MODIFY 
  ORGANIZATION_ID NULL;

ALTER TABLE BENS.ORGANIZATION MODIFY 
  ORGANIZATION_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CODE MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE BENS.EVENT_CODE MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CODE MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE BENS.EVENT_CODE MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CODE MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE BENS.EVENT_CODE MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CODE MODIFY 
  EVENT_CODE_ID NULL;

ALTER TABLE BENS.EVENT_CODE MODIFY 
  EVENT_CODE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CODE MODIFY 
  CODE_NAME NULL;

ALTER TABLE BENS.EVENT_CODE MODIFY 
  CODE_NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CODE MODIFY 
  VALUE_NAME NULL;

ALTER TABLE BENS.EVENT_CODE MODIFY 
  VALUE_NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CODE MODIFY 
  CODING_SYSTEM_NAME NULL;

ALTER TABLE BENS.EVENT_CODE MODIFY 
  CODING_SYSTEM_NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CLASS_REGISTRANT
  DROP CONSTRAINT EVNCLSREG_EVNCLS_FK;


ALTER TABLE BENS.EVENT_CLASS_REGISTRANT ADD (
  CONSTRAINT EVNCLSREG_EVNCLS_FK 
  FOREIGN KEY (EVENT_CLASS_ID) 
  REFERENCES BENS.EVENT_CLASS (EVENT_CLASS_ID)
  ON DELETE SET NULL
  ENABLE VALIDATE);
ALTER TABLE BENS.EVENT_CLASS_REGISTRANT
  DROP CONSTRAINT EVNCLSREG_REG_FK;


ALTER TABLE BENS.EVENT_CLASS_REGISTRANT ADD (
  CONSTRAINT EVNCLSREG_REG_FK 
  FOREIGN KEY (REGISTRANT_ID) 
  REFERENCES BENS.REGISTRANT (REGISTRANT_ID)
  ON DELETE SET NULL
  ENABLE VALIDATE);
ALTER TABLE BENS.EVENT_CLASS_REGISTRANT MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE BENS.EVENT_CLASS_REGISTRANT MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CLASS_REGISTRANT MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE BENS.EVENT_CLASS_REGISTRANT MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CLASS_REGISTRANT MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE BENS.EVENT_CLASS_REGISTRANT MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CLASS_REGISTRANT MODIFY 
  EVENT_CLASS_REGISTRANT_ID NULL;

ALTER TABLE BENS.EVENT_CLASS_REGISTRANT MODIFY 
  EVENT_CLASS_REGISTRANT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CLASS_REGISTRANT MODIFY 
  RELATIONSHIP_TYPE_NAME NULL;

ALTER TABLE BENS.EVENT_CLASS_REGISTRANT MODIFY 
  RELATIONSHIP_TYPE_NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CLASS_REGISTRANT MODIFY 
  REGISTRANT_ID NULL;

ALTER TABLE BENS.EVENT_CLASS_REGISTRANT MODIFY 
  REGISTRANT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CLASS_REGISTRANT MODIFY 
  EVENT_CLASS_ID NULL;

ALTER TABLE BENS.EVENT_CLASS_REGISTRANT MODIFY 
  EVENT_CLASS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CLASS_COMMENT
  DROP CONSTRAINT EVNCLSCOM_EVNCLS_FK;


ALTER TABLE BENS.EVENT_CLASS_COMMENT ADD (
  CONSTRAINT EVNCLSCOM_EVNCLS_FK 
  FOREIGN KEY (EVENT_CLASS_ID) 
  REFERENCES BENS.EVENT_CLASS (EVENT_CLASS_ID)
  ON DELETE SET NULL
  ENABLE VALIDATE);
ALTER TABLE BENS.EVENT_CLASS_COMMENT MODIFY 
  EVENT_CLASS_ID NULL;

ALTER TABLE BENS.EVENT_CLASS_COMMENT MODIFY 
  EVENT_CLASS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CLASS_COMMENT MODIFY 
  EVENT_CLASS_COMMENT_ID NULL;

ALTER TABLE BENS.EVENT_CLASS_COMMENT MODIFY 
  EVENT_CLASS_COMMENT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CLASS_COMMENT MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE BENS.EVENT_CLASS_COMMENT MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CLASS_COMMENT MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE BENS.EVENT_CLASS_COMMENT MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CLASS_COMMENT MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE BENS.EVENT_CLASS_COMMENT MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CLASS
  DROP CONSTRAINT EVNCLS_ACTST_FK;


ALTER TABLE BENS.EVENT_CLASS ADD (
  CONSTRAINT EVNCLS_ACTST_FK 
  FOREIGN KEY (ACTIVATION_STATE_ID) 
  REFERENCES BENS.ACTIVATION_STATE (ACTIVATION_STATE_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.EVENT_CLASS
  DROP CONSTRAINT EVNCLS_EVNCLS_FK;


ALTER TABLE BENS.EVENT_CLASS ADD (
  CONSTRAINT EVNCLS_EVNCLS_FK 
  FOREIGN KEY (PARENT_EVENT_CLASS_ID) 
  REFERENCES BENS.EVENT_CLASS (EVENT_CLASS_ID)
  ON DELETE SET NULL
  ENABLE VALIDATE);
ALTER TABLE BENS.EVENT_CLASS
  DROP CONSTRAINT EVNCLS_EVNCOD_FK;


ALTER TABLE BENS.EVENT_CLASS ADD (
  CONSTRAINT EVNCLS_EVNCOD_FK 
  FOREIGN KEY (EVENT_CODE_ID) 
  REFERENCES BENS.EVENT_CODE (EVENT_CODE_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.EVENT_CLASS
  DROP CONSTRAINT EVNCLS_ORG_FK;


ALTER TABLE BENS.EVENT_CLASS ADD (
  CONSTRAINT EVNCLS_ORG_FK 
  FOREIGN KEY (SPONSOR_ID) 
  REFERENCES BENS.ORGANIZATION (ORGANIZATION_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.EVENT_CLASS MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE BENS.EVENT_CLASS MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CLASS MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE BENS.EVENT_CLASS MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CLASS MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE BENS.EVENT_CLASS MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CLASS MODIFY 
  EVENT_CODE_ID NULL;

ALTER TABLE BENS.EVENT_CLASS MODIFY 
  EVENT_CODE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CLASS MODIFY 
  ACTIVATION_STATE_ID NULL;

ALTER TABLE BENS.EVENT_CLASS MODIFY 
  ACTIVATION_STATE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CLASS MODIFY 
  SPONSOR_ID NULL;

ALTER TABLE BENS.EVENT_CLASS MODIFY 
  SPONSOR_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CATALOG_ENTRY
  DROP CONSTRAINT EVNCATENT_TXNVER_FK;


ALTER TABLE BENS.EVENT_CATALOG_ENTRY ADD (
  CONSTRAINT EVNCATENT_TXNVER_FK 
  FOREIGN KEY (TAXONOMY_VERSION_ID) 
  REFERENCES BENS.TAXONOMY_VERSION (TAXONOMY_VERSION_ID)
  ON DELETE SET NULL
  ENABLE VALIDATE);
ALTER TABLE BENS.EVENT_CATALOG_ENTRY
  DROP CONSTRAINT EVNCTLENT_EVNCLS_FK;


ALTER TABLE BENS.EVENT_CATALOG_ENTRY ADD (
  CONSTRAINT EVNCTLENT_EVNCLS_FK 
  FOREIGN KEY (EVENT_CLASS_ID) 
  REFERENCES BENS.EVENT_CLASS (EVENT_CLASS_ID)
  ON DELETE SET NULL
  ENABLE VALIDATE);
ALTER TABLE BENS.EVENT_CATALOG_ENTRY MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE BENS.EVENT_CATALOG_ENTRY MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CATALOG_ENTRY MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE BENS.EVENT_CATALOG_ENTRY MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CATALOG_ENTRY MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE BENS.EVENT_CATALOG_ENTRY MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CATALOG_ENTRY MODIFY 
  EVENT_CATALOG_ENTRY_ID NULL;

ALTER TABLE BENS.EVENT_CATALOG_ENTRY MODIFY 
  EVENT_CATALOG_ENTRY_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CATALOG_ENTRY MODIFY 
  TAXONOMY_VERSION_ID NULL;

ALTER TABLE BENS.EVENT_CATALOG_ENTRY MODIFY 
  TAXONOMY_VERSION_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.EVENT_CATALOG_ENTRY MODIFY 
  EVENT_CLASS_ID NULL;

ALTER TABLE BENS.EVENT_CATALOG_ENTRY MODIFY 
  EVENT_CLASS_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.CONTACT_PHONE
  DROP CONSTRAINT CONPHN_CONDTL_FK;


ALTER TABLE BENS.CONTACT_PHONE ADD (
  CONSTRAINT CONPHN_CONDTL_FK 
  FOREIGN KEY (CONTACT_DETAIL_ID) 
  REFERENCES BENS.CONTACT_DETAIL (CONTACT_DETAIL_ID)
  ON DELETE SET NULL
  ENABLE VALIDATE);
ALTER TABLE BENS.CONTACT_PHONE MODIFY 
  PHONE_NUMBER NULL;

ALTER TABLE BENS.CONTACT_PHONE MODIFY 
  PHONE_NUMBER NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.CONTACT_PHONE MODIFY 
  PHONE_PRECEDENCE_NAME NULL;

ALTER TABLE BENS.CONTACT_PHONE MODIFY 
  PHONE_PRECEDENCE_NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.CONTACT_PHONE MODIFY 
  CONTACT_PHONE_ID NULL;

ALTER TABLE BENS.CONTACT_PHONE MODIFY 
  CONTACT_PHONE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.CONTACT_PHONE MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE BENS.CONTACT_PHONE MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.CONTACT_PHONE MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE BENS.CONTACT_PHONE MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.CONTACT_PHONE MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE BENS.CONTACT_PHONE MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.CONTACT_PHONE MODIFY 
  CONTACT_DETAIL_ID NULL;

ALTER TABLE BENS.CONTACT_PHONE MODIFY 
  CONTACT_DETAIL_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.CONTACT_DETAIL
  DROP CONSTRAINT CONDET_ORG_FK;


ALTER TABLE BENS.CONTACT_DETAIL ADD (
  CONSTRAINT CONDET_ORG_FK 
  FOREIGN KEY (ORGANIZATION_ID) 
  REFERENCES BENS.ORGANIZATION (ORGANIZATION_ID)
  ON DELETE SET NULL
  ENABLE VALIDATE);
ALTER TABLE BENS.CONTACT_DETAIL MODIFY 
  ORGANIZATION_ID NULL;

ALTER TABLE BENS.CONTACT_DETAIL MODIFY 
  ORGANIZATION_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.CONTACT_DETAIL MODIFY 
  CONTACT_DETAIL_ID NULL;

ALTER TABLE BENS.CONTACT_DETAIL MODIFY 
  CONTACT_DETAIL_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.CONTACT_DETAIL MODIFY 
  CONTACT_PRECEDENCE_NAME NULL;

ALTER TABLE BENS.CONTACT_DETAIL MODIFY 
  CONTACT_PRECEDENCE_NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.CONTACT_DETAIL MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE BENS.CONTACT_DETAIL MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.CONTACT_DETAIL MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE BENS.CONTACT_DETAIL MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.CONTACT_DETAIL MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE BENS.CONTACT_DETAIL MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.CONTACT_CERTIFICATE MODIFY 
  CONTACT_CERTIFICATE_ID NULL;

ALTER TABLE BENS.CONTACT_CERTIFICATE MODIFY 
  CONTACT_CERTIFICATE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.CONTACT_CERTIFICATE MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE BENS.CONTACT_CERTIFICATE MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.CONTACT_CERTIFICATE MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE BENS.CONTACT_CERTIFICATE MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.CONTACT_CERTIFICATE MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE BENS.CONTACT_CERTIFICATE MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.CONTACT_CERTIFICATE
  DROP CONSTRAINT CONCRT_ORG_FK;


ALTER TABLE BENS.CONTACT_CERTIFICATE ADD (
  CONSTRAINT CONCRT_ORG_FK 
  FOREIGN KEY (ORGANIZATION_ID) 
  REFERENCES BENS.ORGANIZATION (ORGANIZATION_ID)
  ON DELETE SET NULL
  ENABLE VALIDATE);
ALTER TABLE BENS.ACTIVATION_STATE MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE BENS.ACTIVATION_STATE MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.ACTIVATION_STATE MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE BENS.ACTIVATION_STATE MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.ACTIVATION_STATE MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE BENS.ACTIVATION_STATE MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.ACTIVATION_STATE MODIFY 
  ACTIVATION_STATE_ID NULL;

ALTER TABLE BENS.ACTIVATION_STATE MODIFY 
  ACTIVATION_STATE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.ACTIVATION_STATE MODIFY 
  STATE_NAME NULL;

ALTER TABLE BENS.ACTIVATION_STATE MODIFY 
  STATE_NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE BENS.ACTIVATION_STATE
  DROP CONSTRAINT ACTST_PK;

ALTER TABLE BENS.ACTIVATION_STATE ADD (
  CONSTRAINT ACTST_PK
  PRIMARY KEY
  (ACTIVATION_STATE_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.CONTACT_CERTIFICATE
  DROP CONSTRAINT CNTCRT_PK;

ALTER TABLE BENS.CONTACT_CERTIFICATE ADD (
  CONSTRAINT CNTCRT_PK
  PRIMARY KEY
  (CONTACT_CERTIFICATE_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.CONTACT_DETAIL
  DROP CONSTRAINT CNTDTL_PK;

ALTER TABLE BENS.CONTACT_DETAIL ADD (
  CONSTRAINT CNTDTL_PK
  PRIMARY KEY
  (CONTACT_DETAIL_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.CONTACT_PHONE
  DROP CONSTRAINT CNTPHN_PK;

ALTER TABLE BENS.CONTACT_PHONE ADD (
  CONSTRAINT CNTPHN_PK
  PRIMARY KEY
  (CONTACT_PHONE_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.EVENT_CATALOG_ENTRY
  DROP CONSTRAINT EVNCTLENT_PK;

ALTER TABLE BENS.EVENT_CATALOG_ENTRY ADD (
  CONSTRAINT EVNCTLENT_PK
  PRIMARY KEY
  (EVENT_CATALOG_ENTRY_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.EVENT_CLASS
  DROP CONSTRAINT EVNCLS_PK;

ALTER TABLE BENS.EVENT_CLASS ADD (
  CONSTRAINT EVNCLS_PK
  PRIMARY KEY
  (EVENT_CLASS_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.EVENT_CLASS_COMMENT
  DROP CONSTRAINT EVNCLSCOM_PK;

ALTER TABLE BENS.EVENT_CLASS_COMMENT ADD (
  CONSTRAINT EVNCLSCOM_PK
  PRIMARY KEY
  (EVENT_CLASS_COMMENT_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.EVENT_CLASS_REGISTRANT
  DROP CONSTRAINT EVNCLSRGS_PK;

ALTER TABLE BENS.EVENT_CLASS_REGISTRANT ADD (
  CONSTRAINT EVNCLSRGS_PK
  PRIMARY KEY
  (EVENT_CLASS_REGISTRANT_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.EVENT_CODE
  DROP CONSTRAINT EVNCOD_PK;

ALTER TABLE BENS.EVENT_CODE ADD (
  CONSTRAINT EVNCOD_PK
  PRIMARY KEY
  (EVENT_CODE_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.ORGANIZATION
  DROP CONSTRAINT ORG_PK;

ALTER TABLE BENS.ORGANIZATION ADD (
  CONSTRAINT ORG_PK
  PRIMARY KEY
  (ORGANIZATION_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.ORGANIZATION_COMMENT
  DROP CONSTRAINT ORGCOM_PK;

ALTER TABLE BENS.ORGANIZATION_COMMENT ADD (
  CONSTRAINT ORGCOM_PK
  PRIMARY KEY
  (ORGANIZATION_COMMENT_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.REGISTRANT
  DROP CONSTRAINT REG_PK;

ALTER TABLE BENS.REGISTRANT ADD (
  CONSTRAINT REG_PK
  PRIMARY KEY
  (REGISTRANT_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.TAXONOMY
  DROP CONSTRAINT TAX_PK;

ALTER TABLE BENS.TAXONOMY ADD (
  CONSTRAINT TAX_PK
  PRIMARY KEY
  (TAXONOMY_ID)
  ENABLE VALIDATE);
ALTER TABLE BENS.TAXONOMY_VERSION
  DROP CONSTRAINT TAXVER_PK;

ALTER TABLE BENS.TAXONOMY_VERSION ADD (
  CONSTRAINT TAXVER_PK
  PRIMARY KEY
  (TAXONOMY_VERSION_ID)
  ENABLE VALIDATE);
