SSS

Tables (81)

admin_logs

  • id — int(11) — Primary key — NOT NULL
  • admin_id — int(11) — NOT NULL
  • path — varchar(30) — NOT NULL
  • body — varchar(150)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

admin_refresh_tokens

  • id — int(11) — Primary key — NOT NULL
  • admin_id — int(11) — NOT NULL
  • token — varchar(300) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

adminfcm

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • user_id — int(11) — NOT NULL
  • token — varchar(255)

admins

  • id — int(11) — Primary key — NOT NULL
  • uid — char(36) — NOT NULL
  • activated — tinyint(1) — NOT NULL
  • account — varchar(20) — NOT NULL
  • name — varchar(20) — NOT NULL
  • level — smallint(6) — NOT NULL
  • sub_level — smallint(6) — NOT NULL
  • password — varchar(250) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

adminsview

  • id — INT(11) — NOT NULL
  • uid — CHAR(36) — NOT NULL
  • activated — TINYINT(1) — NOT NULL
  • account — VARCHAR(20) — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • level — SMALLINT(6) — NOT NULL
  • sub_level — SMALLINT(6) — NOT NULL
  • password — VARCHAR(250) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

alarm_community

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • userId — int(11)
  • isAllowLikes — tinyint(1)
  • likesForm — enum('everyone','people_or_follow','COMMUNITY_GROUP_MEMBER')
  • isAllowComments — tinyint(1)
  • commentsForm — enum('everyone','people_or_follow','COMMUNITY_GROUP_MEMBER')
  • isAllowCommentLikes — tinyint(1)
  • commentLikesForm — enum('everyone','people_or_follow','COMMUNITY_GROUP_MEMBER')
  • isAllowFollow — tinyint(1)
  • followForm — enum('everyone','people_or_follow','COMMUNITY_GROUP_MEMBER')
  • isAllowMention — tinyint(1)
  • mentionForm — enum('everyone','people_or_follow','COMMUNITY_GROUP_MEMBER')
  • isAllowBen — tinyint(1)
  • benForm — enum('everyone','people_or_follow','COMMUNITY_GROUP_MEMBER')
  • isAllowRetweet — tinyint(1)
  • retweetForm — enum('everyone','people_or_follow','COMMUNITY_GROUP_MEMBER')
  • isAllowInviteAccept — tinyint(1)
  • inviteAcceptForm — enum('everyone','people_or_follow','COMMUNITY_GROUP_MEMBER')
  • isAllowDM — tinyint(1)
  • DMForm — enum('everyone','people_or_follow','COMMUNITY_GROUP_MEMBER')

alarms

  • id — int(11) — Primary key — NOT NULL
  • user_uid — varchar(36) — NOT NULL
  • target_uid — varchar(36) — NOT NULL
  • type — smallint(6) — NOT NULL
  • extra — varchar(200)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

bad_words

  • id — int(11) — Primary key — NOT NULL
  • activated — tinyint(1) — NOT NULL
  • word — varchar(50) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

battle_logs

  • id — int(11) — Primary key — NOT NULL
  • battle_uid — varchar(36) — NOT NULL
  • battle_user_id — int(11) — NOT NULL
  • score — int(11) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

battle_users

  • id — int(11) — Primary key — NOT NULL
  • battle_uid — varchar(36) — NOT NULL
  • user_uid — varchar(36) — NOT NULL
  • name — varchar(20)
  • best_score — int(11) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

battles

  • id — int(11) — Primary key — NOT NULL
  • uid — varchar(36) — NOT NULL
  • user_uid — varchar(36) — NOT NULL
  • game_id — int(11) — NOT NULL
  • title — varchar(50)
  • activated — tinyint(1) — NOT NULL
  • user_count — mediumint(9) — NOT NULL
  • end_at — datetime
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

block

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • community_id — varchar(255)
  • user_id — int(11)
  • target_id — int(11)
  • blocked_at — bigint(20)
  • expires_on — bigint(20)
  • reason — varchar(255)
  • type — enum('USERBLOCK','COMMUNITYBLOCK','MUTE','KICK')

channel_post

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • community_id — varchar(255)
  • channel_id — varchar(255)
  • post_id — varchar(255)
  • type — enum('USER','COMMUNITY')
  • visibility — enum('FOLLOWER','PUBLIC','PRIVATE')
  • is_pinned — tinyint(1)

choice

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • poll_id — char(36)
  • title — varchar(255)
  • voted_cnt — int(11)

choicelog

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • user_id — int(11)
  • choice_id — varchar(255)

comment

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • user_id — int(11) — NOT NULL
  • user_uid — varchar(255) — NOT NULL
  • parent_id — varchar(255)
  • post_id — varchar(255) — NOT NULL
  • type — enum('COMMENT','REPLY')
  • content — varchar(500)
  • is_private — tinyint(1)
  • is_pinned — tinyint(1)
  • attatchment_files — longtext
  • like_cnt — int(11)
  • dislike_cnt — int(11)

community

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • owner_id — int(11) — NOT NULL
  • manager_id — int(11)
  • submanager_id — int(11)
  • name — varchar(50) — NOT NULL
  • url — varchar(50)
  • description — varchar(2000) — NOT NULL
  • profile_img — varchar(255)
  • banner_img — varchar(255)
  • member_cnt — int(11)
  • posts_cnt — int(11)
  • visit_cnt — int(11)
  • state — enum('PRIVATE','PUBLIC')
  • is_certificated — tinyint(1)

community_block

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • communityId — varchar(255) — NOT NULL
  • userId — varchar(255) — NOT NULL
  • active — tinyint(1)

community_channel

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • user_id — int(11)
  • community_id — char(36) — Foreign key → community.id
  • title — varchar(50) — NOT NULL
  • description — varchar(255)
  • profile_img — varchar(255)
  • state — enum('PRIVATE','PUBLIC')

community_join

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • community_id — varchar(255) — NOT NULL
  • user_id — int(11) — NOT NULL
  • status — enum('MANAGER','SUBMANAGER','MEMBER','OWNER') — NOT NULL
  • state — enum('ACTIVE','BLOCK','KICK')

community_timeline

  • id — CHAR(36) — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME
  • deletedAt — DATETIME
  • community_id — VARCHAR(255)
  • channel_id — VARCHAR(255)
  • post_id — VARCHAR(255)
  • type — ENUM('USER','COMMUNITY')
  • post_type — ENUM('BLOG','SNS')
  • user_id — INT(11)
  • funtion_type — ENUM('NONE','POLL')
  • attatchment_files — LONGTEXT
  • visibility — ENUM('FOLLOWER','PUBLIC','PRIVATE')
  • hashtags — LONGTEXT
  • like_cnt — INT(11)
  • status — ENUM('ACTIVE','DRAFT')
  • is_pinned — TINYINT(1)

community_visit_log

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • user_id — int(11) — NOT NULL
  • community_id — varchar(255) — NOT NULL

faqs

  • id — int(11) — Primary key — NOT NULL
  • category — smallint(6) — NOT NULL
  • q — varchar(100) — NOT NULL
  • a — varchar(500) — NOT NULL
  • url_img — varchar(255)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

fcm

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • user_id — int(11) — NOT NULL
  • token — varchar(255)

file

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • filename — varchar(255)
  • mimetype — varchar(255)
  • md5 — varchar(255)
  • url — varchar(255)
  • priority — int(11)

follow

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • user_id — int(11) — NOT NULL
  • follow_id — int(11) — NOT NULL

follows

  • id — int(11) — Primary key — NOT NULL
  • user_uid — varchar(36) — NOT NULL
  • target_uid — varchar(36) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

forbidden_words

  • id — int(11) — Primary key — NOT NULL
  • activated — tinyint(1) — NOT NULL
  • word — varchar(50) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

game_challenging_reports

  • id — int(11) — Primary key — NOT NULL
  • user_uid — varchar(36) — NOT NULL
  • game_id — int(11) — NOT NULL
  • rating — smallint(6) — NOT NULL
  • comment — varchar(250)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

game_emotions

  • id — int(11) — Primary key — NOT NULL
  • game_id — int(11) — NOT NULL
  • e1 — int(11) — NOT NULL
  • e2 — int(11) — NOT NULL
  • e3 — int(11) — NOT NULL
  • e4 — int(11) — NOT NULL
  • e5 — int(11) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

game_hearts

  • id — int(11) — Primary key — NOT NULL
  • game_id — int(11) — NOT NULL
  • user_uid — varchar(255) — NOT NULL
  • activated — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

game_logs

  • id — int(11) — Primary key — NOT NULL
  • user_uid — varchar(36) — NOT NULL
  • game_id — int(11) — NOT NULL
  • score — int(11) — NOT NULL
  • playtime — int(11) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

game_post

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • game_id — varchar(255)
  • post_id — varchar(255)
  • is_pinned — tinyint(1)

game_replies

  • id — int(11) — Primary key — NOT NULL
  • game_id — int(11) — NOT NULL
  • user_uid — varchar(36) — NOT NULL
  • parent_reply_id — int(11)
  • content — varchar(500) — NOT NULL
  • count_good — int(11) — NOT NULL
  • count_bad — int(11) — NOT NULL
  • count_reply — int(11) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

game_timeline

  • id — CHAR(36) — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME
  • deletedAt — DATETIME
  • game_id — VARCHAR(255)
  • post_id — VARCHAR(255)
  • post_type — ENUM('BLOG','SNS')
  • funtion_type — ENUM('NONE','POLL')
  • attatchment_files — LONGTEXT
  • visibility — ENUM('FOLLOWER','PUBLIC','PRIVATE')
  • hashtags — LONGTEXT
  • like_cnt — INT(11)
  • status — ENUM('ACTIVE','DRAFT')
  • is_pinned — TINYINT(1)

games

  • id — int(11) — Primary key — NOT NULL
  • activated — tinyint(1) — NOT NULL
  • enabled — tinyint(1) — NOT NULL
  • official — tinyint(1) — NOT NULL
  • category — smallint(6) — NOT NULL
  • user_id — int(11)
  • pathname — varchar(50) — NOT NULL
  • title — varchar(50) — NOT NULL
  • description — varchar(200)
  • version — varchar(20)
  • control_type — smallint(6)
  • hashtags — varchar(255) — NOT NULL
  • count_start — int(11) — NOT NULL
  • count_over — int(11) — NOT NULL
  • count_heart — int(11) — NOT NULL
  • url_game — varchar(255)
  • url_thumb — varchar(255)
  • url_thumb_webp — varchar(255)
  • url_thumb_gif — varchar(255)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

gameview

  • id — INT(11) — NOT NULL
  • activated — TINYINT(1) — NOT NULL
  • enabled — TINYINT(1) — NOT NULL
  • official — TINYINT(1) — NOT NULL
  • category — SMALLINT(6) — NOT NULL
  • user_id — INT(11)
  • pathname — VARCHAR(50) — NOT NULL
  • title — VARCHAR(50) — NOT NULL
  • description — VARCHAR(200)
  • version — VARCHAR(20)
  • control_type — SMALLINT(6)
  • hashtags — VARCHAR(255) — NOT NULL
  • count_start — INT(11) — NOT NULL
  • count_over — INT(11) — NOT NULL
  • count_heart — INT(11) — NOT NULL
  • url_game — VARCHAR(255)
  • url_thumb — VARCHAR(255)
  • url_thumb_webp — VARCHAR(255)
  • url_thumb_gif — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • deleted_at — DATETIME

generated_points_logs

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — NOT NULL
  • game_id — int(11) — NOT NULL
  • pub_type — smallint(6) — NOT NULL
  • exchanged — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

hashtaglog

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • user_id — int(11)
  • text — varchar(255)

hashtags

  • id — int(11) — Primary key — NOT NULL
  • fixed — tinyint(1) — NOT NULL
  • name — varchar(50) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

inventories

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — NOT NULL
  • item_id — int(11) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

items

  • id — int(11) — Primary key — NOT NULL
  • name — varchar(20) — NOT NULL
  • used_type — smallint(6) — NOT NULL
  • period — int(11)
  • is_used — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

like

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • post_id — varchar(255) — NOT NULL
  • comment_id — varchar(255)
  • user_id — int(11)
  • type — enum('POST','COMMENT')
  • state — tinyint(1)

like_log

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • user_id — int(11) — NOT NULL
  • type — enum('POST','COMMENT')
  • object_id — varchar(255) — NOT NULL

notices

  • id — int(11) — Primary key — NOT NULL
  • category — smallint(6) — NOT NULL
  • activated — tinyint(1) — NOT NULL
  • title — varchar(100) — NOT NULL
  • content — varchar(500) — NOT NULL
  • img_link — varchar(500)
  • start_at — datetime — NOT NULL
  • end_at — datetime — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

poll

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • posts_id — char(36)
  • duration — bigint(20)
  • end_time — bigint(20)

portfolio

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • title — varchar(255)
  • description — varchar(255)
  • thumbnail_img — varchar(255)
  • is_public — tinyint(1)
  • user_id — int(11)
  • is_pinned — tinyint(1)

portfolio_post

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • channel_id — varchar(255)
  • portfolio_id — varchar(255)
  • post_id — varchar(255)
  • is_pinned — tinyint(1)

portfolio_timeline

  • id — CHAR(36) — NOT NULL
  • createdAt — DATETIME
  • updatedAt — DATETIME
  • deletedAt — DATETIME
  • channel_id — VARCHAR(255)
  • portfolio_id — VARCHAR(255)
  • post_id — VARCHAR(255)
  • post_type — ENUM('BLOG','SNS')
  • funtion_type — ENUM('NONE','POLL')
  • attatchment_files — LONGTEXT
  • visibility — ENUM('FOLLOWER','PUBLIC','PRIVATE')
  • hashtags — LONGTEXT
  • like_cnt — INT(11)
  • status — ENUM('ACTIVE','DRAFT')
  • is_pinned — TINYINT(1)

posted_at

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • posts_id — char(36) — Foreign key → posts.id
  • channel_id — varchar(255)
  • game_id — varchar(255)
  • community — longtext
  • portfolio_ids — longtext

posts

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • user_id — int(11)
  • post_type — enum('BLOG','SNS')
  • funtion_type — enum('NONE','POLL')
  • attatchment_files — longtext
  • visibility — enum('FOLLOWER','PUBLIC','PRIVATE')
  • content — varchar(255)
  • hashtags — longtext
  • user_tag — longtext
  • like_cnt — int(11)
  • comment_cnt — int(11)
  • read_cnt — int(11)
  • shared_cnt — int(11)
  • scheduled_for — varchar(255)
  • status — enum('ACTIVE','DRAFT')
  • is_retweet — tinyint(1)
  • retweet_id — char(36)

posts_view_log

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • user_id — int(11) — NOT NULL
  • post_id — varchar(255) — NOT NULL

project_versions

  • id — int(11) — Primary key — NOT NULL
  • project_id — int(11) — NOT NULL
  • game_id — int(11)
  • number — int(11) — NOT NULL
  • version — varchar(20)
  • state — varchar(20) — NOT NULL
  • url — varchar(255)
  • size — float
  • description — varchar(255)
  • reason — varchar(255)
  • auto_deploy — tinyint(1)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

projects

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — NOT NULL
  • name — varchar(50)
  • state — smallint(6) — NOT NULL
  • picture — varchar(250)
  • picture2 — varchar(250)
  • picture_webp — varchar(250)
  • control_type — smallint(6)
  • description — varchar(255)
  • hashtags — varchar(255)
  • game_id — int(11)
  • deploy_version_id — int(11)
  • update_version_id — int(11)
  • stage — int(11) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

ref_tags

  • id — int(11) — Primary key — NOT NULL
  • ref_id — int(11)
  • ref_type — varchar(255)
  • tag_id — int(11)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

report

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • reporter_user_id — int(11)
  • user_id — int(11)
  • post_id — varchar(255)
  • comment_id — varchar(255)
  • targetType — enum('COMMENT','POST','USER')
  • report_reason — varchar(100) — NOT NULL
  • isDone — tinyint(1)

search_keyword_log

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • user_id — int(11)
  • keyword — varchar(255) — NOT NULL

share_log

  • id — char(36) — Primary key — NOT NULL
  • createdAt — datetime
  • updatedAt — datetime
  • deletedAt — datetime
  • user_id — int(11) — NOT NULL
  • type — enum('POST','COMMENT')
  • object_id — varchar(255) — NOT NULL

shared_games

  • id — int(11) — Primary key — NOT NULL
  • uid — varchar(36) — NOT NULL
  • user_uid — varchar(36) — NOT NULL
  • game_id — int(11) — NOT NULL
  • count_open — int(11) — NOT NULL
  • count_play — int(11) — NOT NULL
  • count_ad — int(11) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

survey_results

  • id — int(11) — Primary key — NOT NULL
  • user_uid — varchar(36) — NOT NULL
  • survey_id — int(11) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

surveys

  • id — int(11) — Primary key — NOT NULL
  • activated — tinyint(1) — NOT NULL
  • form_id — varchar(100) — NOT NULL
  • form_url — varchar(200) — NOT NULL
  • start_at — datetime — NOT NULL
  • end_at — datetime — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

timelines

  • id — int(11) — Primary key — NOT NULL
  • uid — varchar(36) — NOT NULL
  • user_id — int(11) — NOT NULL
  • game_id — int(11) — NOT NULL
  • type — smallint(6) — NOT NULL
  • extra — varchar(200)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

user_bans

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — NOT NULL
  • admin_id — int(11) — NOT NULL
  • reason — varchar(300) — NOT NULL
  • period — datetime
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

user_claims

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — NOT NULL
  • user_uid — varchar(36) — NOT NULL
  • data — longtext — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

user_external_links

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — NOT NULL
  • name — varchar(30) — NOT NULL
  • url_link — varchar(250) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

user_game_emotions

  • id — int(11) — Primary key — NOT NULL
  • user_uid — varchar(36) — NOT NULL
  • game_id — int(11) — NOT NULL
  • emotion — varchar(4) — NOT NULL
  • activated — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

user_game_reply_reactions

  • id — int(11) — Primary key — NOT NULL
  • reply_id — int(11) — NOT NULL
  • user_uid — varchar(36) — NOT NULL
  • reaction — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

user_games

  • id — int(11) — Primary key — NOT NULL
  • user_uid — varchar(36) — NOT NULL
  • game_id — int(11) — NOT NULL
  • score — int(11) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

user_inquiries

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — NOT NULL
  • category — smallint(6) — NOT NULL
  • title — varchar(100) — NOT NULL
  • text — varchar(500) — NOT NULL
  • response — varchar(500)
  • admin_id — int(11)
  • url_img — varchar(255)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

user_left_logs

  • id — int(11) — Primary key — NOT NULL
  • user_uid — varchar(36)
  • reason_num — smallint(6) — NOT NULL
  • reason_text — varchar(100)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

user_mailboxes

  • id — int(11) — Primary key — NOT NULL
  • user_uid — varchar(36) — NOT NULL
  • is_read — tinyint(1) — NOT NULL
  • category — smallint(6) — NOT NULL
  • title — varchar(100) — NOT NULL
  • content — varchar(500) — NOT NULL
  • hide — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

user_playlist_games

  • id — int(11) — Primary key — NOT NULL
  • user_playlist_id — int(11) — NOT NULL
  • game_id — int(11) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

user_playlists

  • id — int(11) — Primary key — NOT NULL
  • uid — varchar(36) — NOT NULL
  • user_uid — varchar(36) — NOT NULL
  • limit — smallint(6) — NOT NULL
  • title — varchar(100) — NOT NULL
  • url_bg — varchar(250)
  • indexes — longtext
  • count_visited — int(11) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

user_profiles

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — NOT NULL
  • level — mediumint(9) — NOT NULL
  • exp — int(11) — NOT NULL
  • following_cnt — int(11) — NOT NULL
  • followers_cnt — int(11) — NOT NULL
  • state_msg — varchar(100)
  • description — varchar(500)
  • url_banner — varchar(250)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

user_publishings

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — NOT NULL
  • game_id — int(11) — NOT NULL
  • count_open — int(11) — NOT NULL
  • count_play — int(11) — NOT NULL
  • count_ad — int(11) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

user_punisheds

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — NOT NULL
  • is_denied — tinyint(1) — NOT NULL
  • category — varchar(20) — NOT NULL
  • reason — varchar(50) — NOT NULL
  • end_at — datetime — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

user_report_results

  • id — int(11) — Primary key — NOT NULL
  • report_id — int(11) — NOT NULL
  • admin_id — int(11) — NOT NULL
  • content — varchar(500) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

user_reports

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — NOT NULL
  • target_type — smallint(6) — NOT NULL
  • target_id — int(11) — NOT NULL
  • reason_num — varchar(30) — NOT NULL
  • reason — varchar(300)
  • is_done — tinyint(1) — NOT NULL
  • url_img — varchar(255)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

user_settings

  • id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — NOT NULL
  • app_theme — smallint(6) — NOT NULL
  • app_theme_extra — smallint(6)
  • app_language — smallint(6) — NOT NULL
  • notify_alarm — tinyint(1) — NOT NULL
  • notify_battle — tinyint(1) — NOT NULL
  • notify_beat — tinyint(1) — NOT NULL
  • notify_follow — tinyint(1) — NOT NULL
  • notify_like — tinyint(1) — NOT NULL
  • notify_reply — tinyint(1) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

users

  • id — int(11) — Primary key — NOT NULL
  • uid — varchar(36) — NOT NULL
  • activated — tinyint(1) — NOT NULL
  • banned — smallint(6) — NOT NULL
  • name — varchar(20)
  • channel_id — varchar(36) — NOT NULL
  • picture — varchar(250)
  • provider — varchar(20)
  • email — varchar(50)
  • email_verified — tinyint(1)
  • fcm_token — varchar(255)
  • is_developer — tinyint(1)
  • last_log_in — datetime
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • deleted_at — datetime

and 1 more table