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