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)