trace

Tables (11)

comments

  • is_deleted — bit
  • created_at — datetime(6)
  • id — bigint
  • parent_id — bigint
  • post_id — bigint — NOT NULL
  • user_id — bigint
  • content — varchar(255)

daily_mission

  • change_count — int — NOT NULL
  • is_verified — bit
  • id — bigint
  • mission_id — bigint — NOT NULL
  • user_id — bigint — NOT NULL
  • post_id — bigint
  • created_at — date

emotions

  • created_at — datetime(6)
  • id — bigint
  • post_id — bigint — NOT NULL
  • user_id — bigint
  • emotion_type — enum — NOT NULL

fcm_tokens

  • id — bigint
  • created_at — datetime(6) — NOT NULL
  • provider_id — varchar(255) — NOT NULL
  • token — varchar(500) — NOT NULL
  • updated_at — datetime(6) — NOT NULL

mission

  • id — bigint
  • description — varchar(255)

post_images

  • image_order — int
  • created_at — datetime(6)
  • id — bigint
  • post_id — bigint — NOT NULL
  • image_url — varchar(255) — NOT NULL

posts

  • created_at — datetime(6)
  • id — bigint
  • updated_at — datetime(6)
  • user_id — bigint — NOT NULL
  • view_count — bigint — NOT NULL
  • content — text
  • mission_content — varchar(255)
  • title — varchar(255) — NOT NULL
  • post_type — enum — NOT NULL

report

  • id — bigint
  • created_at — datetime(6)
  • reason — enum — NOT NULL
  • report_status — enum — NOT NULL
  • comment_id — bigint
  • post_id — bigint
  • reporter_id — bigint — NOT NULL

user_block

  • id — bigint
  • created_at — datetime(6)
  • blocked_id — bigint — NOT NULL
  • blocker_id — bigint — NOT NULL

users

  • id — bigint
  • verification_count — bigint
  • verification_score — bigint
  • email — varchar(255)
  • nickname — varchar(255)
  • password — varchar(255)
  • profile_image_url — varchar(255)
  • provider — varchar(255) — NOT NULL
  • provider_id — varchar(255) — NOT NULL
  • role — enum — NOT NULL
  • username — varchar(255)

verification

  • is_image_verified — bit — NOT NULL
  • is_text_verified — bit — NOT NULL
  • id — bigint
  • post_id — bigint
  • failure_reason — text
  • success_reason — text