payment
22 rows where customer_id = 65
This data as json, xlsx, CSV (advanced)
Suggested facets: staff_id, amount, payment_date (date), last_update (date)
| payment_id ▼ | customer_id | staff_id | rental_id | amount | payment_date | last_update |
|---|---|---|---|---|---|---|
| 1767 | 65 65 | 1 1 | 295 295 | 4.99 | 2005-05-26 20:33:20.000 | 2020-12-23 07:19:34 |
| 1768 | 65 65 | 2 2 | 657 657 | 0.99 | 2005-05-28 20:23:09.000 | 2020-12-23 07:19:34 |
| 1769 | 65 65 | 1 1 | 2173 2173 | 7.99 | 2005-06-18 00:08:20.000 | 2020-12-23 07:19:34 |
| 1770 | 65 65 | 1 1 | 3051 3051 | 4.99 | 2005-06-20 13:06:52.000 | 2020-12-23 07:19:34 |
| 1771 | 65 65 | 1 1 | 3535 3535 | 4.99 | 2005-07-06 01:32:46.000 | 2020-12-23 07:19:34 |
| 1772 | 65 65 | 1 1 | 4240 4240 | 4.99 | 2005-07-07 13:33:12.000 | 2020-12-23 07:19:34 |
| 1773 | 65 65 | 2 2 | 4635 4635 | 3.99 | 2005-07-08 08:42:40.000 | 2020-12-23 07:19:34 |
| 1774 | 65 65 | 1 1 | 5735 5735 | 3.99 | 2005-07-10 11:39:15.000 | 2020-12-23 07:19:34 |
| 1775 | 65 65 | 2 2 | 6527 6527 | 0.99 | 2005-07-12 04:23:06.000 | 2020-12-23 07:19:34 |
| 1776 | 65 65 | 1 1 | 7877 7877 | 6.99 | 2005-07-28 10:25:36.000 | 2020-12-23 07:19:34 |
| 1777 | 65 65 | 2 2 | 8392 8392 | 1.99 | 2005-07-29 06:00:27.000 | 2020-12-23 07:19:34 |
| 1778 | 65 65 | 2 2 | 8404 8404 | 5.99 | 2005-07-29 06:27:01.000 | 2020-12-23 07:19:34 |
| 1779 | 65 65 | 1 1 | 9293 9293 | 3.99 | 2005-07-30 16:12:28.000 | 2020-12-23 07:19:34 |
| 1780 | 65 65 | 2 2 | 11100 11100 | 5.99 | 2005-08-02 08:08:00.000 | 2020-12-23 07:19:34 |
| 1781 | 65 65 | 1 1 | 11227 11227 | 8.99 | 2005-08-02 12:48:05.000 | 2020-12-23 07:19:34 |
| 1782 | 65 65 | 2 2 | 11461 11461 | 4.99 | 2005-08-02 21:35:00.000 | 2020-12-23 07:19:34 |
| 1783 | 65 65 | 2 2 | 11845 11845 | 2.99 | 2005-08-17 13:16:38.000 | 2020-12-23 07:19:34 |
| 1784 | 65 65 | 1 1 | 12114 12114 | 7.99 | 2005-08-17 23:02:00.000 | 2020-12-23 07:19:34 |
| 1785 | 65 65 | 1 1 | 12688 12688 | 6.99 | 2005-08-18 19:59:54.000 | 2020-12-23 07:19:34 |
| 1786 | 65 65 | 2 2 | 13692 13692 | 0.99 | 2005-08-20 09:07:52.000 | 2020-12-23 07:19:34 |
| 1787 | 65 65 | 2 2 | 14140 14140 | 6.99 | 2005-08-21 02:04:57.000 | 2020-12-23 07:19:34 |
| 1788 | 65 65 | 1 1 | 14356 14356 | 0.99 | 2005-08-21 09:08:51.000 | 2020-12-23 07:19:34 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE payment ( payment_id int NOT NULL, customer_id INT NOT NULL, staff_id SMALLINT NOT NULL, rental_id INT DEFAULT NULL, amount DECIMAL(5,2) NOT NULL, payment_date TIMESTAMP NOT NULL, last_update TIMESTAMP NOT NULL, PRIMARY KEY (payment_id), CONSTRAINT fk_payment_rental FOREIGN KEY (rental_id) REFERENCES rental (rental_id) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT fk_payment_customer FOREIGN KEY (customer_id) REFERENCES customer (customer_id) , CONSTRAINT fk_payment_staff FOREIGN KEY (staff_id) REFERENCES staff (staff_id) ); CREATE INDEX idx_fk_staff_id ON payment(staff_id) ; CREATE INDEX idx_fk_customer_id ON payment(customer_id) ;