payment
20 rows where customer_id = 191
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 |
|---|---|---|---|---|---|---|
| 5176 | 191 191 | 1 1 | 1134 1134 | 2.99 | 2005-05-31 19:14:15.000 | 2020-12-23 07:20:23 |
| 5177 | 191 191 | 2 2 | 1152 1152 | 4.99 | 2005-05-31 21:32:17.000 | 2020-12-23 07:20:23 |
| 5178 | 191 191 | 2 2 | 1173 1173 | 2.99 | 2005-06-14 23:54:46.000 | 2020-12-23 07:20:23 |
| 5179 | 191 191 | 1 1 | 1278 1278 | 0.99 | 2005-06-15 08:09:12.000 | 2020-12-23 07:20:23 |
| 5180 | 191 191 | 1 1 | 1677 1677 | 2.99 | 2005-06-16 11:07:11.000 | 2020-12-23 07:20:23 |
| 5181 | 191 191 | 2 2 | 1870 1870 | 2.99 | 2005-06-17 02:24:36.000 | 2020-12-23 07:20:23 |
| 5182 | 191 191 | 1 1 | 2051 2051 | 4.99 | 2005-06-17 15:10:16.000 | 2020-12-23 07:20:23 |
| 5183 | 191 191 | 2 2 | 2555 2555 | 2.99 | 2005-06-19 03:07:02.000 | 2020-12-23 07:20:23 |
| 5184 | 191 191 | 1 1 | 5338 5338 | 2.99 | 2005-07-09 17:07:07.000 | 2020-12-23 07:20:23 |
| 5185 | 191 191 | 2 2 | 5397 5397 | 5.99 | 2005-07-09 19:43:51.000 | 2020-12-23 07:20:23 |
| 5186 | 191 191 | 1 1 | 5924 5924 | 5.99 | 2005-07-10 21:41:23.000 | 2020-12-23 07:20:23 |
| 5187 | 191 191 | 1 1 | 7150 7150 | 6.99 | 2005-07-27 07:11:14.000 | 2020-12-23 07:20:23 |
| 5188 | 191 191 | 1 1 | 7450 7450 | 3.99 | 2005-07-27 18:18:35.000 | 2020-12-23 07:20:23 |
| 5189 | 191 191 | 1 1 | 7520 7520 | 2.99 | 2005-07-27 21:02:02.000 | 2020-12-23 07:20:23 |
| 5190 | 191 191 | 2 2 | 8583 8583 | 0.99 | 2005-07-29 12:04:50.000 | 2020-12-23 07:20:23 |
| 5191 | 191 191 | 1 1 | 9297 9297 | 4.99 | 2005-07-30 16:26:29.000 | 2020-12-23 07:20:23 |
| 5192 | 191 191 | 1 1 | 9964 9964 | 4.99 | 2005-07-31 16:17:39.000 | 2020-12-23 07:20:23 |
| 5193 | 191 191 | 2 2 | 10532 10532 | 2.99 | 2005-08-01 12:06:35.000 | 2020-12-23 07:20:23 |
| 5194 | 191 191 | 2 2 | 15375 15375 | 4.99 | 2005-08-22 22:12:02.000 | 2020-12-23 07:20:23 |
| 5195 | 191 191 | 1 1 | 14361 14361 | 0.99 | 2006-02-14 15:16:03.000 | 2020-12-23 07:20:23 |
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) ;