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