rental
28 rows where customer_id = 262
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 |
|---|---|---|---|---|---|---|
| 984 | 2005-05-30 22:17:17.000 | 2305 2305 | 262 262 | 2005-06-01 20:15:17.000 | 2 2 | 2020-12-23 07:15:33 |
| 1563 | 2005-06-16 02:46:28.000 | 1516 1516 | 262 262 | 2005-06-18 02:37:28.000 | 1 1 | 2020-12-23 07:15:40 |
| 2771 | 2005-06-19 17:54:48.000 | 40 40 | 262 262 | 2005-06-27 17:14:48.000 | 1 1 | 2020-12-23 07:15:58 |
| 2850 | 2005-06-19 23:06:28.000 | 206 206 | 262 262 | 2005-06-28 03:30:28.000 | 2 2 | 2020-12-23 07:15:59 |
| 2915 | 2005-06-20 03:57:17.000 | 1293 1293 | 262 262 | 2005-06-24 05:59:17.000 | 2 2 | 2020-12-23 07:16:00 |
| 3521 | 2005-07-06 01:00:11.000 | 1440 1440 | 262 262 | 2005-07-11 19:15:11.000 | 2 2 | 2020-12-23 07:16:08 |
| 3699 | 2005-07-06 10:11:25.000 | 418 418 | 262 262 | 2005-07-14 05:18:25.000 | 1 1 | 2020-12-23 07:16:11 |
| 4501 | 2005-07-08 02:12:00.000 | 1412 1412 | 262 262 | 2005-07-10 02:16:00.000 | 2 2 | 2020-12-23 07:16:23 |
| 5503 | 2005-07-10 00:35:37.000 | 3892 3892 | 262 262 | 2005-07-12 20:29:37.000 | 1 1 | 2020-12-23 07:16:38 |
| 6291 | 2005-07-11 17:16:40.000 | 3126 3126 | 262 262 | 2005-07-13 18:24:40.000 | 2 2 | 2020-12-23 07:16:49 |
| 6547 | 2005-07-12 04:57:46.000 | 2656 2656 | 262 262 | 2005-07-18 08:36:46.000 | 2 2 | 2020-12-23 07:16:53 |
| 6724 | 2005-07-12 13:45:15.000 | 2486 2486 | 262 262 | 2005-07-19 19:18:15.000 | 1 1 | 2020-12-23 07:16:55 |
| 6762 | 2005-07-12 15:25:33.000 | 3857 3857 | 262 262 | 2005-07-21 18:57:33.000 | 1 1 | 2020-12-23 07:16:56 |
| 6805 | 2005-07-12 17:23:01.000 | 1758 1758 | 262 262 | 2005-07-21 19:38:01.000 | 2 2 | 2020-12-23 07:16:57 |
| 6986 | 2005-07-27 00:59:05.000 | 2104 2104 | 262 262 | 2005-07-29 00:31:05.000 | 1 1 | 2020-12-23 07:16:59 |
| 9105 | 2005-07-30 08:50:25.000 | 4443 4443 | 262 262 | 2005-08-05 06:08:25.000 | 1 1 | 2020-12-23 07:17:31 |
| 10421 | 2005-08-01 08:14:10.000 | 925 925 | 262 262 | 2005-08-03 05:56:10.000 | 2 2 | 2020-12-23 07:17:49 |
| 10770 | 2005-08-01 20:45:39.000 | 2567 2567 | 262 262 | 2005-08-04 19:21:39.000 | 1 1 | 2020-12-23 07:17:55 |
| 13466 | 2005-08-20 00:55:16.000 | 3088 3088 | 262 262 | 2005-08-22 22:48:16.000 | 1 1 | 2020-12-23 07:18:32 |
| 13808 | 2005-08-20 12:55:43.000 | 3689 3689 | 262 262 | 2005-08-29 11:01:43.000 | 2 2 | 2020-12-23 07:18:38 |
| 14180 | 2005-08-21 03:16:15.000 | 796 796 | 262 262 | 2005-08-24 22:31:15.000 | 2 2 | 2020-12-23 07:18:43 |
| 14465 | 2005-08-21 12:54:22.000 | 4206 4206 | 262 262 | 2005-08-28 10:46:22.000 | 2 2 | 2020-12-23 07:18:47 |
| 14834 | 2005-08-22 01:45:58.000 | 3105 3105 | 262 262 | 2005-08-28 20:52:58.000 | 1 1 | 2020-12-23 07:18:52 |
| 15270 | 2005-08-22 18:48:42.000 | 4123 4123 | 262 262 | 2005-08-28 15:38:42.000 | 2 2 | 2020-12-23 07:18:59 |
| 15456 | 2005-08-23 01:07:01.000 | 2451 2451 | 262 262 | 2005-08-24 23:28:01.000 | 2 2 | 2020-12-23 07:19:01 |
| 15640 | 2005-08-23 08:04:40.000 | 3505 3505 | 262 262 | 2005-08-24 06:38:40.000 | 1 1 | 2020-12-23 07:19:04 |
| 15771 | 2005-08-23 13:18:46.000 | 3667 3667 | 262 262 | 2005-08-26 07:29:46.000 | 1 1 | 2020-12-23 07:19:06 |
| 15918 | 2005-08-23 17:57:35.000 | 1456 1456 | 262 262 | 2005-08-28 14:16:35.000 | 2 2 | 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) ;