젬파이 플랫폼
테이블 (102)
admin_logs
- id — INT — 기본 키 — NOT NULL
- admin_id — INT — NOT NULL
- path — VARCHAR(50) — NOT NULL
- body — VARCHAR(500)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
admin_refresh_tokens
- id — INT — 기본 키 — NOT NULL
- admin_id — INT — NOT NULL
- token — VARCHAR(300) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
adminfcm
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- user_id — INT — NOT NULL
- token — VARCHAR(255)
admins
- id — INT — 기본 키 — NOT NULL
- uid — CHAR(36) — NOT NULL
- activated — TINYINT(1) — NOT NULL
- account — VARCHAR(20) — NOT NULL
- name — VARCHAR(20) — NOT NULL
- level — SMALLINT — NOT NULL
- sub_level — SMALLINT — 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) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- userId — INT
- 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 — 기본 키 — NOT NULL
- user_uid — VARCHAR(36) — NOT NULL
- target_uid — VARCHAR(36) — NOT NULL
- type — SMALLINT — NOT NULL
- extra — VARCHAR(200)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
bad_words
- id — INT — 기본 키 — 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 — 기본 키 — NOT NULL
- battle_uid — VARCHAR(36) — NOT NULL
- battle_user_id — INT — NOT NULL
- score — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
battle_users
- id — INT — 기본 키 — NOT NULL
- battle_uid — VARCHAR(36) — NOT NULL
- user_uid — VARCHAR(36) — NOT NULL
- name — VARCHAR(20)
- best_score — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
battles
- id — INT — 기본 키 — NOT NULL
- uid — VARCHAR(36) — NOT NULL
- user_uid — VARCHAR(36) — NOT NULL
- game_id — INT — NOT NULL
- title — VARCHAR(50)
- activated — TINYINT(1) — NOT NULL
- user_count — MEDIUMINT — NOT NULL
- end_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
block
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- community_id — VARCHAR(255)
- user_id — INT
- target_id — INT
- blocked_at — BIGINT
- expires_on — BIGINT
- reason — VARCHAR(255)
- type — ENUM('USERBLOCK', 'COMMUNITYBLOCK', 'MUTE', 'KICK')
blocks
- id — VARCHAR(36) — 기본 키 — NOT NULL
- community_id — VARCHAR(255)
- user_id — INT
- target_id — INT
- blocked_at — BIGINT
- expires_on — BIGINT
- reason — VARCHAR(255)
- type — ENUM('USERBLOCK', 'COMMUNITYBLOCK', 'MUTE', 'KICK')
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
certification_logs
- id — INT — 기본 키 — NOT NULL
- timestamp — VARCHAR(14) — NOT NULL
- request_no — VARCHAR(30) — NOT NULL
- site_code — VARCHAR(10) — NOT NULL
- token_version_id — VARCHAR(50) — NOT NULL
- integrity_value — VARCHAR(50) — NOT NULL
- key — VARCHAR(16) — NOT NULL
- iv — VARCHAR(16) — NOT NULL
- hmac_key — VARCHAR(32) — NOT NULL
- name — VARCHAR(30)
- phone — VARCHAR(20)
- success — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
channel_post
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — 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)
chat_room_joined
- id — INT — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- entered_at — DATETIME
- user_id — INT — 외래 키 — NOT NULL
- room_id — INT — 외래 키 → chat_rooms.id — NOT NULL
- leaved — TINYINT(1)
- readed_id — INT
- has_name — TINYINT(1)
- name — VARCHAR(50)
- INDEX — `chat_room_joined_ibfk_1`
- INDEX — `chat_room_joined_ibfk_2`
chat_rooms
- id — INT — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- last_chat_at — DATETIME
- last_chat_id — INT
- creator_id — INT — NOT NULL
- creator_uid — CHAR(36) — NOT NULL
- is_group_room — TINYINT(1)
chat_user_meta
- id — INT — 기본 키 — NOT NULL
- user_id — INT — 외래 키 — NOT NULL
- chat_update_check_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
chats
- id — INT — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- type — INT
- contents — VARCHAR(5000)
- room_id — INT — 외래 키 → chat_rooms.id — NOT NULL
- sender_id — INT — NOT NULL
- unsended_at — DATETIME
- INDEX — `chats_ibfk_1`
choice
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- poll_id — CHAR(36) — 외래 키 → poll.id
- title — VARCHAR(255)
- voted_cnt — INT
- INDEX — `poll_id`
choicelog
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- user_id — INT
- choice_id — VARCHAR(255)
coin_meta
- id — INT — 기본 키 — NOT NULL
- admin_id — INT — NOT NULL
- commission_rate — DOUBLE — NOT NULL
- coin_rate — INT — NOT NULL
- point_rate — INT — NOT NULL
- min_amount — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
coin_redemptions
- id — INT — 기본 키 — NOT NULL
- user_uid — VARCHAR(36) — NOT NULL
- bank_account_id — INT — NOT NULL
- amount — INT — NOT NULL
- widthraw_amount — DOUBLE — NOT NULL
- status — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
- memo — VARCHAR(256)
- admin_id — INT
comment
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- user_id — INT — 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 — JSON
- like_cnt — INT
- dislike_cnt — INT
community
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- owner_id — INT
- manager_id — INT
- submanager_id — INT
- name — VARCHAR(50) — NOT NULL
- url — VARCHAR(50)
- description — VARCHAR(2000) — NOT NULL
- profile_img — VARCHAR(255)
- banner_img — VARCHAR(255)
- member_cnt — INT
- posts_cnt — INT
- visit_cnt — INT
- state — ENUM('PRIVATE', 'PUBLIC')
- is_certificated — TINYINT(1)
community_block
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- communityId — VARCHAR(255) — NOT NULL
- userId — VARCHAR(255) — NOT NULL
- active — TINYINT(1)
community_channel
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- user_id — INT
- community_id — CHAR(36) — 외래 키 → community.id
- title — VARCHAR(50) — NOT NULL
- description — VARCHAR(255)
- profile_img — VARCHAR(255)
- state — ENUM('PRIVATE', 'PUBLIC')
- INDEX — `community_id`
community_join
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- community_id — VARCHAR(255) — NOT NULL
- user_id — INT — NOT NULL
- status — ENUM('MANAGER', 'SUBMANAGER', 'MEMBER', 'OWNER') — NOT NULL
- state — ENUM('ACTIVE', 'BLOCK', 'KICK')
community_visit_log
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- user_id — INT — NOT NULL
- community_id — VARCHAR(255) — NOT NULL
events
- id — INT — 기본 키 — NOT NULL
- title — VARCHAR(50) — NOT NULL
- url_img — VARCHAR(255)
- desc — VARCHAR(200)
- start_date — DATETIME — NOT NULL
- end_date — DATETIME — NOT NULL
- type — INT — NOT NULL
- category — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
faqs
- id — INT — 기본 키 — NOT NULL
- category — SMALLINT — 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) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- user_id — INT — NOT NULL
- token — VARCHAR(255)
fcm_log
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- user_id — INT — NOT NULL
- sended_at — DATETIME
- noti_type — INT
- value — VARCHAR(255)
file
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- filename — VARCHAR(255)
- mimetype — VARCHAR(255)
- md5 — VARCHAR(255)
- url — VARCHAR(255)
- priority — INT
follow
- id — CHAR(36) — 기본 키 — NOT NULL
- user_id — INT
- follow_id — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
forbidden_words
- id — INT — 기본 키 — 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 — 기본 키 — NOT NULL
- user_uid — VARCHAR(36) — NOT NULL
- game_id — INT — NOT NULL
- rating — SMALLINT — NOT NULL
- comment — VARCHAR(250)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
game_emotions
- id — INT — 기본 키 — NOT NULL
- game_id — INT — NOT NULL
- e1 — INT — NOT NULL
- e2 — INT — NOT NULL
- e3 — INT — NOT NULL
- e4 — INT — NOT NULL
- e5 — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
game_hearts
- id — INT — 기본 키 — NOT NULL
- game_id — INT — 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_jams
- id — INT — 기본 키 — NOT NULL
- jam_id — INT — NOT NULL
- title — VARCHAR(100) — NOT NULL
- game_id — INT — NOT NULL
- user_id — INT
- is_awarded — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
game_logs
- id — INT — 기본 키 — NOT NULL
- user_uid — VARCHAR(36)
- game_id — INT — NOT NULL
- score — INT — NOT NULL
- playtime — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
game_post
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- game_id — VARCHAR(255)
- post_id — VARCHAR(255)
- is_pinned — TINYINT(1)
game_replies
- id — INT — 기본 키 — NOT NULL
- activated — TINYINT(1) — NOT NULL
- game_id — INT — NOT NULL
- user_uid — VARCHAR(36) — NOT NULL
- parent_reply_id — INT
- target_uid — VARCHAR(36)
- content — VARCHAR(500) — NOT NULL
- count_good — INT — NOT NULL
- count_bad — INT — NOT NULL
- count_reply — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
games
- id — INT — 기본 키 — NOT NULL
- activated — TINYINT(1) — NOT NULL
- enabled — TINYINT(1) — NOT NULL
- official — TINYINT(1)
- category — INT — NOT NULL
- user_id — INT
- pathname — VARCHAR(50) — NOT NULL
- title — VARCHAR(50) — NOT NULL
- description — VARCHAR(2000)
- version — VARCHAR(20)
- stage — INT — NOT NULL
- support_platform — VARCHAR(50)
- game_type — INT
- url_banner — VARCHAR(255)
- control_type — SMALLINT
- hashtags — VARCHAR(255) — NOT NULL
- count_start — INT — NOT NULL
- count_over — INT — NOT NULL
- count_heart — INT — NOT NULL
- url_game — VARCHAR(500)
- url_thumb — VARCHAR(255)
- url_thumb_webp — VARCHAR(255)
- url_thumb_gif — VARCHAR(255)
- meta — JSON
- created_at — DATETIME — NOT NULL
- weighted — DOUBLE
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
generated_points_logs
- id — INT — 기본 키 — NOT NULL
- user_id — INT — NOT NULL
- game_id — INT — NOT NULL
- pub_type — SMALLINT — NOT NULL
- exchanged — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
hashtaglog
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- user_id — INT
- text — VARCHAR(255)
hashtags
- id — INT — 기본 키 — 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 — 기본 키 — NOT NULL
- user_id — INT — NOT NULL
- item_id — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
items
- id — INT — 기본 키 — NOT NULL
- name — VARCHAR(20) — NOT NULL
- used_type — SMALLINT — NOT NULL
- period — INT
- is_used — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
like
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- post_id — VARCHAR(255) — NOT NULL
- comment_id — VARCHAR(255)
- user_id — INT
- type — ENUM('POST', 'COMMENT')
- state — TINYINT(1)
like_log
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- user_id — INT — NOT NULL
- type — ENUM('POST', 'COMMENT')
- object_id — VARCHAR(255) — NOT NULL
logs
- id — BIGINT — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- valid — TINYINT(1)
- reason — BIGINT
- seed — INT
- replay — LONGBLOB
- INDEX — `idx_logs_deleted_at`
meta
- id — INT — 기본 키 — NOT NULL
- and_build_no — INT — NOT NULL
- ios_build_no — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
mogera_files
- id — INT — 기본 키 — NOT NULL
- user_uid — VARCHAR(36) — NOT NULL
- url — VARCHAR(255)
- size — FLOAT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
notices
- id — INT — 기본 키 — NOT NULL
- category — SMALLINT — 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
notifications
- id — INT — 기본 키 — NOT NULL
- user_id — INT
- target_user_id — INT
- is_read — TINYINT(1) — NOT NULL
- content — VARCHAR(500) — NOT NULL
- target_id — VARCHAR(36)
- type — SMALLINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
poll
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- posts_id — CHAR(36) — 외래 키 → posts.id
- duration — BIGINT
- end_time — BIGINT
- INDEX — `posts_id`
portfolio
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- title — VARCHAR(255)
- description — VARCHAR(255)
- thumbnail_img — VARCHAR(255)
- is_public — TINYINT(1)
- user_id — INT
- is_pinned — TINYINT(1)
portfolio_post
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- channel_id — VARCHAR(255)
- portfolio_id — VARCHAR(255)
- post_id — VARCHAR(255)
- is_pinned — TINYINT(1)
post_metadata
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- posts_id — CHAR(36) — 외래 키 → posts.id
- type — INT — NOT NULL
- url — VARCHAR(255)
- title — VARCHAR(255)
- description — VARCHAR(5000)
- img — VARCHAR(500)
- favicon — VARCHAR(500)
- site_name — VARCHAR(500)
- video_url — VARCHAR(500)
- INDEX — `posts_id`
posted_at
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- posts_id — CHAR(36) — 외래 키 → posts.id
- channel_id — VARCHAR(255)
- game_id — VARCHAR(255)
- community — JSON
- portfolio_ids — JSON
- game — JSON
- INDEX — `posts_id`
posts
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- user_id — INT
- post_type — ENUM('BLOG', 'SNS')
- funtion_type — ENUM('NONE', 'POLL')
- attatchment_files — JSON
- visibility — ENUM('FOLLOWER', 'PUBLIC', 'PRIVATE')
- content — VARCHAR(5000)
- hashtags — JSON
- user_tag — JSON
- like_cnt — INT
- comment_cnt — INT
- read_cnt — INT
- shared_cnt — INT
- scheduled_for — VARCHAR(255)
- status — ENUM('ACTIVE', 'DRAFT')
- is_retweet — TINYINT(1)
- retweet_id — CHAR(36)
- is_allow_donate — TINYINT(1)
posts_view_log
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- user_id — INT — NOT NULL
- post_id — VARCHAR(255) — NOT NULL
project_versions
- id — INT — 기본 키 — NOT NULL
- project_id — INT — NOT NULL
- game_id — INT
- number — INT — NOT NULL
- version — VARCHAR(20)
- state — VARCHAR(20) — NOT NULL
- url — VARCHAR(500)
- size — FLOAT
- file_type — INT
- support_platform — VARCHAR(50)
- 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 — 기본 키 — NOT NULL
- user_id — INT — NOT NULL
- name — VARCHAR(50)
- state — SMALLINT — NOT NULL
- picture — VARCHAR(250)
- picture2 — VARCHAR(250)
- picture_webp — VARCHAR(250)
- control_type — SMALLINT
- description — VARCHAR(2000)
- hashtags — VARCHAR(255)
- game_id — INT
- deploy_version_id — INT
- update_version_id — INT
- stage — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
pvp_elos
- id — INT — 기본 키 — NOT NULL
- user_id — INT — NOT NULL
- game_type — INT — NOT NULL
- elo — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
pvp_games
- id — INT — 기본 키 — NOT NULL
- game_pathname — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
ref_items
- id — INT — 기본 키 — NOT NULL
- name — VARCHAR(100)
- description — VARCHAR(100)
- used_type — TINYINT
- lv_min — INT
- lv_max — INT
- img — VARCHAR(100)
- tag — TINYINT
- quantity — BIGINT
- time_limit — INT
- start_at — DATETIME — NOT NULL
- end_at — DATETIME — NOT NULL
- application_method — TINYINT
- package — JSON
- payload — JSON
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
ref_tags
- id — INT — 기본 키 — NOT NULL
- ref_id — INT
- ref_type — VARCHAR(255)
- tag_id — INT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
report
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- reporter_user_id — INT
- user_id — INT
- post_id — VARCHAR(255)
- comment_id — VARCHAR(255)
- targetType — ENUM('COMMENT', 'POST', 'USER')
- report_reason — VARCHAR(100) — NOT NULL
- is_done — TINYINT(1)
- reason — VARCHAR(500)
search_keyword_log
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- user_id — INT
- keyword — VARCHAR(255) — NOT NULL
share_log
- id — CHAR(36) — 기본 키 — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
- deleted_at — DATETIME
- user_id — INT — NOT NULL
- type — ENUM('POST', 'COMMENT')
- object_id — VARCHAR(255) — NOT NULL
shared_games
- id — INT — 기본 키 — NOT NULL
- uid — VARCHAR(36) — NOT NULL
- user_uid — VARCHAR(36) — NOT NULL
- game_id — INT — NOT NULL
- count_open — INT — NOT NULL
- count_play — INT — NOT NULL
- count_ad — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
shops
- id — INT — 기본 키 — NOT NULL
- refitem_id — INT
- shop — TINYINT
- sort — INT — NOT NULL
- order — INT — NOT NULL
- lv_min — INT
- lv_max — INT
- quantity — BIGINT
- store_type — TINYINT
- store_code — VARCHAR(100)
- currency — TINYINT
- price — INT
- tag — TINYINT
- discount — TINYINT
- start_at — DATETIME
- end_at — DATETIME
- suppulment — TINYINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
survey_results
- id — INT — 기본 키 — NOT NULL
- user_uid — VARCHAR(36) — NOT NULL
- survey_id — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
surveys
- id — INT — 기본 키 — 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 — 기본 키 — NOT NULL
- uid — VARCHAR(36) — NOT NULL
- user_id — INT — NOT NULL
- game_id — INT — NOT NULL
- type — SMALLINT — NOT NULL
- extra — VARCHAR(200)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
user-meta
- id — INT — 기본 키 — NOT NULL
- user_id — INT
- notification_check_time — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
user_bank_accounts
- id — INT — 기본 키 — NOT NULL
- user_uid — VARCHAR(36) — NOT NULL
- bank — VARCHAR(100) — NOT NULL
- account_num — INT — NOT NULL
- is_auth — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
- name — VARCHAR(100)
user_bans
- id — INT — 기본 키 — NOT NULL
- user_id — INT — NOT NULL
- admin_id — INT — 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 — 기본 키 — NOT NULL
- user_id — INT — NOT NULL
- user_uid — VARCHAR(36) — NOT NULL
- data — JSON — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
외 22개 테이블