123

Tables (14)

notifications

  • notification_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • post_id — BIGINT
  • shortform_id — BIGINT
  • actor_nickname — VARCHAR(12)
  • subject_title — VARCHAR(200)
  • is_read — BOOLEAN — NOT NULL

posts

  • post_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • youtube_video_id — VARCHAR(20)
  • section_start — INT
  • section_duration — INT

refresh_tokens

  • refresh_token_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • token_hash — VARCHAR(64) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • revoked_at — DATETIME
  • rotated_at — DATETIME
  • session_id — VARCHAR(36) — NOT NULL

sessions

  • session_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • parent_id — BIGINT — Foreign key → sessions.session_id
  • sort_order — INT — NOT NULL

shortform_tracks

  • shortform_id — BIGINT — Foreign key → shortforms.shortform_id — NOT NULL
  • track_id — BIGINT — Foreign key → tracks.track_id — NOT NULL
  • grid_position — INT
  • center_x — DOUBLE — NOT NULL
  • center_y — DOUBLE — NOT NULL
  • zoom — DOUBLE — NOT NULL

shortform_view_logs

  • shortform_view_log_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • shortform_id — BIGINT — Foreign key → shortforms.shortform_id — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • watch_ms — INT — NOT NULL
  • video_ms — INT — NOT NULL

shortforms

  • shortform_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • post_id — BIGINT — Foreign key → posts.post_id — NOT NULL
  • video_path — VARCHAR(500)
  • thumbnail_path — VARCHAR(500)
  • process_status — VARCHAR(20)
  • process_error_message — VARCHAR(1000)
  • is_published — BOOLEAN
  • view_count — BIGINT
  • participants_notified — BOOLEAN

shortforms_views

  • shortform_id — BIGINT — Foreign key → shortforms.shortform_id — NOT NULL
  • count — BIGINT

tags

  • name — VARCHAR(10) — Primary key — NOT NULL
  • post_id — BIGINT — Foreign key → posts.post_id — NOT NULL

track_base_tracks

  • base_track_id — BIGINT — Primary key — NOT NULL
  • track_id — BIGINT — Foreign key → tracks.track_id — NOT NULL

tracks

  • track_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • post_id — BIGINT — Foreign key → posts.post_id — NOT NULL
  • session_id — BIGINT — Foreign key → sessions.session_id
  • video_path — VARCHAR(500) — NOT NULL
  • thumbnail_path — VARCHAR(500)
  • source_type — VARCHAR(20)
  • sync_offset_ms — INT
  • is_synced — BOOLEAN
  • process_status — VARCHAR(20)
  • normalized_video_path — VARCHAR(500)
  • normalized_audio_path — VARCHAR(500)
  • process_error_message — VARCHAR(1000)

tracks_counts

  • id — BIGINT — Foreign key → tracks.track_id — NOT NULL
  • count — INT

user_sessions

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • session_id — BIGINT — Foreign key → sessions.session_id — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • email — VARCHAR(255)
  • nickname — VARCHAR(12)
  • profile_image_url — VARCHAR(500)
  • provider — VARCHAR(20)
  • provider_id — VARCHAR(255)