bin

Tables (4)

ClothingBox (Untitled3)

  • bin_id — INT — Primary key — NOT NULL
  • name — Varchar100
  • address — VARCHAR(255)
  • district_id — INT
  • latitude — DECIMAL(10, 7)
  • longitude — DECIMAL(10, 7)
  • status — VARCHAR(50)
  • updated_date — DATETIME
  • district_id (district_id2) — INT — Foreign key → District.district_id — NOT NULL

District (Untitled2)

  • district_id — INT — Primary key — NOT NULL
  • name — VARCHAR(100)

SearchHistory (Untitled5)

  • search_id — INT — Primary key — NOT NULL
  • query — VARCHAR(255)
  • search_date — DATETIME
  • user_id (user_id2) — Foreign key → User.user_id — NOT NULL

User (Untitled)

  • user_id — Primary key — NOT NULL
  • name — varchar(100) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255)
  • created_at — DATETIME