001 initial.sql

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
    );