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