internetlecture

Tables (4)

enrollment (Untitled2)

  • id (Key) — bigint — Primary key — NOT NULL
  • student_id (Key2) — bigint — Foreign key → student.id — NOT NULL
  • lecture_id (Key3) — bigint — Foreign key → lecture.id — NOT NULL

lecture (Untitled)

  • id (Key) — bigint — Primary key — NOT NULL
  • teacher_id (Key2) — bigint — Foreign key → teacher.id — NOT NULL
  • name (Field) — varchar
  • price (Field2) — int
  • category (Field3) — enum

student (Untitled4)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar
  • password (Field2) — varchar

teacher (Untitled3)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar
  • birthday (Field2) — date