rental
23 rows where customer_id = 431
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 |
|---|---|---|---|---|---|---|
| 1126 | 2005-05-31 17:27:45.000 | 2765 2765 | 431 431 | 2005-06-04 20:06:45.000 | 2 2 | 2020-12-23 07:15:35 |
| 1561 | 2005-06-16 02:41:30.000 | 2263 2263 | 431 431 | 2005-06-22 05:19:30.000 | 1 1 | 2020-12-23 07:15:40 |
| 2096 | 2005-06-17 18:33:04.000 | 1069 1069 | 431 431 | 2005-06-21 17:29:04.000 | 2 2 | 2020-12-23 07:15:48 |
| 2269 | 2005-06-18 06:20:54.000 | 3088 3088 | 431 431 | 2005-06-25 04:51:54.000 | 2 2 | 2020-12-23 07:15:51 |
| 2281 | 2005-06-18 06:47:29.000 | 4212 4212 | 431 431 | 2005-06-20 10:27:29.000 | 2 2 | 2020-12-23 07:15:51 |
| 2761 | 2005-06-19 17:22:17.000 | 2134 2134 | 431 431 | 2005-06-20 20:20:17.000 | 2 2 | 2020-12-23 07:15:58 |
| 3304 | 2005-06-21 07:43:40.000 | 2154 2154 | 431 431 | 2005-06-27 08:06:40.000 | 2 2 | 2020-12-23 07:16:05 |
| 3369 | 2005-06-21 13:20:31.000 | 303 303 | 431 431 | 2005-06-30 13:45:31.000 | 2 2 | 2020-12-23 07:16:06 |
| 4144 | 2005-07-07 08:25:44.000 | 550 550 | 431 431 | 2005-07-16 13:10:44.000 | 2 2 | 2020-12-23 07:16:18 |
| 4801 | 2005-07-08 16:51:36.000 | 761 761 | 431 431 | 2005-07-13 17:23:36.000 | 1 1 | 2020-12-23 07:16:28 |
| 4863 | 2005-07-08 19:03:15.000 | 1 1 | 431 431 | 2005-07-11 21:29:15.000 | 2 2 | 2020-12-23 07:16:29 |
| 7978 | 2005-07-28 14:16:14.000 | 508 508 | 431 431 | 2005-08-01 12:53:14.000 | 2 2 | 2020-12-23 07:17:14 |
| 8810 | 2005-07-29 21:45:19.000 | 1233 1233 | 431 431 | 2005-08-08 01:45:19.000 | 2 2 | 2020-12-23 07:17:26 |
| 10508 | 2005-08-01 11:23:27.000 | 3890 3890 | 431 431 | 2005-08-02 10:17:27.000 | 1 1 | 2020-12-23 07:17:51 |
| 10527 | 2005-08-01 11:55:54.000 | 4530 4530 | 431 431 | 2005-08-05 15:56:54.000 | 2 2 | 2020-12-23 07:17:51 |
| 10959 | 2005-08-02 03:39:39.000 | 4233 4233 | 431 431 | 2005-08-11 07:20:39.000 | 1 1 | 2020-12-23 07:17:57 |
| 11538 | 2005-08-17 00:44:04.000 | 554 554 | 431 431 | 2005-08-18 03:43:04.000 | 2 2 | 2020-12-23 07:18:05 |
| 12273 | 2005-08-18 04:40:50.000 | 3539 3539 | 431 431 | 2005-08-25 01:44:50.000 | 2 2 | 2020-12-23 07:18:15 |
| 13153 | 2005-08-19 13:09:47.000 | 3896 3896 | 431 431 | 2005-08-23 17:35:47.000 | 2 2 | 2020-12-23 07:18:27 |
| 13587 | 2006-02-14 15:16:03.000 | 2455 2455 | 431 431 | 2 2 | 2020-12-23 07:18:34 | |
| 13784 | 2005-08-20 12:11:28.000 | 3087 3087 | 431 431 | 2005-08-25 08:11:28.000 | 1 1 | 2020-12-23 07:18:37 |
| 15809 | 2005-08-23 14:42:07.000 | 1885 1885 | 431 431 | 2005-08-27 15:00:07.000 | 2 2 | 2020-12-23 07:19:06 |
| 15960 | 2005-08-23 19:35:42.000 | 1497 1497 | 431 431 | 2005-08-26 17:36:42.000 | 2 2 | 2020-12-23 07:19:09 |
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) ;