BidProject
Tables (4)
AUCTION (ac)
- Key (CODE) — varchar2(20) — Foreign key → SALES.Key — NOT NULL
- Key (TERM) — varchar2(20) — Foreign key → SALES.Key — NOT NULL
- Field (FINALPRICE) — number
- Field (BUYERID) — varchar(20)
BOARD (b)
- Key (ID) — varchar2(20) — Foreign key → USER1.Key — NOT NULL
- Key (USERNAME) — varchar2(20) — Foreign key → USER1.Key — NOT NULL
- Field (SEQ) — number
- Field (SUBJECT) — varchar2(255)
- Field (CONTENT) — varchar2(4000)
- Field (REF) — number
- Field (LEV) — number
- Field (STEP) — number
- Field (PSEQ) — number
- Field (REPLY) — number
- Field (HIT) — number
- Field (LOGTIME) — date default
SALES (s)
- Key (CODE) — varchar2(20) — Primary key — NOT NULL
- Key (TERM) — varchar2(20) — Primary key — NOT NULL
- Key (PRODNAME) — varchar(200) — Primary key — NOT NULL
- Key (ID) — varchar2(20) — Foreign key → USER1.Key — NOT NULL
- Field (CAT1) — varchar(20)
- Field (PRICE) — number
- Field (CONDITION) — varchar(50)
- Field (REF) — varchar2(1000)
- Field (DESCRIP) — varchar2(4000)
USER1 (u)
- Key (ID) — varchar2(20) — Primary key — NOT NULL
- Key (USERNAME) — varchar2(20) — Primary key — NOT NULL
- Field (PASSWOARD) — varchar2(20)
- Field (ROADFULLADDR) — varchar2(200)
- Field (PHONE) — varchar2(20)
- Field (PWQUESTION) — varchar2(100)
- Field (PWANSWER) — varchar2(20)