LuckyVicky
Tables (3)
Member (회원)
- 회원ID (id) — bigint — Primary key — NOT NULL
- 이메일 (email) — varchar(255)
Animal (동물)
- 동물ID (id) — bigint — Primary key — NOT NULL
- 동물이름 (name) — varchar(255)
- 설정MBTI (mbti) — varchar(255)
- 설명 (summary) — varchar(255)
- 추천습관 (recommend) — varchar(255)
Habit (습관)
- 습관ID (id) — bigint — Primary key — NOT NULL
- 제목 (title) — varchar(255)
- 설명 (description) — varchar(255)
- 습관설정횟수 (goal_count) — bigint
- 습관달성횟수 (count) — bigint
- 회원ID (memberId) — bigint — Foreign key → Member.회원ID — NOT NULL
- 동물ID (animalId) — bigint — Foreign key → Animal.동물ID — NOT NULL