ALTER TABLE LOBR.FILE_ATTACHMENT_DETAIL
  DROP CONSTRAINT FILEATCHDTL_FILEATCH_FK;


ALTER TABLE LOBR.FILE_ATTACHMENT_DETAIL ADD (
  CONSTRAINT FILEATCHDTL_FILEATCH_FK 
  FOREIGN KEY (FILE_ATTACHMENT_ID) 
  REFERENCES LOBR.FILE_ATTACHMENT (FILE_ATTACHMENT_ID)
  ENABLE VALIDATE);
ALTER TABLE LOBR.FILE_ATTACHMENT_DETAIL
  DROP CONSTRAINT FILEATCHDT_PK;

ALTER TABLE LOBR.FILE_ATTACHMENT_DETAIL ADD (
  CONSTRAINT FILEATCHDT_PK
  PRIMARY KEY
  (FILE_ATTACHMENT_DETAIL_ID)
  ENABLE VALIDATE);
ALTER TABLE LOBR.FILE_ATTACHMENT
  DROP CONSTRAINT FILEATT_PK;

ALTER TABLE LOBR.FILE_ATTACHMENT ADD (
  CONSTRAINT FILEATT_PK
  PRIMARY KEY
  (FILE_ATTACHMENT_ID)
  ENABLE VALIDATE);
ALTER TABLE LOBR.FILE_ATTACHMENT
  DROP CONSTRAINT FILEATT_VOAENRAPP_FK;


ALTER TABLE LOBR.FILE_ATTACHMENT ADD (
  CONSTRAINT FILEATT_VOAENRAPP_FK 
  FOREIGN KEY (VOA_ENROLLMENT_APP_ID) 
  REFERENCES VOA.VOA_ENROLLMENT_APPLICATION (VOA_ENROLLMENT_APP_ID)
  ON DELETE SET NULL
  ENABLE VALIDATE);
ALTER TABLE LOBR.FILE_IMAGE
  DROP CONSTRAINT FILEIMG_FILEATCH_FK;


ALTER TABLE LOBR.FILE_IMAGE ADD (
  CONSTRAINT FILEIMG_FILEATCH_FK 
  FOREIGN KEY (FILE_ATTACHMENT_ID) 
  REFERENCES LOBR.FILE_ATTACHMENT (FILE_ATTACHMENT_ID)
  ENABLE VALIDATE);
ALTER TABLE LOBR.FILE_IMAGE
  DROP CONSTRAINT FILEIMG_PK;

ALTER TABLE LOBR.FILE_IMAGE ADD (
  CONSTRAINT FILEIMG_PK
  PRIMARY KEY
  (FILE_IMAGE_ID)
  ENABLE VALIDATE);
ALTER TABLE LOBR.FILE_ATTACHMENT MODIFY 
  FILE_ATTACHMENT_ID NULL;

ALTER TABLE LOBR.FILE_ATTACHMENT MODIFY 
  FILE_ATTACHMENT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_ATTACHMENT MODIFY 
  FILE_NAME NULL;

ALTER TABLE LOBR.FILE_ATTACHMENT MODIFY 
  FILE_NAME NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_ATTACHMENT MODIFY 
  FILE_MIME_TYPE NULL;

ALTER TABLE LOBR.FILE_ATTACHMENT MODIFY 
  FILE_MIME_TYPE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_ATTACHMENT MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE LOBR.FILE_ATTACHMENT MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_ATTACHMENT MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE LOBR.FILE_ATTACHMENT MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_ATTACHMENT MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE LOBR.FILE_ATTACHMENT MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_ATTACHMENT MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE LOBR.FILE_ATTACHMENT MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_ATTACHMENT MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE LOBR.FILE_ATTACHMENT MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_ATTACHMENT_DETAIL MODIFY 
  FILE_ATTACHMENT_DETAIL_ID NULL;

ALTER TABLE LOBR.FILE_ATTACHMENT_DETAIL MODIFY 
  FILE_ATTACHMENT_DETAIL_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_ATTACHMENT_DETAIL MODIFY 
  FILE_ATTACHMENT_ID NULL;

ALTER TABLE LOBR.FILE_ATTACHMENT_DETAIL MODIFY 
  FILE_ATTACHMENT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_ATTACHMENT_DETAIL MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE LOBR.FILE_ATTACHMENT_DETAIL MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_ATTACHMENT_DETAIL MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE LOBR.FILE_ATTACHMENT_DETAIL MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_ATTACHMENT_DETAIL MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE LOBR.FILE_ATTACHMENT_DETAIL MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_ATTACHMENT_DETAIL MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE LOBR.FILE_ATTACHMENT_DETAIL MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_ATTACHMENT_DETAIL MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE LOBR.FILE_ATTACHMENT_DETAIL MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_IMAGE MODIFY 
  FILE_IMAGE_ID NULL;

ALTER TABLE LOBR.FILE_IMAGE MODIFY 
  FILE_IMAGE_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_IMAGE MODIFY 
  FILE_ATTACHMENT_ID NULL;

ALTER TABLE LOBR.FILE_IMAGE MODIFY 
  FILE_ATTACHMENT_ID NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_IMAGE MODIFY 
  FILE_IMAGE NULL;

ALTER TABLE LOBR.FILE_IMAGE MODIFY 
  FILE_IMAGE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_IMAGE MODIFY 
  RECORD_CREATED_BY NULL;

ALTER TABLE LOBR.FILE_IMAGE MODIFY 
  RECORD_CREATED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_IMAGE MODIFY 
  RECORD_CREATED_DATE NULL;

ALTER TABLE LOBR.FILE_IMAGE MODIFY 
  RECORD_CREATED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_IMAGE MODIFY 
  RECORD_MODIFIED_BY NULL;

ALTER TABLE LOBR.FILE_IMAGE MODIFY 
  RECORD_MODIFIED_BY NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_IMAGE MODIFY 
  RECORD_MODIFIED_DATE NULL;

ALTER TABLE LOBR.FILE_IMAGE MODIFY 
  RECORD_MODIFIED_DATE NOT NULL
  ENABLE VALIDATE;
ALTER TABLE LOBR.FILE_IMAGE MODIFY 
  RECORD_MODIFIED_COUNT NULL;

ALTER TABLE LOBR.FILE_IMAGE MODIFY 
  RECORD_MODIFIED_COUNT NOT NULL
  ENABLE VALIDATE;
