rental
23 rows where customer_id = 335
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 |
|---|---|---|---|---|---|---|
| 3329 | 2005-06-21 09:20:31.000 | 3506 3506 | 335 335 | 2005-06-22 10:00:31.000 | 2 2 | 2020-12-23 07:16:05 |
| 3607 | 2005-07-06 05:30:09.000 | 542 542 | 335 335 | 2005-07-08 01:36:09.000 | 2 2 | 2020-12-23 07:16:09 |
| 4016 | 2005-07-07 01:05:50.000 | 3318 3318 | 335 335 | 2005-07-09 05:59:50.000 | 1 1 | 2020-12-23 07:16:16 |
| 4032 | 2005-07-07 02:34:13.000 | 2628 2628 | 335 335 | 2005-07-14 22:43:13.000 | 1 1 | 2020-12-23 07:16:16 |
| 4279 | 2005-07-07 15:01:53.000 | 581 581 | 335 335 | 2005-07-08 09:43:53.000 | 1 1 | 2020-12-23 07:16:20 |
| 4387 | 2005-07-07 20:56:47.000 | 591 591 | 335 335 | 2005-07-16 00:51:47.000 | 1 1 | 2020-12-23 07:16:21 |
| 5024 | 2005-07-09 02:25:12.000 | 2987 2987 | 335 335 | 2005-07-12 03:15:12.000 | 1 1 | 2020-12-23 07:16:31 |
| 5252 | 2005-07-09 13:40:44.000 | 2581 2581 | 335 335 | 2005-07-14 09:41:44.000 | 1 1 | 2020-12-23 07:16:34 |
| 5728 | 2005-07-10 11:26:14.000 | 636 636 | 335 335 | 2005-07-15 12:55:14.000 | 1 1 | 2020-12-23 07:16:41 |
| 6624 | 2005-07-12 09:05:50.000 | 3946 3946 | 335 335 | 2005-07-18 13:59:50.000 | 2 2 | 2020-12-23 07:16:54 |
| 6906 | 2005-07-12 22:03:02.000 | 1435 1435 | 335 335 | 2005-07-15 00:35:02.000 | 1 1 | 2020-12-23 07:16:58 |
| 8634 | 2005-07-29 14:19:57.000 | 2023 2023 | 335 335 | 2005-08-07 13:44:57.000 | 1 1 | 2020-12-23 07:17:24 |
| 8855 | 2005-07-29 23:40:10.000 | 4388 4388 | 335 335 | 2005-08-02 18:07:10.000 | 2 2 | 2020-12-23 07:17:27 |
| 9125 | 2005-07-30 09:43:39.000 | 333 333 | 335 335 | 2005-08-07 14:02:39.000 | 1 1 | 2020-12-23 07:17:31 |
| 9361 | 2005-07-30 18:43:49.000 | 4163 4163 | 335 335 | 2005-08-06 21:24:49.000 | 1 1 | 2020-12-23 07:17:35 |
| 9428 | 2005-07-30 21:18:37.000 | 1948 1948 | 335 335 | 2005-08-05 16:09:37.000 | 1 1 | 2020-12-23 07:17:35 |
| 10606 | 2005-08-01 14:39:15.000 | 81 81 | 335 335 | 2005-08-08 11:31:15.000 | 1 1 | 2020-12-23 07:17:52 |
| 11541 | 2006-02-14 15:16:03.000 | 2026 2026 | 335 335 | 1 1 | 2020-12-23 07:18:05 | |
| 13267 | 2005-08-19 17:31:36.000 | 550 550 | 335 335 | 2005-08-21 13:47:36.000 | 1 1 | 2020-12-23 07:18:29 |
| 13622 | 2005-08-20 06:45:32.000 | 3355 3355 | 335 335 | 2005-08-25 02:40:32.000 | 1 1 | 2020-12-23 07:18:35 |
| 14014 | 2005-08-20 20:47:09.000 | 2188 2188 | 335 335 | 2005-08-21 22:08:09.000 | 2 2 | 2020-12-23 07:18:41 |
| 15005 | 2005-08-22 08:15:44.000 | 2897 2897 | 335 335 | 2005-08-24 09:52:44.000 | 2 2 | 2020-12-23 07:18:55 |
| 15101 | 2005-08-22 11:56:02.000 | 683 683 | 335 335 | 2005-08-28 13:08:02.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) ;