new RecommendVideo

Tables (5)

setting

  • member_id — bigint — Primary key — NOT NULL
  • language — enum('CH','KO') — NOT NULL
  • level — enum('ADVANCED','BEGINNER','INTERMEDIATE') — NOT NULL
  • play_type — enum('SENTENCE','WORD') — NOT NULL

user

  • id — bigint — Primary key — NOT NULL
  • login_id — varchar(255)
  • password — varchar(255)
  • username — varchar(255)
  • role — tinyint — NOT NULL
  • join_time — datetime(6)
  • last_login_time — datetime(6)

video_link

  • id — bigint — Primary key — NOT NULL
  • title — varchar(255)
  • type — enum('DF', 'YT') — NOT NULL — YT : 유튜브영상, DF : 기본영상
  • url — varchar(255)

wdict

  • id — bigint — Primary key — NOT NULL
  • chn — varchar(255)
  • chn_full — varchar(255)
  • clip_exists — varchar(255)
  • example — text
  • homo_num — int
  • kor — varchar(255)
  • level — varchar(255)
  • meaning — text
  • meaning_chn — text
  • origin — varchar(255)
  • pos — varchar(255)
  • pos_eng — varchar(255)
  • word_num — bigint
  • idwdict — int — NOT NULL
  • homoNum — int

wordlist

  • id — bigint — Primary key — NOT NULL
  • type — enum('REC', 'USER') — NOT NULL — USER : 개인 단어장 ,REC : 추천 단어장
  • dictionary_id — bigint — NOT NULL
  • member_id — bigint — NOT NULL