GoalMate

Tables (22)

Goal

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • topic — VARCHAR(200)
  • description — TEXT
  • price — INT — NOT NULL
  • discount_price — INT
  • period — VARCHAR(100)
  • start_date — DATE
  • end_date — DATE
  • participants_limit — INT — NOT NULL
  • free_participants_limit — INT
  • goal_status — ENUM
  • created_at — DATETIME
  • updated_at — DATETIME
  • mentor_id — BIGINT — Foreign key → Mentor.id — NOT NULL
  • Field

GoalContentImage (GoalImage)

  • id — BIGINT — Primary key — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • goal_id — BIGINT — Foreign key → Goal.id — NOT NULL

GoalDailyTodo

  • id — BIGINT — Primary key — NOT NULL
  • todo_date — DATE — NOT NULL
  • description — TEXT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • goal_id — BIGINT — Foreign key → Goal.id — NOT NULL

GoalMidObjective

  • mid_objective_id — BIGINT — Primary key — NOT NULL
  • objective_description — TEXT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • goal_id — BIGINT — Foreign key → Goal.id — NOT NULL

GoalThumbnail

  • id — BIGINT — Primary key — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • goal_id — BIGINT — Foreign key → Goal.id — NOT NULL

GoalWeeklyObjective

  • id — BIGINT — Primary key — NOT NULL
  • week_number — INT — NOT NULL
  • objective_description — TEXT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • goal_id — BIGINT — Foreign key → Goal.id — NOT NULL

Mentee

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • mentee_status — ENUM
  • free_join_count — INT
  • social_id — VARCHAR(255)
  • social_type — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME

MenteeDailyTodo

  • mentee_daily_todo_id — BIGINT — Primary key — NOT NULL
  • todo_date — DATE
  • todo_description — TEXT
  • todo_status — ENUM
  • done_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME
  • mentee_goal_id — BIGINT — Foreign key → MenteeGoal.mentee_goal_id — NOT NULL
  • daily_comment_id — BIGINT — Foreign key → MenteeGoalComment.id — NOT NULL

MenteeGoal

  • mentee_goal_id — BIGINT — Primary key — NOT NULL
  • joined_at — DATETIME
  • mentee_goal_status — ENUM
  • final_comment — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME
  • mentee_id — BIGINT — Foreign key → Mentee.id — NOT NULL
  • goal_id — BIGINT — Foreign key → Goal.id — NOT NULL

MenteeGoalComment

  • id — BIGINT — Primary key — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

Mentor

  • id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • metor_status — INT
  • created_at — DATETIME
  • updated_at — DATETIME

goal

  • id — BIGINT — Primary key — NOT NULL
  • discount_price — INTEGER — NOT NULL
  • end_date — DATE — NOT NULL
  • free_participants_limit — INTEGER — NOT NULL
  • participants_limit — INTEGER — NOT NULL
  • period — INTEGER — NOT NULL
  • price — INTEGER — NOT NULL
  • start_date — DATE — NOT NULL
  • created_at — DATETIME(6)
  • mentor_id — BIGINT — NOT NULL
  • updated_at — DATETIME(6)
  • description — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • topic — VARCHAR(255) — NOT NULL
  • goal_status — ENUM('COMPLETED', 'IN_PROGRESS', 'NOT_STARTED') — NOT NULL

goal_content_image

  • id — BIGINT — Primary key — NOT NULL
  • goal_id — BIGINT — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL

goal_daily_todo

  • id — BIGINT — Primary key — NOT NULL
  • todo_date — DATE — NOT NULL
  • goal_id — BIGINT — NOT NULL
  • description — VARCHAR(255) — NOT NULL

goal_mid_objective

  • id — BIGINT — Primary key — NOT NULL
  • goal_id — BIGINT — NOT NULL
  • description — VARCHAR(255) — NOT NULL

goal_thumbnail_image

  • id — BIGINT — Primary key — NOT NULL
  • goal_id — BIGINT — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL

goal_weekly_objective

  • id — BIGINT — Primary key — NOT NULL
  • week_number — INTEGER — NOT NULL
  • goal_id — BIGINT — NOT NULL
  • description — VARCHAR(255) — NOT NULL

mentee

  • id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME(6)
  • free_join_count — BIGINT — NOT NULL
  • updated_at — DATETIME(6)
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255)
  • social_id — VARCHAR(255) — NOT NULL
  • provider — ENUM('APPLE', 'KAKAO') — NOT NULL
  • role — ENUM('ROLE_ADMIN', 'ROLE_MENTEE', 'ROLE_MENTOR') — NOT NULL
  • status — ENUM('ACTIVE', 'DELETED', 'PENDING') — NOT NULL

mentee_daily_todo

  • id — BIGINT — Primary key — NOT NULL
  • todo_date — DATE — NOT NULL
  • completed_at — DATETIME(6)
  • created_at — DATETIME(6)
  • mentee_goal_id — BIGINT — NOT NULL
  • updated_at — DATETIME(6)
  • description — VARCHAR(255) — NOT NULL
  • status — ENUM('DONE', 'TODO') — NOT NULL

mentee_goal

  • id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME(6)
  • goal_id — BIGINT — NOT NULL
  • joined_at — DATETIME(6) — NOT NULL
  • mentee_id — BIGINT — NOT NULL
  • updated_at — DATETIME(6)
  • final_comment — TINYTEXT — INYTEX
  • status — ENUM('CANCELLED', 'COMPLETED', 'IN_PROGRESS') — NOT NULL

mentee_goal_daily_comment

  • id — BIGINT — Primary key — NOT NULL
  • comment_date — DATE — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • comment — TINYTEXT — NOT NULL — INYTEXT NOT NUL

mentor

  • id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(255)
  • role — ENUM('ROLE_ADMIN', 'ROLE_MENTEE', 'ROLE_MENTOR') — NOT NULL