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)