rental
26 rows where customer_id = 142
This data as json, xlsx, CSV (advanced)
Suggested facets: staff_id, last_update, rental_date (date), return_date (date), last_update (date)
| rental_id ▼ | rental_date | inventory_id | customer_id | return_date | staff_id | last_update |
|---|---|---|---|---|---|---|
| 11 | 2005-05-25 00:09:02.000 | 4443 4443 | 142 142 | 2005-06-02 20:56:02.000 | 2 2 | 2020-12-23 07:15:20 |
| 148 | 2005-05-26 00:25:23.000 | 4252 4252 | 142 142 | 2005-06-01 19:29:23.000 | 2 2 | 2020-12-23 07:15:22 |
| 575 | 2005-05-28 10:56:09.000 | 4451 4451 | 142 142 | 2005-06-05 15:39:09.000 | 1 1 | 2020-12-23 07:15:27 |
| 1268 | 2005-06-15 07:29:30.000 | 3641 3641 | 142 142 | 2005-06-23 12:36:30.000 | 1 1 | 2020-12-23 07:15:37 |
| 3214 | 2005-06-21 01:08:26.000 | 776 776 | 142 142 | 2005-06-23 03:24:26.000 | 2 2 | 2020-12-23 07:16:04 |
| 3492 | 2005-07-05 23:44:37.000 | 980 980 | 142 142 | 2005-07-14 03:54:37.000 | 1 1 | 2020-12-23 07:16:08 |
| 4497 | 2005-07-08 01:51:32.000 | 1995 1995 | 142 142 | 2005-07-15 22:56:32.000 | 1 1 | 2020-12-23 07:16:23 |
| 4531 | 2005-07-08 03:27:59.000 | 3108 3108 | 142 142 | 2005-07-10 22:48:59.000 | 1 1 | 2020-12-23 07:16:23 |
| 6522 | 2005-07-12 04:11:58.000 | 3916 3916 | 142 142 | 2005-07-15 08:32:58.000 | 1 1 | 2020-12-23 07:16:52 |
| 7764 | 2005-07-28 06:40:05.000 | 3537 3537 | 142 142 | 2005-07-30 02:51:05.000 | 2 2 | 2020-12-23 07:17:11 |
| 8513 | 2005-07-29 09:52:59.000 | 3156 3156 | 142 142 | 2005-07-31 12:05:59.000 | 1 1 | 2020-12-23 07:17:22 |
| 8623 | 2005-07-29 13:55:11.000 | 458 458 | 142 142 | 2005-08-05 11:16:11.000 | 1 1 | 2020-12-23 07:17:24 |
| 9020 | 2005-07-30 05:31:27.000 | 1700 1700 | 142 142 | 2005-08-08 06:44:27.000 | 2 2 | 2020-12-23 07:17:29 |
| 9131 | 2005-07-30 09:55:57.000 | 623 623 | 142 142 | 2005-08-01 14:21:57.000 | 1 1 | 2020-12-23 07:17:31 |
| 9419 | 2005-07-30 21:04:59.000 | 4427 4427 | 142 142 | 2005-08-06 15:47:59.000 | 2 2 | 2020-12-23 07:17:35 |
| 10934 | 2005-08-02 02:52:18.000 | 4458 4458 | 142 142 | 2005-08-06 01:23:18.000 | 2 2 | 2020-12-23 07:17:57 |
| 11244 | 2005-08-02 13:33:24.000 | 3423 3423 | 142 142 | 2005-08-10 10:18:24.000 | 2 2 | 2020-12-23 07:18:01 |
| 12964 | 2005-08-19 06:29:13.000 | 2854 2854 | 142 142 | 2005-08-22 12:23:13.000 | 2 2 | 2020-12-23 07:18:25 |
| 13044 | 2005-08-19 09:14:31.000 | 809 809 | 142 142 | 2005-08-20 11:16:31.000 | 1 1 | 2020-12-23 07:18:26 |
| 13745 | 2005-08-20 10:53:49.000 | 1264 1264 | 142 142 | 2005-08-25 13:25:49.000 | 1 1 | 2020-12-23 07:18:37 |
| 13959 | 2005-08-20 18:16:21.000 | 2283 2283 | 142 142 | 2005-08-22 13:56:21.000 | 2 2 | 2020-12-23 07:18:40 |
| 14116 | 2005-08-21 01:11:17.000 | 2356 2356 | 142 142 | 2005-08-24 23:45:17.000 | 2 2 | 2020-12-23 07:18:42 |
| 14813 | 2005-08-22 01:11:37.000 | 3364 3364 | 142 142 | 2005-08-24 05:57:37.000 | 2 2 | 2020-12-23 07:18:52 |
| 15333 | 2005-08-22 20:44:06.000 | 1839 1839 | 142 142 | 2005-08-29 22:34:06.000 | 2 2 | 2020-12-23 07:19:00 |
| 15454 | 2006-02-14 15:16:03.000 | 2946 2946 | 142 142 | 2 2 | 2020-12-23 07:19:01 | |
| 15477 | 2005-08-23 01:46:35.000 | 2406 2406 | 142 142 | 2005-08-28 22:12:35.000 | 1 1 | 2020-12-23 07:19:02 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE rental ( rental_id INT NOT NULL, rental_date TIMESTAMP NOT NULL, inventory_id INT NOT NULL, customer_id INT NOT NULL, return_date TIMESTAMP DEFAULT NULL, staff_id SMALLINT NOT NULL, last_update TIMESTAMP NOT NULL, PRIMARY KEY (rental_id), CONSTRAINT fk_rental_staff FOREIGN KEY (staff_id) REFERENCES staff (staff_id) , CONSTRAINT fk_rental_inventory FOREIGN KEY (inventory_id) REFERENCES inventory (inventory_id) , CONSTRAINT fk_rental_customer FOREIGN KEY (customer_id) REFERENCES customer (customer_id) ); CREATE INDEX idx_rental_fk_inventory_id ON rental(inventory_id) ; CREATE INDEX idx_rental_fk_customer_id ON rental(customer_id) ; CREATE INDEX idx_rental_fk_staff_id ON rental(staff_id) ; CREATE UNIQUE INDEX idx_rental_uq ON rental (rental_date,inventory_id,customer_id) ;