SSAFY System

Tables (8)

algorithm

  • ALGORITHM_GRADE — varchar(20) — Primary key — NOT NULL

attendance

  • STUDENT_ACCOUNT — varchar(20) — Foreign key → student.STUDENT_ACCOUNT — NOT NULL
  • ATTENDANCE_SIGN_IN — datetime
  • ATTENDANCE_SIGN_OUT — datetime
  • ATTENDANCE_CHECK — tinyint(1)

group

  • STUDENT_GROUP — varchar(20) — Primary key — NOT NULL
  • REGION_NAME — varchar(20) — Foreign key → region.REGION_NAME — NOT NULL
  • TEACHER_ID — varchar(20) — Foreign key → teacher.TEACHER_ID

project

  • PROJECT_ID — int — Primary key — NOT NULL
  • PROJECT_TITLE — varchar(100) — NOT NULL
  • PROJECT_GRADE — varchar(20)
  • PROJECT_TYPE — varchar(50)

region

  • REGION_NAME — varchar(20) — Primary key — NOT NULL

relation_student_project

  • _ID — int — Primary key — NOT NULL
  • STUDENT_ACCOUNT — varchar(20) — Foreign key → student.STUDENT_ACCOUNT — NOT NULL
  • PROJECT_ID — int — Foreign key → project.PROJECT_ID — NOT NULL

student

  • STUDENT_ACCOUNT — varchar(20) — Primary key — NOT NULL
  • STUDENT_NAME — varchar(100) — NOT NULL
  • STUDENT_HP — varchar(20)
  • STUDENT_AGE — varchar(5)
  • STUDENT_GENDER — varchar(20)
  • STUDENT_CURRICULUM — varchar(20)
  • STUDENT_GROUP — varchar(20) — Foreign key → group.STUDENT_GROUP
  • REGION_NAME — varchar(20) — Foreign key → group.REGION_NAME
  • GRADE_FIRST_EXAM — varchar(3)
  • GRADE_SECOND_EXAM — varchar(3)
  • GRADE_THIRD_EXAM — varchar(3)
  • ALGORITHM_GRADE — varchar(20) — Foreign key → algorithm.ALGORITHM_GRADE
  • ALGORITHM_ACQUISITION_DATE — datetime

teacher

  • TEACHER_ID — varchar(20) — Primary key — NOT NULL
  • TEACHER_NAME — varchar(20) — NOT NULL
  • TEACHER_HP — varchar(20) — NOT NULL