object
Tables (6)
enrollment
- enrollment_id — INT
- student_id — INT — NOT NULL
- lecture_id — INT — NOT NULL
- grade — VARCHAR(5)
instructor
- instructor_id — INT
- name — VARCHAR(50) — NOT NULL
- age — INT
- gender — VARCHAR(10)
lecture
- lecture_id — INT
- lecture_time — VARCHAR(50) — NOT NULL
- location — VARCHAR(100) — NOT NULL
- subject_id — INT — NOT NULL
- instructor_id — INT — NOT NULL
notice
- notice_id — INT
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- instructor_id — INT — NOT NULL
- lecture_id — INT — NOT NULL
student
- student_id — INT
- name — VARCHAR(50) — NOT NULL
- address — VARCHAR(200)
subject
- subject_id — INT
- subject_name — VARCHAR(100) — NOT NULL