school

Tables (6)

Chats (Untitled6)

  • chat_id (Key) — INT — Primary key — NOT NULL
  • order_id (Key2) — INT — Foreign key → orders.order_id — NOT NULL
  • message (Field) — TEXT
  • createdAt (Field2) — DATETIME

carts (Untitled3)

  • user_id (id2) — INT — Foreign key → users.user_id — NOT NULL
  • product_id (Key) — INT — Foreign key → products.product_id — NOT NULL

manners (Untitled5)

  • user_id (id) — INT — Foreign key → users.user_id — NOT NULL
  • manner (Field) — INT

orders (Untitled4)

  • order_id (Key) — INT — Primary key — NOT NULL
  • user_id (id) — INT — Foreign key → users.user_id — NOT NULL
  • product_id (Key2) — INT — Foreign key → products.product_id — NOT NULL
  • createdAt (Field4) — DATETIME

products (Untitled2)

  • product_id (Key) — INT — Primary key — NOT NULL
  • user_id (id) — INT — Foreign key → users.user_id — NOT NULL
  • name (Field) — VARCHAR(45)
  • price (Field2) — INT
  • description (Field3) — TEXT
  • producturl (Field4) — TEXT
  • createdAt (Field5) — DATETIME
  • area (Field6) — TEXT

users (Untitled)

  • user_id (id) — INT — Primary key — NOT NULL
  • username (Field) — VARCHAR(45)
  • password (Field2) — VARCHAR(128)
  • name (Field3) — VARCHAR(128)
  • email (Field4) — VARCHAR(128)