ALTER TABLE EESRV.FIELD_GROUP
  DROP CONSTRAINT FLDGRP_PK;

ALTER TABLE EESRV.FIELD_GROUP ADD (
  CONSTRAINT FLDGRP_PK
  PRIMARY KEY
  (FIELD_GROUP_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.FIELD_H
  DROP CONSTRAINT FLDH_PK;

ALTER TABLE EESRV.FIELD_H ADD (
  CONSTRAINT FLDH_PK
  PRIMARY KEY
  (FIELD_H_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.FIELD
  DROP CONSTRAINT FLD_PK;

ALTER TABLE EESRV.FIELD ADD (
  CONSTRAINT FLD_PK
  PRIMARY KEY
  (FIELD_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.FIELD_GROUP_H
  DROP CONSTRAINT GRPH_PK;

ALTER TABLE EESRV.FIELD_GROUP_H ADD (
  CONSTRAINT GRPH_PK
  PRIMARY KEY
  (FIELD_GROUP_H_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT
  DROP CONSTRAINT RELATIONSHIP11;


ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT ADD (
  CONSTRAINT RELATIONSHIP11 
  FOREIGN KEY (SERVICE_REQUEST_ID) 
  REFERENCES EESRV.SERVICE_REQUEST (SERVICE_REQUEST_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.FIELD_GROUP
  DROP CONSTRAINT RELATIONSHIP12;


ALTER TABLE EESRV.FIELD_GROUP ADD (
  CONSTRAINT RELATIONSHIP12 
  FOREIGN KEY (PARENT_GROUP_ID) 
  REFERENCES EESRV.FIELD_GROUP (FIELD_GROUP_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.REQUEST_GROUP
  DROP CONSTRAINT RELATIONSHIP13;


ALTER TABLE EESRV.REQUEST_GROUP ADD (
  CONSTRAINT RELATIONSHIP13 
  FOREIGN KEY (SERVICE_REQUEST_ID) 
  REFERENCES EESRV.SERVICE_REQUEST (SERVICE_REQUEST_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.REQUEST_GROUP
  DROP CONSTRAINT RELATIONSHIP14;


ALTER TABLE EESRV.REQUEST_GROUP ADD (
  CONSTRAINT RELATIONSHIP14 
  FOREIGN KEY (FIELD_GROUP_ID) 
  REFERENCES EESRV.FIELD_GROUP (FIELD_GROUP_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.SERVICE_LOG
  DROP CONSTRAINT RELATIONSHIP16;


ALTER TABLE EESRV.SERVICE_LOG ADD (
  CONSTRAINT RELATIONSHIP16 
  FOREIGN KEY (SERVICE_USER_ID) 
  REFERENCES EESRV.SERVICE_USER (SERVICE_USER_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.FIELD
  DROP CONSTRAINT RELATIONSHIP17;


ALTER TABLE EESRV.FIELD ADD (
  CONSTRAINT RELATIONSHIP17 
  FOREIGN KEY (FIELD_GROUP_ID) 
  REFERENCES EESRV.FIELD_GROUP (FIELD_GROUP_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.REQUEST_FIELD
  DROP CONSTRAINT RELATIONSHIP6;


ALTER TABLE EESRV.REQUEST_FIELD ADD (
  CONSTRAINT RELATIONSHIP6 
  FOREIGN KEY (SERVICE_REQUEST_ID) 
  REFERENCES EESRV.SERVICE_REQUEST (SERVICE_REQUEST_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.REQUEST_FIELD
  DROP CONSTRAINT RELATIONSHIP7;


ALTER TABLE EESRV.REQUEST_FIELD ADD (
  CONSTRAINT RELATIONSHIP7 
  FOREIGN KEY (FIELD_ID) 
  REFERENCES EESRV.FIELD (FIELD_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT
  DROP CONSTRAINT RELATIONSHIP9;


ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT ADD (
  CONSTRAINT RELATIONSHIP9 
  FOREIGN KEY (SERVICE_USER_ID) 
  REFERENCES EESRV.SERVICE_USER (SERVICE_USER_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.REQUEST_FIELD_H
  DROP CONSTRAINT ROLFLD_H_PK;

ALTER TABLE EESRV.REQUEST_FIELD_H ADD (
  CONSTRAINT ROLFLD_H_PK
  PRIMARY KEY
  (REQUEST_FIELD_H_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.REQUEST_FIELD
  DROP CONSTRAINT ROLFLD_PK;

ALTER TABLE EESRV.REQUEST_FIELD ADD (
  CONSTRAINT ROLFLD_PK
  PRIMARY KEY
  (REQUEST_FIELD_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.REQUEST_GROUP_H
  DROP CONSTRAINT ROLGRPH_PK;

ALTER TABLE EESRV.REQUEST_GROUP_H ADD (
  CONSTRAINT ROLGRPH_PK
  PRIMARY KEY
  (REQUEST_GROUP_H_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.REQUEST_GROUP
  DROP CONSTRAINT ROLGRP_PK;

ALTER TABLE EESRV.REQUEST_GROUP ADD (
  CONSTRAINT ROLGRP_PK
  PRIMARY KEY
  (REQUEST_GROUP_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.SERVICE_REQUEST
  DROP CONSTRAINT SERVICE_REQUEST_NAME_UK;

ALTER TABLE EESRV.SERVICE_REQUEST ADD (
  CONSTRAINT SERVICE_REQUEST_NAME_UK
  UNIQUE (NAME)
  ENABLE VALIDATE);
ALTER TABLE EESRV.SERVICE_USER
  DROP CONSTRAINT SERVICE_USER_USERNAME_UK;

ALTER TABLE EESRV.SERVICE_USER ADD (
  CONSTRAINT SERVICE_USER_USERNAME_UK
  UNIQUE (USERNAME)
  ENABLE VALIDATE);
ALTER TABLE EESRV.SERVICE_USER
  DROP CONSTRAINT SERV_USR_CK;

ALTER TABLE EESRV.SERVICE_USER ADD (
  CONSTRAINT SERV_USR_CK
  CHECK (ACTIVE_FLAG BETWEEN 0 AND 0 OR ACTIVE_FLAG BETWEEN 1 AND 1)
  ENABLE VALIDATE);
ALTER TABLE EESRV.SERVICE_USER_H
  DROP CONSTRAINT SERV_USR_H_CK;

ALTER TABLE EESRV.SERVICE_USER_H ADD (
  CONSTRAINT SERV_USR_H_CK
  CHECK (ACTIVE_FLAG BETWEEN 0 AND 0 OR ACTIVE_FLAG BETWEEN 1 AND 1)
  ENABLE VALIDATE);
ALTER TABLE EESRV.SERVICE_LOG
  DROP CONSTRAINT SRVLOG_PK;

ALTER TABLE EESRV.SERVICE_LOG ADD (
  CONSTRAINT SRVLOG_PK
  PRIMARY KEY
  (SERVICE_LOG_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT_H
  DROP CONSTRAINT SRVROLASSH_PK;

ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT_H ADD (
  CONSTRAINT SRVROLASSH_PK
  PRIMARY KEY
  (SERVICE_REQ_ASSIGN_H_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT
  DROP CONSTRAINT SRVROLASS_PK;

ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT ADD (
  CONSTRAINT SRVROLASS_PK
  PRIMARY KEY
  (SERVICE_REQUEST_ASSIGNMENT_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.SERVICE_REQUEST_H
  DROP CONSTRAINT SRVROLH_PK;

ALTER TABLE EESRV.SERVICE_REQUEST_H ADD (
  CONSTRAINT SRVROLH_PK
  PRIMARY KEY
  (SERVICE_REQUEST_H_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.SERVICE_REQUEST
  DROP CONSTRAINT SRVROL_PK;

ALTER TABLE EESRV.SERVICE_REQUEST ADD (
  CONSTRAINT SRVROL_PK
  PRIMARY KEY
  (SERVICE_REQUEST_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.SERVICE_USER_H
  DROP CONSTRAINT SRVUSERH_PK;

ALTER TABLE EESRV.SERVICE_USER_H ADD (
  CONSTRAINT SRVUSERH_PK
  PRIMARY KEY
  (SERVICE_USER_H_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.SERVICE_USER
  DROP CONSTRAINT SRVUSER_PK;

ALTER TABLE EESRV.SERVICE_USER ADD (
  CONSTRAINT SRVUSER_PK
  PRIMARY KEY
  (SERVICE_USER_ID)
  ENABLE VALIDATE);
ALTER TABLE EESRV.FIELD_GROUP MODIFY 
  FIELD_GROUP_ID NULL;

ALTER TABLE EESRV.FIELD_GROUP MODIFY 
  FIELD_GROUP_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_GROUP MODIFY 
  NAME NULL;

ALTER TABLE EESRV.FIELD_GROUP MODIFY 
  NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_GROUP MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE EESRV.FIELD_GROUP MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_GROUP MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE EESRV.FIELD_GROUP MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_GROUP MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE EESRV.FIELD_GROUP MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_GROUP MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE EESRV.FIELD_GROUP MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_GROUP MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE EESRV.FIELD_GROUP MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_GROUP MODIFY 
  REQUEST_GROUP_ID NULL;

ALTER TABLE EESRV.REQUEST_GROUP MODIFY 
  REQUEST_GROUP_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_GROUP MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE EESRV.REQUEST_GROUP MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_GROUP MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE EESRV.REQUEST_GROUP MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_GROUP MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE EESRV.REQUEST_GROUP MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_GROUP MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE EESRV.REQUEST_GROUP MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_GROUP MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE EESRV.REQUEST_GROUP MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_GROUP_H MODIFY 
  FIELD_GROUP_H_ID NULL;

ALTER TABLE EESRV.FIELD_GROUP_H MODIFY 
  FIELD_GROUP_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_GROUP_H MODIFY 
  FIELD_GROUP_ID NULL;

ALTER TABLE EESRV.FIELD_GROUP_H MODIFY 
  FIELD_GROUP_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_GROUP_H MODIFY 
  NAME NULL;

ALTER TABLE EESRV.FIELD_GROUP_H MODIFY 
  NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_GROUP_H MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE EESRV.FIELD_GROUP_H MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_GROUP_H MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE EESRV.FIELD_GROUP_H MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_GROUP_H MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE EESRV.FIELD_GROUP_H MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_GROUP_H MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE EESRV.FIELD_GROUP_H MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_GROUP_H MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE EESRV.FIELD_GROUP_H MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_GROUP_H MODIFY 
  TRANSACTION_TYPE_CODE NULL;

ALTER TABLE EESRV.FIELD_GROUP_H MODIFY 
  TRANSACTION_TYPE_CODE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT MODIFY 
  SERVICE_REQUEST_ASSIGNMENT_ID NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT MODIFY 
  SERVICE_REQUEST_ASSIGNMENT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST MODIFY 
  SERVICE_REQUEST_ID NULL;

ALTER TABLE EESRV.SERVICE_REQUEST MODIFY 
  SERVICE_REQUEST_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST MODIFY 
  NAME NULL;

ALTER TABLE EESRV.SERVICE_REQUEST MODIFY 
  NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE EESRV.SERVICE_REQUEST MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE EESRV.SERVICE_REQUEST MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE EESRV.SERVICE_REQUEST MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE EESRV.SERVICE_REQUEST MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE EESRV.SERVICE_REQUEST MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_FIELD MODIFY 
  REQUEST_FIELD_ID NULL;

ALTER TABLE EESRV.REQUEST_FIELD MODIFY 
  REQUEST_FIELD_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_FIELD MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE EESRV.REQUEST_FIELD MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_FIELD MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE EESRV.REQUEST_FIELD MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_FIELD MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE EESRV.REQUEST_FIELD MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_FIELD MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE EESRV.REQUEST_FIELD MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_FIELD MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE EESRV.REQUEST_FIELD MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD MODIFY 
  FIELD_ID NULL;

ALTER TABLE EESRV.FIELD MODIFY 
  FIELD_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD MODIFY 
  NAME NULL;

ALTER TABLE EESRV.FIELD MODIFY 
  NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE EESRV.FIELD MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE EESRV.FIELD MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE EESRV.FIELD MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE EESRV.FIELD MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE EESRV.FIELD MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_GROUP_H MODIFY 
  REQUEST_GROUP_H_ID NULL;

ALTER TABLE EESRV.REQUEST_GROUP_H MODIFY 
  REQUEST_GROUP_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_GROUP_H MODIFY 
  REQUEST_GROUP_ID NULL;

ALTER TABLE EESRV.REQUEST_GROUP_H MODIFY 
  REQUEST_GROUP_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_GROUP_H MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE EESRV.REQUEST_GROUP_H MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_GROUP_H MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE EESRV.REQUEST_GROUP_H MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_GROUP_H MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE EESRV.REQUEST_GROUP_H MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_GROUP_H MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE EESRV.REQUEST_GROUP_H MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_GROUP_H MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE EESRV.REQUEST_GROUP_H MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_GROUP_H MODIFY 
  TRANSACTION_TYPE_CODE NULL;

ALTER TABLE EESRV.REQUEST_GROUP_H MODIFY 
  TRANSACTION_TYPE_CODE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_FIELD_H MODIFY 
  REQUEST_FIELD_H_ID NULL;

ALTER TABLE EESRV.REQUEST_FIELD_H MODIFY 
  REQUEST_FIELD_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_FIELD_H MODIFY 
  REQUEST_FIELD_ID NULL;

ALTER TABLE EESRV.REQUEST_FIELD_H MODIFY 
  REQUEST_FIELD_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_FIELD_H MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE EESRV.REQUEST_FIELD_H MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_FIELD_H MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE EESRV.REQUEST_FIELD_H MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_FIELD_H MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE EESRV.REQUEST_FIELD_H MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_FIELD_H MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE EESRV.REQUEST_FIELD_H MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_FIELD_H MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE EESRV.REQUEST_FIELD_H MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.REQUEST_FIELD_H MODIFY 
  TRANSACTION_TYPE_CODE NULL;

ALTER TABLE EESRV.REQUEST_FIELD_H MODIFY 
  TRANSACTION_TYPE_CODE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_H MODIFY 
  FIELD_H_ID NULL;

ALTER TABLE EESRV.FIELD_H MODIFY 
  FIELD_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_H MODIFY 
  FIELD_ID NULL;

ALTER TABLE EESRV.FIELD_H MODIFY 
  FIELD_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_H MODIFY 
  FIELD_GROUP_ID NULL;

ALTER TABLE EESRV.FIELD_H MODIFY 
  FIELD_GROUP_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_H MODIFY 
  NAME NULL;

ALTER TABLE EESRV.FIELD_H MODIFY 
  NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_H MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE EESRV.FIELD_H MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_H MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE EESRV.FIELD_H MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_H MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE EESRV.FIELD_H MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_H MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE EESRV.FIELD_H MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_H MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE EESRV.FIELD_H MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.FIELD_H MODIFY 
  TRANSACTION_TYPE_CODE NULL;

ALTER TABLE EESRV.FIELD_H MODIFY 
  TRANSACTION_TYPE_CODE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_H MODIFY 
  SERVICE_REQUEST_H_ID NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_H MODIFY 
  SERVICE_REQUEST_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_H MODIFY 
  SERVICE_REQUEST_ID NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_H MODIFY 
  SERVICE_REQUEST_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_H MODIFY 
  NAME NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_H MODIFY 
  NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_H MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_H MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_H MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_H MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_H MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_H MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_H MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_H MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_H MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_H MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_H MODIFY 
  TRANSACTION_TYPE_CODE NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_H MODIFY 
  TRANSACTION_TYPE_CODE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT_H MODIFY 
  SERVICE_REQ_ASSIGN_H_ID NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT_H MODIFY 
  SERVICE_REQ_ASSIGN_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT_H MODIFY 
  SERVICE_REQUEST_ASSIGNMENT_ID NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT_H MODIFY 
  SERVICE_REQUEST_ASSIGNMENT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT_H MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT_H MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT_H MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT_H MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT_H MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT_H MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT_H MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT_H MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT_H MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT_H MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT_H MODIFY 
  TRANSACTION_TYPE_CODE NULL;

ALTER TABLE EESRV.SERVICE_REQUEST_ASSIGNMENT_H MODIFY 
  TRANSACTION_TYPE_CODE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_USER MODIFY 
  SERVICE_USER_ID NULL;

ALTER TABLE EESRV.SERVICE_USER MODIFY 
  SERVICE_USER_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_USER MODIFY 
  USERNAME NULL;

ALTER TABLE EESRV.SERVICE_USER MODIFY 
  USERNAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_USER MODIFY 
  ACTIVE_FLAG NULL;

ALTER TABLE EESRV.SERVICE_USER MODIFY 
  ACTIVE_FLAG NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_USER MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE EESRV.SERVICE_USER MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_USER MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE EESRV.SERVICE_USER MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_USER MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE EESRV.SERVICE_USER MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_USER MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE EESRV.SERVICE_USER MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_USER MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE EESRV.SERVICE_USER MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  SERVICE_USER_H_ID NULL;

ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  SERVICE_USER_H_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  SERVICE_USER_ID NULL;

ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  SERVICE_USER_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  USERNAME NULL;

ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  USERNAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  ACTIVE_FLAG NULL;

ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  ACTIVE_FLAG NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  TRANSACTION_TYPE_CODE NULL;

ALTER TABLE EESRV.SERVICE_USER_H MODIFY 
  TRANSACTION_TYPE_CODE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_LOG MODIFY 
  SERVICE_LOG_ID NULL;

ALTER TABLE EESRV.SERVICE_LOG MODIFY 
  SERVICE_LOG_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_LOG MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE EESRV.SERVICE_LOG MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_LOG MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE EESRV.SERVICE_LOG MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_LOG MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE EESRV.SERVICE_LOG MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_LOG MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE EESRV.SERVICE_LOG MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE EESRV.SERVICE_LOG MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE EESRV.SERVICE_LOG MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
