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