payment
23 rows where customer_id = 85
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 |
|---|---|---|---|---|---|---|
| 2302 | 85 85 | 1 1 | 690 690 | 9.99 | 2005-05-29 00:54:53.000 | 2020-12-23 07:19:42 |
| 2303 | 85 85 | 2 2 | 908 908 | 4.99 | 2005-05-30 10:38:37.000 | 2020-12-23 07:19:42 |
| 2304 | 85 85 | 1 1 | 1685 1685 | 1.99 | 2005-06-16 12:06:57.000 | 2020-12-23 07:19:42 |
| 2305 | 85 85 | 1 1 | 2131 2131 | 5.99 | 2005-06-17 21:02:25.000 | 2020-12-23 07:19:42 |
| 2306 | 85 85 | 2 2 | 2794 2794 | 0.99 | 2005-06-19 18:53:05.000 | 2020-12-23 07:19:42 |
| 2307 | 85 85 | 1 1 | 3165 3165 | 4.99 | 2005-06-20 21:29:17.000 | 2020-12-23 07:19:42 |
| 2308 | 85 85 | 1 1 | 3307 3307 | 1.99 | 2005-06-21 07:52:30.000 | 2020-12-23 07:19:42 |
| 2309 | 85 85 | 2 2 | 3418 3418 | 3.99 | 2005-06-21 17:06:38.000 | 2020-12-23 07:19:42 |
| 2310 | 85 85 | 2 2 | 4451 4451 | 0.99 | 2005-07-07 23:29:54.000 | 2020-12-23 07:19:42 |
| 2311 | 85 85 | 1 1 | 4705 4705 | 2.99 | 2005-07-08 11:50:38.000 | 2020-12-23 07:19:42 |
| 2312 | 85 85 | 1 1 | 5051 5051 | 4.99 | 2005-07-09 03:57:53.000 | 2020-12-23 07:19:42 |
| 2313 | 85 85 | 1 1 | 5519 5519 | 0.99 | 2005-07-10 01:18:32.000 | 2020-12-23 07:19:42 |
| 2314 | 85 85 | 2 2 | 7906 7906 | 0.99 | 2005-07-28 11:31:42.000 | 2020-12-23 07:19:42 |
| 2315 | 85 85 | 2 2 | 9427 9427 | 7.99 | 2005-07-30 21:16:33.000 | 2020-12-23 07:19:42 |
| 2316 | 85 85 | 2 2 | 9957 9957 | 4.99 | 2005-07-31 16:03:55.000 | 2020-12-23 07:19:42 |
| 2317 | 85 85 | 1 1 | 9985 9985 | 2.99 | 2005-07-31 17:14:47.000 | 2020-12-23 07:19:42 |
| 2318 | 85 85 | 1 1 | 10328 10328 | 4.99 | 2005-08-01 04:56:10.000 | 2020-12-23 07:19:42 |
| 2319 | 85 85 | 1 1 | 10548 10548 | 0.99 | 2005-08-01 12:44:32.000 | 2020-12-23 07:19:42 |
| 2320 | 85 85 | 2 2 | 11067 11067 | 8.99 | 2005-08-02 07:03:24.000 | 2020-12-23 07:19:42 |
| 2321 | 85 85 | 2 2 | 12036 12036 | 0.99 | 2005-08-17 20:19:06.000 | 2020-12-23 07:19:42 |
| 2322 | 85 85 | 1 1 | 12456 12456 | 4.99 | 2005-08-18 11:21:51.000 | 2020-12-23 07:19:42 |
| 2323 | 85 85 | 1 1 | 13727 13727 | 3.99 | 2005-08-20 10:08:53.000 | 2020-12-23 07:19:42 |
| 2324 | 85 85 | 2 2 | 13733 13733 | 0.99 | 2005-08-20 10:25:12.000 | 2020-12-23 07:19:42 |
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) ;