mystoreschema.script

Enterprise Java Bean的PPT文档,很好的东西.

CREATE TABLE STOREACCESS(USERNAME VARCHAR(15),PASSWORD VARCHAR(15),USERID VARCHAR(6) NOT NULL PRIMARY KEY,CONSTRAINT SYS_STOREACCESS_UQ UNIQUE(USERNAME))

CREATE TABLE CUSTOMER(CUSTOMERID VARCHAR(6) NOT NULL PRIMARY KEY,USERID VARCHAR(6),FIRSTNAME VARCHAR(15),LASTNAME VARCHAR(15),ADDRESS VARCHAR(25),PHONE VARCHAR(10),MESSAGE VARCHAR(25),SHAREHOLDER_STAT VARCHAR(1) NOT NULL,CONSTRAINT SYS_FK_CUSTOMER FOREIGN KEY(USERID) REFERENCES STOREACCESS(USERID))

CREATE TABLE SUPPLIER(SUPPLIERID VARCHAR(6) NOT NULL PRIMARY KEY,USERID VARCHAR(6),FIRSTNAME VARCHAR(15),LASTNAME VARCHAR(15),ADDRESS VARCHAR(25),MESSAGE VARCHAR(25),CREDIT_LIMIT DECIMAL(12,2) NOT NULL,CONSTRAINT SYS_FK_SUPPLIER FOREIGN KEY(USERID) REFERENCES STOREACCESS(USERID))

CREATE TABLE MANAGER(MANAGERID VARCHAR(6) NOT NULL PRIMARY KEY,USERID VARCHAR(6),FIRSTNAME VARCHAR(15),LASTNAME VARCHAR(15),ADDRESS VARCHAR(25),MESSAGE VARCHAR(25),SALARY DECIMAL(12,2) NOT NULL,CONSTRAINT SYS_FK_MANAGER FOREIGN KEY(USERID) REFERENCES STOREACCESS(USERID))

CREATE TABLE ITEM(ITEMID VARCHAR(6) NOT NULL PRIMARY KEY,SUPPLIERID VARCHAR(6),DESCRIPTION VARCHAR(20),QUANTITY INTEGER,PRICE DECIMAL(12,2) NOT NULL,CONSTRAINT SYS_FK_SUPPLIER FOREIGN KEY(SUPPLIERID) REFERENCES SUPPLIER(SUPPLIERID))