ver B thek-king

db for app thek-king

Tables (50)

Artist (artist)

  • id — int — Primary key — NOT NULL
  • type — int — Foreign key → Term.id — NOT NULL — type of artist, link to term
  • code_artist — varchar(20) — NOT NULL — code of artist, ex) KVI
  • is_group — smallint — is group (0 - not group, 1 - group)
  • img_artist — json — links on the s3 platform to the artist's image
  • name_artist — json — artist name with multi-language support
  • work_artist — json — artist work with multi-language support
  • about_artist — json — info about artist with multi-language support
  • fanclub — json — fanclub with multi-language support
  • birth — datetime
  • debut — datetime
  • social_link — json — link to social {"instagram":"", "twitter":"","web":""}
  • status — smallint — record status (-1 - deleted, 1-active)
  • created_at — datetime
  • updated_at — datetime

Artist Like (artist_like)

  • artist_id — int — Foreign key → Artist.id — NOT NULL — link to artist
  • user_id — int — Foreign key → User.id — NOT NULL — link to user
  • uid — varchar(100)
  • created_at — int

Artist Reply (artist_reply)

  • id — int — Primary key — NOT NULL
  • artist_id — int — Foreign key → Artist.id — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • parent_id — int — link to parent reply
  • mess — varchar(300)
  • status — smallint — status of messege (-1-removed, 1-active)
  • created_at — datetime
  • updated_at — datetime

Artist Reply Report (artist_reply_report)

  • id — int — Primary key — NOT NULL
  • reply_id — int — Foreign key → Artist Reply.id — NOT NULL
  • artist_id — int — Foreign key → Artist Reply.artist_id — NOT NULL
  • from_user_id — int — Foreign key → User.id — NOT NULL — from user, link to user
  • status — smallint — status record (0-not processed, 1-processed)
  • created_at — datetime
  • updated_at — datetime

Artist Vote (artist_vote)

  • id — int — Primary key — NOT NULL
  • artist_id — int — Foreign key → Artist.id — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • type_point — float
  • amount_point — float
  • created_at — datetime

Artist_x_Group (artist_x_group)

  • artist_id — int — Foreign key → Artist.id — NOT NULL — link to artist, table artist
  • group_id — int — Foreign key → Artist.id — NOT NULL — link to group, table artist
  • created_at — datetime — NOT NULL

Cash (cash)

  • cash_id — int — Primary key — NOT NULL
  • type_platform — int
  • sign — varchar(50)
  • cost — float
  • template_point — varchar(100)
  • heart_1_point — float
  • heart_2_point — float
  • star_point — float
  • gold_point — float
  • created_at — datetime
  • status — int
  • updated_at — datetime

Dic (dic)

  • id — int — Primary key — NOT NULL
  • name — varchar(100) — name of the directory
  • slug — varchar(100) — short name in english, ex) artist_type

Fan DIY Contents (fan_diy_content)

  • content_id — int — Primary key — NOT NULL
  • type — int — Foreign key → Term.id — NOT NULL
  • priority — int
  • cost_content — float
  • body_content — varchar(500)
  • period_use_day — int
  • status — enum
  • created_at — datetime
  • updated_at (updatetd_at) — datetime
  • img???? (Field)

Fan DIY contents image (fan_diy_contents_img)

  • img_id — int — Primary key — NOT NULL
  • content_id — int — Foreign key → Fan DIY Contents.content_id — NOT NULL
  • img_title — varchar(100)
  • img_path — varchar(100)
  • created_at — datetime
  • updated_at — datetime

Fan Play (fan_play)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL — link on user
  • artist_id — int — Foreign key → Artist.id — NOT NULL — if there is a link to the artist, then a link to the artist table
  • type — int — Foreign key → Term.id — NOT NULL — record type fan-feed, sign, etc
  • img_play — json — links to images for different languages
  • title_play_lng — json — title if the entry is created from the thek, title if the entry is created from the k, with support for multiple langua…
  • body_play_lng — json — body if the entry is created from the k, with support for multiple languages
  • title_play — varchar(200) — ???title if the record was created by the user
  • body_play — varchar(200) — ???body if the record was created by the user
  • link_play — varchar(200) — link to an external resource
  • guide_play — json — instruction if the entry is from the
  • status — int — recording status, -1 - deleted, 0 - under moderation, 1 - active, 2 - blocked
  • started_at — datetime — start time of the start of the post display
  • ended_at — datetime — end time of the start of the post display
  • created_at — datetime — date of created record
  • updated_at — datetime — date of upatedt record

Fan Play Like (fan_play_like)

  • id — int — Primary key — NOT NULL
  • play_id — int — Foreign key → Fan Play.id — NOT NULL — link to the post if like goes to the post
  • user_id — int — Foreign key → User.id — NOT NULL — link to user
  • reply_id — int — Foreign key → Fan Play Reply.id — NOT NULL — link to the fan reply table if the like is put to the comment
  • created_id — datetime — date of created record

Fan Play Reply (fan_play_reply)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL — link to user, user who left a comment
  • play_id — int — Foreign key → Fan Play.id — NOT NULL — link to the feed to which the comment was left
  • parent_id — int — link to another comment if the comments are under each other
  • mess — varchar(300)
  • status — smallint — record status, -1-removed, 1-active
  • created_at — datetime
  • updated_at — datetime

Fan Play Report (fan_play_report)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL — link to the user who left a comment
  • play_id — int — Foreign key → Fan Play.id — NOT NULL — which feed was the complaint filed against
  • reply_id — int — Foreign key → Fan Play Reply.id — NOT NULL — what reply was the complaint filed about
  • status — smallint — status of complaint processing (0-not processed, 1-processed )
  • created_at (areated_at) — datetime
  • updated_at — datettime

Fan Play Share (fan_play_share)

  • id — int — Primary key — NOT NULL
  • play_id — int — Foreign key → Fan Play.id — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • created_at — datetime

Fan Support (fan_support)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • artist_id — int — Foreign key → Artist.id — NOT NULL
  • type — int — Foreign key → Term.id — NOT NULL
  • group_id — int — Foreign key → Fan Support Product Group.group_id — NOT NULL
  • product_id — int — Foreign key → Fan Support Product.product_id — NOT NULL
  • subject — varchar(300)
  • status — enum
  • created_at — datetime
  • desired_at — datetime
  • ended_at — datetime

Fan Support Donate (fan_support_donate)

  • donate_id — int — Primary key — NOT NULL
  • service_id — int — Foreign key → Service.service_id — NOT NULL
  • type — int — Foreign key → Term.id — NOT NULL
  • donate_title — json
  • created_at — datetime

Fan Support Product (fan_support_product)

  • product_id — int — Primary key — NOT NULL
  • type — int — Foreign key → Term.id — NOT NULL
  • name_product — json
  • about_product — json
  • guide_product — json
  • target_point — float
  • img_product — varchar(200)
  • status — int
  • created_at — datetime
  • updated_at — datetime

Fan Support Product Group (fan_support_product_group)

  • group_id — int — Primary key — NOT NULL
  • type — int — Foreign key → Term.id — NOT NULL
  • code_group — varchar(20)
  • place_id — smallint
  • status — enum
  • created_at — datettime
  • updatetd_at (updated_at) — datettime

Fan Support Vote (fan_support_vote)

  • vote_id — int — Primary key — NOT NULL
  • support_id — int — Foreign key → Fan Support.id — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • group_id — int — Foreign key → Fan Support.group_id — NOT NULL
  • product_id — int — Foreign key → Fan Support.product_id — NOT NULL
  • point — int
  • created_at — datetime

Faq (faq)

  • id — int — Primary key — NOT NULL
  • quest — json — issue with multilingual version support
  • answer — json — response with multilingual version support
  • created_at — datetime
  • updated_at — datetime

Hashtag (hashtag)

  • id — int — Primary key — NOT NULL
  • play_id — int — Foreign key → Fan Play.id — NOT NULL
  • tag — string
  • created_at — datetime
  • Field

Manager (manager)

  • id — int — Primary key — NOT NULL
  • login — varchar(50)
  • email — varchar(100)
  • pass — varchar(40)
  • first_name — varchar(100)
  • last_name — varchar(100)
  • role — smallint — role manager (1-admin, 2-manager, 3-operator)
  • status — smallint — account status (-1 - deleted, 1 - active)
  • created_at — datetime
  • updated_at — datetime

Manager Action Log (manager_action_log)

  • id — bigint — Primary key — NOT NULL
  • manager_id — int — Foreign key → Manager.id — NOT NULL
  • term_id (action_id) — int — Foreign key → Term.id — NOT NULL
  • ip — varchar(20)
  • schema — varchar(50)
  • code — varchar(15)
  • data — text
  • description — varchar(500)
  • dt — datetime

Mission (mission)

  • id — int — Primary key — NOT NULL
  • type — int — Foreign key → Term.id — NOT NULL — type of mission (link to term)
  • sign — varchar(100) — short name on English
  • version — int
  • rule_quest — json — quest rules with international format support
  • type_point — int — type of point
  • award_point — float — reward for completed mission
  • status — smallint — recording status (-1-removed, 0 - not active, 1-active)
  • started_at — datetime — started of mission
  • ended_at — datetime — ended of mission
  • created_at — datetime
  • updated_at — datetime

Mission item (mission_item)

  • id — int — Primary key — NOT NULL
  • mission_id — int — Foreign key → Mission.id — NOT NULL
  • term_id — int — Foreign key → Term.id — NOT NULL
  • quantity — smallint
  • is_active — smallint — is active (-1 - removed, 0-not active, 1-active)
  • type_point — int — type of point ?????
  • award_point — int
  • created_at — datetime
  • updated_at — datetime

Notice (notice)

  • id — int — Primary key — NOT NULL
  • type — smallint
  • title_notice — json
  • body_notice — json
  • started_at — datetime
  • img_notice (img_totice) — json
  • status — smallint
  • created_at — datetime
  • updated_at — datetime

Notice banner (notice_link)

  • id — int — Primary key — NOT NULL
  • type_banner — smallint — 1-banner, 2-popup
  • place_banner — int
  • type — smallint
  • priority — smallint
  • platform — smallint
  • title_banner — json
  • img_banner — json
  • link — varchar(100)
  • status — smallint — status(-1-removed, 0-not active, 1-active)
  • started_at — datetime
  • ended_at — datetime
  • created_at — datetime
  • updated_at — datetime

Point operation (point_operation)

  • id — int — Primary key — NOT NULL
  • manager_id — int — Foreign key → Manager.id — NOT NULL
  • action_id — int — Foreign key → Term.id — NOT NULL
  • code — varchar(100)
  • count — int
  • count_success — int
  • description — varchar(100)
  • created_at — datetime

Product x Group (fan support_product_x_group)

  • group_id — int — Foreign key → Fan Support Product Group.group_id — NOT NULL
  • product_id — int — Foreign key → Fan Support Product.product_id — NOT NULL
  • created_at — datetime
  • priority — int

Purchase Cash (purchase_cash)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • uid — varchar(50)
  • cash_id — int
  • paysys — smallint
  • pay_token — varchar(50)
  • info_payment — mediumtext
  • status — smallint
  • created_at — datetime
  • updated_at — datetime
  • payed_at — datetime

Rank Artist (ranking_artist)

  • rank_id — int — Foreign key → Ranking.rank_id — NOT NULL
  • artist_id — int — Foreign key → Artist.id — NOT NULL
  • status — int
  • created_at — datetime

Rank Reply (ranking_reply)

  • id — int — Primary key — NOT NULL
  • rank_id — int — Foreign key → Ranking.rank_id — NOT NULL — link to rank
  • user_id — int — Foreign key → User.id — NOT NULL — link to the user who left a comment
  • parent_id (parent_reply_id) — int — link to another comment if the comments are under each other
  • artist_id — int — link to artist
  • mess — varchar(300)
  • status — smallint — record status, -1-removed, 1-active
  • created_at — int
  • updated_at — int

Rank Reply Report (ranking_reply_report)

  • id — int — Primary key — NOT NULL
  • reply_id — int — Foreign key → Rank Reply.id — NOT NULL — link to reply
  • rank_id — int — Foreign key → Rank Reply.rank_id — NOT NULL — link to rank
  • from_user_id — int — Foreign key → User.id — NOT NULL — user who left a complaint, link to user
  • status — int — application status (0-not process, 1, process)
  • created_at — datetime
  • updated_at — datetime

Rank Vote (ranking_vote)

  • id — int — Primary key — NOT NULL
  • rank_id — int — Foreign key → Ranking.rank_id — NOT NULL — link to rank
  • user_id — int — Foreign key → User.id — NOT NULL — link to user vote
  • artist_id — int — link to artist
  • type_point??? (type_point) — int — type of point
  • amount_point — float — number of points how much the user gave for voting
  • created_at — datetime

Ranking (ranking)

  • rank_id — int — Primary key — NOT NULL
  • type — int — Foreign key → Term.id — NOT NULL — voting type, const or link to term
  • priority — int — priority vote (1..9)
  • name_vote — json
  • img_banner — json — img for other language
  • tip — json — tips for voting in an international format
  • status — smallint — voting status(-1-removed, 0-not active, 1-active)
  • event_uid — json — uid???
  • started_at — datetime — started vote
  • ended_at — datetime — ended vote
  • resulted_at (result_at) — datetime — resulted vote
  • created_at — datetime
  • updated_at — datetime

Reward Ad (reward_ad)

  • id — int — NOT NULL
  • priority — smallint
  • ad_title — json
  • ad_link — json — array of links
  • ad_img — varchar(200)
  • status — smallint — status record (-1-removed, 0-not active, 1-active)
  • started_at — datetime — date started ad
  • ended_at — datetime — date end ad
  • created_at — datetime
  • updated_at — datetime

Service (service)

  • service_id — int — Primary key — NOT NULL
  • sign — varchar(100)
  • version — int
  • setting — json
  • created_at — int
  • updated_at — datettime

Service Level ??? (Service Level)

  • level_id — int — Primary key — NOT NULL
  • img_level — varchar(100)
  • tittle_level (title_level) — varchar(100)
  • min_exp — int
  • max_exp — int
  • heart1_point — int
  • heart2_point — int
  • star_point — int
  • gold_point — int
  • recomendation — json
  • description — json
  • updated_at — datetime

Sign (sign)

  • id (Key) — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • message — varshar
  • status — int
  • started_at — datetime
  • ended_at — datetime
  • created_at — datetime
  • updated_at — datetime

Sign Reply (sign_reply)

  • id — int — Primary key — NOT NULL
  • sign_id — int — Foreign key → Sign.id — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL — link to user, user who left a comment
  • parent_id — int — link to another comment if the comments are under each other
  • mess — varchar(300)
  • status — smallint — record status, -1-removed, 1-active
  • created_at — datetime
  • updated_at — datetime

Sign Report (sign_report)

  • id — int — Primary key — NOT NULL
  • reply_id — int — Foreign key → Sign Reply.id — NOT NULL
  • sign_id — int — Foreign key → Sign Reply.sign_id — NOT NULL
  • user_id — int — Foreign key → Sign Reply.user_id — NOT NULL — link to user, user who left a comment
  • status — smallint — status of complaint processing (0-not processed, 1-processed )
  • created_at (areated_at) — datetime
  • updated_at — datettime

Term (term)

  • id — int — Primary key — NOT NULL
  • dic_id — int — Foreign key → Dic.id — NOT NULL — link to the dictionary, table dic
  • term — varchar(300) — name of the term
  • slug — varchar(100) — name of the term in abbreviated form
  • title — json — the name to display on the user's phone, with support for different languages
  • valstr — varchar(400) — string type value
  • valint — int — int type value
  • valjs — json — json type value
  • status — int — recording status, -1 - removed, 1-active
  • created_at — datetime
  • updated_at — datettime

User (user)

  • id — int — Primary key — NOT NULL
  • avatar — varchar(50) — link to the user''s avatar image in s3
  • oauth — varchar(30) — if user register from social network (kakao, facebook, google, apple id)
  • email — varchar(50) — NOT NULL
  • cid — string(100)
  • nickname — varchar(50) — NOT NULL — user nickname
  • password — varchar(50) — NOT NULL — user password
  • gender — smallint — NOT NULL — (0-female, 1-male, 2-unspecified)
  • birth — varchar(10) — approximate age (10,20,30,40,50,60+)
  • referral — varchar(100) — referral link for share in social network
  • ad_token — json — NOT NULL — a token that is used in advertising networks when viewing free ads
  • token — varchar(100) — token applications for sending push notifications
  • push — smallint — NOT NULL — should I send push notifications to the user (0-don't send, 1-send)
  • language — varchar(10) — NOT NULL — user's language (ko, en, jp, ch, es)
  • device — json — device information, ex) {'model':'Xiomi 9', 'platform':'Android', 'ver_app'}
  • tz — varchar(30) — NOT NULL — user's time zone, ex) Asia/Seoul
  • status — int — NOT NULL — user's status (-1-removing, 0 - register without confirm, 1-register with confirm, 2-block)
  • exp — int
  • level — int
  • heart_1 — int
  • heart_2 — int
  • start_point (star_point) — int
  • gold_point — int
  • cash_point — int
  • fanpiсk_point (fanpick_point) — datetime
  • last_seen — datetime
  • created_at — datetime — NOT NULL — date and time the record was created
  • updated_at — datetime — NOT NULL

User Action Log (user_action_log)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • action_id — int — Foreign key → Term.id — NOT NULL — link to the description of the action from the term table
  • manager_id — int — Foreign key → Manager.id — NOT NULL
  • description — varchar(100) — description, ex), which manager did the action
  • created_at — datetime

User Ad Log (user_ad_log)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • type — int — ???token that was used
  • type_point — int — type of points provided to the user
  • award_point — int — count of points provided to the user
  • created_at — datetime

User DIY Contents (user_diy_content)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • content_id — int — Foreign key → Fan DIY Contents.content_id — NOT NULL — link to the content record from the fan_diy_content table
  • status — smallint — state of the record, ex), if the user deleted the content, -1-removed, 1-active
  • created_at (creted_at) — datetime
  • updated_at — datetime

User Mission Log (user_mission_log)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • item_id — id — Foreign key → Mission item.id — NOT NULL — link to the sub mission from the list of missions, for example, daily entry, table mission_item
  • mission_id — int — Foreign key → Mission item.mission_id — NOT NULL — link to the type of missions (daily, monthly, etc.) mission table
  • created_at — datetime

User Point Log (user_point_log)

  • id — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • action_id — int — Foreign key → Term.id — NOT NULL
  • type — smallint
  • count — float
  • description — varchar(300)
  • created_at — datetime

User Subscriber (user_subscriber)

  • user_id — int — Foreign key → User.id — NOT NULL
  • subscribed_id — int — Foreign key → User.id — NOT NULL — link on user subscribe
  • uid — varchar(100) — need for push, if, for example, new information has appeared in the form of a user
  • created_at — datetime