test

Tables (4)

category (카테고리 상세)

  • category_id (카테고리 id) — Primary key — NOT NULL
  • goods_id (상품 id) — Foreign key → goods.goods_id — NOT NULL
  • picture_id (사진 id) — Foreign key → goods.picture_id
  • user_id (등록자 id) — Foreign key → goods.user_id — NOT NULL
  • category (카테고리 상세)

goods (상품)

  • goods_id (상품 id) — Primary key — NOT NULL
  • picture_id (사진 id) — Foreign key → picture.id
  • user_id (등록자 id) — Foreign key → user.id — NOT NULL
  • image (이미지)
  • amount (가격)
  • url (구매가능한 url)
  • category (카테고리)
  • thumb (좋아요)

picture (사진)

  • id (사진 id) — Primary key — NOT NULL
  • user_id (등록자 id) — Foreign key → user.id — NOT NULL
  • style (스타일)
  • category (카테고리)
  • thumb (좋아요)
  • comment (댓글)

user (사용자)

  • id — Primary key — NOT NULL
  • password
  • link (로그인 연동정보)
  • admin (운영자 여부) — NOT NULL