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