rental
25 rows where customer_id = 326
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 |
|---|---|---|---|---|---|---|
| 875 | 2005-05-30 05:38:24.000 | 1428 1428 | 326 326 | 2005-06-06 00:34:24.000 | 2 2 | 2020-12-23 07:15:31 |
| 981 | 2005-05-30 21:52:42.000 | 2913 2913 | 326 326 | 2005-06-01 03:15:42.000 | 2 2 | 2020-12-23 07:15:33 |
| 1149 | 2005-05-31 21:03:17.000 | 352 352 | 326 326 | 2005-06-08 19:58:17.000 | 2 2 | 2020-12-23 07:15:35 |
| 1311 | 2005-06-15 10:11:59.000 | 3114 3114 | 326 326 | 2005-06-17 08:44:59.000 | 2 2 | 2020-12-23 07:15:37 |
| 2086 | 2005-06-17 17:32:07.000 | 898 898 | 326 326 | 2005-06-21 20:19:07.000 | 2 2 | 2020-12-23 07:15:48 |
| 2317 | 2005-06-18 09:12:18.000 | 1602 1602 | 326 326 | 2005-06-21 05:50:18.000 | 2 2 | 2020-12-23 07:15:51 |
| 3441 | 2005-06-21 20:00:12.000 | 2863 2863 | 326 326 | 2005-06-24 00:24:12.000 | 2 2 | 2020-12-23 07:16:07 |
| 3886 | 2005-07-06 18:44:24.000 | 2368 2368 | 326 326 | 2005-07-08 15:11:24.000 | 1 1 | 2020-12-23 07:16:14 |
| 4160 | 2005-07-07 09:13:17.000 | 1909 1909 | 326 326 | 2005-07-15 11:50:17.000 | 2 2 | 2020-12-23 07:16:18 |
| 5147 | 2005-07-09 08:17:41.000 | 2270 2270 | 326 326 | 2005-07-18 09:45:41.000 | 2 2 | 2020-12-23 07:16:33 |
| 7117 | 2005-07-27 05:48:36.000 | 2772 2772 | 326 326 | 2005-08-01 00:33:36.000 | 1 1 | 2020-12-23 07:17:01 |
| 7725 | 2005-07-28 04:47:14.000 | 1922 1922 | 326 326 | 2005-08-04 09:03:14.000 | 1 1 | 2020-12-23 07:17:11 |
| 7931 | 2005-07-28 12:23:41.000 | 1923 1923 | 326 326 | 2005-08-06 09:49:41.000 | 2 2 | 2020-12-23 07:17:13 |
| 8467 | 2005-07-29 08:25:35.000 | 263 263 | 326 326 | 2005-08-07 03:28:35.000 | 2 2 | 2020-12-23 07:17:21 |
| 8604 | 2005-07-29 13:07:13.000 | 3909 3909 | 326 326 | 2005-07-31 18:00:13.000 | 2 2 | 2020-12-23 07:17:23 |
| 8739 | 2005-07-29 18:34:33.000 | 4310 4310 | 326 326 | 2005-08-02 16:05:33.000 | 1 1 | 2020-12-23 07:17:26 |
| 9855 | 2005-07-31 13:00:33.000 | 1246 1246 | 326 326 | 2005-08-03 16:18:33.000 | 2 2 | 2020-12-23 07:17:42 |
| 10108 | 2005-07-31 21:02:14.000 | 3703 3703 | 326 326 | 2005-08-01 18:28:14.000 | 1 1 | 2020-12-23 07:17:45 |
| 10173 | 2005-07-31 23:36:59.000 | 2527 2527 | 326 326 | 2005-08-08 20:20:59.000 | 2 2 | 2020-12-23 07:17:46 |
| 10720 | 2005-08-01 19:04:33.000 | 3712 3712 | 326 326 | 2005-08-06 23:12:33.000 | 2 2 | 2020-12-23 07:17:54 |
| 10976 | 2005-08-02 04:11:48.000 | 2418 2418 | 326 326 | 2005-08-06 06:30:48.000 | 2 2 | 2020-12-23 07:17:57 |
| 11010 | 2005-08-02 05:06:27.000 | 869 869 | 326 326 | 2005-08-03 23:47:27.000 | 2 2 | 2020-12-23 07:17:58 |
| 11428 | 2005-08-02 20:03:10.000 | 722 722 | 326 326 | 2005-08-04 01:55:10.000 | 1 1 | 2020-12-23 07:18:04 |
| 11485 | 2005-08-02 22:33:25.000 | 1872 1872 | 326 326 | 2005-08-04 23:26:25.000 | 2 2 | 2020-12-23 07:18:04 |
| 12829 | 2005-08-19 01:38:18.000 | 1129 1129 | 326 326 | 2005-08-25 22:23:18.000 | 2 2 | 2020-12-23 07:18:23 |
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) ;