erd
Tables (6)
Enrollment (Untitled5)
- student_id (pk + FK)
- lecture_id (PK + FK)
- grade (Field3)
Instructor (Untitled)
- instructor_id (Key) — INT — Primary key — NOT NULL
- name (Field)
- age (Field2)
- gender (Field3)
Lecture (Untitled4)
- lecture_time (Field)
- location (Field2)
- Field3
- Field4
- Field5
Notice (Untitled6)
- title (Field)
- content (Field2)
- created_at (Field3)
- instructor_id (Field4)
- lecture_id (FK)
- notice_id (PK)
Student (Untitled2)
- name (Field)
- address (Field2)
- student_id (Field3)
Subject (Untitled3)
- subject_name (Field)
- subject_id (PK)