ASD

Tables (5)

categories (CopyOfCopyOfUntitled2)

  • category_id (Key) — INT — Primary key — NOT NULL
  • category_name (Field2) — VARCHAR(255)
  • description (Field5) — TEXT

order_items (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled2)

  • order_item_id (Key) — INT — Primary key — NOT NULL
  • order_id (Key2) — INT — Foreign key → orders.order_id — NOT NULL
  • user_id (Key22) — INT — Foreign key → orders.user_id — NOT NULL
  • order_id (Field2) — INT
  • product_id (Field5) — INT
  • quantity (Field) — INT
  • price (Field6) — DECIMAL(10, 2)

orders (CopyOfCopyOfCopyOfCopyOfUntitled2)

  • order_id (Key) — INT — Primary key — NOT NULL
  • user_id (Key2) — INT — Foreign key → users.user_id — NOT NULL
  • user_id (Field2) — VARCHAR(100)
  • total_price (Field5) — DECIMAL(10, 2)
  • order_status (Field) — ENUM('Pending', 'Paid', 'Shipped', 'Cancelled')
  • created_at (Field6) — TIMESTAMP

products (CopyOfCopyOfCopyOfUntitled2)

  • product_id (Key) — INT — Primary key — NOT NULL
  • category_id (Key2) — INT — Foreign key → categories.category_id — NOT NULL
  • order_item_id (Key3) — INT — Foreign key → order_items.order_item_id — NOT NULL
  • order_id (Key22) — INT — Foreign key → order_items.order_id — NOT NULL
  • user_id (Key222) — INT — Foreign key → order_items.user_id — NOT NULL
  • product_name (Field2) — VARCHAR(255)
  • description (Field5) — TEXT
  • price (Field) — DECIMAL(10, 2)
  • stock (Field3) — INT
  • category_id (Field4) — INT
  • created_at (Field6) — TIMESTAMP

users (CopyOfUntitled2)

  • user_id (Key) — VARCHAR(100) — Primary key — NOT NULL
  • username (Field) — TIMESTAMP
  • password (Field2) — VARCHAR(255)
  • email (Field3) — VARCHAR(100)
  • phone (Field4) — VARCHAR(20)
  • address (Field5) — TEXT
  • created_at (Field6) — TIMESTAMP