ko-play3.0

Tables (12)

avatar

  • avatar_idx — INT
  • nation_idx — INT — Foreign key → nation.nation_idx — NOT NULL
  • avatar_file — MEDIUMBLOB
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

gallary

  • gallery_idx — INT
  • student_idx — INT — Foreign key → student.student_idx — NOT NULL
  • parent_idx — INT — Foreign key → student.parent_idx — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • snapshot — String

game

  • game_idx — INT
  • game_name — VARCHAR(255)
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • is_rank — NOT NULL

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
  • correct — INT — NOT NULL
  • total_question — INT
  • game_level — INT
  • gained_exp — INT
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

game_purpose

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

music

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

nation

  • nation_idx — INT
  • country_name — VARCHAR(255)
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

parent

  • parent_idx — INT — NOT NULL
  • parent_email — VARCHAR(255) — NOT NULL
  • parent_name — VARCHAR(255) — NOT NULL
  • provider — VARCHAR(255) — NOT NULL
  • nationality — VARCHAR(255)
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • visited — BOOLEAN — NOT NULL

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
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

student

  • student_idx — INT — NOT NULL
  • parent_idx — INT — Foreign key → parent.parent_idx — NOT NULL
  • student_id — VARCHAR(255) — NOT NULL
  • student_pw — VARCHAR(255)
  • nickname — VARCHAR(255)
  • exp — INT
  • birth — DATE
  • profile_img — MEDIUMBLOB
  • school_name — VARCHAR(255)
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • student_name — VARCHAR(255) — NOT NULL
  • update_date — DATETIME
  • visited — BOOLEAN — NOT NULL

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
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • currrent_use — BOOLEAN — NOT NULL
  • update_date — DATETIME

word

  • word_idx — INT
  • word_difficulty — INT
  • img_url — VARCHAR(255)
  • is_deleted — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL