likelion14th

Tables (7)

category (Untitled7)

  • category_id (카테고리ID) — long — Primary key — NOT NULL
  • name (카테고리명) — VARCHAR

comment (Untitled6)

  • comment_id (댓글아이디) — VARCHAR — Primary key — NOT NULL
  • content (댓글내용) — Text
  • date (댓글날짜) — DateTime
  • Field
  • user_id — long — Foreign key → user.user_id — NOT NULL
  • review_id (리뷰아이디) — VARCHAR — Foreign key → review.review_id — NOT NULL

item (Untitled2)

  • item_id (상품id) — INT — Primary key — NOT NULL
  • name (상품이름) — VARCHAR
  • price (상품가격) — Long
  • photo_img (상품이미지) — VARCHAR
  • stock (상품재고) — INT
  • description (상품설명) — VARCHAR
  • category_id (카테고리명) — VARCHAR — Foreign key → category.category_id — NOT NULL

order (Untitled4)

  • order_id (주문번호) — long — Primary key — NOT NULL
  • date (주문날짜) — DATETIME
  • status (주문상태) — VARCHAR
  • total_amount (총결제금액) — long
  • user_id — long — Foreign key → user.user_id — NOT NULL

order_item (Untitled5)

  • item_order_id (상품주문ID) — INT — Primary key — NOT NULL
  • item_count (주문개수) — INT
  • order_id (주문번호) — long — Foreign key → order.order_id — NOT NULL
  • item_id (상품id) — INT — Foreign key → item.item_id — NOT NULL
  • order_price (주문당시 단가) — long

review (Untitled3)

  • review_id (리뷰아이디) — long — Primary key — NOT NULL
  • score (별점) — Double
  • content (리뷰내용) — TEXT
  • date (리뷰날짜) — DATETIME
  • user_id — long — Foreign key → user.user_id — NOT NULL
  • item_id (상품id) — INT — Foreign key → item.item_id — NOT NULL

user (Untitled)

  • user_id — long — Primary key — NOT NULL
  • name (이름) — VARCHAR
  • email (이메일) — VARCHAR
  • password (비밀번호) — VARCHAR
  • photo_img (프로필사진) — VARCHAR
  • sns_id (소셜로그인아이디) — VARCHAR