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