public.payment_p2022_03

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
payment_id	integer	nextval('payment_payment_id_seq'::regclass)	false
customer_id	integer		false		public.customer
staff_id	integer		false		public.staff
rental_id	integer		false		public.rental
amount	numeric(5,2)		false
payment_date	timestamp with time zone		false

Constraints

Name	Type	Definition
payment_p2022_03_pkey	PRIMARY KEY	PRIMARY KEY (payment_date, payment_id)
payment_p2022_03_customer_id_fkey	FOREIGN KEY	FOREIGN KEY (customer_id) REFERENCES customer(customer_id)
payment_p2022_03_rental_id_fkey	FOREIGN KEY	FOREIGN KEY (rental_id) REFERENCES rental(rental_id)
payment_p2022_03_staff_id_fkey	FOREIGN KEY	FOREIGN KEY (staff_id) REFERENCES staff(staff_id)

Indexes

Name	Definition
payment_p2022_03_pkey	CREATE UNIQUE INDEX payment_p2022_03_pkey ON public.payment_p2022_03 USING btree (payment_date, payment_id)
idx_fk_payment_p2022_03_customer_id	CREATE INDEX idx_fk_payment_p2022_03_customer_id ON public.payment_p2022_03 USING btree (customer_id)
idx_fk_payment_p2022_03_staff_id	CREATE INDEX idx_fk_payment_p2022_03_staff_id ON public.payment_p2022_03 USING btree (staff_id)
payment_p2022_03_customer_id_idx	CREATE INDEX payment_p2022_03_customer_id_idx ON public.payment_p2022_03 USING btree (customer_id)

Relations