ssafy

Tables (6)

Attendance

  • ATTENDANCE_NUMBER — int — Primary key — NOT NULL
  • ATTENDANCE — tinyint(1)
  • ATTENDANCE_SIGN_IN — datetime
  • ATTENDANCE_SIGN_OUT — datetime
  • STUDENT_ACCOUNT — varchar(20) — Foreign key → Student.STUDENT_ACCOUNT — NOT NULL
  • ATTENDANCE_DATE — datetime

Grade

  • STUDENT_ACCOUNT — varchar(20) — Foreign key → Student.STUDENT_ACCOUNT — NOT NULL
  • GRADE_FIRST_EXAM — varchar(3)
  • GRADE_SECOND_EXAM — varchar(3)
  • GRADE_THIRD_EXAM — varchar(3)
  • ALGORITHM_GRADE — varchar(20)
  • ALGORITHM_ACQUISITION_DATE — datetime

Group

  • GROUP_ID — varchar(20) — Primary key — NOT NULL
  • GROUP_REGION — varchar(20) — Primary key — NOT NULL
  • GROUP_PROJECT_SUBJECT — varchar(20) — Primary key
  • GROUP_PROJECT_GRADE — varchar(3)
  • GROUP_TEACHER_ID — varchar(20) — Foreign key → Teacher.GROUP_TEACHER_ID — NOT NULL

Student

  • STUDENT_ACCOUNT — varchar(20) — Primary key — NOT NULL
  • STUDENT_NAME — varchar(100)
  • STUDENT_AGE — varchar(5)
  • STUDENT_HP — varchar(20)
  • STUDENT_CURRICULUM — varchar(20)
  • STUDENT_GENDER — varchar(20)
  • GROUP_ID (STUDENT_GROUP_ID) — varchar(20) — Foreign key → Group.GROUP_ID — NOT NULL
  • STUDENT_REGION — varchar(20) — Foreign key → Group.GROUP_REGION — NOT NULL

Teacher

  • GROUP_TEACHER_ID — varchar(20) — Primary key — NOT NULL
  • GROUP_TEACHER_NAME — varchar(20)
  • GROUP_TEACHER_HP — varchar(20)

USERREG

  • STUDENT_ACCOUNT — varchar(20) — Foreign key → Student.STUDENT_ACCOUNT — NOT NULL
  • REG_USER — varchar(20)
  • REG_DT — datetime
  • LAST_USER — varchar(20)
  • LAST_DT — datetime