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