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