NHS

Tables (4)

IMAGE (상품이미지)

  • product_id (Key) — Foreign key → PRODUCT.product_id — NOT NULL
  • image_id (Field)
  • origin_name (Field2)
  • name (Field3)
  • path (Field4)
  • ext (Field5)
  • thumbnail_yn (Field6)

PRODUCT (상품)

  • product_id (Key) — Primary key — NOT NULL
  • detail (Field)
  • price (Field2)
  • stock (Field3)
  • title (Field4)
  • writer (Field5)
  • user_id (Key2) — Foreign key → USER.user_id — NOT NULL

PRODUCT_OPTION (상품 옵션)

  • option_id (Key) — Primary key — NOT NULL
  • product_id (Key2) — Foreign key → PRODUCT.product_id — NOT NULL
  • name (Field)
  • content (Field2)

USER (사용자)

  • user_id (Key) — Primary key — NOT NULL
  • login_id (Field)
  • login_password (Field2)
  • info (Field3)