Shopping
Tables (3)
Cart (장바구니)
- ct_no (Key) — Int — Primary key — NOT NULL
- usr_no (Key2) — Int — Foreign key → User.usr_no — NOT NULL
- prd_no (Key3) — Int — Foreign key → Product.prd_no — NOT NULL
- ct_qnt (수량) — Int
- Field (구매여부) — Boolean
Product (상품)
- prd_no (Key) — Int — Primary key — NOT NULL
- prd_nm (상품명) — String — NOT NULL
- prd_pc (상품 가격) — Int — NOT NULL
User (회원)
- usr_no (Key) — Int — Primary key — NOT NULL
- usr_eml (이메일) — String — NOT NULL
- usr_pw (비밀번호) — String — NOT NULL
- usr_nm (이름) — String
- usr_ph (전화번호) — String — NOT NULL
- usr_adr (주소) — String — NOT NULL