test1

Tables (3)

course

  • course_id — number — Primary key
  • content — varchar(25)
  • title — varchar(20)

register

  • student_id — number — Foreign key → student.student_id
  • course_id — number — Foreign key → course.course_id
  • grade — varchar(4)

student

  • student_id — number — Primary key
  • name — varchar(20)
  • phone — varchar(12)