rental
22 rows where customer_id = 321
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 |
|---|---|---|---|---|---|---|
| 200 | 2005-05-26 07:12:21.000 | 3926 3926 | 321 321 | 2005-05-31 12:07:21.000 | 1 1 | 2020-12-23 07:15:22 |
| 620 | 2005-05-28 15:54:45.000 | 2444 2444 | 321 321 | 2005-06-04 20:26:45.000 | 1 1 | 2020-12-23 07:15:28 |
| 818 | 2005-05-29 20:47:53.000 | 4106 4106 | 321 321 | 2005-06-02 23:18:53.000 | 2 2 | 2020-12-23 07:15:30 |
| 1750 | 2005-06-16 16:57:36.000 | 1103 1103 | 321 321 | 2005-06-25 21:51:36.000 | 1 1 | 2020-12-23 07:15:43 |
| 3410 | 2005-06-21 16:20:47.000 | 1197 1197 | 321 321 | 2005-06-24 19:09:47.000 | 2 2 | 2020-12-23 07:16:07 |
| 3901 | 2005-07-06 19:24:55.000 | 3367 3367 | 321 321 | 2005-07-14 20:30:55.000 | 2 2 | 2020-12-23 07:16:14 |
| 3920 | 2005-07-06 20:26:40.000 | 1551 1551 | 321 321 | 2005-07-15 15:00:40.000 | 2 2 | 2020-12-23 07:16:14 |
| 4281 | 2005-07-07 15:17:50.000 | 1182 1182 | 321 321 | 2005-07-08 11:42:50.000 | 2 2 | 2020-12-23 07:16:20 |
| 4318 | 2005-07-07 17:47:50.000 | 1607 1607 | 321 321 | 2005-07-14 12:15:50.000 | 2 2 | 2020-12-23 07:16:20 |
| 5202 | 2005-07-09 10:53:48.000 | 3417 3417 | 321 321 | 2005-07-15 13:31:48.000 | 1 1 | 2020-12-23 07:16:33 |
| 5867 | 2005-07-10 18:39:01.000 | 730 730 | 321 321 | 2005-07-19 21:56:01.000 | 2 2 | 2020-12-23 07:16:43 |
| 6190 | 2005-07-11 11:36:18.000 | 2564 2564 | 321 321 | 2005-07-19 17:05:18.000 | 2 2 | 2020-12-23 07:16:48 |
| 6859 | 2005-07-12 19:53:57.000 | 4108 4108 | 321 321 | 2005-07-17 19:48:57.000 | 2 2 | 2020-12-23 07:16:58 |
| 8685 | 2005-07-29 16:17:05.000 | 1827 1827 | 321 321 | 2005-08-07 17:44:05.000 | 1 1 | 2020-12-23 07:17:25 |
| 9981 | 2005-07-31 17:08:31.000 | 1354 1354 | 321 321 | 2005-08-01 22:46:31.000 | 2 2 | 2020-12-23 07:17:43 |
| 11722 | 2005-08-17 07:53:03.000 | 2430 2430 | 321 321 | 2005-08-22 06:56:03.000 | 2 2 | 2020-12-23 07:18:08 |
| 12033 | 2005-08-17 20:14:34.000 | 2731 2731 | 321 321 | 2005-08-26 00:22:34.000 | 2 2 | 2020-12-23 07:18:12 |
| 12034 | 2005-08-17 20:15:31.000 | 834 834 | 321 321 | 2005-08-24 15:46:31.000 | 2 2 | 2020-12-23 07:18:12 |
| 12398 | 2005-08-18 09:13:24.000 | 4247 4247 | 321 321 | 2005-08-27 14:58:24.000 | 1 1 | 2020-12-23 07:18:17 |
| 13623 | 2005-08-20 06:49:46.000 | 3948 3948 | 321 321 | 2005-08-25 05:19:46.000 | 2 2 | 2020-12-23 07:18:35 |
| 15673 | 2005-08-23 09:12:50.000 | 3096 3096 | 321 321 | 2005-08-29 12:45:50.000 | 2 2 | 2020-12-23 07:19:04 |
| 15888 | 2005-08-23 16:56:14.000 | 2955 2955 | 321 321 | 2005-08-31 14:32:14.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) ;