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