(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