test

Tables (6)

basket (Untitled5)

  • bas_no (Key) — Primary key — NOT NULL
  • user_id (userId) — Foreign key → customer.user_id — NOT NULL
  • prd_no (Field)
  • totqty (Field3)

category (Untitled)

  • cat_no (Key) — Primary key — NOT NULL
  • cat_name (Field)

customer

  • user_id (userId) — Primary key — NOT NULL
  • user_pwd (userPwd)
  • user_name (userName)
  • addr
  • contact

order (Untitled3)

  • ord_no (Key) — Primary key — NOT NULL
  • user_id (userId) — Foreign key → customer.user_id — NOT NULL
  • order_date (Field)
  • order_addr (Field3)
  • rec_name (Field2)
  • rec_contact (Field4)
  • tot_qty (Field5)
  • tot_price (Field6)
  • point (Field7)
  • ord_type (Field8)

order detail (Untitled4)

  • det_no (Key) — Primary key — NOT NULL
  • ord_no (Key2) — Foreign key → order.ord_no — NOT NULL
  • user_id (userId) — Foreign key → order.user_id — NOT NULL
  • prd_no (Field)
  • ord_qty (Field2)

product

  • prd_no (prdNo) — Primary key — NOT NULL
  • bas_no (Key) — Foreign key → basket.bas_no — NOT NULL
  • user_id (userId) — Foreign key → basket.user_id — NOT NULL
  • det_no (Key2) — Foreign key → order detail.det_no — NOT NULL
  • ord_no (Key22) — Foreign key → order detail.ord_no — NOT NULL
  • user_id (userId2) — Foreign key → order detail.user_id — NOT NULL
  • prd_name (prdName)
  • prd_ctgr (prdCtgr)
  • prd_price (prdPrice)
  • prd_desc (prdDesc)
  • cat_no (Key3) — Foreign key → category.cat_no — NOT NULL