rental
16,044 rows
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 |
|---|---|---|---|---|---|---|
| 1 | 2005-05-24 22:53:30.000 | 367 367 | 130 130 | 2005-05-26 22:04:30.000 | 1 1 | 2020-12-23 07:15:20 |
| 2 | 2005-05-24 22:54:33.000 | 1525 1525 | 459 459 | 2005-05-28 19:40:33.000 | 1 1 | 2020-12-23 07:15:20 |
| 3 | 2005-05-24 23:03:39.000 | 1711 1711 | 408 408 | 2005-06-01 22:12:39.000 | 1 1 | 2020-12-23 07:15:20 |
| 4 | 2005-05-24 23:04:41.000 | 2452 2452 | 333 333 | 2005-06-03 01:43:41.000 | 2 2 | 2020-12-23 07:15:20 |
| 5 | 2005-05-24 23:05:21.000 | 2079 2079 | 222 222 | 2005-06-02 04:33:21.000 | 1 1 | 2020-12-23 07:15:20 |
| 6 | 2005-05-24 23:08:07.000 | 2792 2792 | 549 549 | 2005-05-27 01:32:07.000 | 1 1 | 2020-12-23 07:15:20 |
| 7 | 2005-05-24 23:11:53.000 | 3995 3995 | 269 269 | 2005-05-29 20:34:53.000 | 2 2 | 2020-12-23 07:15:20 |
| 8 | 2005-05-24 23:31:46.000 | 2346 2346 | 239 239 | 2005-05-27 23:33:46.000 | 2 2 | 2020-12-23 07:15:20 |
| 9 | 2005-05-25 00:00:40.000 | 2580 2580 | 126 126 | 2005-05-28 00:22:40.000 | 1 1 | 2020-12-23 07:15:20 |
| 10 | 2005-05-25 00:02:21.000 | 1824 1824 | 399 399 | 2005-05-31 22:44:21.000 | 2 2 | 2020-12-23 07:15:20 |
| 11 | 2005-05-25 00:09:02.000 | 4443 4443 | 142 142 | 2005-06-02 20:56:02.000 | 2 2 | 2020-12-23 07:15:20 |
| 12 | 2005-05-25 00:19:27.000 | 1584 1584 | 261 261 | 2005-05-30 05:44:27.000 | 2 2 | 2020-12-23 07:15:20 |
| 13 | 2005-05-25 00:22:55.000 | 2294 2294 | 334 334 | 2005-05-30 04:28:55.000 | 1 1 | 2020-12-23 07:15:20 |
| 14 | 2005-05-25 00:31:15.000 | 2701 2701 | 446 446 | 2005-05-26 02:56:15.000 | 1 1 | 2020-12-23 07:15:20 |
| 15 | 2005-05-25 00:39:22.000 | 3049 3049 | 319 319 | 2005-06-03 03:30:22.000 | 1 1 | 2020-12-23 07:15:20 |
| 16 | 2005-05-25 00:43:11.000 | 389 389 | 316 316 | 2005-05-26 04:42:11.000 | 2 2 | 2020-12-23 07:15:20 |
| 17 | 2005-05-25 01:06:36.000 | 830 830 | 575 575 | 2005-05-27 00:43:36.000 | 1 1 | 2020-12-23 07:15:20 |
| 18 | 2005-05-25 01:10:47.000 | 3376 3376 | 19 19 | 2005-05-31 06:35:47.000 | 2 2 | 2020-12-23 07:15:20 |
| 19 | 2005-05-25 01:17:24.000 | 1941 1941 | 456 456 | 2005-05-31 06:00:24.000 | 1 1 | 2020-12-23 07:15:20 |
| 20 | 2005-05-25 01:48:41.000 | 3517 3517 | 185 185 | 2005-05-27 02:20:41.000 | 2 2 | 2020-12-23 07:15:20 |
| 21 | 2005-05-25 01:59:46.000 | 146 146 | 388 388 | 2005-05-26 01:01:46.000 | 2 2 | 2020-12-23 07:15:20 |
| 22 | 2005-05-25 02:19:23.000 | 727 727 | 509 509 | 2005-05-26 04:52:23.000 | 2 2 | 2020-12-23 07:15:20 |
| 23 | 2005-05-25 02:40:21.000 | 4441 4441 | 438 438 | 2005-05-29 06:34:21.000 | 1 1 | 2020-12-23 07:15:20 |
| 24 | 2005-05-25 02:53:02.000 | 3273 3273 | 350 350 | 2005-05-27 01:15:02.000 | 1 1 | 2020-12-23 07:15:20 |
| 25 | 2005-05-25 03:21:20.000 | 3961 3961 | 37 37 | 2005-05-27 21:25:20.000 | 2 2 | 2020-12-23 07:15:20 |
| 26 | 2005-05-25 03:36:50.000 | 4371 4371 | 371 371 | 2005-05-31 00:34:50.000 | 1 1 | 2020-12-23 07:15:20 |
| 27 | 2005-05-25 03:41:50.000 | 1225 1225 | 301 301 | 2005-05-30 01:13:50.000 | 2 2 | 2020-12-23 07:15:20 |
| 28 | 2005-05-25 03:42:37.000 | 4068 4068 | 232 232 | 2005-05-26 09:26:37.000 | 2 2 | 2020-12-23 07:15:20 |
| 29 | 2005-05-25 03:47:12.000 | 611 611 | 44 44 | 2005-05-30 00:31:12.000 | 2 2 | 2020-12-23 07:15:20 |
| 30 | 2005-05-25 04:01:32.000 | 3744 3744 | 430 430 | 2005-05-30 03:12:32.000 | 1 1 | 2020-12-23 07:15:20 |
| 31 | 2005-05-25 04:05:17.000 | 4482 4482 | 369 369 | 2005-05-30 07:15:17.000 | 1 1 | 2020-12-23 07:15:20 |
| 32 | 2005-05-25 04:06:21.000 | 3832 3832 | 230 230 | 2005-05-25 23:55:21.000 | 1 1 | 2020-12-23 07:15:20 |
| 33 | 2005-05-25 04:18:51.000 | 1681 1681 | 272 272 | 2005-05-27 03:58:51.000 | 1 1 | 2020-12-23 07:15:20 |
| 34 | 2005-05-25 04:19:28.000 | 2613 2613 | 597 597 | 2005-05-29 00:10:28.000 | 2 2 | 2020-12-23 07:15:20 |
| 35 | 2005-05-25 04:24:36.000 | 1286 1286 | 484 484 | 2005-05-27 07:02:36.000 | 2 2 | 2020-12-23 07:15:20 |
| 36 | 2005-05-25 04:36:26.000 | 1308 1308 | 88 88 | 2005-05-29 00:31:26.000 | 1 1 | 2020-12-23 07:15:20 |
| 37 | 2005-05-25 04:44:31.000 | 403 403 | 535 535 | 2005-05-29 01:03:31.000 | 1 1 | 2020-12-23 07:15:20 |
| 38 | 2005-05-25 04:47:44.000 | 2540 2540 | 302 302 | 2005-06-01 00:58:44.000 | 1 1 | 2020-12-23 07:15:20 |
| 39 | 2005-05-25 04:51:46.000 | 4466 4466 | 207 207 | 2005-05-31 03:14:46.000 | 2 2 | 2020-12-23 07:15:20 |
| 40 | 2005-05-25 05:09:04.000 | 2638 2638 | 413 413 | 2005-05-27 23:12:04.000 | 1 1 | 2020-12-23 07:15:20 |
| 41 | 2005-05-25 05:12:29.000 | 1761 1761 | 174 174 | 2005-06-02 00:28:29.000 | 1 1 | 2020-12-23 07:15:20 |
| 42 | 2005-05-25 05:24:58.000 | 380 380 | 523 523 | 2005-05-31 02:47:58.000 | 2 2 | 2020-12-23 07:15:20 |
| 43 | 2005-05-25 05:39:25.000 | 2578 2578 | 532 532 | 2005-05-26 06:54:25.000 | 2 2 | 2020-12-23 07:15:20 |
| 44 | 2005-05-25 05:53:23.000 | 3098 3098 | 207 207 | 2005-05-29 10:56:23.000 | 2 2 | 2020-12-23 07:15:20 |
| 45 | 2005-05-25 05:59:39.000 | 1853 1853 | 436 436 | 2005-06-02 09:56:39.000 | 2 2 | 2020-12-23 07:15:20 |
| 46 | 2005-05-25 06:04:08.000 | 3318 3318 | 7 7 | 2005-06-02 08:18:08.000 | 2 2 | 2020-12-23 07:15:20 |
| 47 | 2005-05-25 06:05:20.000 | 2211 2211 | 35 35 | 2005-05-30 03:04:20.000 | 1 1 | 2020-12-23 07:15:20 |
| 48 | 2005-05-25 06:20:46.000 | 1780 1780 | 282 282 | 2005-06-02 05:42:46.000 | 1 1 | 2020-12-23 07:15:20 |
| 49 | 2005-05-25 06:39:35.000 | 2965 2965 | 498 498 | 2005-05-30 10:12:35.000 | 2 2 | 2020-12-23 07:15:20 |
| 50 | 2005-05-25 06:44:53.000 | 1983 1983 | 18 18 | 2005-05-28 11:28:53.000 | 2 2 | 2020-12-23 07:15:20 |
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) ;