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