Film archives serve as the custodians of a nation's visual history, offering a window into the past, and providing insights into the societal, cultural, and political climates of bygone eras. For Indonesia, a country with a diverse and dynamic film industry, such archives are crucial in understanding the evolution of its cinema.

| Table | Key Columns | Description | |-------|-------------|-------------| | films | film_id PK , title , release_year , duration , language , censor_rating | Core catalogue. | | film_tags | film_id FK , tag_type (enum: genre, mood, theme, era), tag_value | Auto‑generated tags. | | users | user_id PK , email , created_at , subscription_level | Auth data. | | user_behaviour | user_id FK , film_id FK , event_type (watch, like, rate), timestamp | Interaction log (streamed to Kafka, persisted nightly). | | collections | collection_id PK , name , description , is_dynamic , rule_json , owner_id FK (nullable) , visibility (public/private), pinned_at | Both static and dynamic collections. | | collection_items | collection_id FK , film_id FK , position | Resolved list of films for a collection. | | user_pinned_collections | user_id FK , collection_id FK , pinned_at , order_index | User‑specific shortcuts. |

: For new releases, consider watching movies in the cinema or purchasing/ renting DVDs.