ssafy
Tables (6)
ALGO
- STUDENT_ID — varchar(20) — Primary key — NOT NULL
- STUDENT_ACCOUNT — varchar(20) — Foreign key → Students.STUDENT_ACCOUNT — NOT NULL
- ALGO_GRADE — varchar(20)
- DATE — DATE
ATTENDANCE
- ATTENDANCE_ID — varchar(20) — Primary key — NOT NULL
- STUDENT_ACCOUNT — varchar(20) — Foreign key → Students.STUDENT_ACCOUNT — NOT NULL
- ATTENDANCE — BOOLEAN
- ATTENDANCE_IN — DATE
- ATTENDANCE_OUT — DATE
EXAM_GRADE
- EXAM_NUMBER — varchar(20) — Primary key — NOT NULL
- STUDENT_ACCOUNT — varchar(20) — Foreign key → Students.STUDENT_ACCOUNT — NOT NULL
- GRADE — varchar(20)
PROJECT
- PROJECT_ID (Key) — varchar(20) — Primary key — NOT NULL
- STUDENT_ACCOUNT — varchar(20) — Foreign key → Students.STUDENT_ACCOUNT — NOT NULL
- PROJECT_NAME — varchar(20)
- PROJECT_GRADE — varchar(20)
Students (students)
- STUDENT_ACCOUNT — varchar(20) — Primary key — NOT NULL
- TEACHER_ID — varchar(20) — Foreign key → Teachers.TEACHER_ID — NOT NULL
- STUDENT_NAME — varchar(100) — NOT NULL
- STUDENT_GENDER — varchar(20)
- STUDENT_AGE — varchar(20)
- STUDENT_CURRICULUM — varchar(20)
- STUDENT_REGION — varchar(20)
Teachers (teachers)
- TEACHER_ID — varchar(20) — Primary key — NOT NULL
- TEACHER_NAME — varchar(20)
- TEACHER_HR — varchar(20)