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