rental
24 rows where customer_id = 557
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 |
|---|---|---|---|---|---|---|
| 467 | 2005-05-27 21:10:03.000 | 339 339 | 557 557 | 2005-06-01 16:08:03.000 | 1 1 | 2020-12-23 07:15:26 |
| 478 | 2005-05-27 22:38:20.000 | 424 424 | 557 557 | 2005-05-31 18:39:20.000 | 2 2 | 2020-12-23 07:15:26 |
| 1666 | 2005-06-16 10:17:19.000 | 4019 4019 | 557 557 | 2005-06-21 05:50:19.000 | 1 1 | 2020-12-23 07:15:42 |
| 2988 | 2005-06-20 08:59:08.000 | 3160 3160 | 557 557 | 2005-06-28 04:31:08.000 | 2 2 | 2020-12-23 07:16:01 |
| 3050 | 2005-06-20 13:03:03.000 | 2397 2397 | 557 557 | 2005-06-29 07:22:03.000 | 1 1 | 2020-12-23 07:16:01 |
| 4651 | 2005-07-08 09:39:39.000 | 4064 4064 | 557 557 | 2005-07-09 12:14:39.000 | 2 2 | 2020-12-23 07:16:25 |
| 4851 | 2005-07-08 18:40:05.000 | 134 134 | 557 557 | 2005-07-12 21:46:05.000 | 1 1 | 2020-12-23 07:16:28 |
| 6459 | 2005-07-12 01:12:03.000 | 4025 4025 | 557 557 | 2005-07-15 23:48:03.000 | 1 1 | 2020-12-23 07:16:51 |
| 6713 | 2005-07-12 13:27:36.000 | 4218 4218 | 557 557 | 2005-07-16 11:14:36.000 | 1 1 | 2020-12-23 07:16:55 |
| 6823 | 2005-07-12 18:24:31.000 | 795 795 | 557 557 | 2005-07-17 23:13:31.000 | 1 1 | 2020-12-23 07:16:57 |
| 6898 | 2005-07-12 21:39:04.000 | 1725 1725 | 557 557 | 2005-07-15 20:30:04.000 | 1 1 | 2020-12-23 07:16:58 |
| 9336 | 2005-07-30 18:01:15.000 | 1911 1911 | 557 557 | 2005-08-05 23:10:15.000 | 1 1 | 2020-12-23 07:17:34 |
| 9341 | 2005-07-30 18:07:58.000 | 894 894 | 557 557 | 2005-08-01 17:43:58.000 | 1 1 | 2020-12-23 07:17:34 |
| 9366 | 2005-07-30 18:48:57.000 | 4013 4013 | 557 557 | 2005-08-03 15:17:57.000 | 2 2 | 2020-12-23 07:17:35 |
| 9367 | 2005-07-30 18:49:58.000 | 793 793 | 557 557 | 2005-08-08 22:04:58.000 | 1 1 | 2020-12-23 07:17:35 |
| 11181 | 2005-08-02 10:55:03.000 | 3127 3127 | 557 557 | 2005-08-07 10:43:03.000 | 1 1 | 2020-12-23 07:18:00 |
| 12555 | 2005-08-18 14:49:22.000 | 4434 4434 | 557 557 | 2005-08-26 14:11:22.000 | 2 2 | 2020-12-23 07:18:19 |
| 12789 | 2005-08-19 00:16:19.000 | 2412 2412 | 557 557 | 2005-08-25 00:18:19.000 | 2 2 | 2020-12-23 07:18:22 |
| 13540 | 2005-08-20 03:41:23.000 | 3785 3785 | 557 557 | 2005-08-27 09:09:23.000 | 2 2 | 2020-12-23 07:18:33 |
| 13794 | 2005-08-20 12:25:32.000 | 2148 2148 | 557 557 | 2005-08-23 06:38:32.000 | 2 2 | 2020-12-23 07:18:37 |
| 14278 | 2006-02-14 15:16:03.000 | 2334 2334 | 557 557 | 2 2 | 2020-12-23 07:18:45 | |
| 15236 | 2005-08-22 17:44:27.000 | 4124 4124 | 557 557 | 2005-08-24 23:25:27.000 | 1 1 | 2020-12-23 07:18:58 |
| 15570 | 2005-08-23 05:24:55.000 | 4014 4014 | 557 557 | 2005-08-31 07:06:55.000 | 2 2 | 2020-12-23 07:19:03 |
| 15914 | 2005-08-23 17:49:26.000 | 747 747 | 557 557 | 2005-08-24 12:20:26.000 | 1 1 | 2020-12-23 07:19:08 |
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) ;