rental
31 rows where customer_id = 300
This data as json, xlsx, CSV (advanced)
Suggested facets: staff_id, rental_date (date), return_date (date), last_update (date)
| rental_id ▼ | rental_date | inventory_id | customer_id | return_date | staff_id | last_update |
|---|---|---|---|---|---|---|
| 457 | 2005-05-27 19:52:29.000 | 2368 2368 | 300 300 | 2005-06-02 17:17:29.000 | 2 2 | 2020-12-23 07:15:26 |
| 780 | 2005-05-29 14:18:32.000 | 1919 1919 | 300 300 | 2005-06-06 20:14:32.000 | 1 1 | 2020-12-23 07:15:30 |
| 1111 | 2005-05-31 15:24:19.000 | 1137 1137 | 300 300 | 2005-06-08 21:18:19.000 | 1 1 | 2020-12-23 07:15:34 |
| 1381 | 2005-06-15 15:17:21.000 | 3262 3262 | 300 300 | 2005-06-20 17:07:21.000 | 2 2 | 2020-12-23 07:15:38 |
| 3177 | 2005-06-20 22:32:44.000 | 2546 2546 | 300 300 | 2005-06-22 23:01:44.000 | 1 1 | 2020-12-23 07:16:03 |
| 3775 | 2005-07-06 13:27:33.000 | 3696 3696 | 300 300 | 2005-07-09 10:27:33.000 | 1 1 | 2020-12-23 07:16:12 |
| 4030 | 2005-07-07 02:25:42.000 | 1734 1734 | 300 300 | 2005-07-08 22:53:42.000 | 2 2 | 2020-12-23 07:16:16 |
| 5562 | 2005-07-10 03:17:42.000 | 3604 3604 | 300 300 | 2005-07-12 03:26:42.000 | 1 1 | 2020-12-23 07:16:39 |
| 5705 | 2005-07-10 10:09:17.000 | 4030 4030 | 300 300 | 2005-07-19 07:24:17.000 | 2 2 | 2020-12-23 07:16:41 |
| 6111 | 2005-07-11 07:26:57.000 | 3504 3504 | 300 300 | 2005-07-13 10:43:57.000 | 2 2 | 2020-12-23 07:16:47 |
| 6822 | 2005-07-12 18:23:39.000 | 1592 1592 | 300 300 | 2005-07-19 21:06:39.000 | 1 1 | 2020-12-23 07:16:57 |
| 6998 | 2005-07-27 01:16:29.000 | 788 788 | 300 300 | 2005-07-30 05:50:29.000 | 2 2 | 2020-12-23 07:17:00 |
| 7815 | 2005-07-28 08:14:11.000 | 3551 3551 | 300 300 | 2005-07-30 02:34:11.000 | 2 2 | 2020-12-23 07:17:12 |
| 8117 | 2005-07-28 19:20:16.000 | 1502 1502 | 300 300 | 2005-08-05 23:55:16.000 | 1 1 | 2020-12-23 07:17:16 |
| 8210 | 2005-07-28 23:31:05.000 | 3424 3424 | 300 300 | 2005-08-06 17:36:05.000 | 1 1 | 2020-12-23 07:17:18 |
| 8283 | 2005-07-29 01:52:22.000 | 2002 2002 | 300 300 | 2005-08-05 03:22:22.000 | 2 2 | 2020-12-23 07:17:19 |
| 9078 | 2005-07-30 08:01:00.000 | 955 955 | 300 300 | 2005-07-31 10:39:00.000 | 1 1 | 2020-12-23 07:17:30 |
| 9127 | 2005-07-30 09:46:36.000 | 4114 4114 | 300 300 | 2005-07-31 07:43:36.000 | 1 1 | 2020-12-23 07:17:31 |
| 9791 | 2005-07-31 10:35:22.000 | 3642 3642 | 300 300 | 2005-08-03 05:34:22.000 | 1 1 | 2020-12-23 07:17:41 |
| 10977 | 2005-08-02 04:12:17.000 | 2302 2302 | 300 300 | 2005-08-06 06:52:17.000 | 2 2 | 2020-12-23 07:17:57 |
| 12484 | 2005-08-18 12:39:37.000 | 3690 3690 | 300 300 | 2005-08-24 08:47:37.000 | 2 2 | 2020-12-23 07:18:18 |
| 12644 | 2005-08-18 18:22:27.000 | 1511 1511 | 300 300 | 2005-08-26 00:01:27.000 | 1 1 | 2020-12-23 07:18:20 |
| 13257 | 2005-08-19 17:01:20.000 | 164 164 | 300 300 | 2005-08-24 17:26:20.000 | 1 1 | 2020-12-23 07:18:29 |
| 13296 | 2005-08-19 18:43:53.000 | 1728 1728 | 300 300 | 2005-08-21 23:30:53.000 | 2 2 | 2020-12-23 07:18:30 |
| 13499 | 2005-08-20 01:52:30.000 | 1893 1893 | 300 300 | 2005-08-28 04:57:30.000 | 1 1 | 2020-12-23 07:18:33 |
| 13717 | 2005-08-20 09:50:52.000 | 1629 1629 | 300 300 | 2005-08-28 11:32:52.000 | 2 2 | 2020-12-23 07:18:36 |
| 14674 | 2005-08-21 20:01:34.000 | 572 572 | 300 300 | 2005-08-27 18:33:34.000 | 1 1 | 2020-12-23 07:18:50 |
| 14709 | 2005-08-21 21:07:59.000 | 1856 1856 | 300 300 | 2005-08-31 02:19:59.000 | 1 1 | 2020-12-23 07:18:51 |
| 15051 | 2005-08-22 10:08:50.000 | 1419 1419 | 300 300 | 2005-08-28 10:23:50.000 | 1 1 | 2020-12-23 07:18:55 |
| 15695 | 2006-02-14 15:16:03.000 | 2954 2954 | 300 300 | 1 1 | 2020-12-23 07:19:05 | |
| 15811 | 2005-08-23 14:43:46.000 | 3487 3487 | 300 300 | 2005-08-27 16:43:46.000 | 1 1 | 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) ;