rental
28 rows where customer_id = 57
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 |
|---|---|---|---|---|---|---|
| 152 | 2005-05-26 00:41:10.000 | 2622 2622 | 57 57 | 2005-06-03 06:05:10.000 | 1 1 | 2020-12-23 07:15:22 |
| 943 | 2005-05-30 15:20:19.000 | 3737 3737 | 57 57 | 2005-06-06 18:53:19.000 | 1 1 | 2020-12-23 07:15:32 |
| 2058 | 2005-06-17 15:34:41.000 | 1324 1324 | 57 57 | 2005-06-25 14:50:41.000 | 1 1 | 2020-12-23 07:15:48 |
| 2105 | 2005-06-17 19:15:45.000 | 4090 4090 | 57 57 | 2005-06-20 16:00:45.000 | 1 1 | 2020-12-23 07:15:48 |
| 2360 | 2005-06-18 13:11:13.000 | 37 37 | 57 57 | 2005-06-23 15:32:13.000 | 2 2 | 2020-12-23 07:15:52 |
| 2910 | 2005-06-20 03:31:18.000 | 630 630 | 57 57 | 2005-06-28 00:35:18.000 | 1 1 | 2020-12-23 07:16:00 |
| 3357 | 2005-06-21 11:55:42.000 | 2528 2528 | 57 57 | 2005-06-22 07:19:42.000 | 2 2 | 2020-12-23 07:16:06 |
| 3727 | 2005-07-06 11:16:43.000 | 2886 2886 | 57 57 | 2005-07-07 15:39:43.000 | 1 1 | 2020-12-23 07:16:11 |
| 4226 | 2005-07-07 12:37:56.000 | 1692 1692 | 57 57 | 2005-07-09 08:48:56.000 | 2 2 | 2020-12-23 07:16:19 |
| 5060 | 2005-07-09 04:28:03.000 | 4317 4317 | 57 57 | 2005-07-12 07:41:03.000 | 2 2 | 2020-12-23 07:16:31 |
| 5694 | 2005-07-10 09:40:38.000 | 3476 3476 | 57 57 | 2005-07-14 09:16:38.000 | 1 1 | 2020-12-23 07:16:41 |
| 5948 | 2005-07-10 23:12:08.000 | 3260 3260 | 57 57 | 2005-07-18 19:06:08.000 | 2 2 | 2020-12-23 07:16:44 |
| 6482 | 2005-07-12 01:50:21.000 | 4135 4135 | 57 57 | 2005-07-14 06:49:21.000 | 2 2 | 2020-12-23 07:16:52 |
| 6494 | 2005-07-12 02:42:51.000 | 1124 1124 | 57 57 | 2005-07-20 06:57:51.000 | 1 1 | 2020-12-23 07:16:52 |
| 6649 | 2005-07-12 10:51:09.000 | 70 70 | 57 57 | 2005-07-14 16:05:09.000 | 2 2 | 2020-12-23 07:16:54 |
| 8249 | 2005-07-29 00:48:44.000 | 3331 3331 | 57 57 | 2005-08-07 04:25:44.000 | 2 2 | 2020-12-23 07:17:18 |
| 9086 | 2005-07-30 08:18:46.000 | 2779 2779 | 57 57 | 2005-08-06 06:10:46.000 | 2 2 | 2020-12-23 07:17:30 |
| 9136 | 2005-07-30 10:07:20.000 | 1734 1734 | 57 57 | 2005-07-31 08:20:20.000 | 2 2 | 2020-12-23 07:17:31 |
| 9211 | 2005-07-30 12:59:45.000 | 595 595 | 57 57 | 2005-08-07 18:17:45.000 | 2 2 | 2020-12-23 07:17:32 |
| 9703 | 2005-07-31 07:34:52.000 | 2708 2708 | 57 57 | 2005-08-03 13:33:52.000 | 2 2 | 2020-12-23 07:17:39 |
| 9812 | 2005-07-31 11:28:07.000 | 1540 1540 | 57 57 | 2005-08-01 12:35:07.000 | 2 2 | 2020-12-23 07:17:41 |
| 10169 | 2005-07-31 23:27:13.000 | 2675 2675 | 57 57 | 2005-08-05 20:32:13.000 | 2 2 | 2020-12-23 07:17:46 |
| 12925 | 2005-08-19 04:59:01.000 | 3361 3361 | 57 57 | 2005-08-27 02:03:01.000 | 2 2 | 2020-12-23 07:18:24 |
| 13163 | 2005-08-19 13:29:46.000 | 3068 3068 | 57 57 | 2005-08-22 07:48:46.000 | 2 2 | 2020-12-23 07:18:28 |
| 13743 | 2005-08-20 10:51:27.000 | 3693 3693 | 57 57 | 2005-08-24 15:54:27.000 | 1 1 | 2020-12-23 07:18:37 |
| 13929 | 2005-08-20 17:13:48.000 | 946 946 | 57 57 | 2005-08-28 15:19:48.000 | 1 1 | 2020-12-23 07:18:40 |
| 15571 | 2005-08-23 05:26:30.000 | 716 716 | 57 57 | 2005-08-29 00:54:30.000 | 2 2 | 2020-12-23 07:19:03 |
| 15871 | 2005-08-23 16:24:24.000 | 425 425 | 57 57 | 2005-09-01 13:48:24.000 | 2 2 | 2020-12-23 07:19:07 |
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) ;