SKALA 학사관리시스템
테이블 (12)
tb_assignment
- id — BIGINT — 기본 키 — NOT NULL
- class_group_id — BIGINT — 외래 키 → tb_classgroup.id — NOT NULL
- course_id — BIGINT — 외래 키 → tb_course.id — NOT NULL
- class_session_id — BIGINT — 외래 키 → tb_class_session.id
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- due_at — TIMESTAMPTZ — NOT NULL
- max_score — INTEGER
- created_at — TIMESTAMPTZ — NOT NULL
tb_attendance
- id — BIGINT — 기본 키 — NOT NULL
- class_session_id — BIGINT — 외래 키 → tb_class_session.id — NOT NULL
- student_id — BIGINT — 외래 키 → tb_student.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- check_in_at — TIMESTAMPTZ
- check_out_at — TIMESTAMPTZ
- note — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
tb_class_session
- id — BIGINT — 기본 키 — NOT NULL
- class_group_id — BIGINT — 외래 키 → tb_classgroup.id — NOT NULL
- course_id — BIGINT — 외래 키 → tb_course.id — NOT NULL
- classroom_id — BIGINT — 외래 키 → tb_classroom.id
- session_date — DATE — NOT NULL
- start_time — TIME — NOT NULL
- end_time — TIME — NOT NULL
- class_type — VARCHAR(20) — NOT NULL
- online_url — VARCHAR(500)
- created_at — TIMESTAMPTZ — NOT NULL
tb_classgroup
- id — BIGINT — 기본 키 — NOT NULL
- cohort_id — BIGINT — 외래 키 → tb_cohort.id — NOT NULL
- name — VARCHAR(30) — NOT NULL
- capacity — INTEGER
- created_at — TIMESTAMPTZ — NOT NULL
tb_classroom
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- building — VARCHAR(100)
- capacity — INTEGER
- created_at — TIMESTAMPTZ — NOT NULL
tb_cohort
- id — BIGINT — 기본 키 — NOT NULL
- curriculum_id — BIGINT — 외래 키 → tb_curriculum.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
tb_course
- id — BIGINT — 기본 키 — NOT NULL
- curriculum_id — BIGINT — 외래 키 → tb_curriculum.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- sequence_no — INTEGER
- description — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
tb_curriculum
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
tb_professor
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(255)
- phone — VARCHAR(20)
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
tb_professor_assignment
- id — BIGINT — 기본 키 — NOT NULL
- class_session_id — BIGINT — 외래 키 → tb_class_session.id — NOT NULL
- professor_id — BIGINT — 외래 키 → tb_professor.id — NOT NULL
- role — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
tb_student
- id — BIGINT — 기본 키 — NOT NULL
- class_group_id — BIGINT — 외래 키 → tb_classgroup.id
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- phone — VARCHAR(20)
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
tb_submission
- id — BIGINT — 기본 키 — NOT NULL
- assignment_id — BIGINT — 외래 키 → tb_assignment.id — NOT NULL
- student_id — BIGINT — 외래 키 → tb_student.id — NOT NULL
- submitted_at — TIMESTAMPTZ — NOT NULL
- status — VARCHAR(20) — NOT NULL
- score — INTEGER
- repository_url — VARCHAR(500)
- file_url — VARCHAR(500)
- feedback — TEXT
- created_at — TIMESTAMPTZ — NOT NULL