데베설

테이블 (8)

certificate

  • certificate_id — INT — 기본 키 — NOT NULL
  • student_id — INT — NOT NULL
  • certificate_name — VARCHAR(100) — NOT NULL
  • issuer — VARCHAR(100) — NOT NULL
  • acquisition_date — DATE — NOT NULL

course_history

  • course_history_id — INT — 기본 키 — NOT NULL
  • student_id — INT — NOT NULL
  • professor_id — INT — NOT NULL
  • course_name — VARCHAR(100) — NOT NULL
  • semester — VARCHAR(20) — NOT NULL
  • credit — INT — NOT NULL
  • grade — VARCHAR(10) — NOT NULL

language_score

  • language_score_id — INT — 기본 키 — NOT NULL
  • student_id — INT — NOT NULL
  • test_name — VARCHAR(50) — NOT NULL
  • score — INT — NOT NULL
  • test_date — DATE — NOT NULL
  • expiration_date — DATE

major_history

  • major_id — INT — 기본 키 — NOT NULL
  • student_id — INT — NOT NULL
  • major_name — VARCHAR(100) — NOT NULL
  • department — VARCHAR(50)
  • admission_date — DATE — NOT NULL
  • graduation_date — DATE

professor

  • professor_id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • department — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(15) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • course_history_id — INT — 외래 키 → course_history.course_history_id — NOT NULL
  • project_id — INT — 외래 키 → project.project_id — NOT NULL

project

  • project_id — INT — 기본 키 — NOT NULL
  • student_id — INT — NOT NULL
  • professor_id — INT — NOT NULL
  • project_name — VARCHAR(100) — NOT NULL
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • description — TEXT

student

  • student_id — INT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • birth_date — DATE — NOT NULL
  • phone — VARCHAR(15) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • course_history_id — INT — 외래 키 → course_history.course_history_id — NOT NULL
  • major_id — INT — 외래 키 → major_history.major_id — NOT NULL
  • project_id — INT — 외래 키 → project.project_id — NOT NULL
  • certificate_id — INT — 외래 키 → certificate.certificate_id — NOT NULL
  • volunteer_id — INT — 외래 키 → volunteer.volunteer_id — NOT NULL
  • language_score_id — INT — 외래 키 → language_score.language_score_id — NOT NULL

volunteer

  • volunteer_id — INT — 기본 키 — NOT NULL
  • student_id — INT — NOT NULL
  • volunteer_name — VARCHAR(100) — NOT NULL
  • organization — VARCHAR(100) — NOT NULL
  • hours — INT — NOT NULL
  • volunteer_date — DATE — NOT NULL
  • description — TEXT