thek-king
db for app thek-king
Tables (40)
Artist (artist)
- artist_id — int — Primary key — NOT NULL
- type — int — Foreign key → Term.term_id — NOT NULL
- code_artist — varchar(20) — NOT NULL
- is_group — enum
- name_artist — json
- work_artist — json
- about_artist — json
- fanclub — json
- birth — datetime
- debut — datetime
- social_link — json
- img_artist — json
- status — smallint
- created_at — datetime
- updated_at — datetime
Artist Like (artist_like)
- artist_id — int — Foreign key → Artist.artist_id — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- created_at — int
Artist Reply (artist_reply)
- reply_id — int — Primary key — NOT NULL
- artist_id — int — Foreign key → Artist.artist_id — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- parent_reply_id — int
- mess — varchar(300)
- status — enum
- created_at — datetime
- updated_at — datetime
Artist Reply Report
- reply_id — int — Foreign key → Artist Reply.reply_id — NOT NULL
- artist_id — int — Foreign key → Artist Reply.artist_id — NOT NULL
- user_id — int — Foreign key → Artist Reply.user_id — NOT NULL
- from_user_id — int — Foreign key → User.id — NOT NULL
- status — int
- created_at — int
Artist Vote (artist_vote)
- vote_id — int — Primary key — NOT NULL
- artist_id — int — Foreign key → Artist.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.artist_id — NOT NULL
- group_id — int — Foreign key → Artist.artist_id — NOT NULL
- created_at — datetime — NOT NULL
Dic (dic)
- dic_id — int — Primary key — NOT NULL
- name — varchar(100)
- slug — varchar(100)
Fan DIY Contents (fan_diy_content)
- content_id (id) — int — Primary key — NOT NULL
- type — int — Foreign key → Term.term_id — NOT NULL — sticker type, (1-stickers, 2- frames)
- priority — int — content priority
- cost_content — float — cost of content
- body_content — varchar(500) — body of content
- period_use_day — int — maximum number of days of use
- status — smallint
- created_at — datetime
- updated_at (updatetd_at) — datetime
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 Feed (fan_feed)
- feed_id — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- artist_id — int — Foreign key → Artist.artist_id — NOT NULL
- img_feed — json
- title_feed — varchar(200)
- body_feed — middletext
- link_feed — varchar(200)
- status — int
- created_at — datetime
- updated_at — datetime
Fan Feed Like (fan_feed_like)
- feed_id — int — Foreign key → Fan Feed.feed_id — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- created_id — datetime
Fan Feed Reply (fan_feed_reply)
- reply_id — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- feed_id — int — Foreign key → Fan Feed.feed_id — NOT NULL
- parent_reply_id — int
- mess — varchar(300)
- status — enum
- created_at — int
- updated_at — int
Fan Feed Share (fan_feed_share)
- feed_id — int — Foreign key → Fan Feed.feed_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 — link to the user who posted the donation information
- artist_id — int — Foreign key → Artist.artist_id — NOT NULL — link to artist
- type — int — Foreign key → Term.term_id — NOT NULL — type event 1- advertisement, 2- donation
- group_id — int — Foreign key → Fan Support Product Group.id — NOT NULL
- product_id — int — Foreign key → Fan Support Product.id — NOT NULL
- current_point — float — link to product, table fan_support_product
- status — smallint — status of the event, (1-progress,2-completed)
- created_at — datetime — status of the event, (1-progress,2-completed)
- desired_at — datetime — day of hope
- ended_at — datetime — completion date
Fan Support Product (fan_support_product)
- id — int — Primary key — NOT NULL
- type — int — Foreign key → Term.term_id — NOT NULL — product type 1- advertisement, 2- donation
- name_product — json — product name for multiple languages
- about_product — json — product information
- guide_product — json — description of the manual
- target_point — float — target pont
- img_product — varchar(200) — link to url image in s3
- status (stattus) — smallint — product status (-1-removed, 0 - not ctive, 1 active)
- created_at — datetime
- updated_at — datetime
Fan Support Product Group (fan_support_product_group)
- id — int — Primary key — NOT NULL
- type — int — Foreign key → Term.term_id — NOT NULL — type group, 1- advertisement, 2- donation
- donate_id — int — Foreign key → Setting Fan Support Donate.id — NOT NULL — link to setting donate, table fan_support_donate
- code_group — varchar(20) — code group
- place_ad — int — place of advertising (metro, outdoor advertising) link to term??? or const
- status — smallint — group status (-1-removed, 0-not active, 1-active)
- created_at — datettime
- updatetd_at (updated_at) — datettime
Fan Support Vote (fan_support_vote)
- id — int — Primary key — NOT NULL
- support_id — int — Foreign key → Fan Support.id — NOT NULL — link to support, table fan_support
- user_id — int — Foreign key → User.id — NOT NULL — user who gave the points supported the artist
- id (id2) — int — Foreign key → Fan Support.group_id — NOT NULL
- id (id22) — int — Foreign key → Fan Support.product_id — NOT NULL
- amount_point (point) — float — points given by the user
- created_at — datetime
Fan Talk (fan_talk)
- talk_id — int — Primary key — NOT NULL
- type — int — Foreign key → Term.term_id — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- title_talk — json
- guide_talk (guiede_talk) — json
- banner_talk — json
- started_at — datetime
- ended_at — datetime
- created_at — datetime
- updated_at — datetime
Fan Talk Like & Liki Reply (fan_talk_like)
- reply_id — int — Foreign key → Fan Talk Reply.reply_id — NOT NULL
- talk_id — int — Foreign key → Fan Talk Reply.talk_id — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- created_at — datetime
Fan Talk Reply (fan_talk_reply)
- reply_id — int — Primary key — NOT NULL
- talk_id — int — Foreign key → Fan Talk.talk_id — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- user_id (user_id2) — int — Foreign key → Fan Talk.user_id — NOT NULL
- parent_reply_id — int
- mess — varchar(300)
- status — smallint
- created_at — datetime
Fan Talk Report (fan_talk_report)
- report_id — int — Primary key — NOT NULL
- reply_id — int — Foreign key → Fan Talk Like & Liki Reply.reply_id — NOT NULL
- talk_id — int — Foreign key → Fan Talk.talk_id — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- status — smallint
- created_at (areated_at) — datetime
- updated_at — datettime
Faq (faq)
- id — int — Primary key — NOT NULL
- quest — json
- answer — json
- created_at — datetime
- updated_at — datetime
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
- status — smallint
- 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.term_id — NOT NULL
- ip — varchar(20)
- schema — varchar(50)
- code — varchar(15)
- data — text
- description — varchar(500)
- dt — datetime
Member Pay Log (member_pay_log)
- id — int — Primary key — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- Field
Pay Order (pay_order)
- order_id — int — Primary key — NOT NULL
- paysys — int — Foreign key → Term.term_id — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- type_product — int
- items — json
- descr — varchar(300)
- cost — float
- status — smallint
- created_at — datetime
- pay_at — datetime
Payment (payment)
- pay_id — int — Primary key — NOT NULL
- order_id — int — Foreign key → Pay Order.order_id — NOT NULL
- paysys — int — Foreign key → Pay Order.paysys — NOT NULL
- txn — varchar(100)
- amount — float
- status — smallint
- info — json
- pay_at — datetime
Product x Group (fan support_product_x_group)
- group_id — int — Foreign key → Fan Support Product Group.id — NOT NULL
- product_id — int — Foreign key → Fan Support Product.id — NOT NULL
- donate_id — int — Foreign key → Fan Support Product Group.donate_id — NOT NULL
- created_at — datetime
Rank Artist (rank_artist)
- rank_id — int — Foreign key → Ranking.rank_id — NOT NULL
- artist_id — int — Foreign key → Artist.artist_id — NOT NULL
- created_at — datetime
Rank Reply (rank_reply)
- reply_id — int — Primary key — NOT NULL
- rank_id — int — Foreign key → Ranking.rank_id — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- parent_reply_id — int
- artist_id — int
- mess — varchar(300)
- status — enum
- created_at — int
- updated_at — int
Rank Reply Report (rank_reply_report)
- reply_id — int — Foreign key → Rank Reply.reply_id — NOT NULL
- rank_id — int — Foreign key → Rank Reply.rank_id — NOT NULL
- user_id — int — Foreign key → Rank Reply.user_id — NOT NULL
- from_user_id — int — Foreign key → User.id — NOT NULL
- status — int
- created_at — datetime
Rank Vote (rank_vote)
- vote_id — int — Primary key — NOT NULL
- rank_id — int — Foreign key → Ranking.rank_id — NOT NULL
- user_id — int — Foreign key → User.id — NOT NULL
- artist_id — int
- type_point??? (type_point) — int
- amount_point — float
- created_at — datetime
Ranking (rank)
- rank_id — int — Primary key — NOT NULL
- type — int — Foreign key → Term.term_id — NOT NULL
- priority — int
- name_vote — json
- img_banner — json
- tip — json
- status — smallint
- event_uid — json
- started_at — datetime
- ended_at — datetime
- resulted_at (result_at) — datetime
- created_at — datetime
- updated_at — datetime
Reward Ad (reward_ad)
- id — int — Primary key — NOT NULL
- priority — smallint
- ad_title — json
- ad_link — json
- ad_img — varchar(200)
- status — smallint
- started_at — datetime
- ended_at — datetime
- created_at — datetime
- updated_at — datetime
Setting Fan Support Donate (fan_support_donate)
- id — int — Primary key — NOT NULL
- type — int — Foreign key → Term.term_id — NOT NULL
- version — varchar(30)
- duration_day — int
- start_point — int
- policy — varchar(500)
- created_at — datetime
- updated_at — datetime
Term (term)
- term_id — int — Primary key — NOT NULL
- dic_id — int — Foreign key → Dic.dic_id — NOT NULL
- term — varchar(300)
- slug — varchar(100)
- title — json
- valstr — varchar(400)
- valint — int
- valjs — json
- status — int
- created_at — datetime
- updated_at — datettime
User (user)
- id (user_id) — int — Primary key — NOT NULL
- avatar — varchar(50) — link for user avatar
- oauth — varchar(30) — if user register from social network (link, facebook, google plus, apple id)
- email — varchar(50) — NOT NULL
- nickname — varchar(50) — NOT NULL — user nickname
- password — varchar(50) — NOT NULL — user password
- gender — enum — NOT NULL
- birth — date — date of birthday
- 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)
- push — enum — NOT NULL
- language — varchar(10) — NOT NULL
- device — json
- tz — varchar(30) — NOT NULL
- status — int — NOT NULL — user status (-1-removing, 0 - blocking, 1-normal)
- exp — int
- level — smallint
- 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.term_id — NOT NULL
- description — varchar(100)
- 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.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
- subscriber_id — int — Foreign key → User.id — NOT NULL
- uid — varchar(50)
- created_at — datetime