UNLOCK 0620

Tables (41)

unlock_auth_event

  • id — int — Primary key — NOT NULL
  • event_type — varchar(100)
  • auth_method — varchar(100)
  • method_detail_id — varchar(50)
  • 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
  • group_name — varchar(45) — Foreign key → unlock_auth_group.group_name

unlock_auth_group

  • id — int — Primary key — NOT NULL
  • group_name — varchar(45) — Primary key
  • name — varchar(45)
  • mobile — varchar(45)
  • num — int
  • auth_count — int
  • created_at — datetime
  • updated_at — datetime
  • user_id — int — Foreign key → unlock_users.id — NOT NULL

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_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_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
  • year — varchar(45)
  • 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: 경기/선수정보 숨김
  • attributes — json — Foreign key → unlock_moments_attribute.id — NOT NULL
  • category_id — int — Foreign key → unlock_moments_category.id — NOT NULL
  • edition_id — int — Foreign key → unlock_moments_edition.id — NOT NULL
  • match_id — int — Foreign key → unlock_moments_matchs.id — NOT NULL
  • product_id — bigint — Foreign key → unlock_product.id — NOT NULL
  • player_id — int — Foreign key → unlock_moments_player.id — NOT NULL

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_order — int
  • title — varchar(200)
  • body — text
  • detail_key — varchar(45)
  • created_at — datetime
  • updated_at — datetime
  • content_type_id (content_type) — int — Foreign key → unlock_moments_content_type.id — NOT NULL
  • content_id — int — Foreign key → unlock_moments_content_list.id — NOT NULL

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
  • 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
  • moment_id — int — Foreign key → unlock_moments.id — NOT NULL
  • rarity_id — int — Foreign key → unlock_moments_rarity.id — NOT NULL

unlock_moments_matchs

  • id — int — Primary key — NOT NULL
  • 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
  • team_id_left — int — Foreign key → unlock_moments_teams.id — NOT NULL
  • team_id_right — int — Foreign key → unlock_moments_teams.id — NOT NULL

unlock_moments_player

  • id — int — Primary key — NOT NULL
  • player_score — json
  • player_score_tmp — json
  • match_id — int
  • is_moment — int
  • created_at — datetime
  • updated_at — datetime
  • unique_player_id — int — Foreign key → unlock_moments_unique_player.id — NOT NULL

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
  • 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
  • category_id — int — Foreign key → unlock_news_category.category_id — NOT NULL — 카테고리ID

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_nfc

  • id — int — Primary key — 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
  • user_id — int — Foreign key → unlock_users.id — NOT NULL

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
  • 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)
  • content_id — int — Foreign key → unlock_moments_content_list.id — NOT NULL

unlock_product_img

  • id — int — Primary key — NOT NULL
  • 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
  • product_id — bigint — Foreign key → unlock_product.id — NOT NULL

unlock_push_log

  • id — int — Primary key — NOT NULL
  • 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
  • user_id — int — Foreign key → unlock_users.id — NOT NULL

unlock_qr

  • id — int — Primary key — 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
  • user_id — int — Foreign key → unlock_users.id — NOT NULL

unlock_qr_mint

  • id — int — Primary key — NOT NULL
  • qr_key — varchar(200)
  • auth_group — varchar(45)
  • created_at — datetime
  • updated_at — datetime
  • moment_id — int — Foreign key → unlock_moments.id — NOT NULL

unlock_qr_mint_log

  • id — int — Primary key — NOT NULL
  • auth_type — varchar(45)
  • auth_id — varchar(45)
  • auth_qr — varchar(500)
  • created_at — datetime
  • updated_at — datetime
  • user_id — int — Foreign key → unlock_users.id — NOT NULL
  • moment_id — int — Foreign key → unlock_moments.id — NOT NULL

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
  • event_type — varchar(100)
  • auth_type — varchar(100)
  • auth_id — int
  • auth_detail — varchar(45)
  • method — varchar(45)
  • method_value — int
  • verifier_type — varchar(45)
  • is_valid_auth — tinyint
  • created_at — datetime
  • updated_at — datetime
  • verifier_id — int — Foreign key → unlock_auth_users.id — NOT NULL
  • event_id — int — Foreign key → unlock_auth_event.id — NOT NULL
  • user_id — int — Foreign key → unlock_users.id — NOT NULL
  • group_name — varchar(45) — Foreign key → unlock_auth_event.group_name

unlock_user_fcm_token

  • id — int — Primary key — NOT NULL
  • device_id — varchar(1000) — 기기 고유 아이디
  • device_os — varchar(100)
  • fcm_token — varchar(1000)
  • created_at — datetime
  • updated_at — datetime
  • user_id — int — Foreign key → unlock_users.id — NOT NULL

unlock_user_group

  • id — int — Primary key — NOT NULL
  • group_type — varchar(45)
  • created_at — datetime
  • updated_at — datetime
  • mobiel (mobile) — varchar(15)

unlock_user_membership

  • id — int — Primary key — 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
  • membership_id — int — Foreign key → unlock_membership.id — NOT NULL
  • user_id — int — Foreign key → unlock_users.id — NOT NULL

unlock_user_moments

  • id — int — Primary key — NOT NULL
  • product_parent_id — int
  • token_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
  • moment_id — int — Foreign key → unlock_moments.id — NOT NULL
  • product_id — bigint — Foreign key → unlock_product.id — NOT NULL
  • rarity_id — int — Foreign key → unlock_moments_rarity.id — NOT NULL
  • user_id — int — Foreign key → unlock_users.id — NOT NULL

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)
  • 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
  • match_id — int — Foreign key → unlock_moments_matchs.id — NOT NULL

unlock_vote_log

  • id — int — Primary key — NOT NULL
  • auth_type — varchar(45)
  • auth_value — varchar(45)
  • created_at — datetime
  • updated_at — datetime
  • vote_id — int — Foreign key → unlock_vote.id — NOT NULL
  • player_id — int — Foreign key → unlock_vote_player.id — NOT NULL
  • user_id — int — Foreign key → unlock_users.id — NOT NULL

unlock_vote_player

  • id — int — Primary key — NOT NULL
  • player_img_id — bigint
  • player_img — varchar(1000)
  • vote_num — int
  • created_at — datetime
  • updated_at — datetime
  • vote_id — int — Foreign key → unlock_vote.id — NOT NULL
  • player_id — int — Foreign key → unlock_moments_unique_player.id — NOT NULL