unversityMe

Tables (4)

attempts

  • attempt_token_id — VARCHAR(11) — Primary key — NOT NULL
  • course_id — VARCHAR(11) — Foreign key → course.course_id — NOT NULL
  • program_id — VARCHAR(11) — Foreign key → course.program_id — NOT NULL
  • student_id — VARCHAR(11) — Foreign key → student.student_id — NOT NULL
  • semester — CHAR(1)
  • year — VARCHAR(8) — NOT NULL
  • mark — SMALLINT(3)
  • grade — CHAR(3)

course

  • course_id — VARCHAR(11) — Primary key — NOT NULL
  • program_id — VARCHAR(11) — Foreign key → program.program_id — NOT NULL
  • student_id — VARCHAR(11) — Foreign key → program.student_id — NOT NULL
  • course_name — VARCHAR(255)
  • credit_point — FLOAT(3)
  • year_commenced — VARCHAR(8)

program

  • program_id — VARCHAR(11) — Primary key — NOT NULL
  • student_id — VARCHAR(11) — Foreign key → student.student_id — NOT NULL
  • program_name — VARCHAR(255)
  • credit_point — FLOAT(3)
  • year_commenced — VARCHAR(8)

student

  • student_id — VARCHAR(11) — Primary key — NOT NULL
  • given_name — VARCHAR(255)
  • sure_name — VARCHAR(255)
  • date_birth — VARCHAR(8)
  • enrollment_date — VARCHAR(8)