on_02

Tables (7)

Category (Untitled7)

  • c_id (Key) — Primary key — NOT NULL
  • kind (Field)

Like (Untitled5)

  • l_id (Key) — Primary key — NOT NULL
  • p_id (Key2) — Foreign key → Product.p_id — NOT NULL
  • u_id (Key3) — Foreign key → User.u_id — NOT NULL
  • c_id (Key22) — Foreign key → Product.c_id — NOT NULL
  • o_id (Key32) — Foreign key → Product.o_id — NOT NULL
  • u_id (Key222) — Foreign key → Product.u_id — NOT NULL
  • p_id (Field)
  • seller_id (Field2)
  • buyer_id (Field3)
  • l_created_at (Field4)

Manner (Untitled6)

  • u_id (Key) — Foreign key → User.u_id — NOT NULL
  • manner_temperature (Field)

Order (Untitled4)

  • o_id (Key) — Primary key — NOT NULL
  • u_id (Key2) — Foreign key → User.u_id — NOT NULL
  • p_id (Field)
  • seller_id (Field2)
  • buyer_id (Field3)
  • quantity (Field4)
  • email (Field5)
  • o_created_at (Field6)

Product (Untitled2)

  • p_id (Key) — Primary key — NOT NULL
  • c_id (Key2) — Foreign key → Category.c_id — NOT NULL
  • o_id (Key3) — Foreign key → Order.o_id — NOT NULL
  • u_id (Key22) — Foreign key → Order.u_id — NOT NULL
  • pname (Field2)
  • price (Field3)
  • quantity (Field4)
  • description (Field5)
  • seller_id (Field6)
  • p_created_at (Field7)
  • p_updated_at (Field8)
  • location_to_meet (Field9)

Product_image (Untitled3)

  • i_id (Key) — Primary key — NOT NULL
  • p_id (Key2) — Foreign key → Product.p_id — NOT NULL
  • c_id (Key22) — Foreign key → Product.c_id — NOT NULL
  • o_id (Key3) — Foreign key → Product.o_id — NOT NULL
  • u_id (Key222) — Foreign key → Product.u_id — NOT NULL
  • product (Field)
  • base64_image_url (Field2)

User (Untitled)

  • u_id (Key) — Primary key — NOT NULL
  • uname (Field6)
  • email (Field)
  • password (Field2)
  • u_created_at (Field3)
  • u_updated_at (Field4)
  • number (Field5)