payment
20 rows where customer_id = 162
This data as json, xlsx, CSV (advanced)
Suggested facets: staff_id, amount, last_update, payment_date (date), last_update (date)
| payment_id ▼ | customer_id | staff_id | rental_id | amount | payment_date | last_update |
|---|---|---|---|---|---|---|
| 4402 | 162 162 | 1 1 | 285 285 | 1.99 | 2005-05-26 19:41:40.000 | 2020-12-23 07:20:11 |
| 4403 | 162 162 | 1 1 | 501 501 | 4.99 | 2005-05-28 01:09:36.000 | 2020-12-23 07:20:11 |
| 4404 | 162 162 | 1 1 | 688 688 | 4.99 | 2005-05-29 00:45:24.000 | 2020-12-23 07:20:11 |
| 4405 | 162 162 | 2 2 | 1339 1339 | 4.99 | 2005-06-15 12:21:56.000 | 2020-12-23 07:20:11 |
| 4406 | 162 162 | 1 1 | 2366 2366 | 0.99 | 2005-06-18 13:46:39.000 | 2020-12-23 07:20:11 |
| 4407 | 162 162 | 1 1 | 2547 2547 | 4.99 | 2005-06-19 02:44:17.000 | 2020-12-23 07:20:11 |
| 4408 | 162 162 | 1 1 | 3040 3040 | 0.99 | 2005-06-20 12:34:13.000 | 2020-12-23 07:20:11 |
| 4409 | 162 162 | 2 2 | 3180 3180 | 0.99 | 2005-06-20 22:48:44.000 | 2020-12-23 07:20:12 |
| 4410 | 162 162 | 2 2 | 4982 4982 | 2.99 | 2005-07-09 00:30:52.000 | 2020-12-23 07:20:12 |
| 4411 | 162 162 | 2 2 | 8478 8478 | 4.99 | 2005-07-29 08:40:36.000 | 2020-12-23 07:20:12 |
| 4412 | 162 162 | 1 1 | 8582 8582 | 4.99 | 2005-07-29 12:03:27.000 | 2020-12-23 07:20:12 |
| 4413 | 162 162 | 2 2 | 9167 9167 | 4.99 | 2005-07-30 11:30:37.000 | 2020-12-23 07:20:12 |
| 4414 | 162 162 | 1 1 | 9726 9726 | 7.99 | 2005-07-31 08:37:07.000 | 2020-12-23 07:20:12 |
| 4415 | 162 162 | 1 1 | 9775 9775 | 0.99 | 2005-07-31 10:00:00.000 | 2020-12-23 07:20:12 |
| 4416 | 162 162 | 2 2 | 10093 10093 | 5.99 | 2005-07-31 20:30:32.000 | 2020-12-23 07:20:12 |
| 4417 | 162 162 | 2 2 | 11012 11012 | 0.99 | 2005-08-02 05:09:42.000 | 2020-12-23 07:20:12 |
| 4418 | 162 162 | 1 1 | 13288 13288 | 4.99 | 2005-08-19 18:30:10.000 | 2020-12-23 07:20:12 |
| 4419 | 162 162 | 2 2 | 14301 14301 | 1.99 | 2005-08-21 07:19:48.000 | 2020-12-23 07:20:12 |
| 4420 | 162 162 | 1 1 | 15332 15332 | 4.99 | 2005-08-22 20:41:53.000 | 2020-12-23 07:20:12 |
| 4421 | 162 162 | 1 1 | 14220 14220 | 0.99 | 2006-02-14 15:16:03.000 | 2020-12-23 07:20:12 |
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) ;