PM Dashboard

Tables (13)

COUNSELING

  • id — BIGINT
  • student_id — BIGINT — Foreign key → STUDENT.id — NOT NULL
  • track_id — BIGINT — Foreign key → TRACK.id — NOT NULL
  • pm_id — BIGINT — Foreign key → PM.id — NOT NULL
  • counseling_date — DATE
  • next_counseling_date — DATE
  • content — TEXT
  • next_action — TEXT
  • created_at — TIMESTAMP

COURSE

  • id — BIGINT
  • track_id — BIGINT — Foreign key → TRACK.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL

COURSE_WEEK

  • id — BIGINT
  • course_id — BIGINT — Foreign key → COURSE.id — NOT NULL
  • week_number — INT — NOT NULL
  • lecture_count — INT — NOT NULL

LEARNING_PROGRESS

  • id — BIGINT
  • student_id — BIGINT — Foreign key → STUDENT.id — NOT NULL
  • course_week_id — BIGINT — Foreign key → COURSE_WEEK.id — NOT NULL
  • lecture_number — INT
  • status — VARCHAR(20) — 수강중/수강예정/수강완료
  • assignment_progress — INT — 0~100
  • til_written — BOOLEAN
  • condition_score — INT — 1~5
  • risk_level — VARCHAR(20) — 괜찮아요/조금힘들어요/많이힘들어요
  • comment — TEXT — EX
  • submitted_at — TIMESTAMP

PEER_EVALUATION

  • id — BIGINT
  • student_id — BIGINT — Foreign key → STUDENT.id — NOT NULL
  • track_id — BIGINT — Foreign key → TRACK.id — NOT NULL
  • round — INT — NOT NULL — 회차
  • nps_score — INT — 0~10
  • prev_nps_score — INT — 직전 회차 점수
  • risk_level — VARCHAR(20) — 긴급/주의/정상
  • uploaded_at — TIMESTAMP

PM

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP

PM_TRACK

  • id — BIGINT
  • pm_id — BIGINT — Foreign key → PM.id — NOT NULL
  • track_id — BIGINT — Foreign key → TRACK.id — NOT NULL
  • role — VARCHAR(50)

SATISFACTION_RESPONSE

  • id — BIGINT
  • survey_id — BIGINT — Foreign key → SATISFACTION_SURVEY.id — NOT NULL
  • student_id — BIGINT — Foreign key → STUDENT.id — NOT NULL
  • score — INT — 만족도 점수
  • comment — TEXT — EX
  • flagged — BOOLEAN — 특이사항 플래그
  • submitted_at — TIMESTAMP

SATISFACTION_SURVEY

  • id — BIGINT
  • track_id — BIGINT — Foreign key → TRACK.id — NOT NULL
  • round — INT — NOT NULL — 회차
  • google_form_url — VARCHAR(500)
  • created_at — TIMESTAMP

STUDENT

  • id — BIGINT
  • track_id — BIGINT — Foreign key → TRACK.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • email — VARCHAR(255)
  • phone — VARCHAR(20)
  • created_at — TIMESTAMP

SURVEY

  • id — BIGINT
  • track_id — BIGINT — Foreign key → TRACK.id — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • google_form_url — VARCHAR(500)
  • created_at — TIMESTAMP

SURVEY_SUBMISSION

  • id — BIGINT
  • survey_id — BIGINT — Foreign key → SURVEY.id — NOT NULL
  • student_id — BIGINT — Foreign key → STUDENT.id — NOT NULL
  • submitted — BOOLEAN
  • submitted_at — TIMESTAMP

TRACK

  • id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • start_date — DATE
  • end_date — DATE
  • created_at — TIMESTAMP