rental
25 rows where customer_id = 562
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 |
|---|---|---|---|---|---|---|
| 788 | 2005-05-29 16:13:55.000 | 763 763 | 562 562 | 2005-05-31 16:40:55.000 | 1 1 | 2020-12-23 07:15:30 |
| 941 | 2005-05-30 15:02:25.000 | 3630 3630 | 562 562 | 2005-06-01 17:19:25.000 | 1 1 | 2020-12-23 07:15:32 |
| 1139 | 2005-05-31 19:34:52.000 | 666 666 | 562 562 | 2005-06-06 17:40:52.000 | 1 1 | 2020-12-23 07:15:35 |
| 1998 | 2005-06-17 11:24:57.000 | 4365 4365 | 562 562 | 2005-06-26 09:48:57.000 | 1 1 | 2020-12-23 07:15:47 |
| 2705 | 2005-06-19 13:54:30.000 | 1191 1191 | 562 562 | 2005-06-20 12:31:30.000 | 1 1 | 2020-12-23 07:15:57 |
| 2746 | 2005-06-19 16:21:40.000 | 933 933 | 562 562 | 2005-06-28 11:56:40.000 | 2 2 | 2020-12-23 07:15:57 |
| 3242 | 2005-06-21 02:56:24.000 | 1421 1421 | 562 562 | 2005-06-29 21:41:24.000 | 2 2 | 2020-12-23 07:16:04 |
| 4732 | 2005-07-08 13:09:45.000 | 308 308 | 562 562 | 2005-07-14 10:10:45.000 | 1 1 | 2020-12-23 07:16:27 |
| 4802 | 2005-07-08 16:55:17.000 | 22 22 | 562 562 | 2005-07-15 19:34:17.000 | 1 1 | 2020-12-23 07:16:28 |
| 5360 | 2005-07-09 18:14:03.000 | 679 679 | 562 562 | 2005-07-10 15:17:03.000 | 2 2 | 2020-12-23 07:16:36 |
| 6065 | 2005-07-11 04:25:51.000 | 1007 1007 | 562 562 | 2005-07-17 08:19:51.000 | 1 1 | 2020-12-23 07:16:46 |
| 6607 | 2005-07-12 08:08:50.000 | 337 337 | 562 562 | 2005-07-20 09:17:50.000 | 1 1 | 2020-12-23 07:16:54 |
| 7166 | 2005-07-27 07:36:56.000 | 1375 1375 | 562 562 | 2005-08-02 03:46:56.000 | 1 1 | 2020-12-23 07:17:02 |
| 7430 | 2005-07-27 17:26:14.000 | 4205 4205 | 562 562 | 2005-08-01 13:02:14.000 | 2 2 | 2020-12-23 07:17:06 |
| 7560 | 2005-07-27 22:20:17.000 | 3574 3574 | 562 562 | 2005-08-02 23:00:17.000 | 2 2 | 2020-12-23 07:17:08 |
| 8132 | 2005-07-28 19:57:31.000 | 1303 1303 | 562 562 | 2005-08-02 22:16:31.000 | 2 2 | 2020-12-23 07:17:16 |
| 10868 | 2005-08-02 00:25:15.000 | 2443 2443 | 562 562 | 2005-08-10 02:31:15.000 | 2 2 | 2020-12-23 07:17:56 |
| 12008 | 2005-08-17 19:16:18.000 | 865 865 | 562 562 | 2005-08-18 14:24:18.000 | 2 2 | 2020-12-23 07:18:11 |
| 12248 | 2005-08-18 03:53:18.000 | 2120 2120 | 562 562 | 2005-08-22 04:53:18.000 | 1 1 | 2020-12-23 07:18:15 |
| 13225 | 2005-08-19 15:54:33.000 | 1420 1420 | 562 562 | 2005-08-25 16:40:33.000 | 1 1 | 2020-12-23 07:18:29 |
| 13347 | 2005-08-19 20:28:48.000 | 4038 4038 | 562 562 | 2005-08-28 19:33:48.000 | 2 2 | 2020-12-23 07:18:30 |
| 13639 | 2005-08-20 07:22:07.000 | 2489 2489 | 562 562 | 2005-08-23 11:24:07.000 | 2 2 | 2020-12-23 07:18:35 |
| 15212 | 2005-08-22 16:44:26.000 | 2182 2182 | 562 562 | 2005-08-27 20:26:26.000 | 1 1 | 2020-12-23 07:18:58 |
| 15475 | 2005-08-23 01:44:43.000 | 4503 4503 | 562 562 | 2005-08-23 23:53:43.000 | 2 2 | 2020-12-23 07:19:02 |
| 15900 | 2005-08-23 17:16:30.000 | 1112 1112 | 562 562 | 2005-08-27 18:02:30.000 | 1 1 | 2020-12-23 07:19:08 |
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) ;