YunMarket
Tables (12)
Answer
- id — BIGINT — Primary key — NOT NULL
- question_id — BIGINT — Foreign key → Question.id — NOT NULL
- seller_id — BIGINT — Foreign key → Question.seller_id — NOT NULL
- contents — varchar
- deletedYn — boolean
Cart
- id — BIGINT — Primary key — NOT NULL
- customer_id — BIGINT — Foreign key → Customer.id — NOT NULL
- product_id — BIGINT — Foreign key → Product.id — NOT NULL
- quantity — INT
Category
- id — BIGINT — Primary key — NOT NULL
- name — varchar
Customer
- id — BIGINT — Primary key — NOT NULL
- email — varchar
- password — varchar
- phone — varchar
- address — varchar
- point — INT
- deletedYn — boolean
- created_date — DATETIME
- modified_date — DATETIME
Ordered
- id — BIGINT — Primary key — NOT NULL
- customer_id — BIGINT — Foreign key → Customer.id — NOT NULL
- product_id — BIGINT — Foreign key → Product.id — NOT NULL
- seller_id — BIGINT — Foreign key → Seller.id — NOT NULL
- transaction_id — BIGINT — Foreign key → Transaction.id — NOT NULL
- quantity — INT
- price — INT
- total_amount — INT
- created_date (created_datetime) — DATETIME
Product
- id — BIGINT — Primary key — NOT NULL
- category_id — BIGINT — Foreign key → Category.id — NOT NULL
- seller_id — BIGINT — Foreign key → Seller.id — NOT NULL
- name — varchar
- price — INT
- description — varchar
- quantity — INT
- image — varchar
- ordered_count — BIGINT
- deletedYn — boolean
- created_date — DATETIME
- modified_date — DATETIME
ProductViewHistory
- id — BIGINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → Product.id — NOT NULL
- userIp — varchar
Question
- id — BIGINT — Primary key — NOT NULL
- customer_id — BIGINT — Foreign key → Customer.id — NOT NULL
- product_id — BIGINT — Foreign key → Product.id — NOT NULL
- seller_id — BIGINT — Foreign key → Product.seller_id — NOT NULL
- contents — varchar
- deletedYn — boolean
Review
- id — BITINT — Primary key — NOT NULL
- product_id — BIGINT — Foreign key → Product.id — NOT NULL
- customer_id — BIGINT — Foreign key → Customer.id — NOT NULL
- rating — INT
- contents — varchar
- deletedYn — boolean
- created_date — DATETIME
- modified_date — DATETIME
ReviewComment
- id — BIGINT — Primary key — NOT NULL
- review_id — BITINT — Foreign key → Review.id — NOT NULL
- seller_id — BIGINT — Foreign key → Seller.id — NOT NULL
- contents — varchar
- deletedYn — boolean
- created_date — DATETIME
- modified_date — DATETIME
Seller
- id — BIGINT — Primary key — NOT NULL
- email — varchar
- password — varchar
- phone — varchar
- deletedYn — boolean
- created_date — DATETIME
- modified_date — DATETIME
Transaction
- id — BIGINT — Primary key — NOT NULL
- transaction_date — DATETIME
- transaction_price — INT
- point_use — INT
- deleted — boolean