SSAFY System
Tables (8)
algorithm
- ALGORITHM_GRADE — varchar(20) — Primary key — NOT NULL
attendance
- STUDENT_ACCOUNT — varchar(20) — Foreign key → student.STUDENT_ACCOUNT — NOT NULL
- ATTENDANCE_SIGN_IN — datetime
- ATTENDANCE_SIGN_OUT — datetime
- ATTENDANCE_CHECK — tinyint(1)
group
- STUDENT_GROUP — varchar(20) — Primary key — NOT NULL
- REGION_NAME — varchar(20) — Foreign key → region.REGION_NAME — NOT NULL
- TEACHER_ID — varchar(20) — Foreign key → teacher.TEACHER_ID
project
- PROJECT_ID — int — Primary key — NOT NULL
- PROJECT_TITLE — varchar(100) — NOT NULL
- PROJECT_GRADE — varchar(20)
- PROJECT_TYPE — varchar(50)
region
- REGION_NAME — varchar(20) — Primary key — NOT NULL
relation_student_project
- _ID — int — Primary key — NOT NULL
- STUDENT_ACCOUNT — varchar(20) — Foreign key → student.STUDENT_ACCOUNT — NOT NULL
- PROJECT_ID — int — Foreign key → project.PROJECT_ID — NOT NULL
student
- STUDENT_ACCOUNT — varchar(20) — Primary key — 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_GROUP — varchar(20) — Foreign key → group.STUDENT_GROUP
- REGION_NAME — varchar(20) — Foreign key → group.REGION_NAME
- GRADE_FIRST_EXAM — varchar(3)
- GRADE_SECOND_EXAM — varchar(3)
- GRADE_THIRD_EXAM — varchar(3)
- ALGORITHM_GRADE — varchar(20) — Foreign key → algorithm.ALGORITHM_GRADE
- ALGORITHM_ACQUISITION_DATE — datetime
teacher
- TEACHER_ID — varchar(20) — Primary key — NOT NULL
- TEACHER_NAME — varchar(20) — NOT NULL
- TEACHER_HP — varchar(20) — NOT NULL