shoping

Tables (9)

PurchaseFailedlist (구매실패목록)

  • Key (pfi_num) — int — Primary key — NOT NULL
  • pl_num (pfl_pl_num) — int — Foreign key → Purchaselist.pl_num — NOT NULL

Purchaselist (구매목록)

  • pl_num — int — Primary key — NOT NULL
  • pl_pr_num — int — Foreign key → product.pr_num — NOT NULL
  • pl_me_num — int — Foreign key → member.me_num — NOT NULL

Purchaserefountlist (환불목록)

  • Key (prl_num) — int — Primary key — NOT NULL
  • prl_pl_num — int — Foreign key → Purchaselist.pl_num — NOT NULL

division (분류)

  • di_num — int — Primary key — NOT NULL
  • di_info — varchar(10)

member (회원)

  • me_num — int — Primary key — NOT NULL
  • me_id — varchar(13)
  • me_pw — varchar(20)
  • me_email — varchar(50)
  • me_phonenum — varchar(20)

product (제품)

  • pr_num — int — Primary key — NOT NULL
  • pr_name — varchar(20)
  • pr_di_num — int — Foreign key → division.di_num — NOT NULL
  • pr_price — int
  • pr_info — varchar(100)

productImg (제품이미지)

  • pi_num — int — Primary key — NOT NULL
  • pi_img — img
  • pi_pr_num — int — Foreign key → product.pr_num — NOT NULL

returnlist (반품목록)

  • Key (rl_num) — int — Primary key — NOT NULL
  • pl_num — int — Foreign key → Purchaselist.pl_num — NOT NULL

shoppingbasket (장바구니)

  • sb_num — int — Primary key — NOT NULL
  • sb_me_num — int — Foreign key → member.me_num — NOT NULL
  • sb_pr_num — int — Foreign key → product.pr_num — NOT NULL