coffeeShop

Tables (3)

menu (메뉴)

  • id — int — Primary key — NOT NULL
  • name — varchar(50)
  • price — int

order (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • userId (Key2) — int — Foreign key → user.id — NOT NULL
  • menuId (id) — int — Foreign key → menu.id — NOT NULL
  • price (Field3) — int
  • orderDate (Field4) — date

user (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar(50)
  • points (Field2) — int