coffee-pos-machine

Tables (4)

Untitled (user)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (point) — bigint — NOT NULL

Untitled (point_log)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (user_id) — bigint — NOT NULL
  • Field2 (point) — bigint — NOT NULL

Untitled (order_log)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (user_id) — bigint — NOT NULL
  • Field (beverage_id) — bigint — NOT NULL
  • Field (created_at) — datetime — NOT NULL

beverages (beverage)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar — NOT NULL
  • Field (price) — int — NOT NULL