cool

Tables (5)

customer (Untitled)

  • c_id (Key) — varchar(30) — Primary key — NOT NULL
  • c_name (Field) — varchar(30)
  • c_pw (Field2) — varchar(30)
  • c_email (Field3) — varchar(40)
  • c_pnum (Field4) — varchar(30)

item (Untitled2)

  • i_num (Key) — int — Primary key — NOT NULL
  • i_id (Key3) — varchar(30) — Foreign key → customer.c_id — NOT NULL
  • i_pic (Field) — varchar(30)
  • i_name (Field3) — varchar(30)
  • i_price (Field4) — int
  • i_type (Field5) — varchar(30)
  • i_intro (Field6) — varchar(100)
  • i_date (Field7) — varchar(30)
  • i_ing (Field2) — varchar(10)
  • i_state (Field8) — varchar(10)

od (order)

  • o_num (Key) — int — Primary key — NOT NULL
  • o_sellid (Key2) — varchar(30) — Foreign key → customer.c_id — NOT NULL
  • i_num (Key3) — int — Foreign key → item.i_num — NOT NULL
  • o_buyid (Key32) — varchar(30) — Foreign key → item.i_id — NOT NULL
  • o_date (Field3) — varchar(30)
  • o_price (Field4) — int
  • o_item (Field5) — int

s_log (search log)

  • s_id (Key) — varchar(30) — Foreign key → customer.c_id — NOT NULL
  • s_key (Field) — varchar(30)

wish (wish list)

  • w_id (Key) — varchar(30) — Foreign key → customer.c_id — NOT NULL
  • w_inum (Key2) — int — Foreign key → item.i_num — NOT NULL