rental
24 rows where customer_id = 73
This data as json, xlsx, CSV (advanced)
Suggested facets: staff_id, rental_date (date), return_date (date), last_update (date)
| rental_id ▼ | rental_date | inventory_id | customer_id | return_date | staff_id | last_update |
|---|---|---|---|---|---|---|
| 70 | 2005-05-25 10:15:23.000 | 2168 2168 | 73 73 | 2005-05-27 05:56:23.000 | 2 2 | 2020-12-23 07:15:21 |
| 1133 | 2005-05-31 19:12:21.000 | 4271 4271 | 73 73 | 2005-06-02 20:12:21.000 | 1 1 | 2020-12-23 07:15:35 |
| 1669 | 2005-06-16 10:20:20.000 | 360 360 | 73 73 | 2005-06-18 04:26:20.000 | 1 1 | 2020-12-23 07:15:42 |
| 2940 | 2005-06-20 05:20:01.000 | 2504 2504 | 73 73 | 2005-06-28 06:11:01.000 | 2 2 | 2020-12-23 07:16:00 |
| 4327 | 2005-07-07 18:01:39.000 | 860 860 | 73 73 | 2005-07-12 22:40:39.000 | 1 1 | 2020-12-23 07:16:20 |
| 4789 | 2005-07-08 16:22:01.000 | 20 20 | 73 73 | 2005-07-15 18:29:01.000 | 2 2 | 2020-12-23 07:16:27 |
| 5021 | 2005-07-09 02:09:41.000 | 3445 3445 | 73 73 | 2005-07-13 05:47:41.000 | 1 1 | 2020-12-23 07:16:31 |
| 6514 | 2005-07-12 03:47:44.000 | 3562 3562 | 73 73 | 2005-07-20 00:11:44.000 | 1 1 | 2020-12-23 07:16:52 |
| 6645 | 2005-07-12 10:39:55.000 | 2858 2858 | 73 73 | 2005-07-17 07:41:55.000 | 1 1 | 2020-12-23 07:16:54 |
| 7590 | 2005-07-27 23:24:24.000 | 2152 2152 | 73 73 | 2005-07-28 19:53:24.000 | 2 2 | 2020-12-23 07:17:08 |
| 7683 | 2005-07-28 03:11:29.000 | 1760 1760 | 73 73 | 2005-08-04 00:14:29.000 | 1 1 | 2020-12-23 07:17:10 |
| 8377 | 2005-07-29 05:27:40.000 | 270 270 | 73 73 | 2005-07-30 02:52:40.000 | 2 2 | 2020-12-23 07:17:20 |
| 9212 | 2005-07-30 13:03:13.000 | 2111 2111 | 73 73 | 2005-08-06 09:48:13.000 | 1 1 | 2020-12-23 07:17:32 |
| 9776 | 2005-07-31 10:01:03.000 | 2524 2524 | 73 73 | 2005-08-03 07:20:03.000 | 2 2 | 2020-12-23 07:17:41 |
| 10434 | 2005-08-01 08:47:00.000 | 4073 4073 | 73 73 | 2005-08-06 08:34:00.000 | 1 1 | 2020-12-23 07:17:50 |
| 11102 | 2005-08-02 08:08:30.000 | 3112 3112 | 73 73 | 2005-08-04 09:16:30.000 | 1 1 | 2020-12-23 07:17:59 |
| 11155 | 2005-08-02 09:55:28.000 | 2001 2001 | 73 73 | 2005-08-03 06:00:28.000 | 2 2 | 2020-12-23 07:18:00 |
| 11349 | 2005-08-02 17:21:49.000 | 1871 1871 | 73 73 | 2005-08-06 18:40:49.000 | 1 1 | 2020-12-23 07:18:02 |
| 11609 | 2005-08-17 03:41:11.000 | 351 351 | 73 73 | 2005-08-25 01:30:11.000 | 2 2 | 2020-12-23 07:18:06 |
| 12291 | 2005-08-18 05:08:37.000 | 4270 4270 | 73 73 | 2005-08-23 09:01:37.000 | 1 1 | 2020-12-23 07:18:15 |
| 13108 | 2006-02-14 15:16:03.000 | 3630 3630 | 73 73 | 1 1 | 2020-12-23 07:18:27 | |
| 13886 | 2005-08-20 15:34:43.000 | 2248 2248 | 73 73 | 2005-08-26 11:48:43.000 | 2 2 | 2020-12-23 07:18:39 |
| 15667 | 2005-08-23 09:02:03.000 | 1302 1302 | 73 73 | 2005-08-24 05:47:03.000 | 1 1 | 2020-12-23 07:19:04 |
| 16002 | 2005-08-23 20:47:12.000 | 2770 2770 | 73 73 | 2005-08-27 23:07:12.000 | 1 1 | 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) ;