
npu25.npu.edu
server=j2ee_huh
USER=cs536a1_huanghao
PASSWORD=cs536a1_huanghao

COnnection Pool : OraclePool
JNDI name : Auction

************** Term Project : WE USE THREE TABLES: **************************

DROP TABLE SALE_ITEM;
CREATE TABLE SALE_ITEM(
ITEMID 	    NUMBER(38),
SUMMARY     VARCHAR2(50),
DESCRIPTION VARCHAR2(500),
ITEMNUMBER  NUMBER(10),
STARTDATE   DATE,
CLOSEDATE   DATE,
STARTPRICE  NUMBER(38,2),
INCREMENTAL NUMBER(38,2),
SELLER      VARCHAR2(40),
HIGHESTBID  NUMBER(38,2),
HIGHBIDDER  VARCHAR2(40),
BIDCOUNT    NUMBER(38),
SOLDSTATUS  NUMBER(10),
NOTE        VARCHAR2(20)
);


DROP TABLE REGISTRATION;
CREATE TABLE REGISTRATION(
USERID      VARCHAR2(40),
PASSWORD    VARCHAR2(40),
NAME        VARCHAR2(40),
EMAIL       VARCHAR2(80),
CREDITCARD  VARCHAR2(20),
BALANCE     NUMBER(38,2),
ADDRESS     VARCHAR2(60),
PHONE       VARCHAR2(30),
NOTE        VARCHAR2(20)
);


DROP TABLE BIDS;
CREATE TABLE BIDS(
BIDID    NUMBER PRIMARY KEY,
BIDDER   VARCHAR2(40),
ITEMID   NUMBER(38),
BID      NUMBER(38,2),
BIDDATE  DATE,
COUNTER  NUMBER(38),
NOTE     VARCHAR2(20)
);



--------------------------------------- REFERENCE  ---------------------------------------


