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