Caestro
Tables (9)
device_specs
- id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → sessions.id — NOT NULL
- role — VARCHAR(20) — NOT NULL
- max_zoom — DECIMAL(5,2)
- min_zoom — DECIMAL(5,2)
- screen_ratio — DECIMAL(7,4)
- max_resolution — VARCHAR(20)
- os_type — VARCHAR(10)
- created_at — DATETIME — NOT NULL
friends
- id — BIGINT — Primary key — NOT NULL
- requester_id — BIGINT — Foreign key → users.id — NOT NULL
- addressee_id — BIGINT — Foreign key → users.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
notifications
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- type — VARCHAR(50) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- body — VARCHAR(500) — NOT NULL
- is_read — TINYINT(1) — NOT NULL
- reference_id — BIGINT
- reference_type — VARCHAR(30)
- created_at — DATETIME — NOT NULL
push_tokens
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- token — VARCHAR(500) — NOT NULL
- device_type — VARCHAR(10) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
sessions
- id — BIGINT — Primary key — NOT NULL
- session_code — VARCHAR(100) — NOT NULL
- director_id — BIGINT — Foreign key → users.id — NOT NULL
- camera_id — BIGINT — Foreign key → users.id
- camera_mode — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- expires_at — DATETIME — NOT NULL
- connected_at — DATETIME
- ended_at — DATETIME
- created_at — DATETIME — NOT NULL
shot_daily_limits
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- date — DATE — NOT NULL
- count — TINYINT — NOT NULL
shots
- id — BIGINT — Primary key — NOT NULL
- session_id — BIGINT — Foreign key → sessions.id
- director_id — BIGINT — Foreign key → users.id — NOT NULL
- camera_id — BIGINT — Foreign key → users.id
- mode — VARCHAR(20) — NOT NULL
- best_cut_score — TINYINT
- width — INT
- height — INT
- 위도 (latitude) — DECIMAL(9,6)
- 경도 (longitude) — DECIMAL(9,6)
- file_size_kb — INT
- image_url — VARCHAR(500)
- is_cloud_backed — TINYINT(1) — NOT NULL
- taken_at — DATETIME — NOT NULL
subscriptions
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- plan — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- started_at — DATETIME — NOT NULL
- expires_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- oauth_provider — VARCHAR(20) — NOT NULL
- oauth_id — VARCHAR(100) — NOT NULL
- nickname — VARCHAR(50)
- profile_image — VARCHAR(500)
- role — VARCHAR(10) — NOT NULL
- created_at — DATETIME — NOT NULL