aiweb
Tables (7)
Cart (장바구니)
- cart_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
CartItems (장바구니 항목들)
- cart_item_id — INT — Primary key — NOT NULL
- cart_id (cart_id2) — INT — Foreign key → Cart.cart_id — NOT NULL
- product_id — INT — Foreign key → Products.product_id — NOT NULL
- quantity — INT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
Categories (제품 카테고리)
- category_id — INT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
OrderItems (주문된 제품)
- order_item_id — INT — Primary key — NOT NULL
- order_id — INT — Foreign key → Orders.order_id — NOT NULL
- product_id (product_id2) — INT — Foreign key → Products.product_id — NOT NULL
- quantity — INT — NOT NULL
- price — DECIMAL(10, 2) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
Orders (주문)
- order_id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → Users.user_id — NOT NULL
- status — ENUM('pending', 'completed', 'cancelled')
- total_amount — DECIMAL(10, 2) — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
Products (제품)
- product_id — INT — Primary key — NOT NULL
- category_id (category_id2) — INT — Foreign key → Categories.category_id — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- price — DECIMAL(10, 2) — NOT NULL
- stock — INT — NOT NULL
- category_id — INT
- created_at — DATETIME
- updated_at — DATETIME
Users (사용자)
- user_id — INT — Primary key — NOT NULL
- name — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — ENUM('admin', 'customer')
- created_at — DATETIME
- updated_at — DATETIME