Spring

Tables (4)

Student

  • stu_phone — Primary key — NOT NULL
  • stu_name

lesson

  • lesson_id — Sequence — Primary key — NOT NULL
  • teacher_id — Foreign key → teacher.teacher_id — NOT NULL
  • title
  • room
  • maximum
  • start

registration

  • regist_id — Sequence — Primary key — NOT NULL
  • stu_phone — Foreign key → Student.stu_phone — NOT NULL
  • lesson_id — Sequence — Foreign key → lesson.lesson_id — NOT NULL

teacher

  • teacher_id — Primary key — NOT NULL
  • teacher_name