a

Tables (8)

Brand (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • product_id (Key2) — Foreign key → Product.id — NOT NULL
  • name (Field)

Cart (Untitled5)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key3) — Foreign key → User.id — NOT NULL
  • product_id (Key2) — Foreign key → Product.id — NOT NULL
  • Field
  • Field2

Category (Untitled7)

  • categoryid (Key) — Primary key — NOT NULL
  • Field

Order (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.id — NOT NULL
  • product_id (Key3) — Foreign key → Product.id — NOT NULL
  • address (Field2)
  • delivery (Field3)

Product (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.id — NOT NULL
  • category_id (Key3) — Foreign key → Category.categoryid — NOT NULL
  • name (Field)
  • price (Field2)
  • category (Field3)
  • description (Field7)

ProductOption (Untitled8)

  • product_id (Key) — Foreign key → Product.id — NOT NULL
  • color (Field)
  • size (Field2)
  • stock (Field3)

Review (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — Foreign key → User.id — NOT NULL
  • id (Key3) — Foreign key → Product.id — NOT NULL
  • star (Field3)
  • comment (Field4)

User (Untitled)

  • id (Key) — Primary key — NOT NULL
  • user_id (Field)
  • email (Field2)
  • password (Field3)
  • nickname (Field4)
  • phone_number (Field5)
  • gender (Field6)
  • is_admin (Field7)