sql12.txt

维修信息管理系统

CREATE DOMAIN CODE_EQUIP AS CHAR(12) NOT NULL;
CREATE DOMAIN CODE_MID AS CHAR(5) NOT NULL;
CREATE DOMAIN CODE_PASSWORD AS CHAR(20) NOT NULL;
CREATE DOMAIN CODE_PERSON AS CHAR(6) NOT NULL;
CREATE DOMAIN CODE_SHORT AS CHAR(1) NOT NULL;
CREATE DOMAIN CODE_SYSTEM AS CHAR(3) NOT NULL;
CREATE DOMAIN CODE_TYPE AS CHAR(2) NOT NULL;
CREATE DOMAIN CODE_WORKPLACE AS CHAR(8) NOT NULL;
CREATE DOMAIN TEXT_LONG AS VARCHAR(200);
CREATE DOMAIN TEXT_MID AS VARCHAR(50);
CREATE DOMAIN TEXT_SHORT AS VARCHAR(20);

/* Table: ODB_EQUIP_FAILURE, Owner: ERDBA */
CREATE TABLE ODB_EQUIP_FAILURE (ID INTEGER NOT NULL,
        EQUIP CODE_EQUIP,
        FIND_DATE TIMESTAMP NOT NULL,
        DESCRIP TEXT_LONG,
        MODE CODE_MID  DEFAULT '00000',
        CAUSE CODE_MID  DEFAULT '00000',
        CONSEQUENCE CODE_MID  DEFAULT '00000',
        RESULT CODE_SHORT  DEFAULT '0',
        END_DATE TIMESTAMP,
        LAST_MODIFY TIMESTAMP NOT NULL,
        PERSON CODE_PERSON,
        REMARK TEXT_LONG,
CONSTRAINT ODB_EQUIP_FAILURE_ID PRIMARY KEY (ID));

/* Table: ODB_EQUIP_MOVEMENT, Owner: ERDBA */
CREATE TABLE ODB_EQUIP_MOVEMENT (ID INTEGER NOT NULL,
        EQUIP CODE_EQUIP,
        OPERATION CODE_SHORT,
        MOVE_DATE TIMESTAMP NOT NULL,
        WORKPLACE CODE_WORKPLACE,
        LAST_MODIFY TIMESTAMP NOT NULL,
        PERSON CODE_PERSON,
        REMARK TEXT_LONG,
CONSTRAINT ODB_EQUIP_MOVEMENT_ID PRIMARY KEY (ID));

/* Table: RDB_GROUP_INFO, Owner: ERDBA */
CREATE TABLE RDB_GROUP_INFO (ID CODE_MID,
        NAME TEXT_SHORT,
        GROUP_CHAR TEXT_LONG,
        BOUNDARY BLOB SUB_TYPE 0 SEGMENT SIZE 80,
        DISTRIBUTION CODE_SHORT,
        R1 FLOAT,
        R2 FLOAT,
        R3 FLOAT,
        MTTF FLOAT,
CONSTRAINT RDB_GROUP_INFO_ID PRIMARY KEY (ID));

/* Table: ADB_PERSON, Owner: ERDBA */
CREATE TABLE ADB_PERSON (ID CODE_PERSON,
        NAME TEXT_SHORT,
        TEL TEXT_MID,
        PASSWD CODE_PASSWORD,
        AUTHORITY CODE_SHORT,
CONSTRAINT ADB_PERSON_ID PRIMARY KEY (ID));

/* Table: ADB_MERCHANT, Owner: ERDBA */
CREATE TABLE ADB_MERCHANT (ID CODE_MID,
        NAME TEXT_MID,
        LINKMAN TEXT_SHORT,
        TEL TEXT_MID,
CONSTRAINT ADB_MERCHANT_ID PRIMARY KEY (ID));

/* Table: ADB_OPERATION, Owner: ERDBA */
CREATE TABLE ADB_OPERATION (CODE CODE_SHORT,
        DESCRIPT TEXT_SHORT,
CONSTRAINT ADB_OPERATION_CODE PRIMARY KEY (CODE));

/* Table: ADB_EQUIP, Owner: ERDBA */
CREATE TABLE ADB_EQUIP (ID CODE_EQUIP,
        NAME TEXT_SHORT,
        BUY_DATE TIMESTAMP,
        INI_WORKPLACE CODE_WORKPLACE,
        ENG_CHAR TEXT_LONG,
        MERCHANT CODE_MID,
CONSTRAINT ADB_EQUIP_ID PRIMARY KEY (ID));

/* Table: ADB_WORKPLACE, Owner: ERDBA */
CREATE TABLE ADB_WORKPLACE (CODE CODE_WORKPLACE,
        SYSTEM CODE_SYSTEM,
        TYPE CODE_TYPE,
        EQUIP_GROUP CODE_MID DEFAULT '00000',
CONSTRAINT ADB_WORKPLACE_CODE PRIMARY KEY (CODE));

/* Table: ADB_SYSTEM, Owner: ERDBA */
CREATE TABLE ADB_SYSTEM (CODE CODE_SYSTEM,
        DESCRIPT TEXT_SHORT,
CONSTRAINT ADB_SYSTEM_CODE PRIMARY KEY (CODE));

/* Table: ADB_TYPE, Owner: ERDBA */
CREATE TABLE ADB_TYPE (CODE CODE_TYPE,
        DESCRIPT TEXT_SHORT,
CONSTRAINT ADB_TYPE_CODE PRIMARY KEY (CODE));

/* Table: ADB_DISTRIBUTION, Owner: ERDBA */
CREATE TABLE ADB_DISTRIBUTION (CODE CODE_SHORT,
        NAME TEXT_SHORT,
        PARA_NUM SMALLINT,
        FORMULA TEXT_MID,
CONSTRAINT ADB_DISTRIBUTION_CODE PRIMARY KEY (CODE));

/* Table: ADB_MODE, Owner: ERDBA */
CREATE TABLE ADB_MODE (CODE CODE_MID,
        DESCRIPT TEXT_SHORT,
CONSTRAINT ADB_MODE_CODE PRIMARY KEY (CODE));

/* Table: ADB_CAUSE, Owner: ERDBA */
CREATE TABLE ADB_CAUSE (CODE CODE_MID,
        DESCRIPT TEXT_SHORT,
CONSTRAINT ADB_CAUSE_CODE PRIMARY KEY (CODE));

/* Table: ADB_CONSEQUENCE, Owner: ERDBA */
CREATE TABLE ADB_CONSEQUENCE (CODE CODE_MID,
        DESCRIPT TEXT_SHORT,
CONSTRAINT ADB_CONSEQUENCE_CODE PRIMARY KEY (CODE));

/* Table: ADB_RESULT, Owner: ERDBA */
CREATE TABLE ADB_RESULT (CODE CODE_SHORT,
        DESCRIPT TEXT_SHORT,
CONSTRAINT ADB_RESULT_CODE PRIMARY KEY (CODE));

/*  ForeignKey CAUSE  */
ALTER TABLE ODB_EQUIP_FAILURE
  ADD CONSTRAINT CAUSE 
  FOREIGN KEY (CAUSE) 
  REFERENCES ADB_CAUSE;
/*  ForeignKey CONSEQUENCE  */
ALTER TABLE ODB_EQUIP_FAILURE
  ADD CONSTRAINT CONSEQUENCE 
  FOREIGN KEY (CONSEQUENCE) 
  REFERENCES ADB_CONSEQUENCE;
/*  ForeignKey EQUIP  */
ALTER TABLE ODB_EQUIP_FAILURE
  ADD CONSTRAINT EQUIP 
  FOREIGN KEY (EQUIP) 
  REFERENCES ADB_EQUIP;
/*  ForeignKey MODE  */
ALTER TABLE ODB_EQUIP_FAILURE
  ADD CONSTRAINT MODE 
  FOREIGN KEY (MODE) 
  REFERENCES ADB_MODE;
/*  ForeignKey PERSON  */
ALTER TABLE ODB_EQUIP_FAILURE
  ADD CONSTRAINT PERSON 
  FOREIGN KEY (PERSON) 
  REFERENCES ADB_PERSON;
/*  ForeignKey RESULT  */
ALTER TABLE ODB_EQUIP_FAILURE
  ADD CONSTRAINT RESULT 
  FOREIGN KEY (RESULT) 
  REFERENCES ADB_RESULT;
/*  ForeignKey EQUIP2  */
ALTER TABLE ODB_EQUIP_MOVEMENT
  ADD CONSTRAINT EQUIP2 
  FOREIGN KEY (EQUIP) 
  REFERENCES ADB_EQUIP;
/*  ForeignKey OPERATION  */
ALTER TABLE ODB_EQUIP_MOVEMENT
  ADD CONSTRAINT OPERATION 
  FOREIGN KEY (OPERATION) 
  REFERENCES ADB_OPERATION;
/*  ForeignKey PERSON2  */
ALTER TABLE ODB_EQUIP_MOVEMENT
  ADD CONSTRAINT PERSON2 
  FOREIGN KEY (PERSON) 
  REFERENCES ADB_PERSON;
/*  ForeignKey WORKPLACE  */
ALTER TABLE ODB_EQUIP_MOVEMENT
  ADD CONSTRAINT WORKPLACE 
  FOREIGN KEY (WORKPLACE) 
  REFERENCES ADB_WORKPLACE;
/*  ForeignKey DISTRIBUTION  */
ALTER TABLE RDB_GROUP_INFO
  ADD CONSTRAINT DISTRIBUTION 
  FOREIGN KEY (DISTRIBUTION) 
  REFERENCES ADB_DISTRIBUTION;
/*  ForeignKey MERCHANT  */
ALTER TABLE ADB_EQUIP
  ADD CONSTRAINT MERCHANT 
  FOREIGN KEY (MERCHANT) 
  REFERENCES ADB_MERCHANT;
/*  ForeignKey WORKPLACE3  */
ALTER TABLE ADB_EQUIP
  ADD CONSTRAINT WORKPLACE3 
  FOREIGN KEY (INI_WORKPLACE) 
  REFERENCES ADB_WORKPLACE;
/*  ForeignKey EQUIP_GROUP  */
ALTER TABLE ADB_WORKPLACE
  ADD CONSTRAINT EQUIP_GROUP 
  FOREIGN KEY (EQUIP_GROUP) 
  REFERENCES RDB_GROUP_INFO;
/*  ForeignKey SYSTEM  */
ALTER TABLE ADB_WORKPLACE
  ADD CONSTRAINT SYSTEM 
  FOREIGN KEY (SYSTEM) 
  REFERENCES ADB_SYSTEM;
/*  ForeignKey TYPE  */
ALTER TABLE ADB_WORKPLACE
  ADD CONSTRAINT TYPE 
  FOREIGN KEY (TYPE) 
  REFERENCES ADB_TYPE;