rental
27 rows where customer_id = 139
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 |
|---|---|---|---|---|---|---|
| 1169 | 2005-06-14 23:42:56.000 | 1062 1062 | 139 139 | 2005-06-16 04:02:56.000 | 2 2 | 2020-12-23 07:15:35 |
| 1736 | 2005-06-16 15:52:32.000 | 3771 3771 | 139 139 | 2005-06-21 14:39:32.000 | 2 2 | 2020-12-23 07:15:43 |
| 2659 | 2005-06-19 10:47:42.000 | 66 66 | 139 139 | 2005-06-23 14:03:42.000 | 1 1 | 2020-12-23 07:15:56 |
| 2718 | 2005-06-19 14:49:42.000 | 4443 4443 | 139 139 | 2005-06-26 19:37:42.000 | 1 1 | 2020-12-23 07:15:57 |
| 4660 | 2005-07-08 09:54:47.000 | 1208 1208 | 139 139 | 2005-07-11 15:19:47.000 | 2 2 | 2020-12-23 07:16:25 |
| 4663 | 2005-07-08 09:59:18.000 | 2959 2959 | 139 139 | 2005-07-10 11:25:18.000 | 1 1 | 2020-12-23 07:16:26 |
| 5092 | 2005-07-09 05:57:39.000 | 3256 3256 | 139 139 | 2005-07-12 00:45:39.000 | 2 2 | 2020-12-23 07:16:32 |
| 5265 | 2005-07-09 14:15:01.000 | 4482 4482 | 139 139 | 2005-07-18 14:43:01.000 | 2 2 | 2020-12-23 07:16:34 |
| 5390 | 2005-07-09 19:26:22.000 | 715 715 | 139 139 | 2005-07-14 22:46:22.000 | 1 1 | 2020-12-23 07:16:36 |
| 5494 | 2005-07-10 00:15:00.000 | 3087 3087 | 139 139 | 2005-07-17 01:12:00.000 | 2 2 | 2020-12-23 07:16:38 |
| 6496 | 2005-07-12 02:57:39.000 | 3550 3550 | 139 139 | 2005-07-20 01:43:39.000 | 1 1 | 2020-12-23 07:16:52 |
| 6740 | 2005-07-12 14:22:08.000 | 2431 2431 | 139 139 | 2005-07-14 14:35:08.000 | 1 1 | 2020-12-23 07:16:56 |
| 7369 | 2005-07-27 15:07:58.000 | 3889 3889 | 139 139 | 2005-07-30 09:16:58.000 | 2 2 | 2020-12-23 07:17:05 |
| 7767 | 2005-07-28 06:42:02.000 | 329 329 | 139 139 | 2005-08-05 11:19:02.000 | 2 2 | 2020-12-23 07:17:11 |
| 9415 | 2005-07-30 20:48:31.000 | 3336 3336 | 139 139 | 2005-08-05 19:45:31.000 | 2 2 | 2020-12-23 07:17:35 |
| 9920 | 2005-07-31 14:57:13.000 | 3108 3108 | 139 139 | 2005-08-03 18:58:13.000 | 2 2 | 2020-12-23 07:17:43 |
| 10900 | 2005-08-02 01:34:26.000 | 1749 1749 | 139 139 | 2005-08-07 00:52:26.000 | 2 2 | 2020-12-23 07:17:56 |
| 12859 | 2005-08-19 02:23:23.000 | 2289 2289 | 139 139 | 2005-08-28 04:55:23.000 | 2 2 | 2020-12-23 07:18:23 |
| 13401 | 2005-08-19 22:16:16.000 | 488 488 | 139 139 | 2005-08-25 19:01:16.000 | 2 2 | 2020-12-23 07:18:31 |
| 14736 | 2005-08-21 22:25:53.000 | 207 207 | 139 139 | 2005-08-25 19:01:53.000 | 2 2 | 2020-12-23 07:18:51 |
| 14788 | 2005-08-22 00:27:59.000 | 1917 1917 | 139 139 | 2005-08-29 23:54:59.000 | 2 2 | 2020-12-23 07:18:52 |
| 15024 | 2005-08-22 08:57:10.000 | 1831 1831 | 139 139 | 2005-08-24 10:39:10.000 | 1 1 | 2020-12-23 07:18:55 |
| 15029 | 2005-08-22 09:04:53.000 | 2234 2234 | 139 139 | 2005-08-25 09:03:53.000 | 1 1 | 2020-12-23 07:18:55 |
| 15062 | 2005-08-22 10:34:39.000 | 4393 4393 | 139 139 | 2005-08-26 13:09:39.000 | 2 2 | 2020-12-23 07:18:56 |
| 15218 | 2005-08-22 16:59:05.000 | 10 10 | 139 139 | 2005-08-30 17:01:05.000 | 1 1 | 2020-12-23 07:18:58 |
| 15471 | 2005-08-23 01:38:48.000 | 2591 2591 | 139 139 | 2005-08-31 19:47:48.000 | 1 1 | 2020-12-23 07:19:02 |
| 15743 | 2005-08-23 12:12:05.000 | 1625 1625 | 139 139 | 2005-08-26 11:35:05.000 | 1 1 | 2020-12-23 07:19:05 |
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) ;