SQL Statement
/* Table: PERSON, Owner: MISDBA */
CREATE TABLE PERSON (ID CHAR(6) NOT NULL,
        PASSWD CHAR(20) NOT NULL,
        AUTHORITY CHAR(1) DEFAULT '0',
        NAME VARCHAR(10),
        SEX CHAR(1) DEFAULT 'M' NOT NULL,
        BIRTHDAY TIMESTAMP,
        DEPARTMENT CHAR(3),
        JOB CHAR(3),
        EDU_LEVEL CHAR(1),
        SPECIALTY VARCHAR(20),
        ADDRESS VARCHAR(50),
        TEL VARCHAR(20),
        EMAIL VARCHAR(50),
        STATE CHAR(1) DEFAULT 'T',
        REMARK VARCHAR(4000),
CONSTRAINT PERSON_ID PRIMARY KEY (ID));

SQL Statement
/* Table: PERSONNEL, Owner: MISDBA */
CREATE TABLE PERSONNEL (ID INTEGER NOT NULL,
        PERSON CHAR(6) NOT NULL,
        CHANGE CHAR(1) NOT NULL,
        RECORD_TIME TIMESTAMP NOT NULL,
        DESCRIPTION VARCHAR(4000),
CONSTRAINT PERSONEL_ID PRIMARY KEY (ID));

SQL Statement
/* Table: DEPARTMENT, Owner: MISDBA */
CREATE TABLE DEPARTMENT (ID CHAR(3) NOT NULL,
        NAME VARCHAR(20) NOT NULL,
        MANAGER CHAR(6),
        INTRO VARCHAR(4000),
CONSTRAINT DEPARTMENT_ID PRIMARY KEY (ID));

SQL Statement
/* Table: EDU_LEVEL, Owner: MISDBA */
CREATE TABLE EDU_LEVEL (CODE CHAR(1) NOT NULL,
        DESCRIPTION VARCHAR(20) NOT NULL,
CONSTRAINT EDU_LEVEL_CODE PRIMARY KEY (CODE));

SQL Statement
/* Table: JOB, Owner: MISDBA */
CREATE TABLE JOB (CODE CHAR(3) NOT NULL,
        DESCRIPTION VARCHAR(20) NOT NULL,
CONSTRAINT JOB_CODE PRIMARY KEY (CODE));

SQL Statement
/* Table: PERSONNEL_CHANGE, Owner: MISDBA */
CREATE TABLE PERSONNEL_CHANGE (CODE CHAR(1) NOT NULL,
        DESCRIPTION VARCHAR(20),
CONSTRAINT PERSONNEL_CHANGE_CODE PRIMARY KEY (CODE));

SQL Statement
/* Table: COUNTER, Owner: MISDBA */
CREATE TABLE COUNTER (ID CHAR(1) NOT NULL,
        COUNTER_VALUE INTEGER,
        DESCRIPTION VARCHAR(10),
CONSTRAINT COUNTER_ID PRIMARY KEY (ID));

SQL Statement
/*  ForeignKey DEPARTMENT  */
ALTER TABLE PERSON
  ADD CONSTRAINT DEPARTMENT
  FOREIGN KEY (DEPARTMENT)
  REFERENCES DEPARTMENT;
/*  ForeignKey EDU_LEVEL  */
ALTER TABLE PERSON
  ADD CONSTRAINT EDU_LEVEL
  FOREIGN KEY (EDU_LEVEL)
  REFERENCES EDU_LEVEL;
/*  ForeignKey JOB  */
ALTER TABLE PERSON
  ADD CONSTRAINT JOB
  FOREIGN KEY (JOB)
  REFERENCES JOB;
/*  CheckConstraint SEX  */
ALTER TABLE PERSON
  ADD CONSTRAINT SEX
  CHECK (SEX='M' OR SEX='F');
/*  CheckConstraint STATE  */
ALTER TABLE PERSON
  ADD CONSTRAINT STATE
  CHECK (STATE='T' OR STATE='F');
/*  ForeignKey CHANGE  */
ALTER TABLE PERSONNEL
  ADD CONSTRAINT CHANGE
  FOREIGN KEY (CHANGE)
  REFERENCES PERSONNEL_CHANGE;
/*  ForeignKey PERSON  */
ALTER TABLE PERSONNEL
  ADD CONSTRAINT PERSON
  FOREIGN KEY (PERSON)
  REFERENCES PERSON;
/*  ForeignKey MANAGER  */
ALTER TABLE DEPARTMENT
  ADD CONSTRAINT MANAGER
  FOREIGN KEY (MANAGER)
  REFERENCES PERSON;