cafe

Tables (3)

Untitled (menus)

  • Key (menu_name) — varchar(50) — Primary key — NOT NULL
  • Field (menu_price) — int — NOT NULL
  • Key (staff_name) — varchar(50) — Foreign key → Untitled.Key — NOT NULL

Untitled (staff)

  • Key (staff_name) — varchar(50) — Primary key — NOT NULL
  • Field (staff_nickname) — varchar(10) — NOT NULL

Untitled (user)

  • Key (user_id) — int — Primary key — NOT NULL
  • Field (user_name) — int — NOT NULL
  • Field (user_pw) — int — NOT NULL
  • Field (user_point) — int — NOT NULL