public.payment
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_pkey | PRIMARY KEY | PRIMARY KEY (payment_date, payment_id) |
Indexes
| Name | Definition |
|---|---|
| payment_pkey | CREATE UNIQUE INDEX payment_pkey ON ONLY public.payment USING btree (payment_date, payment_id) |
Relations
