ddmshop
Tables (16)
cart
- cart_id — BIGINT
- user_id — BIGINT
- created_at — TIMESTAMP
cart_item
- cart_item_id — BIGINT
- cart_id — BIGINT
- product_id — BIGINT
- quantity — INT — NOT NULL
- created_at — TIMESTAMP
category
- category_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- parent_category_id — BIGINT
coupon
- coupon_id — BIGINT
- code — VARCHAR(50) — NOT NULL
- discount_amount — DECIMAL(10, 2)
- expiry_date — DATE
- created_at — TIMESTAMP
favorite_product
- favorite_id — BIGINT
- product_id — BIGINT
- created_at — TIMESTAMP
notification
- notification_id — BIGINT
- user_id — BIGINT
- message — TEXT
- is_read — BOOLEAN
- created_at — TIMESTAMP
order_item
- order_item_id — BIGINT
- order_id — BIGINT
- product_id — BIGINT
- quantity — INT — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
orders
- order_id — BIGINT
- user_id — BIGINT
- total_price — DECIMAL(10, 2) — NOT NULL
- status — ENUM('주문완료', '배송준비중', '배송중', '배송완료')
- created_at — TIMESTAMP
product
- product_id — BIGINT
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- price — DECIMAL(10, 2) — NOT NULL
- image_url — VARCHAR(255)
- stock — INT
- category_id — BIGINT
- created_at — TIMESTAMP
product_option
- option_id — BIGINT
- product_id — BIGINT
- option_name — VARCHAR(255)
- option_value — VARCHAR(255)
- stock — INT
review
- review_id — BIGINT
- product_id — BIGINT
- user_id — BIGINT
- rating — INT
- content — TEXT
- created_at — TIMESTAMP
review_reply
- reply_id — BIGINT
- review_id — BIGINT
- user_id — BIGINT
- content — TEXT
- created_at — TIMESTAMP
reward_points
- reward_id — BIGINT
- user_id — BIGINT
- points — INT — NOT NULL
- created_at — TIMESTAMP
shipment
- shipment_id — BIGINT
- order_id — BIGINT
- status — ENUM('배송준비중', '배송중', '배송완료')
- tracking_number — VARCHAR(255)
- created_at — TIMESTAMP
user
- user_id — BIGINT
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(255)
- profile_image_url — VARCHAR(255)
- address — VARCHAR(255)
- phone_number — VARCHAR(20)
- created_at — TIMESTAMP
user_coupon
- user_coupon_id — BIGINT
- user_id — BIGINT
- coupon_id — BIGINT
- used — BOOLEAN
- created_at — TIMESTAMP