kiosk
Tables (6)
item (Untitled2)
- id (Key) — Primary key — NOT NULL
- userId (Key2) — Foreign key → user.id — NOT NULL
- id (Key3) — Foreign key → order_item.id — NOT NULL
- id (Key22) — Foreign key → order_item.userId — NOT NULL
- name (Field)
- price (Field2)
- type (Field3)
- amount (Field4)
itemOrderCustomer (Untitled4)
- id (Key) — Primary key — NOT NULL
- id (Key3) — bigint — Foreign key → option.id — NOT NULL
- id (Key32) — Foreign key → option.id — NOT NULL
- id (Key222) — Foreign key → option.id — NOT NULL
- amount (Field)
option (Untitled)
- id (Key) — bigint — Primary key — NOT NULL
- itemId (Key2) — Foreign key → item.id — NOT NULL
- id (Key22) — Foreign key → item.userId — NOT NULL
- id (Key3) — Foreign key → item.id — NOT NULL
- id (Key222) — Foreign key → item.id — NOT NULL
- extra_price (Field)
- shot_price (Field2)
- hot (Field3)
orderCustomer (Untitled5)
- id (Key) — Primary key — NOT NULL
- itemOrderCustomerId (Key2) — Foreign key → itemOrderCustomer.id — NOT NULL
- id (Key3) — bigint — Foreign key → itemOrderCustomer.id — NOT NULL
- id (Key32) — Foreign key → itemOrderCustomer.id — NOT NULL
- id (Key222) — Foreign key → itemOrderCustomer.id — NOT NULL
- state (Field)
order_item (Untitled3)
- id (Key) — Primary key — NOT NULL
- userId (Key2) — Foreign key → user.id — NOT NULL
- itemId (Field)
- count (Field2)
- Field3
user (Untitled6)
- id (Key) — Primary key — NOT NULL
- name (Field)
- password (Field2)