ChannelX

Tables (19)

channel_follows

  • channel_id — UUID — Foreign key → channels.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

channel_keywords

  • id — BIGSERIAL
  • channel_id — UUID — Foreign key → channels.id — NOT NULL
  • keyword — VARCHAR(40) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

channels

  • id — UUID
  • slug — VARCHAR(64) — NOT NULL
  • name — VARCHAR(80) — NOT NULL
  • description — TEXT
  • avatar_url — TEXT
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

comment_likes

  • comment_id — UUID — Foreign key → comments.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

comments

  • id — UUID
  • feed_id — UUID — Foreign key → feeds.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • parent_comment_id — UUID — Foreign key → comments.id
  • content — TEXT — NOT NULL
  • like_count — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

feed_hashtags

  • feed_id — UUID — Foreign key → feeds.id — NOT NULL
  • hashtag_id — BIGINT — Foreign key → hashtags.id — NOT NULL

feed_likes

  • feed_id — UUID — Foreign key → feeds.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

feed_media

  • id — UUID
  • feed_id — UUID — Foreign key → feeds.id — NOT NULL
  • media_type — VARCHAR(20) — NOT NULL
  • url — TEXT — NOT NULL
  • width — INTEGER
  • height — INTEGER
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

feeds

  • id — UUID
  • author_id — UUID — Foreign key → users.id — NOT NULL
  • channel_id — UUID — Foreign key → channels.id
  • content_text — TEXT — NOT NULL
  • blocks — JSONB — NOT NULL
  • visibility — VARCHAR(20) — NOT NULL
  • like_count — INTEGER — NOT NULL
  • comment_count — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

hashtags

  • id — BIGSERIAL
  • tag — VARCHAR(60) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

idempotency_keys

  • request_hash — TEXT — NOT NULL
  • response_status — INTEGER
  • response_body — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL

inquiries

  • id — UUID
  • channel_id — UUID — Foreign key → channels.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • external_thread_id — TEXT
  • last_message_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

notifications

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • notification_type — VARCHAR(40) — NOT NULL
  • actor_user_id — UUID — Foreign key → users.id
  • target_feed_id — UUID — Foreign key → feeds.id
  • target_comment_id — UUID — Foreign key → comments.id
  • payload — JSONB — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • read_at — TIMESTAMPTZ

outbox_events

  • id — UUID
  • aggregate_type — VARCHAR(40) — NOT NULL
  • aggregate_id — UUID — NOT NULL
  • event_type — VARCHAR(80) — NOT NULL
  • payload — JSONB — NOT NULL
  • idempotency_key — VARCHAR(120)
  • status — VARCHAR(20) — NOT NULL
  • retry_count — INTEGER — NOT NULL
  • available_at — TIMESTAMPTZ — NOT NULL
  • processed_at — TIMESTAMPTZ
  • last_error — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

poll_options

  • id — UUID
  • poll_id — UUID — Foreign key → polls.id — NOT NULL
  • label — TEXT — NOT NULL
  • vote_count — INTEGER — NOT NULL
  • sort_order — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

poll_votes

  • poll_id — UUID — Foreign key → polls.id — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • option_id — UUID — Foreign key → poll_options.id — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

polls

  • id — UUID
  • feed_id — UUID — Foreign key → feeds.id — NOT NULL
  • question — TEXT — NOT NULL
  • total_votes — INTEGER — NOT NULL
  • ends_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

refresh_tokens

  • id — UUID
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • token_hash — TEXT — NOT NULL
  • expires_at — TIMESTAMPTZ — NOT NULL
  • revoked_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

users

  • id — UUID
  • email — CITEXT — NOT NULL
  • password_hash — TEXT — NOT NULL
  • nickname — VARCHAR(40) — NOT NULL
  • profile_image_url — TEXT
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL