public.payment_p2007_06
Documentation | Pagila |
Schema | public |
Name | payment_p2007_06 |
Module | Business |
The payment table records each payment made by a customer in June 2007.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | payment_id | integer | Default: nextval('payment_payment_id_seq'::regclass) | ID used to uniquely identify each payment. | ||||
ID used to uniquely identify each payment. Default: nextval('payment_payment_id_seq'::regclass) |
||||||||
2 | customer_id | smallint | public.customer | The customer whose balance the payment is being applied to. This is a foreign key reference to the customer table. | ||||
The customer whose balance the payment is being applied to. This is a foreign key reference to the customer table. References: public.customer |
||||||||
3 | staff_id | smallint | public.staff | The staff member who processed the payment. This is a foreign key reference to the staff table. | ||||
The staff member who processed the payment. This is a foreign key reference to the staff table. References: public.staff |
||||||||
4 | rental_id | integer | public.rental | The rental that the payment is being applied to. This is optional because some payments are for outstanding fees and may not be directly related to a rental. | ||||
The rental that the payment is being applied to. This is optional because some payments are for outstanding fees and may not be directly related to a rental. References: public.rental |
||||||||
5 | amount | numeric(5, 2) | The amount of the payment. | |||||
The amount of the payment. |
||||||||
6 | payment_date | timestamp without time zone(6) | The date the payment was processed. | |||||
The date the payment was processed. |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
public.payment_p2007_06 | public.customer | public.payment_p2007_06.customer_id = public.customer.customer_id | payment_p2007_06_customer_id_fkey Foreign key constraint referencing customer.customer_id |
|
public.payment_p2007_06.customer_id = public.customer.customer_id Name: payment_p2007_06_customer_id_fkeyForeign key constraint referencing customer.customer_id |
||||
public.payment_p2007_06 | public.rental | public.payment_p2007_06.rental_id = public.rental.rental_id | payment_p2007_06_rental_id_fkey Foreign key constraint referencing rental.rental_id |
|
public.payment_p2007_06.rental_id = public.rental.rental_id Name: payment_p2007_06_rental_id_fkeyForeign key constraint referencing rental.rental_id |
||||
public.payment_p2007_06 | public.staff | public.payment_p2007_06.staff_id = public.staff.staff_id | payment_p2007_06_staff_id_fkey Foreign key constraint referencing staff.staff_id |
|
public.payment_p2007_06.staff_id = public.staff.staff_id Name: payment_p2007_06_staff_id_fkeyForeign key constraint referencing staff.staff_id |
Uses
Name |
---|
public.payment_p2007_06
|
Exported: 2018-10-12 17:07, Last imported: 2018-08-06 09:25