payment
27 rows where customer_id = 45
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 |
|---|---|---|---|---|---|---|
| 1229 | 45 45 | 2 2 | 277 277 | 2.99 | 2005-05-26 17:32:11.000 | 2020-12-23 07:19:27 |
| 1230 | 45 45 | 1 1 | 1806 1806 | 4.99 | 2005-06-16 20:41:57.000 | 2020-12-23 07:19:27 |
| 1231 | 45 45 | 2 2 | 1979 1979 | 2.99 | 2005-06-17 09:45:30.000 | 2020-12-23 07:19:27 |
| 1232 | 45 45 | 2 2 | 2722 2722 | 4.99 | 2005-06-19 14:55:17.000 | 2020-12-23 07:19:27 |
| 1233 | 45 45 | 1 1 | 3391 3391 | 3.99 | 2005-06-21 15:11:02.000 | 2020-12-23 07:19:27 |
| 1234 | 45 45 | 2 2 | 3444 3444 | 0.99 | 2005-06-21 20:39:39.000 | 2020-12-23 07:19:27 |
| 1235 | 45 45 | 1 1 | 4843 4843 | 0.99 | 2005-07-08 18:27:28.000 | 2020-12-23 07:19:27 |
| 1236 | 45 45 | 1 1 | 5181 5181 | 6.99 | 2005-07-09 10:07:27.000 | 2020-12-23 07:19:27 |
| 1237 | 45 45 | 1 1 | 5405 5405 | 7.99 | 2005-07-09 20:11:49.000 | 2020-12-23 07:19:27 |
| 1238 | 45 45 | 1 1 | 5637 5637 | 0.99 | 2005-07-10 06:31:37.000 | 2020-12-23 07:19:27 |
| 1239 | 45 45 | 2 2 | 6001 6001 | 0.99 | 2005-07-11 01:24:44.000 | 2020-12-23 07:19:27 |
| 1240 | 45 45 | 2 2 | 6002 6002 | 2.99 | 2005-07-11 01:27:49.000 | 2020-12-23 07:19:27 |
| 1241 | 45 45 | 1 1 | 6966 6966 | 9.99 | 2005-07-27 00:15:35.000 | 2020-12-23 07:19:27 |
| 1242 | 45 45 | 1 1 | 7436 7436 | 2.99 | 2005-07-27 17:39:12.000 | 2020-12-23 07:19:27 |
| 1243 | 45 45 | 1 1 | 7961 7961 | 3.99 | 2005-07-28 13:47:21.000 | 2020-12-23 07:19:27 |
| 1244 | 45 45 | 1 1 | 10507 10507 | 2.99 | 2005-08-01 11:22:20.000 | 2020-12-23 07:19:27 |
| 1245 | 45 45 | 2 2 | 10878 10878 | 6.99 | 2005-08-02 00:33:12.000 | 2020-12-23 07:19:27 |
| 1246 | 45 45 | 1 1 | 11004 11004 | 8.99 | 2005-08-02 05:04:18.000 | 2020-12-23 07:19:27 |
| 1247 | 45 45 | 1 1 | 11029 11029 | 4.99 | 2005-08-02 05:51:10.000 | 2020-12-23 07:19:27 |
| 1248 | 45 45 | 2 2 | 11483 11483 | 2.99 | 2005-08-02 22:28:22.000 | 2020-12-23 07:19:27 |
| 1249 | 45 45 | 2 2 | 11488 11488 | 3.99 | 2005-08-02 22:35:15.000 | 2020-12-23 07:19:27 |
| 1250 | 45 45 | 1 1 | 11725 11725 | 2.99 | 2005-08-17 08:09:00.000 | 2020-12-23 07:19:27 |
| 1251 | 45 45 | 1 1 | 13340 13340 | 3.99 | 2005-08-19 20:18:39.000 | 2020-12-23 07:19:27 |
| 1252 | 45 45 | 2 2 | 13394 13394 | 4.99 | 2005-08-19 22:05:19.000 | 2020-12-23 07:19:27 |
| 1253 | 45 45 | 1 1 | 14576 14576 | 6.99 | 2005-08-21 16:52:03.000 | 2020-12-23 07:19:27 |
| 1254 | 45 45 | 1 1 | 15812 15812 | 10.99 | 2005-08-23 14:47:26.000 | 2020-12-23 07:19:27 |
| 1255 | 45 45 | 2 2 | 16037 16037 | 7.99 | 2005-08-23 22:13:04.000 | 2020-12-23 07:19:27 |
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) ;