(logical) 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
  • Field2 (point) — bigint — NOT NULL
  • Field (created_at) — bigint — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (purchase_log)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Key (beverage_id) — bigint — Foreign key → beverages.Key — NOT NULL
  • Key (user_id) — bigint — Foreign key → Untitled.Key — NOT NULL

beverages (beverage)

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