commerce

Tables (4)

CartItem (cartItem)

  • cartItem id (id) — BIGINT — Primary key — NOT NULL
  • user id (userId) — BIGINT — Foreign key → User.user id — NOT NULL — ㅈㄷㄹ
  • product id (productId) — BIGINT — Foreign key → Product.product id — NOT NULL
  • quantity — BIGINT — NOT NULL

Product (product)

  • product id (id) — BIGINT — Primary key — NOT NULL
  • product name (name) — varchar — NOT NULL
  • product price (price) — BIGINT — NOT NULL
  • product description (description) — varchar — NOT NULL
  • product average rate (averageRating) — BIGINT — NOT NULL
  • product review count (reviewCount) — BIGINT — NOT NULL — 리뷰 수
  • product created date (createdDate) — DATETIME
  • product modified date (modifiedDate) — DATETIME

Review (review)

  • review id (id) — BIGINT — Primary key — NOT NULL
  • product id (productId) — BIGINT — Foreign key → Product.product id — NOT NULL
  • rating — double
  • review content (content) — varchar — NOT NULL — 리뷰 내용
  • review created date (createdDate) — DATETIME — NOT NULL
  • review modified date (modifiedDate) — DATETIME — NOT NULL
  • user id (userId) — BIGINT — Foreign key → User.user id — NOT NULL — ㅈㄷㄹ

User (user)

  • user id (id) — BIGINT — Primary key — NOT NULL — ㅈㄷㄹ
  • user id for login (userId) — varchar — NOT NULL
  • user password for login (password) — varchar — NOT NULL
  • user nickname (username) — varchar — NOT NULL
  • user created date (createdDate) — DATETIME — NOT NULL
  • user modified date (modifiedDate) — DATETIME — NOT NULL