showping

Tables (7)

admin (Untitled)

  • admin_id (Key) — int — Primary key — NOT NULL
  • admin_account (Field2) — text
  • password (Field3) — text
  • Field — enum
  • admin_id (Key2) — int — Foreign key → admin.admin_id — NOT NULL

cart (Untitled6)

  • cart_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → users.user_id — NOT NULL
  • product_id (Key3) — Foreign key → product.product_id — NOT NULL
  • admin_id (Key22) — int — Foreign key → product.admin_id — NOT NULL
  • categorie_id (Key32) — int — Foreign key → product.categorie_id — NOT NULL
  • admin_id (Key222) — int — Foreign key → product.admin_id — NOT NULL
  • user_id (Field)
  • product_id (Field2)
  • count (Field3)

categories (Untitled3)

  • categorie_id (Key) — int — Primary key — NOT NULL
  • admin_id (Key2) — int — Foreign key → admin.admin_id — NOT NULL
  • name (Field) — text
  • parent_id (Field2) — int

order (Untitled7)

  • order_id (Key) — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → users.user_id — NOT NULL
  • cart_id (Key3) — Foreign key → cart.cart_id — NOT NULL
  • user_id (Key22) — int — Foreign key → cart.user_id — NOT NULL
  • product_id (Key32) — Foreign key → cart.product_id — NOT NULL
  • admin_id (Key222) — int — Foreign key → cart.admin_id — NOT NULL
  • categorie_id (Key322) — int — Foreign key → cart.categorie_id — NOT NULL
  • admin_id (Key2222) — int — Foreign key → cart.admin_id — NOT NULL
  • user_id (Field)
  • product (Field2)
  • status (Field3)

product (Untitled5)

  • product_id (Key) — Primary key — NOT NULL
  • admin_id (Key2) — int — Foreign key → admin.admin_id — NOT NULL
  • categorie_id (Key3) — int — Foreign key → categories.categorie_id — NOT NULL
  • admin_id (Key22) — int — Foreign key → categories.admin_id — NOT NULL
  • category_id (Field)
  • name (Field2)
  • description (Field3)
  • price (Field4)
  • count (Field5)

review (Untitled4)

  • review_id (Key) — int — Primary key — NOT NULL
  • user_id (Key2) — int — Foreign key → users.user_id — NOT NULL
  • product_id (Key3) — Foreign key → product.product_id — NOT NULL
  • admin_id (Key22) — int — Foreign key → product.admin_id — NOT NULL
  • categorie_id (Key32) — int — Foreign key → product.categorie_id — NOT NULL
  • admin_id (Key222) — int — Foreign key → product.admin_id — NOT NULL
  • categorie_id (Key4) — int — Foreign key → categories.categorie_id — NOT NULL
  • admin_id (Key23) — int — Foreign key → categories.admin_id — NOT NULL
  • rating (Field) — int
  • comment (Field2)
  • product (Field3)

users (Untitled2)

  • user_id (Key) — int — Primary key — NOT NULL
  • name (Field) — text
  • e_mail (Field2) — text
  • phone (Field3) — text
  • address (Field4) — text