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