internetstudy

Tables (4)

Enrollment (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • study_id (Key2) — Foreign key → Study.id — NOT NULL
  • student_id (Key3) — Foreign key → Student.id — NOT NULL
  • createtime (Field)

Student (Untitled2)

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

Study (Untitled)

  • id (Key) — Primary key — NOT NULL
  • teahcer_id (Key2) — Foreign key → Teacher.id — NOT NULL
  • title (Field)
  • Field2
  • Field3
  • category (Field4)
  • ispublished (Field5)
  • maketime (Field6)
  • updatetime (Field7)

Teacher (Untitled3)

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