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