rental
22 rows where customer_id = 252
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 |
|---|---|---|---|---|---|---|
| 707 | 2005-05-29 03:18:19.000 | 819 819 | 252 252 | 2005-05-30 02:45:19.000 | 1 1 | 2020-12-23 07:15:29 |
| 1095 | 2005-05-31 13:15:41.000 | 4546 4546 | 252 252 | 2005-06-05 12:10:41.000 | 1 1 | 2020-12-23 07:15:34 |
| 1395 | 2005-06-15 16:21:04.000 | 753 753 | 252 252 | 2005-06-23 12:52:04.000 | 2 2 | 2020-12-23 07:15:38 |
| 2716 | 2005-06-19 14:40:17.000 | 944 944 | 252 252 | 2005-06-27 17:45:17.000 | 2 2 | 2020-12-23 07:15:57 |
| 2968 | 2005-06-20 07:41:47.000 | 4415 4415 | 252 252 | 2005-06-23 04:27:47.000 | 1 1 | 2020-12-23 07:16:00 |
| 4372 | 2005-07-07 20:09:01.000 | 2207 2207 | 252 252 | 2005-07-09 18:24:01.000 | 1 1 | 2020-12-23 07:16:21 |
| 5554 | 2005-07-10 03:03:38.000 | 4084 4084 | 252 252 | 2005-07-17 00:00:38.000 | 2 2 | 2020-12-23 07:16:39 |
| 6357 | 2005-07-11 20:58:51.000 | 658 658 | 252 252 | 2005-07-12 15:06:51.000 | 1 1 | 2020-12-23 07:16:50 |
| 6369 | 2005-07-11 21:23:36.000 | 1086 1086 | 252 252 | 2005-07-13 22:23:36.000 | 2 2 | 2020-12-23 07:16:50 |
| 7024 | 2005-07-27 02:36:40.000 | 3113 3113 | 252 252 | 2005-07-28 06:58:40.000 | 1 1 | 2020-12-23 07:17:00 |
| 7121 | 2005-07-27 05:58:32.000 | 1264 1264 | 252 252 | 2005-07-29 06:14:32.000 | 1 1 | 2020-12-23 07:17:01 |
| 7168 | 2005-07-27 07:51:11.000 | 6 6 | 252 252 | 2005-08-01 04:08:11.000 | 2 2 | 2020-12-23 07:17:02 |
| 7670 | 2005-07-28 02:44:25.000 | 1356 1356 | 252 252 | 2005-07-29 21:55:25.000 | 2 2 | 2020-12-23 07:17:10 |
| 8636 | 2005-07-29 14:24:13.000 | 4308 4308 | 252 252 | 2005-08-02 14:39:13.000 | 1 1 | 2020-12-23 07:17:24 |
| 8899 | 2005-07-30 01:05:30.000 | 4148 4148 | 252 252 | 2005-08-01 23:32:30.000 | 1 1 | 2020-12-23 07:17:28 |
| 10314 | 2005-08-01 04:31:18.000 | 1548 1548 | 252 252 | 2005-08-06 01:49:18.000 | 2 2 | 2020-12-23 07:17:48 |
| 10834 | 2005-08-01 23:28:00.000 | 2270 2270 | 252 252 | 2005-08-07 01:21:00.000 | 1 1 | 2020-12-23 07:17:55 |
| 11764 | 2005-08-17 09:51:54.000 | 4502 4502 | 252 252 | 2005-08-20 07:11:54.000 | 1 1 | 2020-12-23 07:18:08 |
| 13385 | 2005-08-19 21:39:35.000 | 4323 4323 | 252 252 | 2005-08-22 22:38:35.000 | 2 2 | 2020-12-23 07:18:31 |
| 13756 | 2006-02-14 15:16:03.000 | 1146 1146 | 252 252 | 2 2 | 2020-12-23 07:18:37 | |
| 13989 | 2005-08-20 19:27:50.000 | 1470 1470 | 252 252 | 2005-08-28 15:17:50.000 | 2 2 | 2020-12-23 07:18:40 |
| 14774 | 2005-08-21 23:52:32.000 | 3185 3185 | 252 252 | 2005-08-26 23:42:32.000 | 2 2 | 2020-12-23 07:18:51 |
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) ;