SSAFY 교육생
테이블 (4)
Not Attendance (attend_info)
- Date (atd_date) — DATE — 기본 키 — NOT NULL
- Absent Student ID (stu_id) — VARCHAR(20) — 외래 키 → Students.ID
Project Team (teams_info)
- Number (team_number) — CHAR(5) — 기본 키 — NOT NULL
- Name (team_name) — VARCHAR(20)
- Order (team_order) — INT(2)
- Subject (team_subject) — VARCHAR(100)
- Mid Grade (team_grade_mid) — INT(3)
- Final Grade (team_grade_final) — INT(3)
Students (students_info)
- Number (stu_number) — INT(3) — 기본 키 — NOT NULL
- ID (stu_id) — VARCHAR(20) — 기본 키
- Name (stu_name) — VARCHAR(10)
- Age (stu_age) — INT(2)
- Gender (stu_gen) — VARCHAR(2)
- Phone (stu_phone_number) — VARCHAR(15)
- Region (stu_region) — VARCHAR(100)
- Teacher Name (tch_name) — VARCHAR(10) — 외래 키 → Teacher.Name
- 1st Grade (stu_grade_1) — INT(3)
- 2nd Grade (stu_grade_2) — INT(3)
- 3rd Grade (stu_grade_3) — INT(3)
- 4th Grade (stu_grade_4) — INT(3)
- 5th Grade (stu_grade_5) — INT(3)
- Algorithm (stu_grade_algorithm) — VARCHAR(3)
- 1st Team Number (team_number_1) — CHAR(5) — 외래 키 → Project Team.Number — NOT NULL
- 2nd Team Number (team_number_2) — CHAR(5) — 외래 키 → Project Team.Number — NOT NULL
- 3rd Team Number (team_number_3) — CHAR(5) — 외래 키 → Project Team.Number — NOT NULL
Teacher (teachers_info)
- Number (tch_number) — INT(2) — 기본 키 — NOT NULL
- Name (tch_name) — VARCHAR(10) — 기본 키
- ID (tch_id) — VARCHAR(20)
- Phone (tch_phone_number) — VARCHAR(15)
- Class (tch_class) — VARCHAR(10)