5.1.13 The payment Table

The payment table records each payment made by a customer, with information such as the amount and the rental being paid for (when applicable).

The payment table refers to the customer, rental, and staff tables.

Columns

• payment_id: A surrogate primary key used to uniquely identify each payment.

• customer_id: The customer whose balance the payment is being applied to. This is a foreign key reference to the customer table.

• staff_id: The staff member who processed the payment. This is a foreign key reference to the staff table.

• rental_id: 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.

• amount: The amount of the payment.

• payment_date: The date the payment was processed.

• last_update: When the row was created or most recently updated.