쇼핑몰
테이블 (7)
cart
- cart_id — BIGINT
- user_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- quantity — INT — NOT NULL
- added_at — TIMESTAMP
- INDEX — idx_user
- CHECK — (quantity > 0)
categories
- category_id — BIGINT
- parent_category_id — BIGINT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- created_at — TIMESTAMP
- INDEX — idx_parent
order_items
- order_item_id — BIGINT
- order_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- quantity — INT — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- subtotal — DECIMAL(10, 2) — NOT NULL
- INDEX — idx_order
- INDEX — idx_product
- CHECK — (quantity > 0)
- CHECK — (price >= 0)
- CHECK — (subtotal >= 0)
orders
- order_id — BIGINT
- user_id — BIGINT — NOT NULL
- order_date — TIMESTAMP
- total_amount — DECIMAL(10, 2) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- shipping_address — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP
- INDEX — idx_user
- INDEX — idx_status
- INDEX — idx_order_date
- CHECK — (total_amount >= 0)
products
- product_id — BIGINT
- category_id — BIGINT
- name — VARCHAR(200) — NOT NULL
- description — TEXT
- price — DECIMAL(10, 2) — NOT NULL
- stock_quantity — INT — NOT NULL
- image_url — VARCHAR(500)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_category
- INDEX — idx_price
- CHECK — (price >= 0)
- CHECK — (stock_quantity >= 0)
reviews
- review_id — BIGINT
- user_id — BIGINT — NOT NULL
- product_id — BIGINT — NOT NULL
- rating — INT — NOT NULL
- content — TEXT
- created_at — TIMESTAMP
- INDEX — idx_user
- INDEX — idx_product
- INDEX — idx_rating
- CHECK — (rating >= 1 AND rating <= 5)
users
- user_id — BIGINT
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20)
- address — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- INDEX — idx_email