hondi

Tables (4)

like (Untitled4)

  • id (pk) — Primary key — NOT NULL
  • likerID (좋아요 누른 사람 아이디) — Foreign key → user.id — NOT NULL
  • recipeID (좋아요 누른 메뉴 ID) — Foreign key → recipe.id — NOT NULL

recipe (Untitled2)

  • id (pk) — Primary key — NOT NULL
  • raw_text (음성 텍스트)
  • ai_text (ai가 정제한 텍스트)
  • voice (할머니의 음성)
  • userID (유저 아이디) — Foreign key → user.id — NOT NULL
  • createdAt (생성일)

subscribe (Untitled3)

  • id (pk) — Primary key — NOT NULL
  • subscriberId (구독자 ID) — Foreign key → user.id — NOT NULL
  • subscribedID (구독당하는 사람 ID) — Foreign key → user.id — NOT NULL

user (Untitled)

  • id (pk) — Primary key — NOT NULL
  • id (아이디)
  • password (비밀번호)
  • nickname (닉네임)
  • role (enum(owner, user))