kiosk
Tables (12)
category (Untitled2)
- Id — int — Primary key — NOT NULL
- Name — char(10)
coupon (Untitled9)
- id — int — Primary key — NOT NULL
- code (Field) — char(12)
- userid — int — Foreign key → user.Id — NOT NULL
detail (Untitled7)
- Id — int — Primary key — NOT NULL
- amount — int
- menuid — int — Foreign key → menu.Id — NOT NULL
- orderid — int — Foreign key → order.Id — NOT NULL
detection (Untitled12)
- id — int — Primary key — NOT NULL
- images — image
history (Untitled10)
- id — int — Primary key — NOT NULL
- count — int
- updated_at — datetime
- userid — int — Foreign key → user.Id — NOT NULL
- seasonid — int — Foreign key → season.id — NOT NULL
- menuid — int — Foreign key → menu.Id — NOT NULL
menu (Untitled)
- Id — int — Primary key — NOT NULL
- Name — char(20)
- Price — int
- Img — char(50)
- Description — char(300)
- categoryId — int — Foreign key → category.Id — NOT NULL
order (Untitled6)
- Id — int — Primary key — NOT NULL
- virtualuserid — int — Foreign key → virtualUser.Id — NOT NULL
- date — datetime
- price — int
recommend (Untitled11)
- id — int — Primary key — NOT NULL
- userid — int — Foreign key → user.Id — NOT NULL
- menuid — int — Foreign key → menu.Id — NOT NULL
season (Untitled5)
- id — int — Primary key — NOT NULL
- name — char(10)
user (Untitled3)
- Id — int — Primary key — NOT NULL
- phoneNum — char(20)
- point — int
virtualUser (Untitled4)
- Id — int — Primary key — NOT NULL
- Age — int
virtualhistory (Untitled8)
- id — int — Primary key — NOT NULL
- count — int
- virtualuserid — int — Foreign key → virtualUser.Id — NOT NULL
- seasonid — int — Foreign key → season.id — NOT NULL
- menuid — int — Foreign key → menu.Id — NOT NULL