데베설
테이블 (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