Dictionary for database `dvdrental`

Server: PostgreSQL localhost:5432, version 13.8 (Ubuntu 13.8-1.pgdg20.04+1)
Local time stamp: 2022-12-28T14:21:53.0587893+01:00
Schema: public

Table public.actor
Table public.address
Table public.category
Table public.city
Table public.country
Table public.customer
Table public.film
Table public.film_actor
Table public.film_category
Table public.inventory
Table public.language
Table public.payment
Table public.rental
Table public.staff
Table public.store
View public.actor_info
View public.customer_list
View public.film_list
View public.nicer_but_slower_film_list
View public.sales_by_film_category
View public.sales_by_store
View public.staff_list
Enum public.mpaa_rating
Function public._group_concat()
Function public.film_in_stock(p_film_id integer, p_store_id integer)
Function public.film_not_in_stock(p_film_id integer, p_store_id integer)
Function public.get_customer_balance(p_customer_id integer, p_effective_date timestamp without time zone)
Function public.inventory_held_by_customer(p_inventory_id integer)
Function public.inventory_in_stock(p_inventory_id integer)
Function public.last_day()
Function public.last_updated()
Function public.rewards_report(min_monthly_purchases integer, min_dollar_amount_purchased numeric)

Tables

Table `public.actor`

Column		Type	Nullable	Default
#`actor_id`	PK	`integer`	NO	`nextval('actor_actor_id_seq'::regclass)`
#`first_name`		`character varying(45)`	NO
#`last_name`	IDX	`character varying(45)`	NO
#`last_update`		`timestamp without time zone`	NO	`now()`

⇡

Table `public.address`

Column		Type	Nullable	Default
#`address_id`	PK	`integer`	NO	`nextval('address_address_id_seq'::regclass)`
#`address`		`character varying(50)`	NO
#`address2`		`character varying(50)`	YES
#`district`		`character varying(20)`	NO
#`city_id`	FK ➝ `city.city_id`, IDX	`smallint`	NO
#`postal_code`		`character varying(10)`	YES
#`phone`		`character varying(20)`	NO
#`last_update`		`timestamp without time zone`	NO	`now()`

⇡

Table `public.category`

Column		Type	Nullable	Default
#`category_id`	PK	`integer`	NO	`nextval('category_category_id_seq'::regclass)`
#`name`		`character varying(25)`	NO
#`last_update`		`timestamp without time zone`	NO	`now()`

⇡

Table `public.city`

Column		Type	Nullable	Default
#`city_id`	PK	`integer`	NO	`nextval('city_city_id_seq'::regclass)`
#`city`		`character varying(50)`	NO
#`country_id`	FK ➝ `country.country_id`, IDX	`smallint`	NO
#`last_update`		`timestamp without time zone`	NO	`now()`

⇡

Table `public.country`

Column		Type	Nullable	Default
#`country_id`	PK	`integer`	NO	`nextval('country_country_id_seq'::regclass)`
#`country`		`character varying(50)`	NO
#`last_update`		`timestamp without time zone`	NO	`now()`

⇡

Table `public.customer`

Column		Type	Nullable	Default
#`customer_id`	PK	`integer`	NO	`nextval('customer_customer_id_seq'::regclass)`
#`store_id`	IDX	`smallint`	NO
#`first_name`		`character varying(45)`	NO
#`last_name`	IDX	`character varying(45)`	NO
#`email`		`character varying(50)`	YES
#`address_id`	FK ➝ `address.address_id`, IDX	`smallint`	NO
#`activebool`		`boolean`	NO	`true`
#`create_date`		`date`	NO	`('now'::text)::date`
#`last_update`		`timestamp without time zone`	YES	`now()`
#`active`		`integer`	YES

⇡

Table `public.film`

Column		Type	Nullable	Default
#`film_id`	PK	`integer`	NO	`nextval('film_film_id_seq'::regclass)`
#`title`	IDX	`character varying(255)`	NO
#`description`		`text`	YES
#`release_year`		`integer`	YES
#`language_id`	FK ➝ `language.language_id`, IDX	`smallint`	NO
#`rental_duration`		`smallint`	NO	`3`
#`rental_rate`		`numeric(4,2)`	NO	`4.99`
#`length`		`smallint`	YES
#`replacement_cost`		`numeric(5,2)`	NO	`19.99`
#`rating`		`mpaa_rating` _{user defined AS ENUM ('G', 'PG', 'PG-13', 'R', 'NC-17') ➝}	YES	`'G'::mpaa_rating`
#`last_update`		`timestamp without time zone`	NO	`now()`
#`special_features`		`text[]`	YES
#`fulltext`	IDX	`tsvector`	NO

⇡

Table `public.film_actor`

Column		Type	Nullable	Default
#`actor_id`	FK ➝ `actor.actor_id`	`smallint`	NO
#`actor_id`	PK	`smallint`	NO
#`film_id`	FK ➝ `film.film_id`, IDX	`smallint`	NO
#`film_id`	PK	`smallint`	NO
#`last_update`		`timestamp without time zone`	NO	`now()`

⇡

Table `public.film_category`

Column		Type	Nullable	Default
#`film_id`	FK ➝ `film.film_id`	`smallint`	NO
#`film_id`	PK	`smallint`	NO
#`category_id`	FK ➝ `category.category_id`	`smallint`	NO
#`category_id`	PK	`smallint`	NO
#`last_update`		`timestamp without time zone`	NO	`now()`

⇡

Table `public.inventory`

Column		Type	Nullable	Default
#`inventory_id`	PK	`integer`	NO	`nextval('inventory_inventory_id_seq'::regclass)`
#`film_id`	FK ➝ `film.film_id`, IDX	`smallint`	NO
#`store_id`	IDX	`smallint`	NO
#`last_update`		`timestamp without time zone`	NO	`now()`

⇡

Table `public.language`

Column		Type	Nullable	Default
#`language_id`	PK	`integer`	NO	`nextval('language_language_id_seq'::regclass)`
#`name`		`character(20)`	NO
#`last_update`		`timestamp without time zone`	NO	`now()`

⇡

Table `public.payment`

Column		Type	Nullable	Default
#`payment_id`	PK	`integer`	NO	`nextval('payment_payment_id_seq'::regclass)`
#`customer_id`	FK ➝ `customer.customer_id`, IDX	`smallint`	NO
#`staff_id`	FK ➝ `staff.staff_id`, IDX	`smallint`	NO
#`rental_id`	FK ➝ `rental.rental_id`, IDX	`integer`	NO
#`amount`		`numeric(5,2)`	NO
#`payment_date`		`timestamp without time zone`	NO

⇡

Table `public.rental`

Column		Type	Nullable	Default
#`rental_id`	PK	`integer`	NO	`nextval('rental_rental_id_seq'::regclass)`
#`rental_date`	IDX	`timestamp without time zone`	NO
#`inventory_id`	FK ➝ `inventory.inventory_id`, IDX, IDX	`integer`	NO
#`customer_id`	FK ➝ `customer.customer_id`, IDX	`smallint`	NO
#`return_date`		`timestamp without time zone`	YES
#`staff_id`	FK ➝ `staff.staff_id`	`smallint`	NO
#`last_update`		`timestamp without time zone`	NO	`now()`

⇡

Table `public.staff`

Column		Type	Nullable	Default
#`staff_id`	PK	`integer`	NO	`nextval('staff_staff_id_seq'::regclass)`
#`first_name`		`character varying(45)`	NO
#`last_name`		`character varying(45)`	NO
#`address_id`	FK ➝ `address.address_id`	`smallint`	NO
#`email`		`character varying(50)`	YES
#`store_id`		`smallint`	NO
#`active`		`boolean`	NO	`true`
#`username`		`character varying(16)`	NO
#`password`		`character varying(40)`	YES
#`last_update`		`timestamp without time zone`	NO	`now()`
#`picture`		`bytea`	YES

⇡

Table `public.store`

Column		Type	Nullable	Default
#`store_id`	PK	`integer`	NO	`nextval('store_store_id_seq'::regclass)`
#`manager_staff_id`	FK ➝ `staff.staff_id`, IDX	`smallint`	NO
#`address_id`	FK ➝ `address.address_id`	`smallint`	NO
#`last_update`		`timestamp without time zone`	NO	`now()`

⇡

Views

View `public.actor_info`

Column	Type	Comment
`actor_id`	`integer`
`first_name`	`character varying(45)`
`last_name`	`character varying(45)`
`film_info`	`text`

⇡

View `public.customer_list`

Column	Type	Comment
`id`	`integer`
`name`	`text`
`address`	`character varying(50)`
`zip code`	`character varying(10)`
`phone`	`character varying(20)`
`city`	`character varying(50)`
`country`	`character varying(50)`
`notes`	`text`
`sid`	`smallint`

⇡

View `public.film_list`

Column	Type	Comment
`fid`	`integer`
`title`	`character varying(255)`
`description`	`text`
`category`	`character varying(25)`
`price`	`numeric(4,2)`
`length`	`smallint`
`rating`	`mpaa_rating` _{user defined AS ENUM ('G', 'PG', 'PG-13', 'R', 'NC-17') ➝}
`actors`	`text`

⇡

View `public.nicer_but_slower_film_list`

Column	Type	Comment
`fid`	`integer`
`title`	`character varying(255)`
`description`	`text`
`category`	`character varying(25)`
`price`	`numeric(4,2)`
`length`	`smallint`
`rating`	`mpaa_rating` _{user defined AS ENUM ('G', 'PG', 'PG-13', 'R', 'NC-17') ➝}
`actors`	`text`

⇡

View `public.sales_by_film_category`

Column	Type	Comment
`category`	`character varying(25)`
`total_sales`	`numeric`

⇡

View `public.sales_by_store`

Column	Type	Comment
`store`	`text`
`manager`	`text`
`total_sales`	`numeric`

⇡

View `public.staff_list`

Column	Type	Comment
`id`	`integer`
`name`	`text`
`address`	`character varying(50)`
`zip code`	`character varying(10)`
`phone`	`character varying(20)`
`city`	`character varying(50)`
`country`	`character varying(50)`
`sid`	`smallint`

⇡

Enums

Type name	Values	Comment
#`public.mpaa_rating`	`'G', 'PG', 'PG-13', 'R', 'NC-17'`

⇡

Routines

Function `public._group_concat()`

Returns text
Language is sql

⇡

Function `public.film_in_stock(p_film_id integer, p_store_id integer)`

Returns integer
Language is sql

⇡

Function `public.film_not_in_stock(p_film_id integer, p_store_id integer)`

Returns integer
Language is sql

⇡

Function `public.get_customer_balance(p_customer_id integer, p_effective_date timestamp without time zone)`

Returns numeric
Language is plpgsql

⇡

Function `public.inventory_held_by_customer(p_inventory_id integer)`

Returns integer
Language is plpgsql

⇡

Function `public.inventory_in_stock(p_inventory_id integer)`

Returns boolean
Language is plpgsql

⇡

Function `public.last_day()`

Returns date
Language is sql

⇡

Function `public.last_updated()`

Returns trigger
Language is plpgsql

⇡

Function `public.rewards_report(min_monthly_purchases integer, min_dollar_amount_purchased numeric)`

Returns setof customer
Language is plpgsql

⇡

Name		Name	Last commit message	Last commit date
Latest commit History 2 Commits
Controllers		Controllers
Database		Database
Extensions		Extensions
Models		Models
Properties		Properties
.gitignore		.gitignore
LICENSE		LICENSE
Program.cs		Program.cs
WeatherForecast.cs		WeatherForecast.cs
appsettings.Development.json		appsettings.Development.json
appsettings.PgRoutiner.json		appsettings.PgRoutiner.json
appsettings.json		appsettings.json
dvdrental.csproj		dvdrental.csproj
readme.md		readme.md

License

vb-consulting/DVDRental

Folders and files

Latest commit

History

Repository files navigation

Dictionary for database dvdrental

Table of Contents

Tables

Table public.actor

Table public.address

Table public.category

Table public.city

Table public.country

Table public.customer

Table public.film

Table public.film_actor

Table public.film_category

Table public.inventory

Table public.language

Table public.payment

Table public.rental

Table public.staff

Table public.store

Views

View public.actor_info

View public.customer_list

View public.film_list

View public.nicer_but_slower_film_list

View public.sales_by_film_category

View public.sales_by_store

View public.staff_list

Enums

Routines

Function public._group_concat()

Function public.film_in_stock(p_film_id integer, p_store_id integer)

Function public.film_not_in_stock(p_film_id integer, p_store_id integer)

Function public.get_customer_balance(p_customer_id integer, p_effective_date timestamp without time zone)

Function public.inventory_held_by_customer(p_inventory_id integer)

Function public.inventory_in_stock(p_inventory_id integer)

Function public.last_day()

Function public.last_updated()

Function public.rewards_report(min_monthly_purchases integer, min_dollar_amount_purchased numeric)

About

Resources

License

Stars

Watchers

Forks

Releases

Packages 0

Languages

Dictionary for database `dvdrental`

Table `public.actor`

Table `public.address`

Table `public.category`

Table `public.city`

Table `public.country`

Table `public.customer`

Table `public.film`

Table `public.film_actor`

Table `public.film_category`

Table `public.inventory`

Table `public.language`

Table `public.payment`

Table `public.rental`

Table `public.staff`

Table `public.store`

View `public.actor_info`

View `public.customer_list`

View `public.film_list`

View `public.nicer_but_slower_film_list`

View `public.sales_by_film_category`

View `public.sales_by_store`

View `public.staff_list`

Function `public._group_concat()`

Function `public.film_in_stock(p_film_id integer, p_store_id integer)`

Function `public.film_not_in_stock(p_film_id integer, p_store_id integer)`

Function `public.get_customer_balance(p_customer_id integer, p_effective_date timestamp without time zone)`

Function `public.inventory_held_by_customer(p_inventory_id integer)`

Function `public.inventory_in_stock(p_inventory_id integer)`

Function `public.last_day()`

Function `public.last_updated()`

Function `public.rewards_report(min_monthly_purchases integer, min_dollar_amount_purchased numeric)`

Packages