Pagila (sample PostgreSQL database)

- Pagila

public.payment_p2007_05

Documentation	Pagila
Schema	public
Name	payment_p2007_05
Module	Business

The payment table records each payment made by a customer in May 2007.

Columns

		Key	Name	Data type	Null	Attributes	References	Description
	1		payment_id	integer		Default: nextval('payment_payment_id_seq'::regclass)		ID used to uniquely identify each payment.
ID used to uniquely identify each payment. Default: nextval('payment_payment_id_seq'::regclass)
	2		customer_id	smallint			public.customer	The customer whose balance the payment is being applied to. This is a foreign key reference to the customer table.
The customer whose balance the payment is being applied to. This is a foreign key reference to the customer table. References: public.customer
	3		staff_id	smallint			public.staff	The staff member who processed the payment. This is a foreign key reference to the staff table.
The staff member who processed the payment. This is a foreign key reference to the staff table. References: public.staff
	4		rental_id	integer			public.rental	The rental that the payment is being applied to. This is optional because some payments are for outstanding fees and may not be directly related to a rental.
The rental that the payment is being applied to. This is optional because some payments are for outstanding fees and may not be directly related to a rental. References: public.rental
	5		amount	numeric(5, 2)				The amount of the payment.
The amount of the payment.
	6		payment_date	timestamp without time zone(6)				The date the payment was processed.
The date the payment was processed.

Relations

Foreign table		Primary table	Join	Title / Name / Description
public.payment_p2007_05		public.customer	public.payment_p2007_05.customer_id = public.customer.customer_id	payment_p2007_05_customer_id_fkey Foreign key constraint referencing customer.customer_id
public.payment_p2007_05.customer_id = public.customer.customer_id Name: payment_p2007_05_customer_id_fkey Foreign key constraint referencing customer.customer_id
public.payment_p2007_05		public.rental	public.payment_p2007_05.rental_id = public.rental.rental_id	payment_p2007_05_rental_id_fkey Foreign key constraint referencing rental.rental_id
public.payment_p2007_05.rental_id = public.rental.rental_id Name: payment_p2007_05_rental_id_fkey Foreign key constraint referencing rental.rental_id
public.payment_p2007_05		public.staff	public.payment_p2007_05.staff_id = public.staff.staff_id	payment_p2007_05_staff_id_fkey Foreign key constraint referencing staff.staff_id
public.payment_p2007_05.staff_id = public.staff.staff_id Name: payment_p2007_05_staff_id_fkey Foreign key constraint referencing staff.staff_id

Uses

Name
public.payment_p2007_05
public.customer
public.rental
public.staff

Exported: 2018-10-12 17:07, Last imported: 2018-08-06 09:25