UNLOCK - Moments
Tables (18)
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_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_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_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_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