ourhome

Tables (4)

cart (장바구니)

  • cart_id (장바구니ID) — int — Primary key — NOT NULL
  • user_id (사용자ID) — varchar(20) — Foreign key → user.user_id — NOT NULL
  • goods_id (상품ID) — int — Foreign key → goods.goods_id — NOT NULL
  • goods_name (상품명) — varchar(200)
  • goods_quantity (수량) — int
  • goods_price (판매가) — int
  • goods_discount_per (할인율) — int
  • goods_discounted_price (할인가) — int

goods (상품)

  • goods_id (상품ID) — int — Primary key — NOT NULL
  • goods_name (상품명) — varchar(200)
  • goods_explanation (상품 설명) — varchar(500)
  • goods_price (판매가) — int
  • goods_storage (보관법) — varchar(50)
  • goods_discount_per (할인율) — int
  • goods_discounted_price (할인가) — int

goods_image (상품 이미지)

  • goods_image_id (상품이미지 ID) — int — Primary key — NOT NULL
  • goods_id (상품ID) — int — Foreign key → goods.goods_id — NOT NULL
  • goods_filename (이미지 파일명)

user (사용자)

  • user_id (사용자ID) — varchar(20) — Primary key — NOT NULL