Pagila Movie Database Schema
Open Knowledge Format specification for the Pagila PostgreSQL movie rental database schema, including all entities, relationships, and metad
Open source Repository Open in the app JSON
About
# Pagila Movie Database Schema
This OKF bundle documents the complete database schema for the Pagila movie rental system, including all entities, relationships, indexes, and constraints.
## Overview
Pagila is a sample database based on the famous `sakila` database used by PostgreSQL tutorials. It models a movie rental business with:
- Customer management and addresses
- Movie catalog with actors and categories
- Inventory and rental tracking
- Payment and staff management
- Advanced features: embeddings for AI/ML applications
## Browse by Domain
### Documentation
* [README](/README.md) - Complete guide for using this OKF bundle
* [OKF Concept](/concepts/okf-concept.md) - Understanding OKF format and conventions
* [RBAC System](/docs/security/rbac-system.md) - RBAC implementation details
* [Metrics System](/docs/metrics/metrics-system.md) - Metrics system overview
**Developer Documentation**: [docs/](/docs/) - Playbooks, API guides, implementation docs
```
### Core Entities
* [
Details
- Kind
- OKF bundles
- Topic
- Databases
- Publisher
- mbmjava
- Origin
- okf_github
- Category
- dados
- Version
- 0.1
- Added
- 2026-09-09 12:03:57
- Updated
- 2026-09-09 12:03:57
- Origin id
mbmjava/movies:okf/bundle/index.md