sql7.txt

来自「工资管理系统的DELPHI版本」· 文本 代码 · 共 54 行

/* Table: SALARY_SET, Owner: MISDBA */
CREATE TABLE SALARY_SET (PERSON CHAR(6) NOT NULL,
        SALARY FLOAT,
CONSTRAINT SALARY_SET_PEROSN PRIMARY KEY (PERSON));

/* Table: SALARY_OTHER, Owner: MISDBA */
CREATE TABLE SALARY_OTHER (ID INTEGER NOT NULL,
        YEARMONTH CHAR(7) NOT NULL,
        PERSON CHAR(6) NOT NULL,
        OTHER_TYPE CHAR(1) NOT NULL,
        NAME VARCHAR(10) NOT NULL,
        MONEY FLOAT,
        DESCRIPTION VARCHAR(200),
CONSTRAINT SALARY_OTHER_ID PRIMARY KEY (ID));

/* Table: OTHER_TYPE, Owner: MISDBA */
CREATE TABLE OTHER_TYPE (CODE CHAR(1) NOT NULL,
        DESCRIPTION VARCHAR(10) NOT NULL,
CONSTRAINT TYPE_CODE PRIMARY KEY (CODE));

/* Table: SALARY, Owner: MISDBA */
CREATE TABLE SALARY (ID INTEGER NOT NULL,
        YEARMONTH CHAR(7) NOT NULL,
        PERSON CHAR(6) NOT NULL,
        BASIC FLOAT,
        BONUS FLOAT,
        ADD_DETAIL VARCHAR(200),
        ADD_TOTAL FLOAT,
        SUB_DETAIL VARCHAR(200),
        SUB_TOTAL FLOAT,
        TOTAL FLOAT,
CONSTRAINT SALARY_ID PRIMARY KEY (ID));

/*  ForeignKey PERSON8  */
ALTER TABLE SALARY_SET
  ADD CONSTRAINT PERSON8 
  FOREIGN KEY (PERSON) 
  REFERENCES PERSON;
/*  ForeignKey PERSON9  */
ALTER TABLE SALARY_OTHER
  ADD CONSTRAINT PERSON9 
  FOREIGN KEY (PERSON) 
  REFERENCES PERSON;
/*  ForeignKey OTHER_TYPE  */
ALTER TABLE SALARY_OTHER
  ADD CONSTRAINT OTHER_TYPE 
  FOREIGN KEY (OTHER_TYPE) 
  REFERENCES OTHER_TYPE;
/*  ForeignKey PERSON10  */
ALTER TABLE SALARY
  ADD CONSTRAINT PERSON10 
  FOREIGN KEY (PERSON) 
  REFERENCES PERSON;