payment
27 rows where customer_id = 139
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 |
|---|---|---|---|---|---|---|
| 3754 | 139 139 | 2 2 | 1169 1169 | 2.99 | 2005-06-14 23:42:56.000 | 2020-12-23 07:20:03 |
| 3755 | 139 139 | 1 1 | 1736 1736 | 2.99 | 2005-06-16 15:52:32.000 | 2020-12-23 07:20:03 |
| 3756 | 139 139 | 1 1 | 2659 2659 | 0.99 | 2005-06-19 10:47:42.000 | 2020-12-23 07:20:03 |
| 3757 | 139 139 | 2 2 | 2718 2718 | 7.99 | 2005-06-19 14:49:42.000 | 2020-12-23 07:20:03 |
| 3758 | 139 139 | 2 2 | 4660 4660 | 0.99 | 2005-07-08 09:54:47.000 | 2020-12-23 07:20:03 |
| 3759 | 139 139 | 2 2 | 4663 4663 | 2.99 | 2005-07-08 09:59:18.000 | 2020-12-23 07:20:03 |
| 3760 | 139 139 | 2 2 | 5092 5092 | 2.99 | 2005-07-09 05:57:39.000 | 2020-12-23 07:20:03 |
| 3761 | 139 139 | 2 2 | 5265 5265 | 7.99 | 2005-07-09 14:15:01.000 | 2020-12-23 07:20:03 |
| 3762 | 139 139 | 1 1 | 5390 5390 | 6.99 | 2005-07-09 19:26:22.000 | 2020-12-23 07:20:03 |
| 3763 | 139 139 | 1 1 | 5494 5494 | 6.99 | 2005-07-10 00:15:00.000 | 2020-12-23 07:20:03 |
| 3764 | 139 139 | 1 1 | 6496 6496 | 6.99 | 2005-07-12 02:57:39.000 | 2020-12-23 07:20:03 |
| 3765 | 139 139 | 2 2 | 6740 6740 | 0.99 | 2005-07-12 14:22:08.000 | 2020-12-23 07:20:03 |
| 3766 | 139 139 | 1 1 | 7369 7369 | 0.99 | 2005-07-27 15:07:58.000 | 2020-12-23 07:20:03 |
| 3767 | 139 139 | 2 2 | 7767 7767 | 5.99 | 2005-07-28 06:42:02.000 | 2020-12-23 07:20:03 |
| 3768 | 139 139 | 2 2 | 9415 9415 | 2.99 | 2005-07-30 20:48:31.000 | 2020-12-23 07:20:03 |
| 3769 | 139 139 | 2 2 | 9920 9920 | 4.99 | 2005-07-31 14:57:13.000 | 2020-12-23 07:20:03 |
| 3770 | 139 139 | 1 1 | 10900 10900 | 2.99 | 2005-08-02 01:34:26.000 | 2020-12-23 07:20:03 |
| 3771 | 139 139 | 1 1 | 12859 12859 | 6.99 | 2005-08-19 02:23:23.000 | 2020-12-23 07:20:03 |
| 3772 | 139 139 | 2 2 | 13401 13401 | 3.99 | 2005-08-19 22:16:16.000 | 2020-12-23 07:20:03 |
| 3773 | 139 139 | 2 2 | 14736 14736 | 5.99 | 2005-08-21 22:25:53.000 | 2020-12-23 07:20:03 |
| 3774 | 139 139 | 1 1 | 14788 14788 | 2.99 | 2005-08-22 00:27:59.000 | 2020-12-23 07:20:03 |
| 3775 | 139 139 | 1 1 | 15024 15024 | 2.99 | 2005-08-22 08:57:10.000 | 2020-12-23 07:20:03 |
| 3776 | 139 139 | 2 2 | 15029 15029 | 2.99 | 2005-08-22 09:04:53.000 | 2020-12-23 07:20:03 |
| 3777 | 139 139 | 1 1 | 15062 15062 | 2.99 | 2005-08-22 10:34:39.000 | 2020-12-23 07:20:03 |
| 3778 | 139 139 | 1 1 | 15218 15218 | 9.99 | 2005-08-22 16:59:05.000 | 2020-12-23 07:20:03 |
| 3779 | 139 139 | 1 1 | 15471 15471 | 3.99 | 2005-08-23 01:38:48.000 | 2020-12-23 07:20:03 |
| 3780 | 139 139 | 1 1 | 15743 15743 | 0.99 | 2005-08-23 12:12:05.000 | 2020-12-23 07:20:03 |
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) ;