payment
25 rows where customer_id = 456
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 |
|---|---|---|---|---|---|---|
| 12305 | 456 456 | 2 2 | 19 19 | 4.99 | 2005-05-25 01:17:24.000 | 2020-12-23 07:22:05 |
| 12306 | 456 456 | 1 1 | 1288 1288 | 2.99 | 2005-06-15 08:41:52.000 | 2020-12-23 07:22:05 |
| 12307 | 456 456 | 1 1 | 1700 1700 | 0.99 | 2005-06-16 13:18:23.000 | 2020-12-23 07:22:05 |
| 12308 | 456 456 | 2 2 | 2103 2103 | 5.99 | 2005-06-17 19:13:10.000 | 2020-12-23 07:22:05 |
| 12309 | 456 456 | 2 2 | 2146 2146 | 6.99 | 2005-06-17 22:26:23.000 | 2020-12-23 07:22:05 |
| 12310 | 456 456 | 1 1 | 2192 2192 | 4.99 | 2005-06-18 01:35:47.000 | 2020-12-23 07:22:05 |
| 12311 | 456 456 | 1 1 | 2404 2404 | 0.99 | 2005-06-18 16:33:48.000 | 2020-12-23 07:22:05 |
| 12312 | 456 456 | 1 1 | 2581 2581 | 2.99 | 2005-06-19 04:54:13.000 | 2020-12-23 07:22:05 |
| 12313 | 456 456 | 1 1 | 3743 3743 | 7.99 | 2005-07-06 12:03:54.000 | 2020-12-23 07:22:05 |
| 12314 | 456 456 | 2 2 | 3881 3881 | 2.99 | 2005-07-06 18:35:37.000 | 2020-12-23 07:22:05 |
| 12315 | 456 456 | 1 1 | 4141 4141 | 3.99 | 2005-07-07 08:19:20.000 | 2020-12-23 07:22:05 |
| 12316 | 456 456 | 2 2 | 5964 5964 | 0.99 | 2005-07-10 23:47:18.000 | 2020-12-23 07:22:05 |
| 12317 | 456 456 | 2 2 | 6023 6023 | 0.99 | 2005-07-11 02:15:57.000 | 2020-12-23 07:22:05 |
| 12318 | 456 456 | 2 2 | 7248 7248 | 2.99 | 2005-07-27 10:37:45.000 | 2020-12-23 07:22:05 |
| 12319 | 456 456 | 1 1 | 8749 8749 | 4.99 | 2005-07-29 19:13:15.000 | 2020-12-23 07:22:05 |
| 12320 | 456 456 | 2 2 | 10519 10519 | 5.99 | 2005-08-01 11:44:13.000 | 2020-12-23 07:22:05 |
| 12321 | 456 456 | 1 1 | 10813 10813 | 2.99 | 2005-08-01 22:43:00.000 | 2020-12-23 07:22:05 |
| 12322 | 456 456 | 1 1 | 12188 12188 | 4.99 | 2005-08-18 01:51:43.000 | 2020-12-23 07:22:05 |
| 12323 | 456 456 | 1 1 | 13144 13144 | 8.99 | 2005-08-19 12:45:55.000 | 2020-12-23 07:22:05 |
| 12324 | 456 456 | 1 1 | 13348 13348 | 4.99 | 2005-08-19 20:31:48.000 | 2020-12-23 07:22:05 |
| 12325 | 456 456 | 1 1 | 13547 13547 | 4.99 | 2005-08-20 03:53:16.000 | 2020-12-23 07:22:05 |
| 12326 | 456 456 | 2 2 | 14253 14253 | 2.99 | 2005-08-21 05:47:52.000 | 2020-12-23 07:22:05 |
| 12327 | 456 456 | 2 2 | 14690 14690 | 1.99 | 2005-08-21 20:42:25.000 | 2020-12-23 07:22:05 |
| 12328 | 456 456 | 1 1 | 15720 15720 | 3.99 | 2005-08-23 11:15:20.000 | 2020-12-23 07:22:05 |
| 12329 | 456 456 | 1 1 | 15910 15910 | 2.99 | 2005-08-23 17:43:16.000 | 2020-12-23 07:22:05 |
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) ;