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