erd

Tables (4)

menu (Untitled4)

  • menuId (Key) — Long — Primary key — NOT NULL
  • name (Field) — String
  • price (Field2) — Integer

order (Untitled2)

  • orderId (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → user.userId — NOT NULL
  • menuId (Key3) — Long — Foreign key → menu.menuId — NOT NULL
  • amount (Field) — Integer
  • status (Field2) — String

pointHistory (Untitled3)

  • pointId (Key) — Long — Primary key — NOT NULL
  • userId (Key2) — Long — Foreign key → user.userId — NOT NULL
  • amount (Field) — Integer

user (Untitled)

  • userId (Key) — Long — Primary key — NOT NULL
  • point (Field) — Integer