ko-play2.0

Tables (13)

avatar

  • avatar_idx — INT
  • nation_idx — INT — Foreign key → nation.nation_idx — NOT NULL
  • avatar_file — MEDIUMBLOB

gallary

  • gallery_idx — INT
  • student_idx — INT — Foreign key → student.student_idx — NOT NULL
  • parent_idx — INT — Foreign key → student.parent_idx — NOT NULL

game

  • game_idx — INT
  • game_name — VARCHAR(255)

game_data

  • game_data_id — INT
  • student_idx — INT — Foreign key → student.student_idx — NOT NULL
  • game_idx — INT — Foreign key → game.game_idx — NOT NULL
  • play_date — DATE
  • correct — INT — NOT NULL
  • total_question — INT
  • game_level — INT
  • gained_exp — INT
  • is_rank — BOOLEAN

game_purpose

  • game_purpose_idx — INT
  • game_idx — INT — Foreign key → game.game_idx — NOT NULL
  • game_purpose — VARCHAR(255)

music

  • music_idx — INT
  • word_idx — INT — Foreign key → word.word_idx — NOT NULL
  • music_url — VARCHAR(255)

nation

  • nation_idx — INT
  • country_name — VARCHAR(255)

parent

  • parent_idx — INT
  • parent_email — VARCHAR(255)
  • parent_name — VARCHAR(255)
  • provider — VARCHAR(255)
  • nationality — VARCHAR(255)

recommend_level

  • level_idx — INT
  • student_idx — INT — Foreign key → student.student_idx — NOT NULL
  • parent_idx — INT — Foreign key → student.parent_idx — NOT NULL
  • level_speech — INT
  • level_reading — INT
  • level_listening — INT

student

  • student_idx — INT
  • parent_idx — INT — Foreign key → parent.parent_idx — NOT NULL
  • student_id — VARCHAR(255)
  • student_pw — VARCHAR(255)
  • nickname — VARCHAR(255)
  • student_level — INT
  • exp — INT
  • birth — DATE
  • profile_img — MEDIUMBLOB
  • school_name — VARCHAR(255)

student_level_per_nation

  • student_level_per_nation_idx — INT
  • student_idx — INT — Foreign key → student.student_idx — NOT NULL
  • nation_idx — INT — Foreign key → nation.nation_idx — NOT NULL
  • nation_level — INT

student_useable_avatar

  • student_usable_avatar_idx — INT
  • student_idx — INT — Foreign key → student.student_idx — NOT NULL
  • avatar_idx — INT — Foreign key → avatar.avatar_idx — NOT NULL
  • nation_idx — INT — Foreign key → avatar.nation_idx — NOT NULL

word

  • word_idx — INT
  • word_difficulty — INT
  • word_class — VARCHAR(255)
  • img_url — VARCHAR(255)