rental
28 rows where customer_id = 166
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 |
|---|---|---|---|---|---|---|
| 662 | 2005-05-28 21:09:31.000 | 2968 2968 | 166 166 | 2005-06-01 19:00:31.000 | 2 2 | 2020-12-23 07:15:28 |
| 1412 | 2005-06-15 17:09:48.000 | 4236 4236 | 166 166 | 2005-06-18 17:05:48.000 | 2 2 | 2020-12-23 07:15:38 |
| 2211 | 2005-06-18 02:29:10.000 | 4114 4114 | 166 166 | 2005-06-22 02:02:10.000 | 1 1 | 2020-12-23 07:15:50 |
| 2874 | 2005-06-20 00:42:26.000 | 331 331 | 166 166 | 2005-06-28 01:37:26.000 | 2 2 | 2020-12-23 07:15:59 |
| 3085 | 2005-06-20 15:42:33.000 | 4282 4282 | 166 166 | 2005-06-21 16:51:33.000 | 2 2 | 2020-12-23 07:16:02 |
| 3606 | 2005-07-06 05:28:02.000 | 1737 1737 | 166 166 | 2005-07-10 04:51:02.000 | 1 1 | 2020-12-23 07:16:09 |
| 3642 | 2005-07-06 07:18:20.000 | 4204 4204 | 166 166 | 2005-07-09 01:37:20.000 | 1 1 | 2020-12-23 07:16:10 |
| 4389 | 2005-07-07 20:58:58.000 | 1672 1672 | 166 166 | 2005-07-13 19:57:58.000 | 2 2 | 2020-12-23 07:16:21 |
| 4658 | 2005-07-08 09:51:11.000 | 3131 3131 | 166 166 | 2005-07-10 12:30:11.000 | 2 2 | 2020-12-23 07:16:25 |
| 5184 | 2005-07-09 10:14:34.000 | 1101 1101 | 166 166 | 2005-07-14 16:05:34.000 | 2 2 | 2020-12-23 07:16:33 |
| 5380 | 2005-07-09 19:08:44.000 | 3047 3047 | 166 166 | 2005-07-11 20:09:44.000 | 1 1 | 2020-12-23 07:16:36 |
| 5646 | 2005-07-10 07:08:09.000 | 1471 1471 | 166 166 | 2005-07-14 03:48:09.000 | 2 2 | 2020-12-23 07:16:40 |
| 5855 | 2005-07-10 17:54:06.000 | 2457 2457 | 166 166 | 2005-07-18 15:41:06.000 | 2 2 | 2020-12-23 07:16:43 |
| 6237 | 2005-07-11 14:19:12.000 | 2215 2215 | 166 166 | 2005-07-15 15:05:12.000 | 1 1 | 2020-12-23 07:16:48 |
| 6882 | 2005-07-12 20:50:39.000 | 2469 2469 | 166 166 | 2005-07-14 21:01:39.000 | 1 1 | 2020-12-23 07:16:58 |
| 7581 | 2005-07-27 23:14:35.000 | 2051 2051 | 166 166 | 2005-07-29 21:30:35.000 | 1 1 | 2020-12-23 07:17:08 |
| 8052 | 2005-07-28 16:57:31.000 | 2460 2460 | 166 166 | 2005-08-03 18:03:31.000 | 2 2 | 2020-12-23 07:17:15 |
| 9009 | 2005-07-30 05:12:01.000 | 4136 4136 | 166 166 | 2005-08-07 10:58:01.000 | 1 1 | 2020-12-23 07:17:29 |
| 10422 | 2005-08-01 08:17:11.000 | 37 37 | 166 166 | 2005-08-10 10:08:11.000 | 2 2 | 2020-12-23 07:17:49 |
| 12683 | 2005-08-18 19:50:43.000 | 1802 1802 | 166 166 | 2005-08-26 00:47:43.000 | 1 1 | 2020-12-23 07:18:20 |
| 12968 | 2005-08-19 06:38:18.000 | 3108 3108 | 166 166 | 2005-08-20 08:29:18.000 | 1 1 | 2020-12-23 07:18:25 |
| 13582 | 2005-08-20 05:28:11.000 | 211 211 | 166 166 | 2005-08-23 02:06:11.000 | 2 2 | 2020-12-23 07:18:34 |
| 13901 | 2005-08-20 16:06:53.000 | 3281 3281 | 166 166 | 2005-08-28 11:30:53.000 | 1 1 | 2020-12-23 07:18:39 |
| 14261 | 2005-08-21 06:07:24.000 | 1426 1426 | 166 166 | 2005-08-26 09:57:24.000 | 1 1 | 2020-12-23 07:18:45 |
| 14281 | 2005-08-21 06:40:48.000 | 1848 1848 | 166 166 | 2005-08-26 11:42:48.000 | 2 2 | 2020-12-23 07:18:45 |
| 15213 | 2005-08-22 16:49:02.000 | 2002 2002 | 166 166 | 2005-08-31 20:22:02.000 | 1 1 | 2020-12-23 07:18:58 |
| 15216 | 2005-08-22 16:57:02.000 | 1633 1633 | 166 166 | 2005-08-24 16:11:02.000 | 2 2 | 2020-12-23 07:18:58 |
| 15806 | 2005-08-23 14:31:50.000 | 2683 2683 | 166 166 | 2005-08-27 16:08:50.000 | 2 2 | 2020-12-23 07:19:06 |
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) ;