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