fdfa
Tables (81)
client
- id — int — Primary key — NOT NULL
- name — varchar(100)
- email — varchar(100)
- retainer_fee — int
- updated_at — datetime
- created_at — datetime
d_unlock_moments_type
- id — int — Primary key — NOT NULL
- type_name — varchar(45)
- type_description — varchar(45)
- created_at — datetime
- updated_at — datetime
invite_codes
- id — int — Primary key — NOT NULL
- inviter_mobile — varchar(20) — NOT NULL
- invite_code — int — NOT NULL
- invitee_mobile — varchar(20) — NOT NULL
- code_created_at — timestamp
- used_date — datetime
- create_date — datetime
kk_event_0613
- id — int — Primary key — NOT NULL
- phone — varchar(20) — NOT NULL
- claim_date — date — NOT NULL
- timestamp — datetime — NOT NULL
tmp_log
- id — int — Primary key — NOT NULL
- method — varchar(45)
- data — text
- created_at — datetime
un_as3cf_items
- id — bigint — Primary key — NOT NULL
- provider — varchar(18) — NOT NULL
- region — varchar(255) — NOT NULL
- bucket — varchar(255) — NOT NULL
- path — varchar(1024) — NOT NULL
- original_path — varchar(1024) — NOT NULL
- is_private — tinyint(1) — NOT NULL
- source_type — varchar(18) — NOT NULL
- source_id — bigint — NOT NULL
- source_path — varchar(1024) — NOT NULL
- original_source_path — varchar(1024) — NOT NULL
- extra_info — longtext
- originator — tinyint — NOT NULL
- is_verified — tinyint(1) — NOT NULL
un_commentmeta
- meta_id — bigint — Primary key — NOT NULL
- comment_id — bigint — NOT NULL
- meta_key — varchar(255)
- meta_value — longtext
un_comments
- comment_ID — bigint — Primary key — NOT NULL
- comment_post_ID — bigint — NOT NULL
- comment_author — tinytext — NOT NULL
- comment_author_email — varchar(100) — NOT NULL
- comment_author_url — varchar(200) — NOT NULL
- comment_author_IP — varchar(100) — NOT NULL
- comment_date — datetime — NOT NULL
- comment_date_gmt — datetime — NOT NULL
- comment_content — text — NOT NULL
- comment_karma — int — NOT NULL
- comment_approved — varchar(20) — NOT NULL
- comment_agent — varchar(255) — NOT NULL
- comment_type — varchar(20) — NOT NULL
- comment_parent — bigint — NOT NULL
- user_id — bigint — NOT NULL
un_links
- link_id — bigint — Primary key — NOT NULL
- link_url — varchar(255) — NOT NULL
- link_name — varchar(255) — NOT NULL
- link_image — varchar(255) — NOT NULL
- link_target — varchar(25) — NOT NULL
- link_description — varchar(255) — NOT NULL
- link_visible — varchar(20) — NOT NULL
- link_owner — bigint — NOT NULL
- link_rating — int — NOT NULL
- link_updated — datetime — NOT NULL
- link_rel — varchar(255) — NOT NULL
- link_notes — mediumtext — NOT NULL
- link_rss — varchar(255) — NOT NULL
un_options
- option_id — bigint — Primary key — NOT NULL
- option_name — varchar(191) — NOT NULL
- option_value — longtext — NOT NULL
- autoload — varchar(20) — NOT NULL
un_postmeta
- meta_id — bigint — Primary key — NOT NULL
- post_id — bigint — NOT NULL
- meta_key — varchar(255)
- meta_value — longtext
un_posts
- ID — bigint — Primary key — NOT NULL
- post_author — bigint — NOT NULL
- post_date — datetime — NOT NULL
- post_date_gmt — datetime — NOT NULL
- post_content — longtext — NOT NULL
- post_title — text — NOT NULL
- post_excerpt — text — NOT NULL
- post_status — varchar(20) — NOT NULL
- comment_status — varchar(20) — NOT NULL
- ping_status — varchar(20) — NOT NULL
- post_password — varchar(255) — NOT NULL
- post_name — varchar(200) — NOT NULL
- to_ping — text — NOT NULL
- pinged — text — NOT NULL
- post_modified — datetime — NOT NULL
- post_modified_gmt — datetime — NOT NULL
- post_content_filtered — longtext — NOT NULL
- post_parent — bigint — NOT NULL
- guid — varchar(255) — NOT NULL
- menu_order — int — NOT NULL
- post_type — varchar(20) — NOT NULL
- post_mime_type — varchar(100) — NOT NULL
- comment_count — bigint — NOT NULL
un_product
- id — bigint — Primary key — NOT NULL
- title — varchar(255)
- regular_price — int
- membership_price — int
- first_price — int
- is_first_sale — tinyint
- sales_start — datetime
- sales_end — datetime
- qty — int
- status — smallint — NOT NULL
- update_at — datetime
- created_at — datetime
un_term_relationships
- object_id — bigint — Primary key — NOT NULL
- term_taxonomy_id — bigint — Primary key — NOT NULL
- term_order — int — NOT NULL
un_term_taxonomy
- term_taxonomy_id — bigint — Primary key — NOT NULL
- term_id — bigint — NOT NULL
- taxonomy — varchar(32) — NOT NULL
- description — longtext — NOT NULL
- parent — bigint — NOT NULL
- count — bigint — NOT NULL
un_termmeta
- meta_id — bigint — Primary key — NOT NULL
- term_id — bigint — NOT NULL
- meta_key — varchar(255)
- meta_value — longtext
un_terms
- term_id — bigint — Primary key — NOT NULL
- name — varchar(200) — NOT NULL
- slug — varchar(200) — NOT NULL
- term_group — bigint — NOT NULL
un_usermeta
- umeta_id — bigint — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- meta_key — varchar(255)
- meta_value — longtext
un_users
- ID — bigint — Primary key — NOT NULL
- user_login — varchar(60) — NOT NULL
- user_pass — varchar(255) — NOT NULL
- user_nicename — varchar(50) — NOT NULL
- user_email — varchar(100) — NOT NULL
- user_url — varchar(100) — NOT NULL
- user_registered — datetime — NOT NULL
- user_activation_key — varchar(255) — NOT NULL
- user_status — int — NOT NULL
- display_name — varchar(250) — NOT NULL
unlock_address
- id — int — Primary key — NOT NULL
- user_id — int — NOT NULL
- name — varchar(20)
- mobile — varchar(20)
- address_1 — varchar(100)
- address_2 — varchar(100)
- postcode — int
- comment — varchar(255)
- is_select — tinyint
- created_at — datetime
- updated_at — datetime
unlock_airdrop_setting
- id — int — Primary key — NOT NULL
- airdrop_to — varchar(45)
- airdrop_type — varchar(45)
- type_id — int
- num — int
- is_valid — tinyint
- created_at — datetime
- updated_at — datetime
unlock_auth_event
- id — int — Primary key — NOT NULL
- event_type — varchar(100)
- auth_method — varchar(100)
- method_detail_id — varchar(50)
- group_name — varchar(45)
- title — varchar(100)
- short_title — varchar(45)
- log_detail — varchar(45)
- success_msg — varchar(100)
- fail_msg — varchar(100)
- noti_msg — varchar(100)
- popup_msg — varchar(100)
- already_noti_msg — varchar(100)
- already_popup_msg — varchar(100)
- page_to — varchar(45)
- related_img — varchar(1000)
- description — varchar(1000)
- start_at — datetime
- expire_date — datetime
- created_at — datetime
- updated_at — datetime
unlock_auth_group
- id — int — Primary key — NOT NULL
- group_name — varchar(45)
- name — varchar(45)
- user_id — int
- mobile — varchar(45)
- num — int
- auth_count — int
- created_at — datetime
- updated_at — datetime
unlock_auth_users
- id — int — Primary key — NOT NULL
- verifier_id — varchar(100)
- password — varchar(255)
- is_valid — int
- event_id — int
- refresh_token — varchar(255)
- expire_date — datetime
- created_at — datetime
- updated_at — datetime
unlock_chat
- id — int — Primary key — NOT NULL
- room_no — varchar(100) — 채팅방 번호
- room_name — varchar(100) — 채팅방 이름
- room_category — varchar(100) — 채팅방 카테고리
- room_status — int — 0:비활성 1:활성
- start_at — datetime
- end_at — datetime
- author_id — varchar(100)
- created_at — datetime
- updated_at — datetime
unlock_chat_policy
- id — int — Primary key — NOT NULL
- title — varchar(100)
- detail — varchar(100)
- created_at — datetime
- updated_at — datetime
unlock_chat_room
- id — int — Primary key — NOT NULL
- room_name — varchar(45)
- room_id — varchar(500)
- notification — varchar(300)
- is_live — tinyint
- created_at — datetime
- updated_at — datetime
unlock_content_img
- id — int — Primary key — NOT NULL
- page — varchar(45)
- img_type — varchar(45)
- img_url — varchar(1000)
- is_valid — int
- created_at — datetime
- updated_at — datetime
unlock_content_text
- id — int — Primary key — NOT NULL
- page — varchar(45)
- category — varchar(45)
- title — varchar(45)
- content — varchar(500)
- is_valid — int
- created_at — datetime
- updated_at — datetime
unlock_cp
- id — int — Primary key — NOT NULL
- user_id — int
- mobile — varchar(15)
- token_id — int
- plate — varchar(45)
- collectors_pad — int
- created_at — datetime
- updated_at — datetime
unlock_email_auth
- id — int — Primary key — NOT NULL
- email — varchar(100)
- auth_status — int
- created_at — datetime
- updated_at — datetime
unlock_event
- id — int — Primary key — NOT NULL
- event_type — varchar(45)
- auth_method — varchar(45)
- method_detail_id — int
- title — varchar(100)
- short_title — varchar(100)
- success_msg — varchar(100)
- fail_msg — varchar(100)
- related_img — varchar(1000)
- description — text
- start_at — datetime
- end_at — datetime
- expire_date — datetime
- created_at — datetime
- updated_at — datetime
unlock_faq
- id — bigint — Primary key — NOT NULL
- title — varchar(255)
- content — text
- created_at — datetime
- updated_at — datetime
unlock_live_subscription
- id — int — Primary key — NOT NULL
- user_id — int
- device_id — varchar(500)
- fcm_token — varchar(500)
- topic — varchar(45)
- is_subscribe — int
- is_active — int
- created_at — datetime
- updated_at — datetime
unlock_live_topic
- id — int — Primary key — NOT NULL
- live_type — varchar(45)
- topic_name — varchar(45)
- subscribe_cnt — int
- created_at — datetime
- updated_at — datetime
unlock_logs
- id — bigint — Primary key — NOT NULL
- log — text
- created_at — datetime
unlock_membership
- id — int — Primary key — NOT NULL
- membership_name — varchar(100) — 멤버쉽 이름
- id_prefix — varchar(45)
- description — varchar(500)
- theme_color — varchar(45)
- expire_date — datetime — 유효기간
- created_at — datetime
- updated_at — datetime
unlock_moments
- id — int — Primary key — NOT NULL
- status — tinyint — 모먼츠 유효성/ 1= 도감에 포함됨
- description — text — 모먼츠 이미지 상황 설명
- moment_type — varchar(45)
- moment_sticker — varchar(1000)
- total_supply — int
- rarity_num — json
- category_id — int — Foreign key → unlock_moments_category.id
- edition_id — int — Foreign key → unlock_moments_edition.id
- attributes — json — {‘attributes’:‘승리투수’,’홈런’}
- match_id — int — moments_match
- year — varchar(45)
- player_id — int — moments_player
- product_id — int
- content_id — int
- img_format — varchar(45)
- img_id — bigint
- img_url — varchar(2550)
- reveal_at — datetime — 리빌 가능한 시간
- created_at — datetime
- updated_at — datetime
- moment_id — varchar(50)
- moment_name — varchar(45) — moments_imgs
- moment_status — json — {"game": 0, "sale": 0}\\nGame 시작 후 : 1\\n판매 시작 후 : 1
- bw_index — int
- info_status — tinyint — 0 : all, 1: 경기정보 숨김, 2: 선수 정보 숨김, 3: 경기/선수정보 숨김
unlock_moments_attribute
- id — int — Primary key — NOT NULL
- attribute_name — varchar(45)
- attribute_short_name — varchar(45)
- attribute_description — varchar(45)
- created_at — datetime
- updated_at — datetime
unlock_moments_category
- id — int — Primary key — NOT NULL
- category_id — int
- category_name — varchar(45)
- category_short_name — varchar(45)
- category_eng_name — varchar(45)
- created_at — datetime
- updated_at — datetime
unlock_moments_content
- id — int — Primary key — NOT NULL
- content_id — varchar(45)
- content_type — int
- content_order — int
- title — varchar(200)
- body — text
- detail_key — varchar(45)
- created_at — datetime
- updated_at — datetime
unlock_moments_content_list
- id — int — Primary key — NOT NULL
- title — varchar(200)
- description — varchar(500)
- created_at — datetime
- updated_at — datetime
unlock_moments_content_type
- id — int — Primary key — NOT NULL
- type_name — varchar(45)
- type_title — varchar(100)
- type_subtitle — varchar(100)
- detail_key — varchar(45)
- description — varchar(500)
- created_at — datetime
- updated_at — datetime
unlock_moments_edition
- id — int — Primary key — NOT NULL
- status — tinyint
- edition_id — int
- edition_name — varchar(45)
- edition_short_name — varchar(45)
- edition_description — varchar(45)
- reveal_type — varchar(45)
- bw_index — int
- max_num — int
- default_img_id — int
- default_img_url — varchar(255)
- created_at — datetime
- updated_at — datetime
unlock_moments_imgs
- id — int — Primary key — NOT NULL
- moment_id — int
- rarity_id — int — rarity 테이블 따로있음
- img_category — varchar(45)
- holo_effect — tinyint
- img_format — varchar(45)
- img_id — bigint
- img_url — varchar(2550)
- small_img_id — bigint
- small_img_url — varchar(2550)
- is_valid — int
- created_at — datetime
- updated_at — datetime
unlock_moments_matchs
- id — int — Primary key — NOT NULL
- team_id_left — int — moments_team
- team_id_right — int — moments_team
- match_date — datetime
- home_team — varchar(45)
- win_team — varchar(45)
- match_location — varchar(45)
- match_pitcher — varchar(45)
- gameId — varchar(100)
- match_score — json — {‘innings’:1,2,3,4,5,’scores’:{‘left’:2,3,4,5,6,’right’:4,4,7,8,6},’summary_title’:‘R’,’H’,’E’,’B’,’summary_score’:{‘le…
- match_score_tmp — json
- match_end_date — datetime
- is_live — tinyint
- created_at — datetime
- updated_at — datetime
unlock_moments_player
- id — int — Primary key — NOT NULL
- unique_player_id — varchar(50)
- player_score — json
- player_score_tmp — json
- match_id — int
- is_moment — int
- created_at — datetime
- updated_at — datetime
unlock_moments_rarity
- id — int — Primary key — NOT NULL
- rarity_name — varchar(45)
- rarity_point — int
- theme_color — varchar(45)
- rarity_img_id — bigint
- rarity_img — varchar(1000)
- created_at — datetime
- updated_at — datetime
unlock_moments_tag
- id — int — Primary key — NOT NULL
- moment_id — varchar(45)
- tag_type — varchar(45)
- title — text
- sub_title — varchar(45)
- tag_status — int
- created_at — datetime
- updated_at — datetime
unlock_moments_teams
- id — int — Primary key — NOT NULL
- live_activity_id — int
- team_name — varchar(45)
- team_short_name — varchar(45)
- team_logo_id — bigint
- team_logo — varchar(255)
- created_at — datetime
- updated_at — datetime
unlock_moments_unique_player
- id — int — Primary key — NOT NULL
- player_name — varchar(45)
- player_type — varchar(45)
- player_eng_name — varchar(45)
- player_back_number — varchar(45)
- img_id — bigint
- img_url — varchar(1000)
- related_moment_cnt — int
- created_at — datetime
- updated_at — datetime
unlock_news
- id — int — Primary key — NOT NULL
- category_id — int — 카테고리 ID
- news_title — text — 뉴스 타이틀
- news_subtitle — text — 뉴스 서브타이틀
- news_order — int
- related_moment_id — int
- related_player_id — int
- moment_edition — varchar(45)
- news_img_id — bigint
- news_sub_img_id — bigint
- news_img_url — varchar(255) — 뉴스 이미지경로
- news_sub_img_url — varchar(255) — 뉴스 서브이미지경로
- news_status — int — 0: 게시안됨 1: 게시됨
- author_id — int — 작성자 ID
- match_id — int
- moment_id — int
- page_to — varchar(255)
- start_at — datetime
- updated_at — datetime
- created_at — datetime
unlock_news_author
- author_id — int — Primary key — NOT NULL
- author_name — varchar(50) — 작가 이름
- author_email — varchar(50) — 작가 이메일
- author_profile — varchar(255) — 작가 프로필
- author_status — int — 0: 활동 1: 비활동
- updated_at — datetime
- created_at — datetime
unlock_news_category
- category_id — int — Primary key — NOT NULL — 카테고리ID
- category_type — varchar(50) — 카테고리 타입
- type_name — varchar(45)
- category_name — varchar(45) — 카테고리 이름
- category_sub_name — varchar(45)
- category_description — varchar(100) — 카테고리 설명
- updated_at — datetime
- created_at — datetime
unlock_news_detail
- id — int — Primary key — NOT NULL
- news_id — varchar(45)
- detail_type — varchar(45)
- detail_title — varchar(45)
- detail_content — text
- detail_img_id — bigint
- detail_img_url — varchar(255)
- detail_footer — varchar(45)
- btn_text — varchar(100)
- btn_color — varchar(100)
- page_to — varchar(500)
- updated_at — datetime
- created_at — datetime
unlock_news_notice
- id — int — Primary key — NOT NULL
- notice_id — varchar(45)
- detail_type — varchar(45)
- detail_title — varchar(45)
- detail_content — text
- detail_img_url — varchar(255)
- updated_at — datetime
- created_at — datetime
unlock_nfc
- id — int — Primary key — NOT NULL
- user_id — int — NOT NULL
- auth_type — varchar(50)
- type_detail_id — int
- nfc_uuid — varchar(500)
- nfc_key — varchar(500)
- cnt — int
- is_valid — int — NOT NULL
- created_at — datetime
- updated_at — datetime
unlock_order_item
- id — bigint — Primary key — NOT NULL
- order_id — bigint — NOT NULL
- product_id — bigint
- qty — int
- moments_qty — int
- price — int
- sub_total — int
- vat_total — int
- line_total — int
- title — varchar(255)
- detail_info — varchar(100)
- p_type — varchar(100)
- updated_at — datetime
- created_at — datetime
unlock_payment
- id — bigint — Primary key — NOT NULL
- user_id — bigint — NOT NULL
- object_id — bigint
- object_type — varchar(20)
- status — smallint
- imp_uid — varchar(100)
- merchant_uid — varchar(100)
- toss_uid — varchar(100)
- sub_total — int
- vat_total — int
- order_total — int
- paid_total — int
- refunded_total — int
- user_agent — text
- user_ip — varchar(255)
- updated_at — datetime
- created_at — datetime
unlock_product
- id — bigint — Primary key — NOT NULL
- title — varchar(255)
- product_type — varchar(45)
- thumbnail_id — int
- thumbnail — varchar(255)
- regular_price — int
- membership_price — int
- content_id — int
- sales_start — datetime
- sales_end — datetime
- first_price — int
- is_first_sale — tinyint
- qty — int
- moments_qty — int
- status — smallint — NOT NULL
- remain_qty — int
- sales_qty — int
- auth_group — varchar(100)
- max_once_num — int
- is_deliver — tinyint
- is_deliver_fee — tinyint
- bundle — json
- updated_at — datetime
- created_at — datetime
- is_test — tinyint
- reveal_type — varchar(45)
- auth_type — varchar(45)
unlock_product_img
- id — int — Primary key — NOT NULL
- product_id — int
- img_category — varchar(45)
- img_order — int
- img_id — int
- img_format — varchar(30)
- img_url — varchar(1000)
- created_at — datetime
- updated_at — datetime
- holo_effect — tinyint
unlock_push_list
- id — int — Primary key — NOT NULL
- msg — varchar(45)
- page_to — varchar(45)
- created_at — datetime
- updated_at — datetime
unlock_push_log
- id — int — Primary key — NOT NULL
- user_id — int
- fcm_token — varchar(45)
- title — varchar(50)
- text — varchar(500)
- push_type — varchar(45)
- page_to — varchar(1000)
- is_read — tinyint
- is_important — tinyint
- is_deleted — tinyint
- created_at — datetime
- updated_at — datetime
unlock_qr
- id — int — Primary key — NOT NULL
- user_id — int — NOT NULL
- auth_type — varchar(50)
- type_detail_id — int
- event_type — varchar(100) — NOT NULL
- event_id — int — NOT NULL
- qr_key — varchar(500)
- cnt — int
- is_valid — int — NOT NULL — 0: 활성안됨 1: 활성됨
- created_at — datetime
- updated_at — datetime
unlock_qr_mint
- id — int — Primary key — NOT NULL
- moment_id — int
- qr_key — varchar(200)
- auth_group — varchar(45)
- created_at — datetime
- updated_at — datetime
unlock_qr_mint_log
- id — int — Primary key — NOT NULL
- user_id — int
- auth_type — varchar(45)
- auth_id — varchar(45)
- moment_id — int
- auth_qr — varchar(500)
- created_at — datetime
- updated_at — datetime
unlock_qr_user_unique
- id — int — Primary key — NOT NULL
- user_id — int
- qr_key — varchar(100)
- is_valid — int
- created_at — datetime
- updated_at — datetime
unlock_roulette_setting
- id — int — Primary key — NOT NULL
- edition_id — int
- edition_name — varchar(45)
- num — int
- noti_msg — varchar(200)
- created_at — datetime
- updated_at — datetime
unlock_shop_order
- id — bigint — Primary key — NOT NULL
- order_key — varchar(100)
- user_id — bigint — NOT NULL
- status — smallint
- qty — int
- pay_method — varchar(20)
- sub_total — int
- vat_total — int
- shipping_fee — int
- order_total — int
- name — varchar(100)
- mobile — varchar(20)
- address_1 — varchar(100)
- address_2 — varchar(100)
- postcode — int
- comment — varchar(255)
- delivery — tinyint
- updated_at — datetime
- created_at — datetime
unlock_user_agree
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → unlock_users.id
- category — varchar(100)
- detail — varchar(200)
- agree — int
- insert_date — datetime
unlock_user_auth_log
- id — int — Primary key — NOT NULL
- user_id — int — NOT NULL
- event_type — varchar(100)
- event_id — int
- auth_type — varchar(100)
- auth_id — int
- auth_detail — varchar(45)
- method — varchar(45)
- method_value — int
- verifier_type — varchar(45)
- verifier_id — int
- is_valid_auth — tinyint
- created_at — datetime
- updated_at — datetime
unlock_user_auth_right
- id — int — Primary key — NOT NULL
- user_id — int
- event_id — int
- auth_cnt — int
- is_valid — tinyint
- created_at — datetime
- updated_at — datetime
unlock_user_fcm_token
- id — int — Primary key — NOT NULL
- user_id — int
- device_id — varchar(1000) — 기기 고유 아이디
- device_os — varchar(100)
- fcm_token — varchar(1000)
- created_at — datetime
- updated_at — datetime
unlock_user_group
- id — int — Primary key — NOT NULL
- group_type — varchar(45)
- mobile — varchar(45)
- created_at — datetime
- updated_at — datetime
unlock_user_membership
- id — int — Primary key — NOT NULL
- user_id — int — NOT NULL
- membership_id — int — NOT NULL
- token_id — int
- membership_class — varchar(100) — NOT NULL
- membership_no — varchar(50)
- is_activated — int — NOT NULL
- expire_date — datetime
- insert_date — datetime
- modify_date — datetime
unlock_user_moments
- id — int — Primary key — NOT NULL
- product_id — int
- product_parent_id — int
- moment_id — int — NOT NULL
- token_id — int
- user_id — int
- rarity_id — int
- reveal_status — int — reveal 실행 후 상태 1로 바뀜 0: default 1: open된 상태
- moment_note — varchar(410)
- order_id — int
- is_special_moment — int
- is_voted — tinyint
- special_moment_change_date — datetime
- published_at — datetime
- revealed_at — datetime
- created_at — datetime
- updated_at — datetime
- moment_status — json
unlock_users
- id — int — Primary key — NOT NULL
- mobile — varchar(20) — NOT NULL — 사용자 휴대폰 번호
- name — varchar(100) — 사용자이름(닉네임)
- email — varchar(100) — 사용자이메일
- password — text
- profile_img — varchar(1000)
- email_auth_status — tinyint — 기본값 0, 인증됨 1
- updated_at — datetime
- created_at — datetime
- mobile_token — varchar(255)
- rx_fcm — tinyint
- rx_sms — tinyint
- rx_email — tinyint
- admin_level — int
unlock_vote
- id — int — Primary key — NOT NULL
- title — varchar(45)
- subtitle — varchar(200)
- add_text — varchar(50)
- vote_type — varchar(45)
- title_web — varchar(300)
- match_id — int
- start_at — datetime
- end_at — datetime
- vote_num — int
- is_active — tinyint
- vote_right_type — varchar(100)
- vote_right_num — int
- is_publish — tinyint — 0 unpublished\n1 publish\n2 publish only admin
- is_live — tinyint
- created_at — datetime
- updated_at — datetime
unlock_vote_log
- id — int — Primary key — NOT NULL
- user_id — int
- vote_id — int
- player_id — int
- auth_type — varchar(45)
- auth_value — varchar(45)
- created_at — datetime
- updated_at — datetime
unlock_vote_player
- id — int — Primary key — NOT NULL
- vote_id — int
- player_id — int
- player_img_id — bigint
- player_img — varchar(1000)
- vote_num — int
- created_at — datetime
- updated_at — datetime
and 1 more table