aa

Tables (4)

friend (친구)

  • user_id (유저아이디) — INT — Foreign key → user.user_id — NOT NULL
  • friend_id (유저아이디2) — INT — Foreign key → user.user_id — NOT NULL

recipe (레시피)

  • recipe_id (레시피아이디) — INT — Primary key — NOT NULL
  • id (유저아이디) — INT — Foreign key → user.user_id — NOT NULL
  • espresso (에스프레소) — INT
  • water (물) — INT
  • syrup (시럽) — INT
  • star (별점) — INT

request (친구요청)

  • user_id (유저아이디) — INT — Foreign key → user.user_id — NOT NULL
  • friend_id (유저아이디2) — INT — Foreign key → user.user_id — NOT NULL

user (유저)

  • user_id (유저아이디) — INT — Primary key — NOT NULL
  • name (유저이름) — VARCHAR