多权限维修信息管理系统Delphi+SQL版.rar_Open Net_delphi can_usb_webapi asp.ne

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;