Database

Standar Desain Database

Aturan umum

• gunakan bigint/uuid sesuai kebutuhan identitas publik;
• gunakan foreign key secara konsisten;
• buat index untuk kolom pencarian, sorting, dan relation;
• gunakan soft delete untuk data penting;
• gunakan enum atau constant untuk status yang terbatas;
• timestamps wajib pada tabel inti.

Database Blueprint

Entitas Identity & Access

• users
• user_profiles
• roles
• permissions
• role_permissions
• model_has_roles
• model_has_permissions
• sessions
• user_devices
• auth_logs

Entitas Content Core

• contents
• content_types
• genres
• content_genres
• tags
• content_tags
• content_languages
• content_countries
• content_status_histories

Entitas Type-Specific

• movies
• series
• anime
• videos
• short_dramas
• k_dramas
• mangas
• novels

Entitas Struktur Series

• seasons
• episodes

Entitas Media

• media_assets
• video_sources
• video_manifests
• subtitles
• trailers
• media_jobs

Entitas User Activity

• watch_histories
• watch_progresses
• watchlists
• favorites
• user_notifications

Entitas Social

• comments
• comment_reports
• ratings
• reviews

Entitas Monetization

• plans
• subscriptions
• entitlements
• payment_transactions
• subscription_invoices

Entitas CMS & Marketing

• pages
• page_sections
• banners
• ads
• ad_slots
• news_articles

Entitas Observability

• audit_logs
• system_logs
• failed_jobs
• settings
• feature_flags