rental
26 rows where customer_id = 510
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 |
|---|---|---|---|---|---|---|
| 75 | 2005-05-25 11:13:34.000 | 3393 3393 | 510 510 | 2005-06-03 12:58:34.000 | 1 1 | 2020-12-23 07:15:21 |
| 372 | 2005-05-27 08:13:58.000 | 4089 4089 | 510 510 | 2005-06-04 03:50:58.000 | 2 2 | 2020-12-23 07:15:24 |
| 1118 | 2005-05-31 16:23:02.000 | 213 213 | 510 510 | 2005-06-03 20:00:02.000 | 1 1 | 2020-12-23 07:15:35 |
| 1435 | 2005-06-15 18:32:30.000 | 2769 2769 | 510 510 | 2005-06-24 12:44:30.000 | 2 2 | 2020-12-23 07:15:39 |
| 1757 | 2005-06-16 17:32:24.000 | 4491 4491 | 510 510 | 2005-06-18 13:12:24.000 | 1 1 | 2020-12-23 07:15:43 |
| 1925 | 2005-06-17 06:16:47.000 | 3995 3995 | 510 510 | 2005-06-21 06:03:47.000 | 1 1 | 2020-12-23 07:15:46 |
| 2729 | 2005-06-19 15:06:15.000 | 4449 4449 | 510 510 | 2005-06-27 17:58:15.000 | 2 2 | 2020-12-23 07:15:57 |
| 2806 | 2005-06-19 19:30:48.000 | 2114 2114 | 510 510 | 2005-06-20 19:42:48.000 | 2 2 | 2020-12-23 07:15:58 |
| 2817 | 2005-06-19 20:05:22.000 | 3476 3476 | 510 510 | 2005-06-24 23:29:22.000 | 1 1 | 2020-12-23 07:15:58 |
| 3352 | 2005-06-21 11:26:29.000 | 578 578 | 510 510 | 2005-06-28 07:26:29.000 | 1 1 | 2020-12-23 07:16:06 |
| 3465 | 2005-06-21 22:10:01.000 | 1488 1488 | 510 510 | 2005-06-30 21:35:01.000 | 1 1 | 2020-12-23 07:16:07 |
| 3744 | 2005-07-06 12:10:02.000 | 3343 3343 | 510 510 | 2005-07-08 11:49:02.000 | 2 2 | 2020-12-23 07:16:12 |
| 4014 | 2005-07-07 00:58:54.000 | 583 583 | 510 510 | 2005-07-12 02:40:54.000 | 1 1 | 2020-12-23 07:16:16 |
| 5851 | 2005-07-10 17:40:47.000 | 3944 3944 | 510 510 | 2005-07-11 19:24:47.000 | 2 2 | 2020-12-23 07:16:43 |
| 6531 | 2005-07-12 04:35:24.000 | 4231 4231 | 510 510 | 2005-07-16 05:37:24.000 | 2 2 | 2020-12-23 07:16:53 |
| 7457 | 2005-07-27 18:35:17.000 | 3635 3635 | 510 510 | 2005-07-30 12:41:17.000 | 2 2 | 2020-12-23 07:17:07 |
| 7678 | 2005-07-28 02:58:16.000 | 3398 3398 | 510 510 | 2005-08-06 04:22:16.000 | 1 1 | 2020-12-23 07:17:10 |
| 7794 | 2005-07-28 07:28:03.000 | 4509 4509 | 510 510 | 2005-08-06 12:32:03.000 | 2 2 | 2020-12-23 07:17:12 |
| 8763 | 2005-07-29 19:38:24.000 | 374 374 | 510 510 | 2005-08-04 16:51:24.000 | 1 1 | 2020-12-23 07:17:26 |
| 8926 | 2005-07-30 02:10:31.000 | 3677 3677 | 510 510 | 2005-08-03 23:56:31.000 | 1 1 | 2020-12-23 07:17:28 |
| 10131 | 2005-07-31 21:45:28.000 | 4169 4169 | 510 510 | 2005-08-04 00:19:28.000 | 2 2 | 2020-12-23 07:17:46 |
| 10265 | 2005-08-01 03:05:04.000 | 3338 3338 | 510 510 | 2005-08-08 08:09:04.000 | 1 1 | 2020-12-23 07:17:47 |
| 11996 | 2005-08-17 18:34:37.000 | 2720 2720 | 510 510 | 2005-08-20 22:25:37.000 | 2 2 | 2020-12-23 07:18:11 |
| 12317 | 2005-08-18 06:17:06.000 | 90 90 | 510 510 | 2005-08-22 08:56:06.000 | 1 1 | 2020-12-23 07:18:16 |
| 12406 | 2005-08-18 09:38:02.000 | 4368 4368 | 510 510 | 2005-08-22 12:56:02.000 | 1 1 | 2020-12-23 07:18:17 |
| 15065 | 2005-08-22 10:46:44.000 | 468 468 | 510 510 | 2005-08-27 09:40:44.000 | 2 2 | 2020-12-23 07:18:56 |
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) ;