rental
23 rows where customer_id = 62
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 |
|---|---|---|---|---|---|---|
| 885 | 2005-05-30 06:54:28.000 | 646 646 | 62 62 | 2005-06-03 07:03:28.000 | 2 2 | 2020-12-23 07:15:32 |
| 947 | 2005-05-30 15:36:57.000 | 4478 4478 | 62 62 | 2005-06-04 18:48:57.000 | 1 1 | 2020-12-23 07:15:32 |
| 1241 | 2005-06-15 04:59:43.000 | 4377 4377 | 62 62 | 2005-06-24 03:32:43.000 | 2 2 | 2020-12-23 07:15:36 |
| 1486 | 2005-06-15 21:25:30.000 | 847 847 | 62 62 | 2005-06-16 16:36:30.000 | 1 1 | 2020-12-23 07:15:39 |
| 1587 | 2005-06-16 04:52:28.000 | 1781 1781 | 62 62 | 2005-06-23 07:36:28.000 | 1 1 | 2020-12-23 07:15:41 |
| 3021 | 2005-06-20 11:13:01.000 | 120 120 | 62 62 | 2005-06-28 16:15:01.000 | 2 2 | 2020-12-23 07:16:01 |
| 3035 | 2005-06-20 12:17:03.000 | 1223 1223 | 62 62 | 2005-06-26 17:42:03.000 | 2 2 | 2020-12-23 07:16:01 |
| 3287 | 2005-06-21 06:32:39.000 | 4406 4406 | 62 62 | 2005-06-24 09:29:39.000 | 2 2 | 2020-12-23 07:16:05 |
| 3327 | 2005-06-21 09:04:50.000 | 3083 3083 | 62 62 | 2005-06-30 05:45:50.000 | 1 1 | 2020-12-23 07:16:05 |
| 3843 | 2005-07-06 16:35:40.000 | 3844 3844 | 62 62 | 2005-07-07 18:29:40.000 | 1 1 | 2020-12-23 07:16:13 |
| 4159 | 2005-07-07 09:10:57.000 | 3625 3625 | 62 62 | 2005-07-09 10:19:57.000 | 2 2 | 2020-12-23 07:16:18 |
| 5292 | 2005-07-09 15:16:54.000 | 3195 3195 | 62 62 | 2005-07-11 15:21:54.000 | 1 1 | 2020-12-23 07:16:35 |
| 8360 | 2005-07-29 05:08:00.000 | 4135 4135 | 62 62 | 2005-08-02 00:40:00.000 | 1 1 | 2020-12-23 07:17:20 |
| 10080 | 2005-07-31 20:07:10.000 | 4355 4355 | 62 62 | 2005-08-04 23:07:10.000 | 2 2 | 2020-12-23 07:17:45 |
| 10815 | 2005-08-01 22:46:21.000 | 877 877 | 62 62 | 2005-08-03 02:43:21.000 | 2 2 | 2020-12-23 07:17:55 |
| 11297 | 2005-08-02 15:22:47.000 | 2531 2531 | 62 62 | 2005-08-11 18:45:47.000 | 1 1 | 2020-12-23 07:18:02 |
| 11988 | 2005-08-17 18:23:50.000 | 3429 3429 | 62 62 | 2005-08-18 22:30:50.000 | 2 2 | 2020-12-23 07:18:11 |
| 13512 | 2005-08-20 02:27:13.000 | 4508 4508 | 62 62 | 2005-08-28 04:40:13.000 | 2 2 | 2020-12-23 07:18:33 |
| 14574 | 2005-08-21 16:50:34.000 | 1611 1611 | 62 62 | 2005-08-26 14:24:34.000 | 2 2 | 2020-12-23 07:18:49 |
| 14594 | 2005-08-21 17:34:24.000 | 2978 2978 | 62 62 | 2005-08-26 22:04:24.000 | 2 2 | 2020-12-23 07:18:49 |
| 14821 | 2005-08-22 01:20:19.000 | 3155 3155 | 62 62 | 2005-08-29 03:06:19.000 | 2 2 | 2020-12-23 07:18:52 |
| 15464 | 2005-08-23 01:15:18.000 | 3235 3235 | 62 62 | 2005-08-29 02:58:18.000 | 2 2 | 2020-12-23 07:19:02 |
| 15591 | 2005-08-23 06:11:52.000 | 64 64 | 62 62 | 2005-08-25 05:34:52.000 | 1 1 | 2020-12-23 07:19:03 |
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) ;