@sakila/pg

sq inspect @ 2026-05-23T04:03:38Z

Property	Value
Name	`sakila`
FQ name	`sakila.public`
Driver	`postgres`
DB product	`PostgreSQL 12.16 on aarch64-unknown-linux-musl, compiled by gcc (Alpine 12.2.1_git20220924-r10) 12.2.1 20220924, 64-bit`
DB version	`12.16`
Schema	`public`
Catalog	`sakila`
Size	`16.6MB`
Tables	`21`
Views	`7`
Location	`postgres://sakila:xxxxx@localhost/sakila`

Entity Relationship Diagram

erDiagram
    actor {
        int actor_id PK
        text first_name
        text last_name
        datetime last_update
    }
    address {
        int address_id PK
        text address
        text address2
        text district
        int city_id FK
        text postal_code
        text phone
        datetime last_update
    }
    category {
        int category_id PK
        text name
        datetime last_update
    }
    city {
        int city_id PK
        text city
        int country_id FK
        datetime last_update
    }
    country {
        int country_id PK
        text country
        datetime last_update
    }
    customer {
        int customer_id PK
        int store_id FK
        text first_name
        text last_name
        text email
        int address_id FK
        bool activebool
        date create_date
        datetime last_update
        int active
    }
    film {
        int film_id PK
        text title
        text description
        int release_year
        int language_id FK
        int original_language_id FK
        int rental_duration
        decimal rental_rate
        int length
        decimal replacement_cost
        unknown rating
        datetime last_update
        unknown special_features
        text fulltext
    }
    film_actor {
        int actor_id PK,FK
        int film_id PK,FK
        datetime last_update
    }
    film_category {
        int film_id PK,FK
        int category_id PK,FK
        datetime last_update
    }
    inventory {
        int inventory_id PK
        int film_id FK
        int store_id FK
        datetime last_update
    }
    language {
        int language_id PK
        text name
        datetime last_update
    }
    payment {
        int payment_id PK
        int customer_id FK
        int staff_id FK
        int rental_id FK
        decimal amount
        datetime payment_date
    }
    payment_p2007_01 {
        int payment_id
        int customer_id FK
        int staff_id FK
        int rental_id FK
        decimal amount
        datetime payment_date
    }
    payment_p2007_02 {
        int payment_id
        int customer_id FK
        int staff_id FK
        int rental_id FK
        decimal amount
        datetime payment_date
    }
    payment_p2007_03 {
        int payment_id
        int customer_id FK
        int staff_id FK
        int rental_id FK
        decimal amount
        datetime payment_date
    }
    payment_p2007_04 {
        int payment_id
        int customer_id FK
        int staff_id FK
        int rental_id FK
        decimal amount
        datetime payment_date
    }
    payment_p2007_05 {
        int payment_id
        int customer_id FK
        int staff_id FK
        int rental_id FK
        decimal amount
        datetime payment_date
    }
    payment_p2007_06 {
        int payment_id
        int customer_id FK
        int staff_id FK
        int rental_id FK
        decimal amount
        datetime payment_date
    }
    rental {
        int rental_id PK
        datetime rental_date
        int inventory_id FK
        int customer_id FK
        datetime return_date
        int staff_id FK
        datetime last_update
    }
    staff {
        int staff_id PK
        text first_name
        text last_name
        int address_id FK
        text email
        int store_id FK
        bool active
        text username
        text password
        datetime last_update
        bytes picture
    }
    store {
        int store_id PK
        int manager_staff_id FK
        int address_id FK
        datetime last_update
    }
    actor_info {
        int actor_id
        text first_name
        text last_name
        text film_info
    }
    customer_list {
        int id
        text name
        text address
        text zip_code
        text phone
        text city
        text country
        text notes
        int sid
    }
    film_list {
        int fid
        text title
        text description
        text category
        decimal price
        int length
        unknown rating
        text actors
    }
    nicer_but_slower_film_list {
        int fid
        text title
        text description
        text category
        decimal price
        int length
        unknown rating
        text actors
    }
    sales_by_film_category {
        text category
        decimal total_sales
    }
    sales_by_store {
        text store
        text manager
        decimal total_sales
    }
    staff_list {
        int id
        text name
        text address
        text zip_code
        text phone
        text city
        text country
        int sid
    }
    city ||--o{ address : "address_city_id_fkey"
    country ||--o{ city : "city_country_id_fkey"
    address ||--o{ customer : "customer_address_id_fkey"
    store ||--o{ customer : "customer_store_id_fkey"
    language |o--o{ film : "film_original_language_id_fkey"
    language ||--o{ film : "film_language_id_fkey"
    actor ||--o{ film_actor : "film_actor_actor_id_fkey"
    film ||--o{ film_actor : "film_actor_film_id_fkey"
    category ||--o{ film_category : "film_category_category_id_fkey"
    film ||--o{ film_category : "film_category_film_id_fkey"
    film ||--o{ inventory : "inventory_film_id_fkey"
    store ||--o{ inventory : "inventory_store_id_fkey"
    customer ||--o{ payment : "payment_customer_id_fkey"
    rental ||--o{ payment : "payment_rental_id_fkey"
    staff ||--o{ payment : "payment_staff_id_fkey"
    customer ||--o{ payment_p2007_01 : "payment_p2007_01_customer_id_fkey"
    rental ||--o{ payment_p2007_01 : "payment_p2007_01_rental_id_fkey"
    staff ||--o{ payment_p2007_01 : "payment_p2007_01_staff_id_fkey"
    customer ||--o{ payment_p2007_02 : "payment_p2007_02_customer_id_fkey"
    rental ||--o{ payment_p2007_02 : "payment_p2007_02_rental_id_fkey"
    staff ||--o{ payment_p2007_02 : "payment_p2007_02_staff_id_fkey"
    customer ||--o{ payment_p2007_03 : "payment_p2007_03_customer_id_fkey"
    rental ||--o{ payment_p2007_03 : "payment_p2007_03_rental_id_fkey"
    staff ||--o{ payment_p2007_03 : "payment_p2007_03_staff_id_fkey"
    customer ||--o{ payment_p2007_04 : "payment_p2007_04_customer_id_fkey"
    rental ||--o{ payment_p2007_04 : "payment_p2007_04_rental_id_fkey"
    staff ||--o{ payment_p2007_04 : "payment_p2007_04_staff_id_fkey"
    customer ||--o{ payment_p2007_05 : "payment_p2007_05_customer_id_fkey"
    rental ||--o{ payment_p2007_05 : "payment_p2007_05_rental_id_fkey"
    staff ||--o{ payment_p2007_05 : "payment_p2007_05_staff_id_fkey"
    customer ||--o{ payment_p2007_06 : "payment_p2007_06_customer_id_fkey"
    rental ||--o{ payment_p2007_06 : "payment_p2007_06_rental_id_fkey"
    staff ||--o{ payment_p2007_06 : "payment_p2007_06_staff_id_fkey"
    customer ||--o{ rental : "rental_customer_id_fkey"
    inventory ||--o{ rental : "rental_inventory_id_fkey"
    staff ||--o{ rental : "rental_staff_id_fkey"
    address ||--o{ staff : "staff_address_id_fkey"
    store ||--o{ staff : "staff_store_id_fkey"
    address ||--o{ store : "store_address_id_fkey"
    staff ||--o{ store : "store_manager_staff_id_fkey"

Tables & views

`actor`

table · 200 rows · 72.0KB

Entity Relationship Diagram

erDiagram
    actor {
        int actor_id PK
        text first_name
        text last_name
        datetime last_update
    }
    actor ||--o{ film_actor : "film_actor_actor_id_fkey"

Columns
Column	Type	PK	Default
`actor_id`	`integer`	✓	`nextval('actor_actor_id_seq'::regclass)`
`first_name`	`character varying`
`last_name`	`character varying`
`last_update`	`timestamp without time zone`		`now()`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`actor_id` ← `film_actor.actor_id`	`film_actor_actor_id_fkey`	cascade	restrict

Indexes
Index	Columns	Unique	Primary	Type
`actor_pkey`	`actor_id`	✓	✓	btree
`idx_actor_last_name`	`last_name`			btree

`address`

table · 603 rows · 144.0KB

Entity Relationship Diagram

erDiagram
    address {
        int address_id PK
        text address
        text address2
        text district
        int city_id FK
        text postal_code
        text phone
        datetime last_update
    }
    city ||--o{ address : "address_city_id_fkey"
    address ||--o{ customer : "customer_address_id_fkey"
    address ||--o{ staff : "staff_address_id_fkey"
    address ||--o{ store : "store_address_id_fkey"

Columns
Column	Type	Nullable	PK	FK	Default
`address_id`	`integer`		✓		`nextval('address_address_id_seq'::regclass)`
`address`	`character varying`
`address2`	`character varying`	✓
`district`	`character varying`
`city_id`	`smallint`			✓
`postal_code`	`character varying`	✓
`phone`	`character varying`
`last_update`	`timestamp without time zone`				`now()`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`city_id` → `city.city_id`	`address_city_id_fkey`	cascade	restrict
`address_id` ← `customer.address_id`	`customer_address_id_fkey`	cascade	restrict
`address_id` ← `staff.address_id`	`staff_address_id_fkey`	cascade	restrict
`address_id` ← `store.address_id`	`store_address_id_fkey`	cascade	restrict

Indexes
Index	Columns	Unique	Primary	Type
`address_pkey`	`address_id`	✓	✓	btree
`idx_fk_city_id`	`city_id`			btree

`category`

table · 16 rows · 24.0KB

Entity Relationship Diagram

erDiagram
    category {
        int category_id PK
        text name
        datetime last_update
    }
    category ||--o{ film_category : "film_category_category_id_fkey"

Columns
Column	Type	PK	Default
`category_id`	`integer`	✓	`nextval('category_category_id_seq'::regclass)`
`name`	`character varying`
`last_update`	`timestamp without time zone`		`now()`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`category_id` ← `film_category.category_id`	`film_category_category_id_fkey`	cascade	restrict

Indexes
Index	Columns	Unique	Primary	Type
`category_pkey`	`category_id`	✓	✓	btree

`city`

table · 600 rows · 136.0KB

Entity Relationship Diagram

erDiagram
    city {
        int city_id PK
        text city
        int country_id FK
        datetime last_update
    }
    city ||--o{ address : "address_city_id_fkey"
    country ||--o{ city : "city_country_id_fkey"

Columns
Column	Type	PK	FK	Default
`city_id`	`integer`	✓		`nextval('city_city_id_seq'::regclass)`
`city`	`character varying`
`country_id`	`smallint`		✓
`last_update`	`timestamp without time zone`			`now()`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`country_id` → `country.country_id`	`city_country_id_fkey`	cascade	restrict
`city_id` ← `address.city_id`	`address_city_id_fkey`	cascade	restrict

Indexes
Index	Columns	Unique	Primary	Type
`city_pkey`	`city_id`	✓	✓	btree
`idx_fk_country_id`	`country_id`			btree

`country`

table · 109 rows · 24.0KB

Entity Relationship Diagram

erDiagram
    country {
        int country_id PK
        text country
        datetime last_update
    }
    country ||--o{ city : "city_country_id_fkey"

Columns
Column	Type	PK	Default
`country_id`	`integer`	✓	`nextval('country_country_id_seq'::regclass)`
`country`	`character varying`
`last_update`	`timestamp without time zone`		`now()`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`country_id` ← `city.country_id`	`city_country_id_fkey`	cascade	restrict

Indexes
Index	Columns	Unique	Primary	Type
`country_pkey`	`country_id`	✓	✓	btree

`customer`

table · 599 rows · 232.0KB

Entity Relationship Diagram

erDiagram
    customer {
        int customer_id PK
        int store_id FK
        text first_name
        text last_name
        text email
        int address_id FK
        bool activebool
        date create_date
        datetime last_update
        int active
    }
    address ||--o{ customer : "customer_address_id_fkey"
    store ||--o{ customer : "customer_store_id_fkey"
    customer ||--o{ payment : "payment_customer_id_fkey"
    customer ||--o{ payment_p2007_01 : "payment_p2007_01_customer_id_fkey"
    customer ||--o{ payment_p2007_02 : "payment_p2007_02_customer_id_fkey"
    customer ||--o{ payment_p2007_03 : "payment_p2007_03_customer_id_fkey"
    customer ||--o{ payment_p2007_04 : "payment_p2007_04_customer_id_fkey"
    customer ||--o{ payment_p2007_05 : "payment_p2007_05_customer_id_fkey"
    customer ||--o{ payment_p2007_06 : "payment_p2007_06_customer_id_fkey"
    customer ||--o{ rental : "rental_customer_id_fkey"

Columns
Column	Type	Nullable	PK	FK	Default
`customer_id`	`integer`		✓		`nextval('customer_customer_id_seq'::regclass)`
`store_id`	`smallint`			✓
`first_name`	`character varying`
`last_name`	`character varying`
`email`	`character varying`	✓
`address_id`	`smallint`			✓
`activebool`	`boolean`				`true`
`create_date`	`date`				`('now'::text)::date`
`last_update`	`timestamp without time zone`	✓			`now()`
`active`	`integer`	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`address_id` → `address.address_id`	`customer_address_id_fkey`	cascade	restrict
`store_id` → `store.store_id`	`customer_store_id_fkey`	cascade	restrict
`customer_id` ← `payment.customer_id`	`payment_customer_id_fkey`	cascade	restrict
`customer_id` ← `payment_p2007_01.customer_id`	`payment_p2007_01_customer_id_fkey`
`customer_id` ← `payment_p2007_02.customer_id`	`payment_p2007_02_customer_id_fkey`
`customer_id` ← `payment_p2007_03.customer_id`	`payment_p2007_03_customer_id_fkey`
`customer_id` ← `payment_p2007_04.customer_id`	`payment_p2007_04_customer_id_fkey`
`customer_id` ← `payment_p2007_05.customer_id`	`payment_p2007_05_customer_id_fkey`
`customer_id` ← `payment_p2007_06.customer_id`	`payment_p2007_06_customer_id_fkey`
`customer_id` ← `rental.customer_id`	`rental_customer_id_fkey`	cascade	restrict

Indexes
Index	Columns	Unique	Primary	Type
`customer_pkey`	`customer_id`	✓	✓	btree
`idx_fk_address_id`	`address_id`			btree
`idx_fk_store_id`	`store_id`			btree
`idx_last_name`	`last_name`			btree

`film`

table · 1000 rows · 728.0KB

Entity Relationship Diagram

erDiagram
    film {
        int film_id PK
        text title
        text description
        int release_year
        int language_id FK
        int original_language_id FK
        int rental_duration
        decimal rental_rate
        int length
        decimal replacement_cost
        unknown rating
        datetime last_update
        unknown special_features
        text fulltext
    }
    language |o--o{ film : "film_original_language_id_fkey"
    language ||--o{ film : "film_language_id_fkey"
    film ||--o{ film_actor : "film_actor_film_id_fkey"
    film ||--o{ film_category : "film_category_film_id_fkey"
    film ||--o{ inventory : "inventory_film_id_fkey"

Columns
Column	Type	Nullable	PK	FK	Default
`film_id`	`integer`		✓		`nextval('film_film_id_seq'::regclass)`
`title`	`character varying`
`description`	`text`	✓
`release_year`	`integer`	✓
`language_id`	`smallint`			✓
`original_language_id`	`smallint`	✓		✓
`rental_duration`	`smallint`				`3`
`rental_rate`	`numeric`				`4.99`
`length`	`smallint`	✓
`replacement_cost`	`numeric`				`19.99`
`rating`	`USER-DEFINED`	✓			`'G'::mpaa_rating`
`last_update`	`timestamp without time zone`				`now()`
`special_features`	`ARRAY`	✓
`fulltext`	`tsvector`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`language_id` → `language.language_id`	`film_language_id_fkey`	cascade	restrict
`original_language_id` → `language.language_id`	`film_original_language_id_fkey`	cascade	restrict
`film_id` ← `film_actor.film_id`	`film_actor_film_id_fkey`	cascade	restrict
`film_id` ← `film_category.film_id`	`film_category_film_id_fkey`	cascade	restrict
`film_id` ← `inventory.film_id`	`inventory_film_id_fkey`	cascade	restrict

Indexes
Index	Columns	Unique	Primary	Type
`film_fulltext_idx`	`fulltext`			gist
`film_pkey`	`film_id`	✓	✓	btree
`idx_fk_language_id`	`language_id`			btree
`idx_fk_original_language_id`	`original_language_id`			btree
`idx_title`	`title`			btree

`film_actor`

table · 5462 rows · 568.0KB

Entity Relationship Diagram

erDiagram
    film_actor {
        int actor_id PK,FK
        int film_id PK,FK
        datetime last_update
    }
    actor ||--o{ film_actor : "film_actor_actor_id_fkey"
    film ||--o{ film_actor : "film_actor_film_id_fkey"

Columns
Column	Type	PK	FK	Default
`actor_id`	`smallint`	✓	✓
`film_id`	`smallint`	✓	✓
`last_update`	`timestamp without time zone`			`now()`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`actor_id` → `actor.actor_id`	`film_actor_actor_id_fkey`	cascade	restrict
`film_id` → `film.film_id`	`film_actor_film_id_fkey`	cascade	restrict

Indexes
Index	Columns	Unique	Primary	Type
`film_actor_pkey`	`actor_id, film_id`	✓	✓	btree
`idx_fk_film_id`	`film_id`			btree

`film_category`

table · 1000 rows · 112.0KB

Entity Relationship Diagram

erDiagram
    film_category {
        int film_id PK,FK
        int category_id PK,FK
        datetime last_update
    }
    category ||--o{ film_category : "film_category_category_id_fkey"
    film ||--o{ film_category : "film_category_film_id_fkey"

Columns
Column	Type	PK	FK	Default
`film_id`	`smallint`	✓	✓
`category_id`	`smallint`	✓	✓
`last_update`	`timestamp without time zone`			`now()`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`category_id` → `category.category_id`	`film_category_category_id_fkey`	cascade	restrict
`film_id` → `film.film_id`	`film_category_film_id_fkey`	cascade	restrict

Indexes
Index	Columns	Unique	Primary	Type
`film_category_pkey`	`film_id, category_id`	✓	✓	btree

`inventory`

table · 4581 rows · 488.0KB

Entity Relationship Diagram

erDiagram
    inventory {
        int inventory_id PK
        int film_id FK
        int store_id FK
        datetime last_update
    }
    film ||--o{ inventory : "inventory_film_id_fkey"
    store ||--o{ inventory : "inventory_store_id_fkey"
    inventory ||--o{ rental : "rental_inventory_id_fkey"

Columns
Column	Type	PK	FK	Default
`inventory_id`	`integer`	✓		`nextval('inventory_inventory_id_seq'::regclass)`
`film_id`	`smallint`		✓
`store_id`	`smallint`		✓
`last_update`	`timestamp without time zone`			`now()`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`film_id` → `film.film_id`	`inventory_film_id_fkey`	cascade	restrict
`store_id` → `store.store_id`	`inventory_store_id_fkey`	cascade	restrict
`inventory_id` ← `rental.inventory_id`	`rental_inventory_id_fkey`	cascade	restrict

Indexes
Index	Columns	Unique	Primary	Type
`idx_store_id_film_id`	`store_id, film_id`			btree
`inventory_pkey`	`inventory_id`	✓	✓	btree

`language`

table · 6 rows · 24.0KB

Entity Relationship Diagram

erDiagram
    language {
        int language_id PK
        text name
        datetime last_update
    }
    language |o--o{ film : "film_original_language_id_fkey"
    language ||--o{ film : "film_language_id_fkey"

Columns
Column	Type	PK	Default
`language_id`	`integer`	✓	`nextval('language_language_id_seq'::regclass)`
`name`	`character`
`last_update`	`timestamp without time zone`		`now()`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`language_id` ← `film.language_id`	`film_language_id_fkey`	cascade	restrict
`language_id` ← `film.original_language_id`	`film_original_language_id_fkey`	cascade	restrict

Indexes
Index	Columns	Unique	Primary	Type
`language_pkey`	`language_id`	✓	✓	btree

`payment`

table · 16049 rows · 2.0MB

Entity Relationship Diagram

erDiagram
    payment {
        int payment_id PK
        int customer_id FK
        int staff_id FK
        int rental_id FK
        decimal amount
        datetime payment_date
    }
    customer ||--o{ payment : "payment_customer_id_fkey"
    rental ||--o{ payment : "payment_rental_id_fkey"
    staff ||--o{ payment : "payment_staff_id_fkey"

Columns
Column	Type	PK	FK	Default
`payment_id`	`integer`	✓		`nextval('payment_payment_id_seq'::regclass)`
`customer_id`	`smallint`		✓
`staff_id`	`smallint`		✓
`rental_id`	`integer`		✓
`amount`	`numeric`
`payment_date`	`timestamp without time zone`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`customer_id` → `customer.customer_id`	`payment_customer_id_fkey`	cascade	restrict
`rental_id` → `rental.rental_id`	`payment_rental_id_fkey`	cascade	set null
`staff_id` → `staff.staff_id`	`payment_staff_id_fkey`	cascade	restrict

Indexes
Index	Columns	Unique	Primary	Type
`idx_fk_customer_id`	`customer_id`			btree
`idx_fk_staff_id`	`staff_id`			btree
`payment_pkey`	`payment_id`	✓	✓	btree

`payment_p2007_01`

table · 0 rows · 16.0KB

Entity Relationship Diagram

erDiagram
    payment_p2007_01 {
        int payment_id
        int customer_id FK
        int staff_id FK
        int rental_id FK
        decimal amount
        datetime payment_date
    }
    customer ||--o{ payment_p2007_01 : "payment_p2007_01_customer_id_fkey"
    rental ||--o{ payment_p2007_01 : "payment_p2007_01_rental_id_fkey"
    staff ||--o{ payment_p2007_01 : "payment_p2007_01_staff_id_fkey"

Columns
Column	Type	FK	Default
`payment_id`	`integer`		`nextval('payment_payment_id_seq'::regclass)`
`customer_id`	`smallint`	✓
`staff_id`	`smallint`	✓
`rental_id`	`integer`	✓
`amount`	`numeric`
`payment_date`	`timestamp without time zone`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`customer_id` → `customer.customer_id`	`payment_p2007_01_customer_id_fkey`
`rental_id` → `rental.rental_id`	`payment_p2007_01_rental_id_fkey`
`staff_id` → `staff.staff_id`	`payment_p2007_01_staff_id_fkey`

Indexes
Index	Columns	Unique	Primary	Type
`idx_fk_payment_p2007_01_customer_id`	`customer_id`			btree
`idx_fk_payment_p2007_01_staff_id`	`staff_id`			btree

`payment_p2007_02`

table · 0 rows · 16.0KB

Entity Relationship Diagram

erDiagram
    payment_p2007_02 {
        int payment_id
        int customer_id FK
        int staff_id FK
        int rental_id FK
        decimal amount
        datetime payment_date
    }
    customer ||--o{ payment_p2007_02 : "payment_p2007_02_customer_id_fkey"
    rental ||--o{ payment_p2007_02 : "payment_p2007_02_rental_id_fkey"
    staff ||--o{ payment_p2007_02 : "payment_p2007_02_staff_id_fkey"

Columns
Column	Type	FK	Default
`payment_id`	`integer`		`nextval('payment_payment_id_seq'::regclass)`
`customer_id`	`smallint`	✓
`staff_id`	`smallint`	✓
`rental_id`	`integer`	✓
`amount`	`numeric`
`payment_date`	`timestamp without time zone`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`customer_id` → `customer.customer_id`	`payment_p2007_02_customer_id_fkey`
`rental_id` → `rental.rental_id`	`payment_p2007_02_rental_id_fkey`
`staff_id` → `staff.staff_id`	`payment_p2007_02_staff_id_fkey`

Indexes
Index	Columns	Unique	Primary	Type
`idx_fk_payment_p2007_02_customer_id`	`customer_id`			btree
`idx_fk_payment_p2007_02_staff_id`	`staff_id`			btree

`payment_p2007_03`

table · 0 rows · 16.0KB

Entity Relationship Diagram

erDiagram
    payment_p2007_03 {
        int payment_id
        int customer_id FK
        int staff_id FK
        int rental_id FK
        decimal amount
        datetime payment_date
    }
    customer ||--o{ payment_p2007_03 : "payment_p2007_03_customer_id_fkey"
    rental ||--o{ payment_p2007_03 : "payment_p2007_03_rental_id_fkey"
    staff ||--o{ payment_p2007_03 : "payment_p2007_03_staff_id_fkey"

Columns
Column	Type	FK	Default
`payment_id`	`integer`		`nextval('payment_payment_id_seq'::regclass)`
`customer_id`	`smallint`	✓
`staff_id`	`smallint`	✓
`rental_id`	`integer`	✓
`amount`	`numeric`
`payment_date`	`timestamp without time zone`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`customer_id` → `customer.customer_id`	`payment_p2007_03_customer_id_fkey`
`rental_id` → `rental.rental_id`	`payment_p2007_03_rental_id_fkey`
`staff_id` → `staff.staff_id`	`payment_p2007_03_staff_id_fkey`

Indexes
Index	Columns	Unique	Primary	Type
`idx_fk_payment_p2007_03_customer_id`	`customer_id`			btree
`idx_fk_payment_p2007_03_staff_id`	`staff_id`			btree

`payment_p2007_04`

table · 0 rows · 16.0KB

Entity Relationship Diagram

erDiagram
    payment_p2007_04 {
        int payment_id
        int customer_id FK
        int staff_id FK
        int rental_id FK
        decimal amount
        datetime payment_date
    }
    customer ||--o{ payment_p2007_04 : "payment_p2007_04_customer_id_fkey"
    rental ||--o{ payment_p2007_04 : "payment_p2007_04_rental_id_fkey"
    staff ||--o{ payment_p2007_04 : "payment_p2007_04_staff_id_fkey"

Columns
Column	Type	FK	Default
`payment_id`	`integer`		`nextval('payment_payment_id_seq'::regclass)`
`customer_id`	`smallint`	✓
`staff_id`	`smallint`	✓
`rental_id`	`integer`	✓
`amount`	`numeric`
`payment_date`	`timestamp without time zone`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`customer_id` → `customer.customer_id`	`payment_p2007_04_customer_id_fkey`
`rental_id` → `rental.rental_id`	`payment_p2007_04_rental_id_fkey`
`staff_id` → `staff.staff_id`	`payment_p2007_04_staff_id_fkey`

Indexes
Index	Columns	Unique	Primary	Type
`idx_fk_payment_p2007_04_customer_id`	`customer_id`			btree
`idx_fk_payment_p2007_04_staff_id`	`staff_id`			btree

`payment_p2007_05`

table · 0 rows · 16.0KB

Entity Relationship Diagram

erDiagram
    payment_p2007_05 {
        int payment_id
        int customer_id FK
        int staff_id FK
        int rental_id FK
        decimal amount
        datetime payment_date
    }
    customer ||--o{ payment_p2007_05 : "payment_p2007_05_customer_id_fkey"
    rental ||--o{ payment_p2007_05 : "payment_p2007_05_rental_id_fkey"
    staff ||--o{ payment_p2007_05 : "payment_p2007_05_staff_id_fkey"

Columns
Column	Type	FK	Default
`payment_id`	`integer`		`nextval('payment_payment_id_seq'::regclass)`
`customer_id`	`smallint`	✓
`staff_id`	`smallint`	✓
`rental_id`	`integer`	✓
`amount`	`numeric`
`payment_date`	`timestamp without time zone`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`customer_id` → `customer.customer_id`	`payment_p2007_05_customer_id_fkey`
`rental_id` → `rental.rental_id`	`payment_p2007_05_rental_id_fkey`
`staff_id` → `staff.staff_id`	`payment_p2007_05_staff_id_fkey`

Indexes
Index	Columns	Unique	Primary	Type
`idx_fk_payment_p2007_05_customer_id`	`customer_id`			btree
`idx_fk_payment_p2007_05_staff_id`	`staff_id`			btree

`payment_p2007_06`

table · 0 rows · 16.0KB

Entity Relationship Diagram

erDiagram
    payment_p2007_06 {
        int payment_id
        int customer_id FK
        int staff_id FK
        int rental_id FK
        decimal amount
        datetime payment_date
    }
    customer ||--o{ payment_p2007_06 : "payment_p2007_06_customer_id_fkey"
    rental ||--o{ payment_p2007_06 : "payment_p2007_06_rental_id_fkey"
    staff ||--o{ payment_p2007_06 : "payment_p2007_06_staff_id_fkey"

Columns
Column	Type	FK	Default
`payment_id`	`integer`		`nextval('payment_payment_id_seq'::regclass)`
`customer_id`	`smallint`	✓
`staff_id`	`smallint`	✓
`rental_id`	`integer`	✓
`amount`	`numeric`
`payment_date`	`timestamp without time zone`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`customer_id` → `customer.customer_id`	`payment_p2007_06_customer_id_fkey`
`rental_id` → `rental.rental_id`	`payment_p2007_06_rental_id_fkey`
`staff_id` → `staff.staff_id`	`payment_p2007_06_staff_id_fkey`

Indexes
Index	Columns	Unique	Primary	Type
`idx_fk_payment_p2007_06_customer_id`	`customer_id`			btree
`idx_fk_payment_p2007_06_staff_id`	`staff_id`			btree

`rental`

table · 16044 rows · 2.7MB

Entity Relationship Diagram

erDiagram
    rental {
        int rental_id PK
        datetime rental_date
        int inventory_id FK
        int customer_id FK
        datetime return_date
        int staff_id FK
        datetime last_update
    }
    rental ||--o{ payment : "payment_rental_id_fkey"
    rental ||--o{ payment_p2007_01 : "payment_p2007_01_rental_id_fkey"
    rental ||--o{ payment_p2007_02 : "payment_p2007_02_rental_id_fkey"
    rental ||--o{ payment_p2007_03 : "payment_p2007_03_rental_id_fkey"
    rental ||--o{ payment_p2007_04 : "payment_p2007_04_rental_id_fkey"
    rental ||--o{ payment_p2007_05 : "payment_p2007_05_rental_id_fkey"
    rental ||--o{ payment_p2007_06 : "payment_p2007_06_rental_id_fkey"
    customer ||--o{ rental : "rental_customer_id_fkey"
    inventory ||--o{ rental : "rental_inventory_id_fkey"
    staff ||--o{ rental : "rental_staff_id_fkey"

Columns
Column	Type	Nullable	PK	FK	Default
`rental_id`	`integer`		✓		`nextval('rental_rental_id_seq'::regclass)`
`rental_date`	`timestamp without time zone`
`inventory_id`	`integer`			✓
`customer_id`	`smallint`			✓
`return_date`	`timestamp without time zone`	✓
`staff_id`	`smallint`			✓
`last_update`	`timestamp without time zone`				`now()`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`customer_id` → `customer.customer_id`	`rental_customer_id_fkey`	cascade	restrict
`inventory_id` → `inventory.inventory_id`	`rental_inventory_id_fkey`	cascade	restrict
`staff_id` → `staff.staff_id`	`rental_staff_id_fkey`	cascade	restrict
`rental_id` ← `payment_p2007_01.rental_id`	`payment_p2007_01_rental_id_fkey`
`rental_id` ← `payment_p2007_02.rental_id`	`payment_p2007_02_rental_id_fkey`
`rental_id` ← `payment_p2007_03.rental_id`	`payment_p2007_03_rental_id_fkey`
`rental_id` ← `payment_p2007_04.rental_id`	`payment_p2007_04_rental_id_fkey`
`rental_id` ← `payment_p2007_05.rental_id`	`payment_p2007_05_rental_id_fkey`
`rental_id` ← `payment_p2007_06.rental_id`	`payment_p2007_06_rental_id_fkey`
`rental_id` ← `payment.rental_id`	`payment_rental_id_fkey`	cascade	set null

Indexes
Index	Columns	Unique	Primary	Type
`idx_fk_inventory_id`	`inventory_id`			btree
`idx_unq_rental_rental_date_inventory_id_customer_id`	`rental_date, inventory_id, customer_id`	✓		btree
`rental_pkey`	`rental_id`	✓	✓	btree

`staff`

table · 2 rows · 32.0KB

Entity Relationship Diagram

erDiagram
    staff {
        int staff_id PK
        text first_name
        text last_name
        int address_id FK
        text email
        int store_id FK
        bool active
        text username
        text password
        datetime last_update
        bytes picture
    }
    staff ||--o{ payment : "payment_staff_id_fkey"
    staff ||--o{ payment_p2007_01 : "payment_p2007_01_staff_id_fkey"
    staff ||--o{ payment_p2007_02 : "payment_p2007_02_staff_id_fkey"
    staff ||--o{ payment_p2007_03 : "payment_p2007_03_staff_id_fkey"
    staff ||--o{ payment_p2007_04 : "payment_p2007_04_staff_id_fkey"
    staff ||--o{ payment_p2007_05 : "payment_p2007_05_staff_id_fkey"
    staff ||--o{ payment_p2007_06 : "payment_p2007_06_staff_id_fkey"
    staff ||--o{ rental : "rental_staff_id_fkey"
    address ||--o{ staff : "staff_address_id_fkey"
    store ||--o{ staff : "staff_store_id_fkey"
    staff ||--o{ store : "store_manager_staff_id_fkey"

Columns
Column	Type	Nullable	PK	FK	Default
`staff_id`	`integer`		✓		`nextval('staff_staff_id_seq'::regclass)`
`first_name`	`character varying`
`last_name`	`character varying`
`address_id`	`smallint`			✓
`email`	`character varying`	✓
`store_id`	`smallint`			✓
`active`	`boolean`				`true`
`username`	`character varying`
`password`	`character varying`	✓
`last_update`	`timestamp without time zone`				`now()`
`picture`	`bytea`	✓

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`address_id` → `address.address_id`	`staff_address_id_fkey`	cascade	restrict
`store_id` → `store.store_id`	`staff_store_id_fkey`
`staff_id` ← `payment_p2007_01.staff_id`	`payment_p2007_01_staff_id_fkey`
`staff_id` ← `payment_p2007_02.staff_id`	`payment_p2007_02_staff_id_fkey`
`staff_id` ← `payment_p2007_03.staff_id`	`payment_p2007_03_staff_id_fkey`
`staff_id` ← `payment_p2007_04.staff_id`	`payment_p2007_04_staff_id_fkey`
`staff_id` ← `payment_p2007_05.staff_id`	`payment_p2007_05_staff_id_fkey`
`staff_id` ← `payment_p2007_06.staff_id`	`payment_p2007_06_staff_id_fkey`
`staff_id` ← `payment.staff_id`	`payment_staff_id_fkey`	cascade	restrict
`staff_id` ← `rental.staff_id`	`rental_staff_id_fkey`	cascade	restrict
`staff_id` ← `store.manager_staff_id`	`store_manager_staff_id_fkey`	cascade	restrict

Indexes
Index	Columns	Unique	Primary	Type
`staff_pkey`	`staff_id`	✓	✓	btree

`store`

table · 2 rows · 40.0KB

Entity Relationship Diagram

erDiagram
    store {
        int store_id PK
        int manager_staff_id FK
        int address_id FK
        datetime last_update
    }
    store ||--o{ customer : "customer_store_id_fkey"
    store ||--o{ inventory : "inventory_store_id_fkey"
    store ||--o{ staff : "staff_store_id_fkey"
    address ||--o{ store : "store_address_id_fkey"
    staff ||--o{ store : "store_manager_staff_id_fkey"

Columns
Column	Type	PK	FK	Default
`store_id`	`integer`	✓		`nextval('store_store_id_seq'::regclass)`
`manager_staff_id`	`smallint`		✓
`address_id`	`smallint`		✓
`last_update`	`timestamp without time zone`			`now()`

Foreign keys
Relationship (→ references · ← referenced by)	Constraint	On update	On delete
`address_id` → `address.address_id`	`store_address_id_fkey`	cascade	restrict
`manager_staff_id` → `staff.staff_id`	`store_manager_staff_id_fkey`	cascade	restrict
`store_id` ← `customer.store_id`	`customer_store_id_fkey`	cascade	restrict
`store_id` ← `inventory.store_id`	`inventory_store_id_fkey`	cascade	restrict
`store_id` ← `staff.store_id`	`staff_store_id_fkey`

Indexes
Index	Columns	Unique	Primary	Type
`idx_unq_manager_staff_id`	`manager_staff_id`	✓		btree
`store_pkey`	`store_id`	✓	✓	btree

`actor_info`

view · 200 rows

Entity Relationship Diagram

erDiagram
    actor_info {
        int actor_id
        text first_name
        text last_name
        text film_info
    }

Columns
Column	Type	Nullable
`actor_id`	`integer`	✓
`first_name`	`character varying`	✓
`last_name`	`character varying`	✓
`film_info`	`text`	✓

`customer_list`

view · 599 rows

Entity Relationship Diagram

erDiagram
    customer_list {
        int id
        text name
        text address
        text zip_code
        text phone
        text city
        text country
        text notes
        int sid
    }

Columns
Column	Type	Nullable
`id`	`integer`	✓
`name`	`text`	✓
`address`	`character varying`	✓
`zip code`	`character varying`	✓
`phone`	`character varying`	✓
`city`	`character varying`	✓
`country`	`character varying`	✓
`notes`	`text`	✓
`sid`	`smallint`	✓

`film_list`

view · 997 rows

Entity Relationship Diagram

erDiagram
    film_list {
        int fid
        text title
        text description
        text category
        decimal price
        int length
        unknown rating
        text actors
    }

Columns
Column	Type	Nullable
`fid`	`integer`	✓
`title`	`character varying`	✓
`description`	`text`	✓
`category`	`character varying`	✓
`price`	`numeric`	✓
`length`	`smallint`	✓
`rating`	`USER-DEFINED`	✓
`actors`	`text`	✓

`nicer_but_slower_film_list`

view · 997 rows

Entity Relationship Diagram

erDiagram
    nicer_but_slower_film_list {
        int fid
        text title
        text description
        text category
        decimal price
        int length
        unknown rating
        text actors
    }

Columns
Column	Type	Nullable
`fid`	`integer`	✓
`title`	`character varying`	✓
`description`	`text`	✓
`category`	`character varying`	✓
`price`	`numeric`	✓
`length`	`smallint`	✓
`rating`	`USER-DEFINED`	✓
`actors`	`text`	✓

`sales_by_film_category`

view · 16 rows

Entity Relationship Diagram

erDiagram
    sales_by_film_category {
        text category
        decimal total_sales
    }

Columns
Column	Type	Nullable	PK	FK
`category`	`character varying`	✓
`total_sales`	`numeric`	✓

`sales_by_store`

view · 2 rows

Entity Relationship Diagram

erDiagram
    sales_by_store {
        text store
        text manager
        decimal total_sales
    }

Columns
Column	Type	Nullable
`store`	`text`	✓
`manager`	`text`	✓
`total_sales`	`numeric`	✓

`staff_list`

view · 2 rows

Entity Relationship Diagram

erDiagram
    staff_list {
        int id
        text name
        text address
        text zip_code
        text phone
        text city
        text country
        int sid
    }

Columns
Column	Type	Nullable
`id`	`integer`	✓
`name`	`text`	✓
`address`	`character varying`	✓
`zip code`	`character varying`	✓
`phone`	`character varying`	✓
`city`	`character varying`	✓
`country`	`character varying`	✓
`sid`	`smallint`	✓