BIDPROJECT

Tables (4)

Untitled (USER1)

  • Key (ID) — varchar2(20) — Primary key — NOT NULL
  • Key2 (USERNAME) — varchar2(20) — Primary key — NOT NULL
  • Field (PASSWORD) — varchar2(20)
  • Field2 (ROADFULLADDR) — varchar2(200)
  • Field3 (PHONE) — varchar2(20)
  • Field (PWQUESTION) — varchar2(100)
  • Field (PWANSWER) — varchar2(20)

Untitled (SALES)

  • Key (CODE) — varchare2(20) — Primary key — NOT NULL
  • Key2 (TERM) — varchar2(20) — Primary key — NOT NULL
  • Key (ID) — varchar2(20) — Foreign key → Untitled.Key — NOT NULL
  • Key2 (USERNAME) — varchar2(20) — Foreign key → Untitled.Key2 — NOT NULL
  • Field (CAT1) — varchar2(20)
  • Field (PRODNAME) — varchar2(200)
  • Field (PRICE) — number
  • Field (CONDITION) — varchar2(50)
  • Field (REF) — varchar2(1000)
  • Field (DESCRIP) — varchar2(4000)

Untitled (BOARD)

  • Key (ID) — varchar2(20) — Foreign key → Untitled.Key — NOT NULL
  • Key2 (USERNAME) — varchar2(20) — Foreign key → Untitled.Key2 — NOT NULL
  • Field (SEQ) — number
  • Field2 (SUBJECT) — varchar2(255)
  • Field3 (CONTENT) — varchar2(4000)
  • Field4 (LEV) — number
  • Field (STEP) — number
  • Field (PSEQ) — number
  • Field (REPLY) — number
  • Field (HIT) — number
  • Field (LOGTIME) — DATE

Untitled (AUCTION)

  • Key (ID) — varchar2(20) — Foreign key → Untitled.Key — NOT NULL
  • Key (CODE) — varchare2(20) — Foreign key → Untitled.Key — NOT NULL
  • Key2 (TERM) — varchar2(20) — Foreign key → Untitled.Key2 — NOT NULL
  • Field (FINALPRICE) — number