CREATE TABLE NOTICE ( NOTICE_ID INTEGER PRIMARY KEY, NOTICE_TITLE VARCHAR(500) NOT NULL, NOTICE_CONTENTS VARCHAR(4000) NOT NULL, NOTICE_REGISTRATION_DATE VARCHAR(10) NOT NULL, NOTICE_LAST_MODIFIER VARCHAR(100) NOT NULL, NOTICE_LAST_MODIFIED_DATE DATE, NOTICE_FILE_CNT INTEGER, NOTICE_RETRIEVED_CNT INTEGER );