rental
21 rows where customer_id = 429
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 |
|---|---|---|---|---|---|---|
| 150 | 2005-05-26 00:28:39.000 | 909 909 | 429 429 | 2005-06-01 02:10:39.000 | 2 2 | 2020-12-23 07:15:22 |
| 290 | 2005-05-26 20:08:33.000 | 2776 2776 | 429 429 | 2005-05-30 00:32:33.000 | 1 1 | 2020-12-23 07:15:23 |
| 601 | 2005-05-28 14:08:22.000 | 3225 3225 | 429 429 | 2005-06-04 10:50:22.000 | 1 1 | 2020-12-23 07:15:27 |
| 799 | 2005-05-29 17:24:48.000 | 1713 1713 | 429 429 | 2005-06-05 12:25:48.000 | 1 1 | 2020-12-23 07:15:30 |
| 844 | 2005-05-30 00:58:20.000 | 536 536 | 429 429 | 2005-06-01 00:38:20.000 | 1 1 | 2020-12-23 07:15:31 |
| 1781 | 2005-06-16 19:20:24.000 | 2841 2841 | 429 429 | 2005-06-25 17:02:24.000 | 2 2 | 2020-12-23 07:15:43 |
| 1798 | 2005-06-16 20:16:15.000 | 1654 1654 | 429 429 | 2005-06-20 22:23:15.000 | 2 2 | 2020-12-23 07:15:44 |
| 1916 | 2005-06-17 05:29:59.000 | 4428 4428 | 429 429 | 2005-06-26 05:35:59.000 | 2 2 | 2020-12-23 07:15:45 |
| 3409 | 2005-06-21 16:17:38.000 | 3374 3374 | 429 429 | 2005-06-22 14:16:38.000 | 1 1 | 2020-12-23 07:16:07 |
| 5868 | 2005-07-10 18:39:16.000 | 452 452 | 429 429 | 2005-07-15 21:19:16.000 | 1 1 | 2020-12-23 07:16:43 |
| 6196 | 2005-07-11 12:05:46.000 | 995 995 | 429 429 | 2005-07-18 08:27:46.000 | 2 2 | 2020-12-23 07:16:48 |
| 6886 | 2005-07-12 20:58:04.000 | 4533 4533 | 429 429 | 2005-07-18 16:56:04.000 | 2 2 | 2020-12-23 07:16:58 |
| 6977 | 2005-07-27 00:40:50.000 | 3545 3545 | 429 429 | 2005-08-02 19:08:50.000 | 2 2 | 2020-12-23 07:16:59 |
| 7352 | 2005-07-27 14:38:29.000 | 35 35 | 429 429 | 2005-07-28 14:24:29.000 | 1 1 | 2020-12-23 07:17:05 |
| 8136 | 2005-07-28 20:05:48.000 | 3434 3434 | 429 429 | 2005-08-01 20:31:48.000 | 2 2 | 2020-12-23 07:17:16 |
| 8143 | 2005-07-28 20:23:11.000 | 3629 3629 | 429 429 | 2005-08-01 18:17:11.000 | 1 1 | 2020-12-23 07:17:17 |
| 8175 | 2005-07-28 21:38:16.000 | 641 641 | 429 429 | 2005-08-07 01:34:16.000 | 2 2 | 2020-12-23 07:17:17 |
| 9849 | 2005-07-31 12:44:34.000 | 2230 2230 | 429 429 | 2005-08-02 16:49:34.000 | 1 1 | 2020-12-23 07:17:42 |
| 12259 | 2005-08-18 04:14:35.000 | 2904 2904 | 429 429 | 2005-08-18 22:30:35.000 | 2 2 | 2020-12-23 07:18:15 |
| 12953 | 2005-08-19 06:04:07.000 | 3954 3954 | 429 429 | 2005-08-28 11:05:07.000 | 1 1 | 2020-12-23 07:18:24 |
| 14495 | 2005-08-21 14:04:39.000 | 3215 3215 | 429 429 | 2005-08-22 16:53:39.000 | 2 2 | 2020-12-23 07:18:48 |
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) ;