rental
26 rows where customer_id = 225
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 |
|---|---|---|---|---|---|---|
| 812 | 2005-05-29 20:00:30.000 | 1099 1099 | 225 225 | 2005-05-30 19:43:30.000 | 2 2 | 2020-12-23 07:15:30 |
| 963 | 2005-05-30 18:52:53.000 | 1921 1921 | 225 225 | 2005-06-07 16:19:53.000 | 2 2 | 2020-12-23 07:15:33 |
| 2226 | 2005-06-18 03:39:56.000 | 3487 3487 | 225 225 | 2005-06-24 07:26:56.000 | 2 2 | 2020-12-23 07:15:50 |
| 3574 | 2005-07-06 03:36:01.000 | 2799 2799 | 225 225 | 2005-07-10 01:29:01.000 | 2 2 | 2020-12-23 07:16:09 |
| 4345 | 2005-07-07 18:52:57.000 | 2235 2235 | 225 225 | 2005-07-15 21:24:57.000 | 2 2 | 2020-12-23 07:16:21 |
| 4824 | 2005-07-08 17:37:39.000 | 1855 1855 | 225 225 | 2005-07-16 18:27:39.000 | 1 1 | 2020-12-23 07:16:28 |
| 4955 | 2005-07-08 23:16:21.000 | 1103 1103 | 225 225 | 2005-07-14 02:09:21.000 | 2 2 | 2020-12-23 07:16:30 |
| 5067 | 2005-07-09 04:52:35.000 | 1480 1480 | 225 225 | 2005-07-11 23:33:35.000 | 2 2 | 2020-12-23 07:16:32 |
| 6159 | 2005-07-11 09:55:34.000 | 126 126 | 225 225 | 2005-07-13 10:01:34.000 | 2 2 | 2020-12-23 07:16:47 |
| 6317 | 2005-07-11 18:47:41.000 | 4206 4206 | 225 225 | 2005-07-14 18:18:41.000 | 1 1 | 2020-12-23 07:16:49 |
| 6350 | 2005-07-11 20:30:15.000 | 2853 2853 | 225 225 | 2005-07-16 21:30:15.000 | 1 1 | 2020-12-23 07:16:50 |
| 6526 | 2005-07-12 04:21:20.000 | 1718 1718 | 225 225 | 2005-07-18 23:45:20.000 | 2 2 | 2020-12-23 07:16:53 |
| 6532 | 2005-07-12 04:38:32.000 | 2361 2361 | 225 225 | 2005-07-13 03:54:32.000 | 1 1 | 2020-12-23 07:16:53 |
| 7347 | 2005-07-27 14:31:24.000 | 3779 3779 | 225 225 | 2005-07-31 16:19:24.000 | 1 1 | 2020-12-23 07:17:05 |
| 7524 | 2005-07-27 21:11:44.000 | 4295 4295 | 225 225 | 2005-08-03 02:17:44.000 | 1 1 | 2020-12-23 07:17:07 |
| 8054 | 2005-07-28 17:02:18.000 | 1062 1062 | 225 225 | 2005-08-06 11:55:18.000 | 1 1 | 2020-12-23 07:17:15 |
| 8110 | 2005-07-28 19:07:45.000 | 1244 1244 | 225 225 | 2005-08-04 22:12:45.000 | 1 1 | 2020-12-23 07:17:16 |
| 9980 | 2005-07-31 17:02:00.000 | 122 122 | 225 225 | 2005-08-08 11:11:00.000 | 2 2 | 2020-12-23 07:17:43 |
| 9993 | 2005-07-31 17:30:20.000 | 2503 2503 | 225 225 | 2005-08-01 20:53:20.000 | 2 2 | 2020-12-23 07:17:44 |
| 10138 | 2005-07-31 22:02:09.000 | 179 179 | 225 225 | 2005-08-07 20:46:09.000 | 2 2 | 2020-12-23 07:17:46 |
| 10793 | 2005-08-01 21:48:03.000 | 3018 3018 | 225 225 | 2005-08-10 19:16:03.000 | 1 1 | 2020-12-23 07:17:55 |
| 11333 | 2005-08-02 16:53:00.000 | 3335 3335 | 225 225 | 2005-08-07 20:49:00.000 | 2 2 | 2020-12-23 07:18:02 |
| 11384 | 2005-08-02 18:23:01.000 | 2840 2840 | 225 225 | 2005-08-05 17:59:01.000 | 1 1 | 2020-12-23 07:18:03 |
| 11395 | 2005-08-02 18:47:44.000 | 4234 4234 | 225 225 | 2005-08-10 17:07:44.000 | 2 2 | 2020-12-23 07:18:03 |
| 11437 | 2005-08-02 20:20:06.000 | 2679 2679 | 225 225 | 2005-08-05 22:17:06.000 | 2 2 | 2020-12-23 07:18:04 |
| 14444 | 2005-08-21 12:07:25.000 | 2211 2211 | 225 225 | 2005-08-28 08:36:25.000 | 2 2 | 2020-12-23 07:18:47 |
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) ;