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