rental
23 rows where customer_id = 76
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 |
|---|---|---|---|---|---|---|
| 574 | 2005-05-28 10:44:28.000 | 3883 3883 | 76 76 | 2005-06-04 11:42:28.000 | 1 1 | 2020-12-23 07:15:27 |
| 926 | 2005-05-30 12:15:54.000 | 4327 4327 | 76 76 | 2005-06-01 08:53:54.000 | 2 2 | 2020-12-23 07:15:32 |
| 1487 | 2005-06-15 21:27:42.000 | 3791 3791 | 76 76 | 2005-06-22 03:09:42.000 | 2 2 | 2020-12-23 07:15:39 |
| 1791 | 2005-06-16 20:04:28.000 | 301 301 | 76 76 | 2005-06-23 22:30:28.000 | 1 1 | 2020-12-23 07:15:44 |
| 2111 | 2005-06-17 19:47:21.000 | 2108 2108 | 76 76 | 2005-06-19 22:46:21.000 | 2 2 | 2020-12-23 07:15:48 |
| 2397 | 2005-06-18 15:51:25.000 | 2895 2895 | 76 76 | 2005-06-24 15:52:25.000 | 1 1 | 2020-12-23 07:15:52 |
| 2894 | 2005-06-20 02:22:42.000 | 4316 4316 | 76 76 | 2005-06-22 00:38:42.000 | 1 1 | 2020-12-23 07:15:59 |
| 3416 | 2005-06-21 17:05:29.000 | 1215 1215 | 76 76 | 2005-06-23 17:58:29.000 | 2 2 | 2020-12-23 07:16:07 |
| 4099 | 2005-07-07 06:20:33.000 | 1930 1930 | 76 76 | 2005-07-16 08:39:33.000 | 1 1 | 2020-12-23 07:16:17 |
| 5571 | 2005-07-10 03:48:20.000 | 1084 1084 | 76 76 | 2005-07-11 02:09:20.000 | 2 2 | 2020-12-23 07:16:39 |
| 6789 | 2005-07-12 16:34:40.000 | 1973 1973 | 76 76 | 2005-07-14 17:02:40.000 | 2 2 | 2020-12-23 07:16:56 |
| 8253 | 2005-07-29 00:57:06.000 | 2388 2388 | 76 76 | 2005-08-07 01:46:06.000 | 1 1 | 2020-12-23 07:17:18 |
| 8357 | 2005-07-29 04:59:44.000 | 892 892 | 76 76 | 2005-08-01 04:26:44.000 | 1 1 | 2020-12-23 07:17:20 |
| 8405 | 2005-07-29 06:28:19.000 | 2164 2164 | 76 76 | 2005-08-07 08:14:19.000 | 2 2 | 2020-12-23 07:17:20 |
| 8935 | 2005-07-30 02:38:45.000 | 285 285 | 76 76 | 2005-08-02 07:11:45.000 | 2 2 | 2020-12-23 07:17:28 |
| 9312 | 2005-07-30 16:59:17.000 | 2483 2483 | 76 76 | 2005-08-03 17:24:17.000 | 2 2 | 2020-12-23 07:17:34 |
| 10082 | 2005-07-31 20:09:32.000 | 1275 1275 | 76 76 | 2005-08-01 15:41:32.000 | 2 2 | 2020-12-23 07:17:45 |
| 10795 | 2005-08-01 21:56:37.000 | 2748 2748 | 76 76 | 2005-08-03 01:36:37.000 | 1 1 | 2020-12-23 07:17:55 |
| 11172 | 2005-08-02 10:27:52.000 | 1207 1207 | 76 76 | 2005-08-11 12:47:52.000 | 1 1 | 2020-12-23 07:18:00 |
| 13697 | 2005-08-20 09:21:08.000 | 291 291 | 76 76 | 2005-08-29 12:33:08.000 | 1 1 | 2020-12-23 07:18:36 |
| 14637 | 2005-08-21 19:01:00.000 | 1846 1846 | 76 76 | 2005-08-26 23:03:00.000 | 2 2 | 2020-12-23 07:18:50 |
| 15169 | 2005-08-22 15:21:56.000 | 794 794 | 76 76 | 2005-08-28 09:40:56.000 | 1 1 | 2020-12-23 07:18:57 |
| 15566 | 2005-08-23 05:17:23.000 | 4344 4344 | 76 76 | 2005-09-01 08:09:23.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) ;