payment
23 rows where customer_id = 37
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 |
|---|---|---|---|---|---|---|
| 1011 | 37 37 | 1 1 | 25 25 | 0.99 | 2005-05-25 03:21:20.000 | 2020-12-23 07:19:24 |
| 1012 | 37 37 | 1 1 | 923 923 | 2.99 | 2005-05-30 11:58:50.000 | 2020-12-23 07:19:24 |
| 1013 | 37 37 | 1 1 | 1583 1583 | 4.99 | 2005-06-16 04:44:23.000 | 2020-12-23 07:19:24 |
| 1014 | 37 37 | 2 2 | 1812 1812 | 1.99 | 2005-06-16 21:08:46.000 | 2020-12-23 07:19:24 |
| 1015 | 37 37 | 2 2 | 1854 1854 | 3.99 | 2005-06-17 00:43:57.000 | 2020-12-23 07:19:24 |
| 1016 | 37 37 | 2 2 | 3472 3472 | 7.99 | 2005-07-05 22:56:33.000 | 2020-12-23 07:19:24 |
| 1017 | 37 37 | 1 1 | 3734 3734 | 5.99 | 2005-07-06 11:40:27.000 | 2020-12-23 07:19:24 |
| 1018 | 37 37 | 1 1 | 5425 5425 | 5.99 | 2005-07-09 21:02:26.000 | 2020-12-23 07:19:24 |
| 1019 | 37 37 | 2 2 | 7939 7939 | 0.99 | 2005-07-28 12:45:47.000 | 2020-12-23 07:19:24 |
| 1020 | 37 37 | 1 1 | 8419 8419 | 9.99 | 2005-07-29 06:54:48.000 | 2020-12-23 07:19:24 |
| 1021 | 37 37 | 1 1 | 9567 9567 | 5.99 | 2005-07-31 02:36:11.000 | 2020-12-23 07:19:24 |
| 1022 | 37 37 | 1 1 | 10538 10538 | 2.99 | 2005-08-01 12:22:41.000 | 2020-12-23 07:19:24 |
| 1023 | 37 37 | 1 1 | 11176 11176 | 3.99 | 2005-08-02 10:39:43.000 | 2020-12-23 07:19:24 |
| 1024 | 37 37 | 1 1 | 13046 13046 | 7.99 | 2005-08-19 09:21:10.000 | 2020-12-23 07:19:24 |
| 1025 | 37 37 | 2 2 | 13147 13147 | 4.99 | 2005-08-19 12:55:09.000 | 2020-12-23 07:19:24 |
| 1026 | 37 37 | 2 2 | 13444 13444 | 0.99 | 2005-08-20 00:00:24.000 | 2020-12-23 07:19:24 |
| 1027 | 37 37 | 2 2 | 13493 13493 | 3.99 | 2005-08-20 01:33:36.000 | 2020-12-23 07:19:24 |
| 1028 | 37 37 | 2 2 | 14025 14025 | 8.99 | 2005-08-20 21:19:36.000 | 2020-12-23 07:19:24 |
| 1029 | 37 37 | 1 1 | 14084 14084 | 0.99 | 2005-08-20 23:42:46.000 | 2020-12-23 07:19:24 |
| 1030 | 37 37 | 2 2 | 14532 14532 | 2.99 | 2005-08-21 15:15:03.000 | 2020-12-23 07:19:24 |
| 1031 | 37 37 | 1 1 | 15028 15028 | 3.99 | 2005-08-22 09:03:44.000 | 2020-12-23 07:19:24 |
| 1032 | 37 37 | 1 1 | 15904 15904 | 0.99 | 2005-08-23 17:32:19.000 | 2020-12-23 07:19:24 |
| 1033 | 37 37 | 2 2 | 16035 16035 | 0.99 | 2005-08-23 22:08:04.000 | 2020-12-23 07:19:24 |
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) ;