IPA
Tables (31)
account
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- age — int
- birth — datetime
- ci — varchar(255)
- email — varchar(255) — NOT NULL
- gender — varchar(255)
- last_access_at — datetime
- last_access_social_type — varchar(255)
- mobile — varchar(255)
- name — varchar(255)
- password — varchar(255)
- verification_type — varchar(255) — NOT NULL
account_profile
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- account_id — bigint
- nick_name — varchar(255)
- profile_img — varchar(255)
- badge_id — bigint
- nickname_last_modified_at — datetime
account_relation
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- account_id — bigint — NOT NULL
- related_account_id — bigint — NOT NULL
- relation_type — varchar(40) — NOT NULL
account_social
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- access_token — varchar(2048) — NOT NULL
- account_id — bigint
- email — varchar(255) — NOT NULL
- refresh_token — varchar(2048)
- social_id — varchar(255) — NOT NULL
- social_type — varchar(255) — NOT NULL
auth_client
- id — varchar(32) — NOT NULL
- created_at — datetime — NOT NULL
- scope — varchar(32) — NOT NULL
- secret — varchar(128) — NOT NULL
- updated_at — datetime
auth_token
- id — bigint
- access_token — varchar(512)
- account_id — bigint
- app_type — varchar(16)
- app_version — varchar(255)
- created_at — datetime
- enable — bit — NOT NULL
- phone_uid — varchar(255)
- refresh_token — varchar(512)
bad_word
- id — bigint
- word — varchar(255)
badge
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- description — varchar(255)
- main_img — varchar(255)
- name — varchar(255)
- text_img — varchar(255)
- view_order — int
banner
- id — bigint
- banner_type — varchar(45) — NOT NULL
- end_at — datetime
- img_url — varchar(255)
- landing_url — varchar(255)
- show_yn — bit
- start_at — datetime
- sub_title — varchar(255)
- title — varchar(255)
- view_order — int
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- memo — varchar(255)
brand
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- main_img — varchar(255)
- name — varchar(255)
character_info
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- main_img — varchar(255)
- name — varchar(255)
- brand_id — bigint
- tag_count — int — NOT NULL
comment
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- account_id — bigint
- comment_type — varchar(255) — NOT NULL
- contents — varchar(400)
- discarded — bit
- ref_id — bigint
- reported — bit
- target_id — bigint — NOT NULL
- reaction_count — int
comment_reaction
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- account_id — bigint — NOT NULL
- comment_id — bigint — NOT NULL
comment_report
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- account_id — bigint — NOT NULL
- comment_account_id — bigint
- comment_id — bigint — NOT NULL
- report_reason — varchar(255)
- status — varchar(255)
default_profile_img
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- img_url — varchar(255)
- view_order — int
email_verification
- id — bigint
- code — varchar(100)
- email — varchar(255) — NOT NULL
- expire_time — datetime
- validate — bit
feed
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- account_id — bigint
- comment_count — int — NOT NULL
- contents — text — NOT NULL
- reaction_count — int — NOT NULL
- topic_id — bigint
- blinded — bit — NOT NULL
feed_character_map
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- character_info_id — bigint
- feed_id — bigint
- view_order — int
feed_image
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- feed_id — bigint
- img_url — varchar(255)
- view_order — int
feed_reaction
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- account_id — bigint — NOT NULL
- feed_id — bigint — NOT NULL
feed_report
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- account_id — bigint — NOT NULL
- feed_account_id — bigint
- feed_id — bigint — NOT NULL
- report_reason — varchar(255)
- status — varchar(255)
log_access_info
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- account_id — bigint
- app_bundle_id — varchar(32)
- app_type — varchar(16)
- app_version — varchar(16)
- phone_uid — varchar(255)
penalty
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- checked — bit
- end_at — datetime
- penalty_reason — varchar(255)
- report_type — varchar(255)
- target_id — bigint — NOT NULL
poll
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- account_id — bigint — NOT NULL
- end_at — datetime
- feed_id — bigint
- total_answer_count — int
poll_answer
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- account_id — bigint
- poll_id — bigint — NOT NULL
- poll_question_id — bigint
poll_question
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- answer_count — int
- contents — varchar(255)
- poll_id — bigint
profile_badge_map
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- account_id — bigint — NOT NULL
- badge_id — bigint — NOT NULL
temp_nick_name
- id — bigint
- adjective — varchar(255)
- animal_name — varchar(255)
topic
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- name — varchar(255)
user_report
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- account_id — bigint — NOT NULL
- report_reason — varchar(255)
- status — varchar(255)
- target_account_id — bigint — NOT NULL
withdraw_account
- id — bigint
- created_at — datetime — NOT NULL
- deleted_at — datetime
- register_id — varchar(45)
- updated_at — datetime
- account_id — bigint — NOT NULL
- email — varchar(255) — NOT NULL