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)