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