2024_DANPOONG_TEAM_27_FE

Tables (4)

Fortune (운세)

  • fortune_id (운세ID) — BIGINT — Primary key — NOT NULL
  • user_id (유저ID) — BIGINT — Foreign key → User.user_id — NOT NULL
  • name (이름) — VARCHAR
  • date (날짜) — LOCALDATE
  • description (설명) — VARCHAR
  • Field

Goal (목표)

  • goal_id (목표ID) — BIGINT — Primary key — NOT NULL
  • user_id (유저ID) — BIGINT — Foreign key → User.user_id — NOT NULL
  • name (이름) — VARCHAR
  • isCompleted (달성여부) — BOOLEAN
  • start_date (시작날짜) — LOCALDATE
  • end_date (종료날짜) — LOCALDATE

Todo (할일)

  • todo_id (할일ID) — BIGINT — Primary key — NOT NULL
  • goal_id (목표ID) — BIGINT — Foreign key → Goal.goal_id — NOT NULL
  • name (이름) — VARCHAR
  • isCompleted (완료여부) — BOOLEAN

User (사용자)

  • user_id (유저ID) — BIGINT — Primary key — NOT NULL
  • name (이름) — VARCHAR
  • email (이메일) — VARCHAR
  • profileImage (사진) — VARCHAR
  • nickname (닉네임) — VARCHAR
  • gender (성별) — VARCHAR
  • date_of_birth (생년월일) — LOCALDATETIME