WordTestService

Tables (6)

student (CopyOfUntitled5)

  • nickname (Key) — Foreign key → user.nickname — NOT NULL
  • teacher_list (Field)

teacher (Untitled5)

  • nickname (Key) — Foreign key → user.nickname — NOT NULL
  • student_list (Field)

user (Untitled)

  • nickname (Key) — Primary key — NOT NULL
  • id (Field)
  • password (Field2)
  • email (Field3)
  • level (Field4)
  • is_teacher (Field5)
  • is_student (Field6)

word_correct_percentage (Untitled3)

  • word (Key) — Foreign key → wordtest.word — NOT NULL
  • correct (Field)
  • incorrect (Field2)

wordtest (Untitled2)

  • word (Key) — Primary key — NOT NULL
  • mean (Field2)
  • is_correct (Field3)

wrong_answers_note (Untitled4)

  • word (Key) — Foreign key → wordtest.word — NOT NULL
  • word (Field)
  • mean (Field2)