likelion14th

Tables (7)

category (Untitled3)

  • 카테고리ID (category_id) — INT — Primary key — NOT NULL
  • 카테고리이름 (category_name) — VARCHAR(255)

comment (Untitled7)

  • 댓글ID (comment_id) — INT — Primary key — NOT NULL
  • 댓글좋아요 (comment_like) — INT
  • 사용자ID (user_id) — INT — Foreign key → user.사용자ID — NOT NULL
  • 리뷰ID (review_id) — INT — Foreign key → review.리뷰ID — NOT NULL

order (Untitled5)

  • 주문번호 (ordr_id) — INT — Primary key — NOT NULL
  • 주문날짜 (order_date) — DATETIME
  • 주문상태 (order_status) — VARCHAR(50)
  • 사용자ID (user_id) — INT — Foreign key → user.사용자ID — NOT NULL

product (Untitled2)

  • 상품ID (product_id) — INT — Primary key — NOT NULL
  • 상품가격 (product_price) — INT
  • 상품개수 (product_quantity) — INT
  • 삼품이름 (product_name) — VARCHAR(255)
  • 별점평균 (product_rating_average) — DECIMAL(3, 2)
  • 상품설명 (product_description) — TEXT
  • 카테고리ID (category_id) — INT — Foreign key → category.카테고리ID — NOT NULL

product_order (Untitled6)

  • 상품주문ID (product_order_id) — INT — Primary key — NOT NULL
  • 상품ID (product_id) — INT — Foreign key → product.상품ID — NOT NULL
  • 주문번호 (ordr_id) — INT — Foreign key → order.주문번호 — NOT NULL
  • 주문개수 (product_order_count) — INT

review (Untitled4)

  • 리뷰ID (review_id) — INT — Primary key — NOT NULL
  • 별점 (review_rating) — INT
  • 리뷰내용 (review_content) — TEXT
  • 리뷰날짜 (review_date) — DATETIME
  • 사용자ID (user_id) — INT — Foreign key → user.사용자ID — NOT NULL
  • 상품ID (product_id) — INT — Foreign key → product.상품ID — NOT NULL

user (Untitled)

  • 사용자ID (user_id) — INT — Primary key — NOT NULL
  • 사용자이름 (user_name) — VARCHAR(50)
  • 사용자이메일 (user_email) — VARCHAR(50)
  • 사용자비밀번호 (user_password) — VARCHAR(255)