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