rental
22 rows where customer_id = 325
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 |
|---|---|---|---|---|---|---|
| 131 | 2005-05-25 21:42:46.000 | 815 815 | 325 325 | 2005-05-30 23:25:46.000 | 2 2 | 2020-12-23 07:15:21 |
| 2502 | 2005-06-18 23:12:13.000 | 2622 2622 | 325 325 | 2005-06-20 04:19:13.000 | 2 2 | 2020-12-23 07:15:54 |
| 2507 | 2005-06-18 23:39:22.000 | 3121 3121 | 325 325 | 2005-06-21 19:23:22.000 | 1 1 | 2020-12-23 07:15:54 |
| 2808 | 2005-06-19 19:34:45.000 | 65 65 | 325 325 | 2005-06-27 14:49:45.000 | 1 1 | 2020-12-23 07:15:58 |
| 5470 | 2005-07-09 23:10:49.000 | 3254 3254 | 325 325 | 2005-07-18 04:30:49.000 | 1 1 | 2020-12-23 07:16:37 |
| 5740 | 2005-07-10 11:51:58.000 | 2147 2147 | 325 325 | 2005-07-12 07:53:58.000 | 2 2 | 2020-12-23 07:16:41 |
| 5775 | 2005-07-10 13:34:26.000 | 2175 2175 | 325 325 | 2005-07-15 10:01:26.000 | 1 1 | 2020-12-23 07:16:42 |
| 6135 | 2005-07-11 08:32:23.000 | 833 833 | 325 325 | 2005-07-17 08:43:23.000 | 1 1 | 2020-12-23 07:16:47 |
| 6622 | 2005-07-12 09:04:11.000 | 4350 4350 | 325 325 | 2005-07-13 04:27:11.000 | 1 1 | 2020-12-23 07:16:54 |
| 7223 | 2005-07-27 09:42:27.000 | 2623 2623 | 325 325 | 2005-08-04 04:02:27.000 | 1 1 | 2020-12-23 07:17:03 |
| 7687 | 2005-07-28 03:20:26.000 | 689 689 | 325 325 | 2005-08-02 05:48:26.000 | 2 2 | 2020-12-23 07:17:10 |
| 8539 | 2005-07-29 10:48:24.000 | 599 599 | 325 325 | 2005-07-30 06:29:24.000 | 2 2 | 2020-12-23 07:17:22 |
| 10030 | 2005-07-31 18:39:36.000 | 1392 1392 | 325 325 | 2005-08-03 15:29:36.000 | 2 2 | 2020-12-23 07:17:44 |
| 10070 | 2005-07-31 19:46:29.000 | 1010 1010 | 325 325 | 2005-08-03 22:21:29.000 | 1 1 | 2020-12-23 07:17:45 |
| 10326 | 2005-08-01 04:55:34.000 | 3856 3856 | 325 325 | 2005-08-02 05:18:34.000 | 1 1 | 2020-12-23 07:17:48 |
| 10412 | 2005-08-01 07:57:16.000 | 1555 1555 | 325 325 | 2005-08-04 11:44:16.000 | 2 2 | 2020-12-23 07:17:49 |
| 12097 | 2005-08-17 22:35:24.000 | 4135 4135 | 325 325 | 2005-08-18 20:31:24.000 | 2 2 | 2020-12-23 07:18:13 |
| 12779 | 2005-08-18 23:44:00.000 | 1814 1814 | 325 325 | 2005-08-26 05:27:00.000 | 2 2 | 2020-12-23 07:18:22 |
| 13054 | 2005-08-19 09:34:02.000 | 2983 2983 | 325 325 | 2005-08-23 05:25:02.000 | 2 2 | 2020-12-23 07:18:26 |
| 14452 | 2005-08-21 12:23:20.000 | 4231 4231 | 325 325 | 2005-08-27 06:26:20.000 | 1 1 | 2020-12-23 07:18:47 |
| 14672 | 2005-08-21 19:59:33.000 | 4144 4144 | 325 325 | 2005-08-30 19:40:33.000 | 1 1 | 2020-12-23 07:18:50 |
| 15009 | 2005-08-22 08:27:27.000 | 4025 4025 | 325 325 | 2005-08-26 05:57:27.000 | 2 2 | 2020-12-23 07:18:55 |
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) ;