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