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