rental
25 rows where customer_id = 232
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 |
|---|---|---|---|---|---|---|
| 28 | 2005-05-25 03:42:37.000 | 4068 4068 | 232 232 | 2005-05-26 09:26:37.000 | 2 2 | 2020-12-23 07:15:20 |
| 805 | 2005-05-29 18:18:18.000 | 3132 3132 | 232 232 | 2005-06-07 15:11:18.000 | 2 2 | 2020-12-23 07:15:30 |
| 1619 | 2005-06-16 07:14:13.000 | 4258 4258 | 232 232 | 2005-06-19 05:50:13.000 | 2 2 | 2020-12-23 07:15:41 |
| 2833 | 2005-06-19 21:34:54.000 | 1976 1976 | 232 232 | 2005-06-28 16:21:54.000 | 1 1 | 2020-12-23 07:15:58 |
| 6234 | 2005-07-11 14:16:10.000 | 2911 2911 | 232 232 | 2005-07-19 19:55:10.000 | 1 1 | 2020-12-23 07:16:48 |
| 6309 | 2005-07-11 18:13:24.000 | 1054 1054 | 232 232 | 2005-07-13 23:11:24.000 | 1 1 | 2020-12-23 07:16:49 |
| 7123 | 2005-07-27 06:08:48.000 | 134 134 | 232 232 | 2005-08-04 05:26:48.000 | 1 1 | 2020-12-23 07:17:02 |
| 7653 | 2005-07-28 01:58:30.000 | 814 814 | 232 232 | 2005-07-28 23:32:30.000 | 2 2 | 2020-12-23 07:17:09 |
| 7707 | 2005-07-28 04:07:47.000 | 2563 2563 | 232 232 | 2005-07-29 02:02:47.000 | 1 1 | 2020-12-23 07:17:10 |
| 7749 | 2005-07-28 05:53:36.000 | 3585 3585 | 232 232 | 2005-08-01 03:49:36.000 | 1 1 | 2020-12-23 07:17:11 |
| 7990 | 2005-07-28 14:43:08.000 | 188 188 | 232 232 | 2005-08-01 10:51:08.000 | 2 2 | 2020-12-23 07:17:14 |
| 8306 | 2005-07-29 03:12:26.000 | 1708 1708 | 232 232 | 2005-08-01 23:26:26.000 | 1 1 | 2020-12-23 07:17:19 |
| 8401 | 2005-07-29 06:25:08.000 | 3121 3121 | 232 232 | 2005-08-01 06:49:08.000 | 1 1 | 2020-12-23 07:17:20 |
| 8655 | 2005-07-29 15:04:42.000 | 3986 3986 | 232 232 | 2005-08-04 11:26:42.000 | 1 1 | 2020-12-23 07:17:24 |
| 9270 | 2005-07-30 15:03:16.000 | 700 700 | 232 232 | 2005-07-31 16:09:16.000 | 2 2 | 2020-12-23 07:17:33 |
| 9330 | 2005-07-30 17:44:24.000 | 4227 4227 | 232 232 | 2005-08-08 17:39:24.000 | 1 1 | 2020-12-23 07:17:34 |
| 9365 | 2005-07-30 18:46:02.000 | 1539 1539 | 232 232 | 2005-08-03 20:15:02.000 | 1 1 | 2020-12-23 07:17:35 |
| 10157 | 2005-07-31 22:38:48.000 | 2960 2960 | 232 232 | 2005-08-01 21:38:48.000 | 1 1 | 2020-12-23 07:17:46 |
| 10539 | 2005-08-01 12:23:00.000 | 3341 3341 | 232 232 | 2005-08-07 10:25:00.000 | 2 2 | 2020-12-23 07:17:51 |
| 11861 | 2005-08-17 13:53:47.000 | 2674 2674 | 232 232 | 2005-08-21 16:07:47.000 | 1 1 | 2020-12-23 07:18:09 |
| 12853 | 2005-08-19 02:15:32.000 | 3753 3753 | 232 232 | 2005-08-27 21:26:32.000 | 2 2 | 2020-12-23 07:18:23 |
| 13707 | 2005-08-20 09:33:58.000 | 826 826 | 232 232 | 2005-08-23 07:44:58.000 | 2 2 | 2020-12-23 07:18:36 |
| 14527 | 2005-08-21 15:07:42.000 | 3496 3496 | 232 232 | 2005-08-23 12:31:42.000 | 1 1 | 2020-12-23 07:18:48 |
| 14857 | 2005-08-22 02:42:39.000 | 4150 4150 | 232 232 | 2005-08-24 21:26:39.000 | 2 2 | 2020-12-23 07:18:53 |
| 15553 | 2005-08-23 04:33:39.000 | 1659 1659 | 232 232 | 2005-08-25 07:53:39.000 | 2 2 | 2020-12-23 07:19:03 |
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) ;