ㄷㅂㅅ
Tables (6)
course_history
- course_history_id — INT — Primary key — 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
major_history
- major_id — INT — Primary key — 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 — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- department — VARCHAR(50) — NOT NULL
- phone — VARCHAR(15) — NOT NULL
- email — VARCHAR(100) — NOT NULL
project
- project_id — INT — Primary key — 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 — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- birth_date — DATE — NOT NULL
- phone — VARCHAR(15) — NOT NULL
- email — VARCHAR(100) — NOT NULL