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