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)