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))