rental
20 rows where customer_id = 320
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 |
|---|---|---|---|---|---|---|
| 1258 | 2005-06-15 06:21:30.000 | 4530 4530 | 320 320 | 2005-06-18 05:43:30.000 | 2 2 | 2020-12-23 07:15:36 |
| 1484 | 2005-06-15 21:22:35.000 | 1589 1589 | 320 320 | 2005-06-20 02:27:35.000 | 2 2 | 2020-12-23 07:15:39 |
| 1567 | 2005-06-16 03:13:30.000 | 3098 3098 | 320 320 | 2005-06-21 23:56:30.000 | 1 1 | 2020-12-23 07:15:40 |
| 2216 | 2005-06-18 03:08:17.000 | 1428 1428 | 320 320 | 2005-06-19 08:13:17.000 | 1 1 | 2020-12-23 07:15:50 |
| 2883 | 2005-06-20 01:29:10.000 | 585 585 | 320 320 | 2005-06-28 06:12:10.000 | 1 1 | 2020-12-23 07:15:59 |
| 3519 | 2005-07-06 00:57:29.000 | 4314 4314 | 320 320 | 2005-07-10 21:12:29.000 | 2 2 | 2020-12-23 07:16:08 |
| 3756 | 2005-07-06 12:40:38.000 | 30 30 | 320 320 | 2005-07-11 09:29:38.000 | 1 1 | 2020-12-23 07:16:12 |
| 4173 | 2005-07-07 09:57:26.000 | 4272 4272 | 320 320 | 2005-07-10 04:05:26.000 | 1 1 | 2020-12-23 07:16:18 |
| 7057 | 2005-07-27 03:50:03.000 | 1196 1196 | 320 320 | 2005-08-04 04:36:03.000 | 1 1 | 2020-12-23 07:17:01 |
| 7064 | 2005-07-27 03:53:29.000 | 4204 4204 | 320 320 | 2005-08-03 06:32:29.000 | 1 1 | 2020-12-23 07:17:01 |
| 7930 | 2005-07-28 12:21:08.000 | 4181 4181 | 320 320 | 2005-07-30 11:56:08.000 | 1 1 | 2020-12-23 07:17:13 |
| 8144 | 2005-07-28 20:30:55.000 | 3556 3556 | 320 320 | 2005-07-31 18:10:55.000 | 2 2 | 2020-12-23 07:17:17 |
| 8235 | 2005-07-29 00:22:56.000 | 1581 1581 | 320 320 | 2005-08-03 04:03:56.000 | 2 2 | 2020-12-23 07:17:18 |
| 8238 | 2005-07-29 00:30:06.000 | 2941 2941 | 320 320 | 2005-08-02 22:52:06.000 | 2 2 | 2020-12-23 07:17:18 |
| 8794 | 2005-07-29 20:59:38.000 | 3509 3509 | 320 320 | 2005-07-31 00:15:38.000 | 2 2 | 2020-12-23 07:17:26 |
| 9509 | 2005-07-31 00:22:42.000 | 818 818 | 320 320 | 2005-08-03 23:24:42.000 | 1 1 | 2020-12-23 07:17:37 |
| 11208 | 2005-08-02 12:02:37.000 | 4566 4566 | 320 320 | 2005-08-05 10:56:37.000 | 1 1 | 2020-12-23 07:18:00 |
| 11560 | 2005-08-17 01:20:30.000 | 2316 2316 | 320 320 | 2005-08-18 04:29:30.000 | 2 2 | 2020-12-23 07:18:05 |
| 14171 | 2005-08-21 03:00:42.000 | 4179 4179 | 320 320 | 2005-08-24 00:54:42.000 | 1 1 | 2020-12-23 07:18:43 |
| 15302 | 2005-08-22 19:44:53.000 | 188 188 | 320 320 | 2005-08-24 18:13:53.000 | 2 2 | 2020-12-23 07:18:59 |
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) ;