CoffeeBin
Tables (3)
Untitled (User)
- Key (id) — int — Primary key — NOT NULL
- Field (token) — varchar(255)
- Field (phone_num) — varchar(100)
- Field (email) — varchar(255)
- Field (point) — int
- Field (createAt) — TIMESTAMP — NOT NULL
- Field2 (updateAt) — TIMESTAMP — NOT NULL
- Field3 (status) — varchar(20) — NOT NULL
Untitled (History)
- Key (id) — int — Primary key — NOT NULL
- Key (u_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (plus_point) — int
- Field (cur_point) — int
- Field (createAt) — TIMESTAMP — NOT NULL
- updateAt — TIMESTAMP — NOT NULL
- Field3 (status) — varchar(20)
Untitled (Bin)
- Key (id) — int — Primary key — NOT NULL
- Field (name) — varchar(20)
- Field (latitude) — numeric(12,6) — NOT NULL
- Field (longitude) — numeric(12,6)
- Field (plastic_amount) — int
- Field (paper_amount) — int
- Field (createAt) — TIMESTAMP — NOT NULL
- Field2 (updateAt) — TIMESTAMP — NOT NULL
- Field3 (status) — varchar(20) — NOT NULL