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