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)