dvdrental
Tables (15)
actor
- actor_id — int4 — Primary key — NOT NULL
- first_name — varchar(45) — NOT NULL
- last_name — varchar(45) — NOT NULL
- last_update — timestamp(6) — NOT NULL
address
- address_id — int4 — Primary key — NOT NULL
- address — varchar(50) — NOT NULL
- address2 — varchar(50)
- district — varchar(20) — NOT NULL
- city_id — int2 — Foreign key → city.city_id — NOT NULL
- postal_code — varchar(10)
- phone — varchar(20) — NOT NULL
- last_update — timestamp(6) — NOT NULL
category
- category_id — int4 — Primary key — NOT NULL
- name — varchar(25) — NOT NULL
- last_update — timestamp(6) — NOT NULL
city
- city_id — int4 — Primary key — NOT NULL
- city — varchar(50) — NOT NULL
- country_id — int2 — Foreign key → country.country_id — NOT NULL
- last_update — timestamp(6) — NOT NULL
country
- country_id — int4 — Primary key — NOT NULL
- country — varchar(50) — NOT NULL
- last_update — timestamp(6) — NOT NULL
customer
- customer_id — int4 — Primary key — NOT NULL
- store_id — int2 — NOT NULL
- first_name — varchar(45) — NOT NULL
- last_name — varchar(45) — NOT NULL
- email — varchar(50)
- address_id — int2 — Foreign key → address.address_id — NOT NULL
- activebool — bool — NOT NULL
- create_date — date — NOT NULL
- last_update — timestamp(6)
- active — int4
film
- film_id — int4 — Primary key — NOT NULL
- title — varchar(255) — NOT NULL
- description — text
- release_year — "public"."year"
- language_id — int2 — Foreign key → language.language_id — NOT NULL
- rental_duration — int2 — NOT NULL
- rental_rate — numeric(4,2) — NOT NULL
- length — int2
- replacement_cost — numeric(5,2) — NOT NULL
- rating — "public"."mpaa_rating"
- last_update — timestamp(6) — NOT NULL
- special_features — text
- fulltext — tsvector — NOT NULL
film_actor
- actor_id — int2 — Foreign key → actor.actor_id — NOT NULL
- film_id — int2 — Foreign key → film.film_id — NOT NULL
- last_update — timestamp(6) — NOT NULL
film_category
- category_id — int2 — Foreign key → category.category_id — NOT NULL
- film_id — int2 — Foreign key → film.film_id — NOT NULL
- last_update — timestamp(6) — NOT NULL
inventory
- inventory_id — int4 — Primary key — NOT NULL
- film_id — int2 — Foreign key → film.film_id — NOT NULL
- store_id — int2 — NOT NULL
- last_update — timestamp(6) — NOT NULL
language
- language_id — int4 — Primary key — NOT NULL
- name — char(20) — NOT NULL
- last_update — timestamp(6) — NOT NULL
payment
- payment_id — int4 — Primary key — NOT NULL
- customer_id — int2 — Foreign key → customer.customer_id — NOT NULL
- staff_id — int2 — Foreign key → staff.staff_id — NOT NULL
- rental_id — int4 — Foreign key → rental.rental_id — NOT NULL
- amount — numeric(5,2) — NOT NULL
- payment_date — timestamp(6) — NOT NULL
rental
- rental_id — int4 — Primary key — NOT NULL
- rental_date — timestamp(6) — NOT NULL
- inventory_id — int4 — Foreign key → inventory.inventory_id — NOT NULL
- customer_id — int2 — Foreign key → customer.customer_id — NOT NULL
- return_date — timestamp(6)
- staff_id — int2 — Foreign key → staff.staff_id — NOT NULL
- last_update — timestamp(6) — NOT NULL
staff
- staff_id — int4 — Primary key — NOT NULL
- first_name — varchar(45) — NOT NULL
- last_name — varchar(45) — NOT NULL
- address_id — int2 — Foreign key → address.address_id — NOT NULL
- email — varchar(50)
- store_id — int2 — NOT NULL
- active — bool — NOT NULL
- username — varchar(16) — NOT NULL
- password — varchar(40)
- last_update — timestamp(6) — NOT NULL
- picture — bytea
store
- store_id — int4 — Primary key — NOT NULL
- manager_staff_id — int2 — Foreign key → staff.staff_id — NOT NULL
- address_id — int2 — Foreign key → address.address_id — NOT NULL
- last_update — timestamp(6) — NOT NULL