rental
22 rows where customer_id = 4
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 |
|---|---|---|---|---|---|---|
| 1297 | 2005-06-15 09:31:28.000 | 1075 1075 | 4 4 | 2005-06-19 04:33:28.000 | 1 1 | 2020-12-23 07:15:37 |
| 1633 | 2005-06-16 08:08:40.000 | 280 280 | 4 4 | 2005-06-17 11:12:40.000 | 1 1 | 2020-12-23 07:15:41 |
| 1707 | 2005-06-16 14:01:27.000 | 185 185 | 4 4 | 2005-06-18 09:35:27.000 | 1 1 | 2020-12-23 07:15:42 |
| 1735 | 2005-06-16 15:51:52.000 | 97 97 | 4 4 | 2005-06-20 13:27:52.000 | 1 1 | 2020-12-23 07:15:43 |
| 2043 | 2005-06-17 14:31:12.000 | 2495 2495 | 4 4 | 2005-06-19 11:04:12.000 | 2 2 | 2020-12-23 07:15:47 |
| 2642 | 2005-06-19 09:39:01.000 | 2065 2065 | 4 4 | 2005-06-25 08:33:01.000 | 1 1 | 2020-12-23 07:15:56 |
| 7660 | 2005-07-28 02:10:10.000 | 4385 4385 | 4 4 | 2005-07-30 04:29:10.000 | 2 2 | 2020-12-23 07:17:10 |
| 7718 | 2005-07-28 04:37:59.000 | 3587 3587 | 4 4 | 2005-07-29 09:20:59.000 | 2 2 | 2020-12-23 07:17:10 |
| 8741 | 2005-07-29 18:44:57.000 | 165 165 | 4 4 | 2005-08-03 18:25:57.000 | 2 2 | 2020-12-23 07:17:26 |
| 9100 | 2005-07-30 08:46:09.000 | 4117 4117 | 4 4 | 2005-08-05 10:34:09.000 | 1 1 | 2020-12-23 07:17:31 |
| 9371 | 2005-07-30 18:58:00.000 | 2980 2980 | 4 4 | 2005-08-03 15:14:00.000 | 1 1 | 2020-12-23 07:17:35 |
| 11069 | 2005-08-02 07:09:34.000 | 57 57 | 4 4 | 2005-08-08 08:39:34.000 | 1 1 | 2020-12-23 07:17:59 |
| 11110 | 2005-08-02 08:20:31.000 | 4311 4311 | 4 4 | 2005-08-04 05:06:31.000 | 2 2 | 2020-12-23 07:17:59 |
| 11529 | 2005-08-17 00:28:01.000 | 3071 3071 | 4 4 | 2005-08-19 04:47:01.000 | 2 2 | 2020-12-23 07:18:05 |
| 12151 | 2005-08-18 00:14:03.000 | 1976 1976 | 4 4 | 2005-08-18 23:52:03.000 | 2 2 | 2020-12-23 07:18:13 |
| 12294 | 2005-08-18 05:14:44.000 | 2479 2479 | 4 4 | 2005-08-27 01:32:44.000 | 2 2 | 2020-12-23 07:18:15 |
| 12856 | 2005-08-19 02:19:13.000 | 132 132 | 4 4 | 2005-08-23 07:49:13.000 | 2 2 | 2020-12-23 07:18:23 |
| 13704 | 2005-08-20 09:32:04.000 | 3373 3373 | 4 4 | 2005-08-23 14:29:04.000 | 2 2 | 2020-12-23 07:18:36 |
| 13807 | 2005-08-20 12:55:40.000 | 3822 3822 | 4 4 | 2005-08-28 09:06:40.000 | 2 2 | 2020-12-23 07:18:38 |
| 14225 | 2005-08-21 04:53:37.000 | 984 984 | 4 4 | 2005-08-25 23:39:37.000 | 2 2 | 2020-12-23 07:18:44 |
| 15147 | 2005-08-22 13:58:23.000 | 2553 2553 | 4 4 | 2005-08-28 14:33:23.000 | 2 2 | 2020-12-23 07:18:57 |
| 15635 | 2005-08-23 07:43:00.000 | 3308 3308 | 4 4 | 2005-08-27 10:47:00.000 | 1 1 | 2020-12-23 07:19:04 |
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) ;