payment
24 rows where customer_id = 123
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 |
|---|---|---|---|---|---|---|
| 3312 | 123 123 | 1 1 | 992 992 | 2.99 | 2005-05-30 23:47:56.000 | 2020-12-23 07:19:57 |
| 3313 | 123 123 | 2 2 | 1490 1490 | 4.99 | 2005-06-15 21:42:17.000 | 2020-12-23 07:19:57 |
| 3314 | 123 123 | 1 1 | 1751 1751 | 0.99 | 2005-06-16 17:00:14.000 | 2020-12-23 07:19:57 |
| 3315 | 123 123 | 2 2 | 1775 1775 | 4.99 | 2005-06-16 18:28:19.000 | 2020-12-23 07:19:57 |
| 3316 | 123 123 | 2 2 | 1951 1951 | 0.99 | 2005-06-17 08:30:35.000 | 2020-12-23 07:19:57 |
| 3317 | 123 123 | 1 1 | 2594 2594 | 2.99 | 2005-06-19 05:43:43.000 | 2020-12-23 07:19:57 |
| 3318 | 123 123 | 1 1 | 4442 4442 | 3.99 | 2005-07-07 23:05:30.000 | 2020-12-23 07:19:57 |
| 3319 | 123 123 | 1 1 | 4860 4860 | 8.99 | 2005-07-08 18:54:07.000 | 2020-12-23 07:19:57 |
| 3320 | 123 123 | 2 2 | 7535 7535 | 4.99 | 2005-07-27 21:32:39.000 | 2020-12-23 07:19:57 |
| 3321 | 123 123 | 1 1 | 7727 7727 | 2.99 | 2005-07-28 04:52:43.000 | 2020-12-23 07:19:57 |
| 3322 | 123 123 | 2 2 | 7768 7768 | 0.99 | 2005-07-28 06:44:03.000 | 2020-12-23 07:19:57 |
| 3323 | 123 123 | 1 1 | 7852 7852 | 2.99 | 2005-07-28 09:34:29.000 | 2020-12-23 07:19:57 |
| 3324 | 123 123 | 1 1 | 7969 7969 | 5.99 | 2005-07-28 13:57:37.000 | 2020-12-23 07:19:57 |
| 3325 | 123 123 | 2 2 | 8699 8699 | 4.99 | 2005-07-29 16:53:00.000 | 2020-12-23 07:19:57 |
| 3326 | 123 123 | 2 2 | 9529 9529 | 4.99 | 2005-07-31 01:05:26.000 | 2020-12-23 07:19:57 |
| 3327 | 123 123 | 1 1 | 10066 10066 | 4.99 | 2005-07-31 19:30:01.000 | 2020-12-23 07:19:57 |
| 3328 | 123 123 | 2 2 | 10295 10295 | 8.99 | 2005-08-01 03:53:49.000 | 2020-12-23 07:19:57 |
| 3329 | 123 123 | 1 1 | 12360 12360 | 2.99 | 2005-08-18 07:46:35.000 | 2020-12-23 07:19:57 |
| 3330 | 123 123 | 1 1 | 12402 12402 | 3.99 | 2005-08-18 09:27:34.000 | 2020-12-23 07:19:57 |
| 3331 | 123 123 | 1 1 | 13668 13668 | 2.99 | 2005-08-20 08:26:06.000 | 2020-12-23 07:19:57 |
| 3332 | 123 123 | 2 2 | 15152 15152 | 7.99 | 2005-08-22 14:25:21.000 | 2020-12-23 07:19:57 |
| 3333 | 123 123 | 2 2 | 15525 15525 | 4.99 | 2005-08-23 03:43:32.000 | 2020-12-23 07:19:57 |
| 3334 | 123 123 | 1 1 | 15621 15621 | 1.99 | 2005-08-23 07:13:43.000 | 2020-12-23 07:19:57 |
| 3335 | 123 123 | 2 2 | 15787 15787 | 2.99 | 2005-08-23 13:51:57.000 | 2020-12-23 07:19:57 |
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) ;