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)