rental
24 rows where customer_id = 258
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 |
|---|---|---|---|---|---|---|
| 1743 | 2005-06-16 16:38:10.000 | 2777 2777 | 258 258 | 2005-06-17 13:13:10.000 | 1 1 | 2020-12-23 07:15:43 |
| 2678 | 2005-06-19 12:12:23.000 | 4230 4230 | 258 258 | 2005-06-21 16:28:23.000 | 2 2 | 2020-12-23 07:15:56 |
| 2931 | 2005-06-20 04:50:45.000 | 3122 3122 | 258 258 | 2005-06-29 09:18:45.000 | 1 1 | 2020-12-23 07:16:00 |
| 4408 | 2005-07-07 21:41:06.000 | 2482 2482 | 258 258 | 2005-07-11 00:32:06.000 | 1 1 | 2020-12-23 07:16:22 |
| 4677 | 2005-07-08 10:30:36.000 | 1226 1226 | 258 258 | 2005-07-14 12:40:36.000 | 1 1 | 2020-12-23 07:16:26 |
| 4897 | 2005-07-08 20:25:11.000 | 2950 2950 | 258 258 | 2005-07-09 17:16:11.000 | 1 1 | 2020-12-23 07:16:29 |
| 5312 | 2005-07-09 16:03:09.000 | 2123 2123 | 258 258 | 2005-07-13 16:41:09.000 | 2 2 | 2020-12-23 07:16:35 |
| 5674 | 2005-07-10 08:26:26.000 | 548 548 | 258 258 | 2005-07-16 02:43:26.000 | 1 1 | 2020-12-23 07:16:40 |
| 5935 | 2005-07-10 22:11:04.000 | 3371 3371 | 258 258 | 2005-07-19 18:12:04.000 | 2 2 | 2020-12-23 07:16:44 |
| 6012 | 2005-07-11 02:00:12.000 | 2609 2609 | 258 258 | 2005-07-17 02:49:12.000 | 2 2 | 2020-12-23 07:16:45 |
| 7814 | 2005-07-28 08:09:48.000 | 2662 2662 | 258 258 | 2005-08-01 13:14:48.000 | 2 2 | 2020-12-23 07:17:12 |
| 8675 | 2005-07-29 15:56:18.000 | 1026 1026 | 258 258 | 2005-07-30 18:50:18.000 | 1 1 | 2020-12-23 07:17:25 |
| 9069 | 2005-07-30 07:39:59.000 | 1852 1852 | 258 258 | 2005-08-02 04:10:59.000 | 1 1 | 2020-12-23 07:17:30 |
| 10293 | 2005-08-01 03:44:26.000 | 1570 1570 | 258 258 | 2005-08-05 04:16:26.000 | 2 2 | 2020-12-23 07:17:48 |
| 10315 | 2005-08-01 04:34:45.000 | 895 895 | 258 258 | 2005-08-07 05:27:45.000 | 1 1 | 2020-12-23 07:17:48 |
| 10325 | 2005-08-01 04:52:12.000 | 2749 2749 | 258 258 | 2005-08-08 09:31:12.000 | 1 1 | 2020-12-23 07:17:48 |
| 10332 | 2005-08-01 04:57:32.000 | 642 642 | 258 258 | 2005-08-10 02:42:32.000 | 2 2 | 2020-12-23 07:17:48 |
| 10393 | 2005-08-01 06:52:50.000 | 808 808 | 258 258 | 2005-08-05 08:45:50.000 | 1 1 | 2020-12-23 07:17:49 |
| 12246 | 2005-08-18 03:48:41.000 | 3199 3199 | 258 258 | 2005-08-25 05:12:41.000 | 1 1 | 2020-12-23 07:18:15 |
| 12296 | 2005-08-18 05:16:28.000 | 2091 2091 | 258 258 | 2005-08-22 10:32:28.000 | 1 1 | 2020-12-23 07:18:15 |
| 13491 | 2005-08-20 01:30:56.000 | 2503 2503 | 258 258 | 2005-08-28 23:26:56.000 | 2 2 | 2020-12-23 07:18:33 |
| 13695 | 2005-08-20 09:13:25.000 | 3114 3114 | 258 258 | 2005-08-27 11:51:25.000 | 2 2 | 2020-12-23 07:18:36 |
| 13897 | 2005-08-20 16:02:28.000 | 628 628 | 258 258 | 2005-08-23 14:29:28.000 | 1 1 | 2020-12-23 07:18:39 |
| 14901 | 2005-08-22 04:31:37.000 | 4297 4297 | 258 258 | 2005-08-29 08:24:37.000 | 1 1 | 2020-12-23 07:18:53 |
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) ;