public.payment_p2022_07
Description
Columns
Name | Type | Default | Nullable | Children | Parents | Comment |
---|---|---|---|---|---|---|
payment_id | integer | nextval('payment_payment_id_seq'::regclass) | false | |||
customer_id | integer | false | ||||
staff_id | integer | false | ||||
rental_id | integer | false | ||||
amount | numeric(5,2) | false | ||||
payment_date | timestamp with time zone | false |
Constraints
Name | Type | Definition |
---|---|---|
payment_p2022_07_pkey | PRIMARY KEY | PRIMARY KEY (payment_date, payment_id) |
Indexes
Name | Definition |
---|---|
payment_p2022_07_pkey | CREATE UNIQUE INDEX payment_p2022_07_pkey ON public.payment_p2022_07 USING btree (payment_date, payment_id) |