rental
25 rows where customer_id = 414
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 |
|---|---|---|---|---|---|---|
| 85 | 2005-05-25 13:05:34.000 | 470 470 | 414 414 | 2005-05-29 16:53:34.000 | 1 1 | 2020-12-23 07:15:21 |
| 261 | 2005-05-26 15:44:23.000 | 1369 1369 | 414 414 | 2005-06-02 09:47:23.000 | 2 2 | 2020-12-23 07:15:23 |
| 2246 | 2005-06-18 04:54:29.000 | 4287 4287 | 414 414 | 2005-06-22 09:14:29.000 | 1 1 | 2020-12-23 07:15:50 |
| 2559 | 2005-06-19 03:09:46.000 | 4433 4433 | 414 414 | 2005-06-28 07:49:46.000 | 1 1 | 2020-12-23 07:15:55 |
| 3318 | 2005-06-21 08:23:05.000 | 1111 1111 | 414 414 | 2005-06-27 14:07:05.000 | 2 2 | 2020-12-23 07:16:05 |
| 3957 | 2005-07-06 22:05:47.000 | 443 443 | 414 414 | 2005-07-16 01:08:47.000 | 1 1 | 2020-12-23 07:16:15 |
| 4437 | 2005-07-07 22:55:41.000 | 3578 3578 | 414 414 | 2005-07-13 19:40:41.000 | 1 1 | 2020-12-23 07:16:22 |
| 6462 | 2005-07-12 01:15:24.000 | 4534 4534 | 414 414 | 2005-07-19 05:11:24.000 | 2 2 | 2020-12-23 07:16:52 |
| 6728 | 2005-07-12 13:56:48.000 | 2113 2113 | 414 414 | 2005-07-15 18:49:48.000 | 1 1 | 2020-12-23 07:16:56 |
| 6845 | 2005-07-12 19:20:41.000 | 3833 3833 | 414 414 | 2005-07-14 15:27:41.000 | 1 1 | 2020-12-23 07:16:57 |
| 7009 | 2005-07-27 01:45:44.000 | 1585 1585 | 414 414 | 2005-07-28 05:50:44.000 | 1 1 | 2020-12-23 07:17:00 |
| 7779 | 2005-07-28 07:11:11.000 | 3663 3663 | 414 414 | 2005-07-30 11:12:11.000 | 1 1 | 2020-12-23 07:17:11 |
| 9650 | 2005-07-31 05:47:32.000 | 2997 2997 | 414 414 | 2005-08-04 00:50:32.000 | 2 2 | 2020-12-23 07:17:39 |
| 9991 | 2005-07-31 17:26:27.000 | 3662 3662 | 414 414 | 2005-08-03 17:36:27.000 | 1 1 | 2020-12-23 07:17:44 |
| 10107 | 2005-07-31 21:01:46.000 | 1326 1326 | 414 414 | 2005-08-09 01:33:46.000 | 2 2 | 2020-12-23 07:17:45 |
| 11706 | 2005-08-17 07:23:46.000 | 4234 4234 | 414 414 | 2005-08-18 10:13:46.000 | 2 2 | 2020-12-23 07:18:07 |
| 12930 | 2005-08-19 05:11:32.000 | 4410 4410 | 414 414 | 2005-08-22 02:20:32.000 | 2 2 | 2020-12-23 07:18:24 |
| 13042 | 2005-08-19 09:06:08.000 | 1047 1047 | 414 414 | 2005-08-22 13:46:08.000 | 2 2 | 2020-12-23 07:18:26 |
| 13242 | 2005-08-19 16:28:47.000 | 230 230 | 414 414 | 2005-08-24 22:13:47.000 | 2 2 | 2020-12-23 07:18:29 |
| 13308 | 2005-08-19 18:59:42.000 | 3189 3189 | 414 414 | 2005-08-28 13:21:42.000 | 2 2 | 2020-12-23 07:18:30 |
| 13404 | 2005-08-19 22:18:42.000 | 416 416 | 414 414 | 2005-08-23 16:29:42.000 | 2 2 | 2020-12-23 07:18:31 |
| 13494 | 2005-08-20 01:36:34.000 | 1632 1632 | 414 414 | 2005-08-21 06:52:34.000 | 1 1 | 2020-12-23 07:18:33 |
| 13657 | 2005-08-20 08:01:39.000 | 1752 1752 | 414 414 | 2005-08-23 07:31:39.000 | 1 1 | 2020-12-23 07:18:35 |
| 15140 | 2005-08-22 13:39:20.000 | 1402 1402 | 414 414 | 2005-08-30 18:19:20.000 | 2 2 | 2020-12-23 07:18:57 |
| 15481 | 2005-08-23 01:59:14.000 | 3262 3262 | 414 414 | 2005-08-27 04:38:14.000 | 1 1 | 2020-12-23 07:19:02 |
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) ;