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