ssafy
Tables (7)
Algo (Untitled4)
- aid (Key) — INT — Primary key — NOT NULL
- STUDENT_HP (Key2) — String — Foreign key → Student.STUDENT_HP — NOT NULL
- ALGORITHM_GRADE (Field) — String
- ALGORITHM_ACQUISITION_DATE (Field2) — String
Attendance (Untitled5)
- attid (Key) — INT — Primary key — NOT NULL
- STUDENT_HP (Key2) — String — Foreign key → Student.STUDENT_HP — NOT NULL
- ATTENDANCE_DATE (Field) — INT
- ATTENDANCE_SIGN_IN (Field2) — Datetime
- ATTENDANCE_SIGN_OUT (Field3) — Datetime
Exam (Untitled3)
- eid (Key) — INT — Primary key — NOT NULL
- STUDENT_HP (Key2) — String — Foreign key → Student.STUDENT_HP — NOT NULL
- EXAM_GRADE (Field) — String
- GRADE_TERM (Field2) — String
Group (Untitled2)
- gid (Key) — INT — Primary key — NOT NULL
- STUDENT_HP (Key2) — String — Foreign key → Student.STUDENT_HP — NOT NULL
- GROUP_TEACHER_ID (Field) — STring
- GROUP_TEACHER_NAME (Field2) — String
- GROUP_TEACHER_HP (Field4) — String
Student (Untitled)
- STUDENT_HP (Key) — String — Primary key — NOT NULL
- STUDENT_ACCOUNT (Field) — String
- STUDENT_NAME (Field2) — String
- STUDENT_AGE (Field3) — String
- STUDENT_GENDER (Field4) — String
- STUDENT_GENDER (Field5) — String
- STUDENT_REGION (Field6) — String
- STUDENT_GROUP (Field7) — String
- REG_DT (Field8) — Datetime
- LAST_DT (Field9) — Datetime
Team (Untitled7)
- tid (Key) — INT — Primary key — NOT NULL
- TEPROJECT (Field) — String
- PROPJECT_GRADE (Field2) — String
Team_Student (Untitled6)
- Key — Primary key — NOT NULL
- STUDENT_HP (Key2) — String — Foreign key → Student.STUDENT_HP — NOT NULL
- tid (Key3) — INT — Foreign key → Team.tid — NOT NULL
- Field