payment
18 rows where customer_id = 140
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 |
|---|---|---|---|---|---|---|
| 3781 | 140 140 | 1 1 | 1586 1586 | 4.99 | 2005-06-16 04:51:18.000 | 2020-12-23 07:20:03 |
| 3782 | 140 140 | 1 1 | 1687 1687 | 2.99 | 2005-06-16 12:09:20.000 | 2020-12-23 07:20:03 |
| 3783 | 140 140 | 2 2 | 2332 2332 | 6.99 | 2005-06-18 10:53:51.000 | 2020-12-23 07:20:03 |
| 3784 | 140 140 | 2 2 | 3171 3171 | 0.99 | 2005-06-20 22:15:47.000 | 2020-12-23 07:20:03 |
| 3785 | 140 140 | 1 1 | 6286 6286 | 4.99 | 2005-07-11 16:55:35.000 | 2020-12-23 07:20:03 |
| 3786 | 140 140 | 1 1 | 6407 6407 | 9.99 | 2005-07-11 23:02:19.000 | 2020-12-23 07:20:03 |
| 3787 | 140 140 | 2 2 | 6571 6571 | 0.99 | 2005-07-12 05:51:47.000 | 2020-12-23 07:20:03 |
| 3788 | 140 140 | 1 1 | 6918 6918 | 2.99 | 2005-07-12 22:30:29.000 | 2020-12-23 07:20:03 |
| 3789 | 140 140 | 1 1 | 7170 7170 | 4.99 | 2005-07-27 07:58:26.000 | 2020-12-23 07:20:03 |
| 3790 | 140 140 | 1 1 | 9094 9094 | 4.99 | 2005-07-30 08:35:10.000 | 2020-12-23 07:20:03 |
| 3791 | 140 140 | 1 1 | 9404 9404 | 0.99 | 2005-07-30 20:21:35.000 | 2020-12-23 07:20:03 |
| 3792 | 140 140 | 1 1 | 10342 10342 | 6.99 | 2005-08-01 05:11:11.000 | 2020-12-23 07:20:03 |
| 3793 | 140 140 | 2 2 | 11430 11430 | 3.99 | 2005-08-02 20:04:36.000 | 2020-12-23 07:20:03 |
| 3794 | 140 140 | 1 1 | 12086 12086 | 4.99 | 2005-08-17 22:20:01.000 | 2020-12-23 07:20:03 |
| 3795 | 140 140 | 1 1 | 12675 12675 | 4.99 | 2005-08-18 19:34:02.000 | 2020-12-23 07:20:03 |
| 3796 | 140 140 | 2 2 | 13053 13053 | 10.99 | 2005-08-19 09:31:48.000 | 2020-12-23 07:20:03 |
| 3797 | 140 140 | 1 1 | 15261 15261 | 2.99 | 2005-08-22 18:24:34.000 | 2020-12-23 07:20:03 |
| 3798 | 140 140 | 1 1 | 15852 15852 | 2.99 | 2005-08-23 15:47:02.000 | 2020-12-23 07:20:03 |
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) ;