rental
24 rows where customer_id = 153
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 |
|---|---|---|---|---|---|---|
| 2224 | 2005-06-18 03:33:58.000 | 1336 1336 | 153 153 | 2005-06-18 22:10:58.000 | 1 1 | 2020-12-23 07:15:50 |
| 2649 | 2005-06-19 10:20:09.000 | 98 98 | 153 153 | 2005-06-21 10:05:09.000 | 1 1 | 2020-12-23 07:15:56 |
| 2893 | 2005-06-20 02:22:08.000 | 397 397 | 153 153 | 2005-06-26 21:01:08.000 | 2 2 | 2020-12-23 07:15:59 |
| 2945 | 2005-06-20 05:49:27.000 | 4193 4193 | 153 153 | 2005-06-26 09:48:27.000 | 1 1 | 2020-12-23 07:16:00 |
| 3795 | 2005-07-06 14:37:41.000 | 240 240 | 153 153 | 2005-07-11 20:27:41.000 | 2 2 | 2020-12-23 07:16:12 |
| 3949 | 2005-07-06 21:46:36.000 | 1765 1765 | 153 153 | 2005-07-11 03:18:36.000 | 1 1 | 2020-12-23 07:16:15 |
| 4194 | 2005-07-07 10:59:39.000 | 1753 1753 | 153 153 | 2005-07-15 09:34:39.000 | 1 1 | 2020-12-23 07:16:18 |
| 4670 | 2005-07-08 10:14:18.000 | 3317 3317 | 153 153 | 2005-07-16 15:10:18.000 | 2 2 | 2020-12-23 07:16:26 |
| 5676 | 2005-07-10 08:38:32.000 | 3595 3595 | 153 153 | 2005-07-13 10:11:32.000 | 1 1 | 2020-12-23 07:16:40 |
| 5771 | 2005-07-10 13:26:45.000 | 3275 3275 | 153 153 | 2005-07-14 15:43:45.000 | 1 1 | 2020-12-23 07:16:42 |
| 6818 | 2005-07-12 18:20:54.000 | 1013 1013 | 153 153 | 2005-07-21 00:03:54.000 | 2 2 | 2020-12-23 07:16:57 |
| 7824 | 2005-07-28 08:34:47.000 | 2241 2241 | 153 153 | 2005-08-05 09:43:47.000 | 2 2 | 2020-12-23 07:17:12 |
| 9936 | 2005-07-31 15:27:41.000 | 979 979 | 153 153 | 2005-08-06 16:25:41.000 | 1 1 | 2020-12-23 07:17:43 |
| 10015 | 2005-07-31 18:11:17.000 | 67 67 | 153 153 | 2005-08-03 15:48:17.000 | 2 2 | 2020-12-23 07:17:44 |
| 11368 | 2005-08-02 18:03:05.000 | 866 866 | 153 153 | 2005-08-07 20:40:05.000 | 1 1 | 2020-12-23 07:18:03 |
| 12103 | 2005-08-17 22:49:09.000 | 4363 4363 | 153 153 | 2005-08-24 21:53:09.000 | 1 1 | 2020-12-23 07:18:13 |
| 12439 | 2005-08-18 10:44:57.000 | 3204 3204 | 153 153 | 2005-08-22 06:51:57.000 | 1 1 | 2020-12-23 07:18:17 |
| 12882 | 2005-08-19 03:33:46.000 | 911 911 | 153 153 | 2005-08-21 22:49:46.000 | 1 1 | 2020-12-23 07:18:23 |
| 14664 | 2005-08-21 19:48:47.000 | 4377 4377 | 153 153 | 2005-08-27 16:47:47.000 | 1 1 | 2020-12-23 07:18:50 |
| 14747 | 2005-08-21 23:00:02.000 | 201 201 | 153 153 | 2005-08-26 18:58:02.000 | 2 2 | 2020-12-23 07:18:51 |
| 14944 | 2005-08-22 06:01:26.000 | 535 535 | 153 153 | 2005-08-24 10:33:26.000 | 2 2 | 2020-12-23 07:18:54 |
| 15267 | 2005-08-22 18:37:48.000 | 2966 2966 | 153 153 | 2005-08-24 00:22:48.000 | 1 1 | 2020-12-23 07:18:59 |
| 15444 | 2005-08-23 00:46:52.000 | 959 959 | 153 153 | 2005-08-29 20:37:52.000 | 2 2 | 2020-12-23 07:19:01 |
| 15593 | 2005-08-23 06:15:09.000 | 3734 3734 | 153 153 | 2005-08-27 07:47:09.000 | 2 2 | 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) ;