ssafy
Tables (6)
Attendance
- Index — INT — Primary key — NOT NULL
- Student_No — VARCHAR(20) — Foreign key → Student.Student_No — NOT NULL
- Attendance1/1 — TINYINT(1)
- Attendance1/1_Sign_In — DATETIME
- Attendance1/1_Sign_Out — DATETIME
- Attendance1/2 — TINYINT(1)
- Attendance1/2_Sign_In — DATETIME
- Attendance1/2_Sign_Out — DATETIME
- Attendance1/3 — TINYINT(1)
- Attendance1/3_Sign_In — DATETIME
- Attendance1/3_Sign_Out — DATETIME
Grade
- Index (PK) — INT — Primary key — NOT NULL
- Student_No — VARCHAR(20) — Foreign key → Student.Student_No — 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
- Grade_First_Project — VARCHAR(3)
- Grade_Second_Project — VARCHAR(3)
- Grade_Third_Project — VARCHAR(3)
Region
- Region_Name — VARCHAR(20) — Primary key — NOT NULL
- Group_No — VARCHAR(20) — Primary key — NOT NULL
- Teacher_id — VARCHAR(20) — Foreign key → Teacher.Teacher_id — NOT NULL
Student
- Student_No — INT — Primary key — NOT NULL
- Student_Account — VARCHAR(20)
- Student_Name — VARCHAR(100)
- Student_HP — VARCHAR(20)
- Student_Age — VARCHAR(5)
- Student_Gender — VARCHAR(20)
- Student_Curriculum — VARCHAR(20)
- Region_Name — VARCHAR(20) — Foreign key → Region.Region_Name — NOT NULL
- Team_id — INT — Foreign key → Team.Team_id — NOT NULL
- Group_No — VARCHAR(20) — Foreign key → Region.Group_No — NOT NULL
Teacher
- Teacher_id — VARCHAR(20) — Primary key — NOT NULL
- Teacher_Name — VARCHAR(20)
- Teacher_Hp — VARCHAR(20)
Team
- Team_id — INT — Primary key — NOT NULL
- Team_Subject — VARCHAR(20)
- Region_Name — VARCHAR(20) — Foreign key → Region.Region_Name — NOT NULL
- Group_No — VARCHAR(20) — Foreign key → Region.Group_No — NOT NULL