11
Tables (17)
check_goals
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- goal_id — BIGINT — Foreign key → goals.id — NOT NULL
- created_at — TIMESTAMP
comment_likes
- id — BIGSERIAL
- comment_id — BIGINT — Foreign key → comments.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- created_at — TIMESTAMP
comments
- id — BIGSERIAL
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- content — VARCHAR(500) — NOT NULL
- status — VARCHAR(20)
- deleted_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
follows
- id — BIGSERIAL
- follower_user_id — BIGINT — Foreign key → users.id — NOT NULL
- following_user_id — BIGINT — Foreign key → users.id — NOT NULL
- created_at — TIMESTAMP
goal_snapshots
- id — BIGSERIAL
- goal_id — BIGINT — Foreign key → goals.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- snapshot_reason — VARCHAR(50) — NOT NULL
- snapshot_data — JSONB — NOT NULL
- created_at — TIMESTAMP
goals
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- status — VARCHAR(20)
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- total_target_count — INTEGER — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
post_likes
- id — BIGSERIAL
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- created_at — TIMESTAMP
post_tags
- id — BIGSERIAL
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- tag_id — BIGINT — Foreign key → tags.id — NOT NULL
- created_at — TIMESTAMP
posts
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- goal_id — BIGINT — Foreign key → goals.id
- vote_id — BIGINT — Foreign key → votes.id
- title — VARCHAR(255) — NOT NULL
- content — TEXT
- has_goal — BOOLEAN
- has_vote — BOOLEAN
- goal_summary — JSONB
- vote_summary — JSONB
- status — VARCHAR(20)
- deleted_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
reports
- id — BIGSERIAL
- reporter_user_id — BIGINT — Foreign key → users.id — NOT NULL
- reported_user_id — BIGINT — Foreign key → users.id
- target_id — BIGINT — NOT NULL
- target_type — VARCHAR(20) — NOT NULL
- reason_type — VARCHAR(100)
- reason_detail — TEXT
- status — VARCHAR(20)
- handled_at — TIMESTAMP
- created_at — TIMESTAMP
scraps
- id — BIGSERIAL
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- created_at — TIMESTAMP
social_login
- id — BIGSERIAL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_user_id — VARCHAR(255) — NOT NULL
- linked_at — TIMESTAMP
- created_at — TIMESTAMP
tags
- id — BIGSERIAL
- name — VARCHAR(100) — NOT NULL
- is_active — BOOLEAN
- created_at — TIMESTAMP
users
- id — BIGSERIAL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- nickname — VARCHAR(100) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- gender — VARCHAR(20)
- birth_date — DATE
- profile_image_url — VARCHAR(500)
- total_goals_count — INTEGER
- role — VARCHAR(20)
- status — VARCHAR(20)
- deleted_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
vote_options
- id — BIGSERIAL
- vote_id — BIGINT — Foreign key → votes.id — NOT NULL
- content — VARCHAR(255) — NOT NULL
- sort_order — INTEGER
- created_at — TIMESTAMP
vote_participations
- id — BIGSERIAL
- vote_id — BIGINT — Foreign key → votes.id — NOT NULL
- vote_option_id — BIGINT — Foreign key → vote_options.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- created_at — TIMESTAMP
votes
- id — BIGSERIAL
- question — VARCHAR(255) — NOT NULL
- is_closed — BOOLEAN
- end_date — TIMESTAMP — NOT NULL
- created_at — TIMESTAMP
- updated_at — TIMESTAMP