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