cinema-memory
Tables (7)
film_tags
- film_id — BIGINT — Foreign key → films.id — NOT NULL
- tag_id — BIGINT — Foreign key → tags.id — NOT NULL
films
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(160) — NOT NULL
- description — VARCHAR(1000)
- cover_image_url — VARCHAR(700)
- mood — VARCHAR(80)
- visibility — VARCHAR(30) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- INDEX — idx_films_user_created
media_assets
- id — BIGINT — Primary key — NOT NULL
- scene_id — BIGINT — Foreign key → memory_scenes.id
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- s3_key — VARCHAR(700) — NOT NULL
- cdn_url — VARCHAR(700) — NOT NULL
- content_type — VARCHAR(120) — NOT NULL
- byte_size — BIGINT — NOT NULL
- thumbnail_url — VARCHAR(700)
- created_at — DATETIME(6) — NOT NULL
- media_data — LONGBLOB
- file_name — VARCHAR(255) — NOT NULL
- INDEX — idx_media_scene
- INDEX — idx_media_assets_file_name
memory_scenes
- id — BIGINT — Primary key — NOT NULL
- film_id — BIGINT — Foreign key → films.id — NOT NULL
- title — VARCHAR(160) — NOT NULL
- body — TEXT — NOT NULL
- memory_date — DATE
- location — VARCHAR(255)
- mood — VARCHAR(80)
- sort_order — INT — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- INDEX — idx_scenes_film_order
oauth_accounts
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- provider — VARCHAR(40) — NOT NULL
- provider_user_id — VARCHAR(255) — NOT NULL
- email — VARCHAR(255)
- created_at — DATETIME(6) — NOT NULL
tags
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- name — VARCHAR(80) — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255)
- display_name — VARCHAR(120) — NOT NULL
- avatar_url — VARCHAR(500)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- role — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- INDEX — idx_users_role