db_final_exam

Tables (6)

Cart (Untitled2)

  • user_id (int) — pk — Foreign key → User.id — NOT NULL
  • product_id (Key) — pk — Foreign key → Product.id — NOT NULL
  • quantity (Field)
  • added_at (Field2)

Order (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • user_id (int) — pk — Foreign key → User.id — NOT NULL
  • total_amount (Field)
  • payment_date (Field2)
  • payment_method (Field3)
  • recipient_name (Field4)
  • shipping_address (Field5)
  • shipping_phone (Field6)
  • shipping_status (Field7)
  • shipping_company (Field8)
  • tracking_number (Field9)
  • created_at (Field10)

OrderItem (Untitled4)

  • order_id (Key3) — pk — Foreign key → Order.id — NOT NULL
  • product_id (Key2) — pk — Foreign key → Product.id — NOT NULL
  • quantity (Field)

Product (Untitled)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • description (Field2)
  • price (Field3)
  • brand (Field4)
  • category_id (Field5)
  • stock_quantity (Field6)
  • is_available (Field7)
  • registered_at (Field8)

Review (Untitled5)

  • product_id (Key) — pk — Foreign key → Product.id — NOT NULL
  • user_id (int) — pk — Foreign key → User.id — NOT NULL
  • rating (Field)
  • comment (Field2)
  • image_url (Field3)

User (사용자)

  • id (int) — pk — Primary key — NOT NULL
  • name (Field) — varchar
  • email (Field2)
  • password_hash (Field3)
  • phone (Field4)
  • default_address (Field5)
  • registered_at (Field6)