rental
22 rows where customer_id = 79
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 |
|---|---|---|---|---|---|---|
| 840 | 2005-05-30 00:28:41.000 | 4049 4049 | 79 79 | 2005-05-31 20:39:41.000 | 2 2 | 2020-12-23 07:15:31 |
| 859 | 2005-05-30 02:36:20.000 | 3032 3032 | 79 79 | 2005-06-02 07:49:20.000 | 2 2 | 2020-12-23 07:15:31 |
| 928 | 2005-05-30 12:27:14.000 | 246 246 | 79 79 | 2005-06-05 13:56:14.000 | 2 2 | 2020-12-23 07:15:32 |
| 3096 | 2005-06-20 16:17:56.000 | 3851 3851 | 79 79 | 2005-06-24 10:17:56.000 | 2 2 | 2020-12-23 07:16:02 |
| 3178 | 2005-06-20 22:35:12.000 | 3517 3517 | 79 79 | 2005-06-23 19:39:12.000 | 1 1 | 2020-12-23 07:16:03 |
| 3641 | 2005-07-06 07:17:09.000 | 3834 3834 | 79 79 | 2005-07-11 07:25:09.000 | 1 1 | 2020-12-23 07:16:10 |
| 3748 | 2005-07-06 12:11:22.000 | 2920 2920 | 79 79 | 2005-07-12 07:22:22.000 | 1 1 | 2020-12-23 07:16:12 |
| 4049 | 2005-07-07 03:34:53.000 | 4172 4172 | 79 79 | 2005-07-15 04:10:53.000 | 2 2 | 2020-12-23 07:16:16 |
| 4530 | 2005-07-08 03:27:05.000 | 3775 3775 | 79 79 | 2005-07-11 07:44:05.000 | 1 1 | 2020-12-23 07:16:23 |
| 4736 | 2005-07-08 13:22:55.000 | 3009 3009 | 79 79 | 2005-07-17 07:27:55.000 | 1 1 | 2020-12-23 07:16:27 |
| 5205 | 2005-07-09 10:56:37.000 | 161 161 | 79 79 | 2005-07-13 05:45:37.000 | 1 1 | 2020-12-23 07:16:33 |
| 5555 | 2005-07-10 03:08:55.000 | 2551 2551 | 79 79 | 2005-07-11 01:36:55.000 | 2 2 | 2020-12-23 07:16:39 |
| 6162 | 2005-07-11 10:12:30.000 | 786 786 | 79 79 | 2005-07-19 06:02:30.000 | 2 2 | 2020-12-23 07:16:47 |
| 7220 | 2005-07-27 09:35:54.000 | 3867 3867 | 79 79 | 2005-08-04 06:00:54.000 | 2 2 | 2020-12-23 07:17:03 |
| 8849 | 2005-07-29 23:21:01.000 | 4300 4300 | 79 79 | 2005-08-03 20:01:01.000 | 1 1 | 2020-12-23 07:17:27 |
| 9814 | 2005-07-31 11:29:46.000 | 136 136 | 79 79 | 2005-08-08 15:49:46.000 | 1 1 | 2020-12-23 07:17:41 |
| 9845 | 2005-07-31 12:28:05.000 | 2417 2417 | 79 79 | 2005-08-06 06:47:05.000 | 1 1 | 2020-12-23 07:17:42 |
| 9989 | 2005-07-31 17:22:39.000 | 1713 1713 | 79 79 | 2005-08-01 18:55:39.000 | 1 1 | 2020-12-23 07:17:44 |
| 10676 | 2005-08-01 17:14:15.000 | 629 629 | 79 79 | 2005-08-04 12:34:15.000 | 1 1 | 2020-12-23 07:17:53 |
| 11641 | 2005-08-17 04:45:39.000 | 2717 2717 | 79 79 | 2005-08-20 10:38:39.000 | 1 1 | 2020-12-23 07:18:07 |
| 13026 | 2005-08-19 08:22:45.000 | 3026 3026 | 79 79 | 2005-08-21 09:31:45.000 | 1 1 | 2020-12-23 07:18:26 |
| 14179 | 2005-08-21 03:14:27.000 | 3956 3956 | 79 79 | 2005-08-26 00:46:27.000 | 2 2 | 2020-12-23 07:18:43 |
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) ;