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