payment
22 rows where customer_id = 443
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 |
|---|---|---|---|---|---|---|
| 11947 | 443 443 | 2 2 | 1068 1068 | 4.99 | 2005-05-31 09:32:15.000 | 2020-12-23 07:22:00 |
| 11948 | 443 443 | 1 1 | 2871 2871 | 2.99 | 2005-06-20 00:27:49.000 | 2020-12-23 07:22:00 |
| 11949 | 443 443 | 2 2 | 3510 3510 | 5.99 | 2005-07-06 00:27:41.000 | 2020-12-23 07:22:00 |
| 11950 | 443 443 | 2 2 | 6625 6625 | 5.99 | 2005-07-12 09:06:40.000 | 2020-12-23 07:22:00 |
| 11951 | 443 443 | 1 1 | 6913 6913 | 4.99 | 2005-07-12 22:18:12.000 | 2020-12-23 07:22:00 |
| 11952 | 443 443 | 2 2 | 6983 6983 | 2.99 | 2005-07-27 00:55:03.000 | 2020-12-23 07:22:00 |
| 11953 | 443 443 | 1 1 | 7317 7317 | 2.99 | 2005-07-27 13:19:41.000 | 2020-12-23 07:22:00 |
| 11954 | 443 443 | 1 1 | 7667 7667 | 8.99 | 2005-07-28 02:37:22.000 | 2020-12-23 07:22:00 |
| 11955 | 443 443 | 1 1 | 7987 7987 | 9.99 | 2005-07-28 14:36:52.000 | 2020-12-23 07:22:00 |
| 11956 | 443 443 | 2 2 | 9740 9740 | 1.99 | 2005-07-31 09:08:03.000 | 2020-12-23 07:22:00 |
| 11957 | 443 443 | 1 1 | 10014 10014 | 4.99 | 2005-07-31 18:10:56.000 | 2020-12-23 07:22:00 |
| 11958 | 443 443 | 2 2 | 10081 10081 | 5.99 | 2005-07-31 20:07:44.000 | 2020-12-23 07:22:00 |
| 11959 | 443 443 | 2 2 | 10360 10360 | 0.99 | 2005-08-01 05:52:53.000 | 2020-12-23 07:22:00 |
| 11960 | 443 443 | 1 1 | 11449 11449 | 4.99 | 2005-08-02 20:44:43.000 | 2020-12-23 07:22:00 |
| 11961 | 443 443 | 1 1 | 12415 12415 | 4.99 | 2005-08-18 09:54:01.000 | 2020-12-23 07:22:00 |
| 11962 | 443 443 | 2 2 | 12857 12857 | 4.99 | 2005-08-19 02:20:13.000 | 2020-12-23 07:22:00 |
| 11963 | 443 443 | 1 1 | 13489 13489 | 2.99 | 2005-08-20 01:29:06.000 | 2020-12-23 07:22:00 |
| 11964 | 443 443 | 1 1 | 14561 14561 | 2.99 | 2005-08-21 16:20:43.000 | 2020-12-23 07:22:00 |
| 11965 | 443 443 | 2 2 | 14611 14611 | 6.99 | 2005-08-21 18:01:41.000 | 2020-12-23 07:22:00 |
| 11966 | 443 443 | 1 1 | 15182 15182 | 0.99 | 2005-08-22 15:47:05.000 | 2020-12-23 07:22:00 |
| 11967 | 443 443 | 2 2 | 15393 15393 | 4.99 | 2005-08-22 23:04:09.000 | 2020-12-23 07:22:00 |
| 11968 | 443 443 | 1 1 | 15519 15519 | 0.99 | 2005-08-23 03:23:32.000 | 2020-12-23 07:22:00 |
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) ;