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)