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