Skip to main content

public.payment_p2022_07

Description

Columns

NameTypeDefaultNullableChildrenParentsComment
payment_idintegernextval('payment_payment_id_seq'::regclass)false
customer_idintegerfalse
staff_idintegerfalse
rental_idintegerfalse
amountnumeric(5,2)false
payment_datetimestamp with time zonefalse

Constraints

NameTypeDefinition
payment_p2022_07_pkeyPRIMARY KEYPRIMARY KEY (payment_date, payment_id)

Indexes

NameDefinition
payment_p2022_07_pkeyCREATE UNIQUE INDEX payment_p2022_07_pkey ON public.payment_p2022_07 USING btree (payment_date, payment_id)

Relations

er