day1

Tables (8)

SSAFY (GROUP)

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

SSAFY (grade)

  • GRADE_ID — INT(11) — Primary key — 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
  • PROJECT_GRADE — varchar(20)

SSAFY (attendance)

  • ATTENDANCE_ID — INT(11) — Primary key — NOT NULL
  • ATTENDANCE_1/1 — tinyint(1)
  • ATTENDANCE_1/1_SIGN_IN — datetime
  • ATTENDANCE_1/1_SIGN_OUT — datetime
  • ATTENDANCE_1/2 — tinyint(1)
  • ATTENDANCE_1/2_SIGN_IN — datetime
  • ATTENDANCE_1/2_SIGN_OUT — datetime
  • ATTENDANCE_1/3 — tinyint(1)
  • ATTENDANCE_1/3_SIGN_IN — datetime
  • ATTENDANCE_1/3_SIGN_OUT — datetime
  • ATTENDANCE_1/4 — tinyint(1)
  • ATTENDANCE_1/4_SIGN_IN — datetime
  • ATTENDANCE_1/4_SIGN_OUT — datetime
  • ATTENDANCE_1/5 — tinyint(1)
  • ATTENDANCE_1/5_SIGN_IN — datetime
  • ATTENDANCE_1/5_SIGN_OUT — datetime
  • ATTENDANCE_1/6 — tinyint(1)
  • ATTENDANCE_1/6_SIGN_IN — datetime
  • ATTENDANCE_1/6_SIGN_OUT — datetime
  • ATTENDANCE_1/7 — tinyint(1)
  • ATTENDANCE_1/7_SIGN_IN — datetime
  • ATTENDANCE_1/7_SIGN_OUT — datetime
  • ATTENDANCE_1/8 — tinyint(1)
  • ATTENDANCE_1/8_SIGN_IN — datetime
  • ATTENDANCE_1/8_SIGN_OUT — datetime
  • ATTENDANCE_1/9 — tinyint(1)
  • ATTENDANCE_1/9_SIGN_IN — datetime
  • ATTENDANCE_1/9_SIGN_OUT — datetime
  • ATTENDANCE_1/10 — tinyint(1)
  • ATTENDANCE_1/10_SIGN_IN — datetime
  • ATTENDANCE_1/10_SIGN_OUT — datetime

SSAFY (TIME)

  • TIEM_ID (TIME_ID) — INT(11) — Primary key — NOT NULL
  • REG_USER — varchar(20)
  • REG_DT — datetime
  • LAST_USER — varchar(20)
  • LAST_DT — datetime

SSAFY (student)

  • STUDENT_ID — INT(11) — Primary key — NOT NULL
  • STUDENT_GROUP — varchar(20) — Foreign key → SSAFY.STUDENT_GROUP — NOT NULL
  • STUDENT_ACCOUNT — varchar(20) — 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_REGION — varchar(20)

SSAFY (grade_contact)

  • STUDENT_ID — INT(11) — Foreign key → SSAFY.STUDENT_ID — NOT NULL
  • GRADE_ID — INT(11) — Foreign key → SSAFY.GRADE_ID — NOT NULL

SSAFY (student_contact)

  • STUDENT_ID — INT(11) — Foreign key → SSAFY.STUDENT_ID — NOT NULL
  • TIEM_ID (TIME_ID) — INT(11) — Foreign key → SSAFY.TIEM_ID — NOT NULL

SSAFY (attendance_contact)

  • STUDENT_ID — INT(11) — Foreign key → SSAFY.STUDENT_ID — NOT NULL
  • ATTENDANCE_ID — INT(11) — Foreign key → SSAFY.ATTENDANCE_ID — NOT NULL