젬파이 플랫폼

테이블 (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개 테이블