sos-rookies

Tables (10)

ai_events

  • eventId — VARCHAR(255)
  • userId — BIGINT — NOT NULL
  • promptId — VARCHAR(255) — NOT NULL
  • prompt — LONGTEXT — NOT NULL
  • videoId — VARCHAR(255) — NOT NULL
  • video — VARCHAR(2048) — NOT NULL
  • message — TEXT
  • payloadRaw — LONGTEXT — NOT NULL
  • receivedAt — TIMESTAMP
  • INDEX — idx_ai_events_user
  • INDEX — idx_ai_events_prompt
  • INDEX — idx_ai_events_video

es_environment_metadata

  • id — BIGINT
  • es_doc_id — VARCHAR(255) — NOT NULL
  • location — VARCHAR(255)
  • location_id — VARCHAR(255)
  • recorded_at — VARCHAR(255)
  • indexed_at — DATETIME
  • source — VARCHAR(255)

es_reddit_metadata

  • id — BIGINT
  • subreddit — VARCHAR(100) — NOT NULL
  • title — TEXT — NOT NULL
  • reddit_id — VARCHAR(40) — NOT NULL
  • es_doc_id — VARCHAR(200) — NOT NULL
  • num_comments — INT
  • score — INT
  • upvote_ratio — DECIMAL(4,3)
  • posted_at — TIMESTAMP — NOT NULL
  • indexed_at — TIMESTAMP — NOT NULL
  • INDEX — idx_reddit_meta_subreddit
  • INDEX — idx_reddit_meta_posted_at
  • INDEX — idx_reddit_meta_subreddit_posted

es_youtube_metadata

  • ytdata_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • es_doc_id — VARCHAR(255) — NOT NULL
  • channel_id — VARCHAR(255) — NOT NULL
  • indexed_at — DATETIME

google_token

  • id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.user_id
  • access_token — TEXT — NOT NULL
  • refresh_token — TEXT
  • expires_at — TIMESTAMP — NOT NULL
  • youtube_channel_id — VARCHAR(64)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

job_results

  • result_id — BIGINT — Primary key
  • job_id — BIGINT — Foreign key → jobs.job_id
  • status — VARCHAR(20) — NOT NULL
  • result_type — VARCHAR(20) — NOT NULL
  • result_key — VARCHAR(500) — NOT NULL
  • prompt — TEXT
  • created_at — TIMESTAMP

jobs

  • job_id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.user_id
  • status — VARCHAR(20) — NOT NULL
  • purpose — VARCHAR(50) — NOT NULL
  • location_code — VARCHAR(20)
  • prompt_text — TEXT
  • source_image_key — VARCHAR(500)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

kafka_message

  • id — BIGINT
  • source — VARCHAR(255)
  • ts — BIGINT
  • temp — DOUBLE
  • humidity — DOUBLE
  • rawJson — TEXT

reddit_token

  • id — BIGINT — Primary key
  • user_id — BIGINT — Foreign key → users.user_id
  • reddit_user_id — VARCHAR(40)
  • reddit_username — VARCHAR(100)
  • access_token — LONGTEXT — NOT NULL
  • refresh_token — LONGTEXT
  • token_type — VARCHAR(20)
  • expires_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • user_id — BIGINT — Primary key
  • username — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL