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