PM Dashboard
Tables (7)
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
PM
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- email — 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)
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
TRACK
- id — BIGINT
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- start_date — DATE
- end_date — DATE
- created_at — TIMESTAMP