db

Tables (15)

Address

  • address_id — INT
  • user_id — INT — Foreign key → User.user_id — NOT NULL
  • recipient_name — VARCHAR(50)
  • phone — VARCHAR(20)
  • address — VARCHAR(255)
  • is_default — BOOLEAN

Brand

  • brand_id — INT
  • brand_name — VARCHAR(100)

Cart

  • cart_id — INT
  • user_id — INT — Foreign key → User.user_id
  • created_at — DATETIME

CartItem

  • cart_item_id — INT
  • cart_id — INT — Foreign key → Cart.cart_id
  • product_id — INT — Foreign key → Product.product_id
  • option_value_id — INT — Foreign key → OptionValue.option_value_id
  • quantity — INT

Category

  • category_id — INT
  • category_name — VARCHAR(100)
  • parent_id — INT — Foreign key → Category.category_id

Inquiry

  • inquiry_id — INT
  • user_id — INT — Foreign key → User.user_id
  • title — VARCHAR(200)
  • content — TEXT
  • status — VARCHAR(50)
  • created_at — DATETIME

OptionValue

  • option_value_id — INT
  • option_id — INT — Foreign key → ProductOption.option_id
  • option_value_name — VARCHAR(100)
  • stock_quantity — INT
  • sku — VARCHAR(100)

OrderItem

  • order_item_id — INT
  • order_id — INT — Foreign key → Orders.order_id
  • product_id — INT — Foreign key → Product.product_id
  • option_value_id — INT — Foreign key → OptionValue.option_value_id
  • quantity — INT
  • price — INT

Orders

  • order_id — INT
  • user_id — INT — Foreign key → User.user_id
  • address_id — INT — Foreign key → Address.address_id
  • order_status — VARCHAR(50)
  • total_amount — INT
  • ordered_at — DATETIME

Payment

  • payment_id — INT
  • order_id — INT — Foreign key → Orders.order_id
  • payment_method — VARCHAR(50)
  • payment_status — VARCHAR(50)
  • paid_amount — INT
  • paid_at — DATETIME

Product

  • product_id — INT
  • category_id — INT — Foreign key → Category.category_id
  • brand_id — INT — Foreign key → Brand.brand_id
  • product_name — VARCHAR(100)
  • price — INT
  • description — TEXT
  • main_image — VARCHAR(255)
  • created_at — DATETIME

ProductOption

  • option_id — INT
  • product_id — INT — Foreign key → Product.product_id
  • option_name — VARCHAR(100)
  • extra_price — INT

Seller

  • seller_id — INT
  • seller_name — VARCHAR(100)
  • business_number — VARCHAR(100)
  • seller_phone — VARCHAR(20)

Shipping

  • shipping_id — INT
  • order_id — INT — Foreign key → Orders.order_id
  • courier — VARCHAR(50)
  • tracking_number — VARCHAR(100)
  • shipping_status — VARCHAR(50)
  • shipped_at — DATETIME
  • delivered_at — DATETIME

User

  • user_id — INT
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20)
  • created_at — DATETIME