ezenstudy

Tables (4)

Enrollment (Untitled2)

  • id (Key) — Primary key — NOT NULL
  • studentid (Key2) — Foreign key → Lecture.id — NOT NULL
  • enrollid (Key3) — Foreign key → Student.id — NOT NULL

Lecture (Untitled)

  • id (Key) — Primary key — NOT NULL
  • teacherid (Key2) — Foreign key → Teacher.id — NOT NULL
  • name (Field)
  • price (Field2)
  • category (Field3)

Student (Untitled3)

  • id (Key) — Primary key — NOT NULL
  • email (Field)
  • password (Field2)

Teacher (Untitled4)

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