scenediary
Tables (7)
diaries
- id — BIGINT
- trip_day_id — BIGINT — Foreign key → trip_days.id — NOT NULL
- user_id — BIGINT — NOT NULL
- title — VARCHAR(200)
- content — TEXT — NOT NULL
- tone — VARCHAR(50)
- word_count — INT
- generated_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- tags — VARCHAR(200)
diary_generations
- id — BIGINT
- diary_id — BIGINT — NOT NULL
- model_used — VARCHAR(100) — NOT NULL
- prompt_text — TEXT
- response_text — TEXT
- input_tokens — INT
- output_tokens — INT
- duration_ms — INT
- status — VARCHAR(20) — NOT NULL
- error_message — TEXT
- created_at — TIMESTAMP — NOT NULL
photo_generations
- id — BIGINT
- photo_id — BIGINT — NOT NULL
- model_used — VARCHAR(100) — NOT NULL
- analysis_text — TEXT
- analysis_json — JSON
- input_tokens — INT
- output_tokens — INT
- created_at — TIMESTAMP — NOT NULL
photos
- id — BIGINT
- trip_day_id — BIGINT — Foreign key → trip_days.id — NOT NULL
- user_id — BIGINT — NOT NULL
- file_url — VARCHAR(500) — NOT NULL
- thumbnail_url — VARCHAR(500)
- original_filename — VARCHAR(255)
- file_size_bytes — BIGINT
- mime_type — VARCHAR(50)
- width — INT
- height — INT
- taken_at — TIMESTAMP
- latitude — DECIMAL(10, 7)
- longitude — DECIMAL(10, 7)
- location_name — VARCHAR(300)
- place_id — VARCHAR(200)
- display_order — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
trip_days
- id — BIGINT
- trip_id — BIGINT — Foreign key → trips.id — NOT NULL
- day_number — INT — NOT NULL
- date — DATE — NOT NULL
- location_summary — VARCHAR(200)
- weather — VARCHAR(50)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
trips
- id — BIGINT
- user_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- destination — VARCHAR(200)
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
- cover_photo_id — BIGINT
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
users
- id — BIGINT
- device_id — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(50)
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL — 사용자 (인증 없음, 기기 단위 식별)'; CREATE INDEX idx_users_device_id ON users(device_i