rental
21 rows where customer_id = 88
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 |
|---|---|---|---|---|---|---|
| 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 |
| 1433 | 2005-06-15 18:30:00.000 | 2310 2310 | 88 88 | 2005-06-16 15:14:00.000 | 1 1 | 2020-12-23 07:15:39 |
| 2483 | 2005-06-18 21:22:23.000 | 4225 4225 | 88 88 | 2005-06-25 01:14:23.000 | 1 1 | 2020-12-23 07:15:54 |
| 2878 | 2005-06-20 01:09:14.000 | 4120 4120 | 88 88 | 2005-06-21 21:40:14.000 | 2 2 | 2020-12-23 07:15:59 |
| 3524 | 2005-07-06 01:01:51.000 | 1626 1626 | 88 88 | 2005-07-11 19:52:51.000 | 2 2 | 2020-12-23 07:16:08 |
| 3620 | 2005-07-06 06:01:50.000 | 1661 1661 | 88 88 | 2005-07-08 05:04:50.000 | 1 1 | 2020-12-23 07:16:10 |
| 3673 | 2005-07-06 09:02:09.000 | 1837 1837 | 88 88 | 2005-07-15 06:45:09.000 | 2 2 | 2020-12-23 07:16:11 |
| 3846 | 2005-07-06 16:43:10.000 | 2829 2829 | 88 88 | 2005-07-14 11:09:10.000 | 2 2 | 2020-12-23 07:16:13 |
| 6643 | 2005-07-12 10:39:22.000 | 174 174 | 88 88 | 2005-07-18 13:52:22.000 | 1 1 | 2020-12-23 07:16:54 |
| 6916 | 2005-07-12 22:29:18.000 | 3311 3311 | 88 88 | 2005-07-19 16:46:18.000 | 1 1 | 2020-12-23 07:16:58 |
| 7088 | 2005-07-27 04:42:28.000 | 373 373 | 88 88 | 2005-08-04 07:09:28.000 | 2 2 | 2020-12-23 07:17:01 |
| 7621 | 2005-07-28 00:34:06.000 | 1833 1833 | 88 88 | 2005-08-06 00:13:06.000 | 1 1 | 2020-12-23 07:17:09 |
| 8296 | 2005-07-29 02:43:25.000 | 2543 2543 | 88 88 | 2005-08-01 00:23:25.000 | 1 1 | 2020-12-23 07:17:19 |
| 8526 | 2005-07-29 10:20:48.000 | 575 575 | 88 88 | 2005-08-03 14:15:48.000 | 1 1 | 2020-12-23 07:17:22 |
| 8692 | 2005-07-29 16:43:39.000 | 3192 3192 | 88 88 | 2005-08-01 15:54:39.000 | 2 2 | 2020-12-23 07:17:25 |
| 10424 | 2005-08-01 08:22:54.000 | 1921 1921 | 88 88 | 2005-08-06 13:44:54.000 | 1 1 | 2020-12-23 07:17:50 |
| 11056 | 2005-08-02 06:36:27.000 | 1404 1404 | 88 88 | 2005-08-10 06:02:27.000 | 1 1 | 2020-12-23 07:17:58 |
| 14097 | 2005-08-21 00:28:48.000 | 4351 4351 | 88 88 | 2005-08-29 22:15:48.000 | 1 1 | 2020-12-23 07:18:42 |
| 14827 | 2005-08-22 01:32:32.000 | 2267 2267 | 88 88 | 2005-08-31 06:21:32.000 | 2 2 | 2020-12-23 07:18:52 |
| 15098 | 2005-08-22 11:48:19.000 | 4414 4414 | 88 88 | 2005-08-31 11:07:19.000 | 2 2 | 2020-12-23 07:18:56 |
| 15898 | 2005-08-23 17:13:01.000 | 3502 3502 | 88 88 | 2005-08-29 11:22:01.000 | 2 2 | 2020-12-23 07:19:08 |
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) ;