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