payment
26 rows where customer_id = 510
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 |
|---|---|---|---|---|---|---|
| 13731 | 510 510 | 1 1 | 75 75 | 8.99 | 2005-05-25 11:13:34.000 | 2020-12-23 07:22:23 |
| 13732 | 510 510 | 1 1 | 372 372 | 5.99 | 2005-05-27 08:13:58.000 | 2020-12-23 07:22:23 |
| 13733 | 510 510 | 2 2 | 1118 1118 | 4.99 | 2005-05-31 16:23:02.000 | 2020-12-23 07:22:23 |
| 13734 | 510 510 | 2 2 | 1435 1435 | 5.99 | 2005-06-15 18:32:30.000 | 2020-12-23 07:22:23 |
| 13735 | 510 510 | 2 2 | 1757 1757 | 0.99 | 2005-06-16 17:32:24.000 | 2020-12-23 07:22:23 |
| 13736 | 510 510 | 2 2 | 1925 1925 | 0.99 | 2005-06-17 06:16:47.000 | 2020-12-23 07:22:23 |
| 13737 | 510 510 | 1 1 | 2729 2729 | 8.99 | 2005-06-19 15:06:15.000 | 2020-12-23 07:22:23 |
| 13738 | 510 510 | 2 2 | 2806 2806 | 0.99 | 2005-06-19 19:30:48.000 | 2020-12-23 07:22:23 |
| 13739 | 510 510 | 2 2 | 2817 2817 | 0.99 | 2005-06-19 20:05:22.000 | 2020-12-23 07:22:23 |
| 13740 | 510 510 | 2 2 | 3352 3352 | 8.99 | 2005-06-21 11:26:29.000 | 2020-12-23 07:22:23 |
| 13741 | 510 510 | 2 2 | 3465 3465 | 5.99 | 2005-06-21 22:10:01.000 | 2020-12-23 07:22:23 |
| 13742 | 510 510 | 2 2 | 3744 3744 | 2.99 | 2005-07-06 12:10:02.000 | 2020-12-23 07:22:23 |
| 13743 | 510 510 | 1 1 | 4014 4014 | 4.99 | 2005-07-07 00:58:54.000 | 2020-12-23 07:22:23 |
| 13744 | 510 510 | 2 2 | 5851 5851 | 4.99 | 2005-07-10 17:40:47.000 | 2020-12-23 07:22:23 |
| 13745 | 510 510 | 1 1 | 6531 6531 | 1.99 | 2005-07-12 04:35:24.000 | 2020-12-23 07:22:23 |
| 13746 | 510 510 | 1 1 | 7457 7457 | 2.99 | 2005-07-27 18:35:17.000 | 2020-12-23 07:22:23 |
| 13747 | 510 510 | 1 1 | 7678 7678 | 8.99 | 2005-07-28 02:58:16.000 | 2020-12-23 07:22:23 |
| 13748 | 510 510 | 2 2 | 7794 7794 | 9.99 | 2005-07-28 07:28:03.000 | 2020-12-23 07:22:23 |
| 13749 | 510 510 | 2 2 | 8763 8763 | 3.99 | 2005-07-29 19:38:24.000 | 2020-12-23 07:22:23 |
| 13750 | 510 510 | 1 1 | 8926 8926 | 4.99 | 2005-07-30 02:10:31.000 | 2020-12-23 07:22:23 |
| 13751 | 510 510 | 1 1 | 10131 10131 | 0.99 | 2005-07-31 21:45:28.000 | 2020-12-23 07:22:23 |
| 13752 | 510 510 | 2 2 | 10265 10265 | 7.99 | 2005-08-01 03:05:04.000 | 2020-12-23 07:22:23 |
| 13753 | 510 510 | 2 2 | 11996 11996 | 4.99 | 2005-08-17 18:34:37.000 | 2020-12-23 07:22:23 |
| 13754 | 510 510 | 1 1 | 12317 12317 | 0.99 | 2005-08-18 06:17:06.000 | 2020-12-23 07:22:23 |
| 13755 | 510 510 | 2 2 | 12406 12406 | 2.99 | 2005-08-18 09:38:02.000 | 2020-12-23 07:22:23 |
| 13756 | 510 510 | 1 1 | 15065 15065 | 4.99 | 2005-08-22 10:46:44.000 | 2020-12-23 07:22:23 |
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) ;