SSAFYDaily1

Tables (5)

attendence

  • ATTENDENCE_NO — varchar(20) — Primary key — NOT NULL
  • STUDENT_ACCOUNT — varchar(20) — Foreign key → user.STUDENT_ACCOUNT — NOT NULL
  • ATTENDENCE — tinyint(1)
  • ATTENDENCE_DATE — datetime
  • ATTENDENCE_SIGN_IN — datetime
  • ATTENDENCE_SIGN_OUT — datetime

pjt1_team

  • TEAM_NO_PJT1 — varchar(3) — Primary key — NOT NULL
  • GARDE (GRADE) — varchar(3)

pjt2_team

  • TEAM_NO_PJT2 — varchar(3) — Primary key — NOT NULL
  • GARDE (GRADE) — varchar(3)

pjt3_team

  • TEAM_NO_PJT3 — varchar(3) — Primary key — NOT NULL
  • GARDE (GRADE) — varchar(3)

user

  • STUDENT_ACCOUNT — varchar(20) — Primary key — NOT NULL
  • STUDENT_NAME — varchar(100)
  • STUDENT_HP — varchar(20)
  • STUDENT_AGE — varchar(5)
  • STUDENT_GENDER — varchar(20)
  • STUDENT_CURRICULUM — varchar(20)
  • STUDENT_REGION — varchar(100)
  • STUDENT_GROUP — varchar(20)
  • GROUP_TEACHER_ID — varchar(20)
  • GROUP_TEACHER_NAME — varchar(100)
  • GROUP_TEACHER_HP — varchar(20)
  • GRADE_FIRST_EXAM — varchar(3)
  • GRADE_SECOND_EXAM — varchar(3)
  • GRADE_THIRD_EXAM — varchar(3)
  • ALGORITHM_GRADE — varchar(3)
  • ALGORITHM_ACQUISITION_DATE — datetime
  • REG_USER — varchar(100)
  • REG_DT — datetime
  • LAST_USER — varchar(100)
  • LAST_DT — datetime
  • TEAM_NO_PJT1 — varchar(3) — Foreign key → pjt1_team.TEAM_NO_PJT1 — NOT NULL
  • TEAM_NO_PJT2 — varchar(3) — Foreign key → pjt2_team.TEAM_NO_PJT2 — NOT NULL
  • TEAM_NO_PJT3 — varchar(3) — Foreign key → pjt3_team.TEAM_NO_PJT3 — NOT NULL