rental
26 rows where customer_id = 304
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 |
|---|---|---|---|---|---|---|
| 135 | 2005-05-25 21:58:58.000 | 103 103 | 304 304 | 2005-06-03 17:50:58.000 | 1 1 | 2020-12-23 07:15:21 |
| 415 | 2005-05-27 14:51:45.000 | 3698 3698 | 304 304 | 2005-05-28 19:07:45.000 | 2 2 | 2020-12-23 07:15:25 |
| 937 | 2005-05-30 14:47:31.000 | 1054 1054 | 304 304 | 2005-06-05 09:53:31.000 | 2 2 | 2020-12-23 07:15:32 |
| 1414 | 2005-06-15 17:26:32.000 | 4005 4005 | 304 304 | 2005-06-22 22:30:32.000 | 1 1 | 2020-12-23 07:15:38 |
| 1525 | 2005-06-16 00:26:07.000 | 1467 1467 | 304 304 | 2005-06-19 22:37:07.000 | 2 2 | 2020-12-23 07:15:40 |
| 2039 | 2005-06-17 14:03:43.000 | 1514 1514 | 304 304 | 2005-06-24 09:21:43.000 | 1 1 | 2020-12-23 07:15:47 |
| 2902 | 2005-06-20 02:45:35.000 | 2787 2787 | 304 304 | 2005-06-26 07:51:35.000 | 1 1 | 2020-12-23 07:15:59 |
| 4466 | 2005-07-08 00:12:53.000 | 3320 3320 | 304 304 | 2005-07-17 03:49:53.000 | 2 2 | 2020-12-23 07:16:23 |
| 4812 | 2005-07-08 17:07:11.000 | 3281 3281 | 304 304 | 2005-07-17 21:03:11.000 | 2 2 | 2020-12-23 07:16:28 |
| 5411 | 2005-07-09 20:23:38.000 | 4292 4292 | 304 304 | 2005-07-16 01:17:38.000 | 2 2 | 2020-12-23 07:16:36 |
| 5712 | 2005-07-10 10:40:32.000 | 3480 3480 | 304 304 | 2005-07-12 11:45:32.000 | 1 1 | 2020-12-23 07:16:41 |
| 5749 | 2005-07-10 12:20:36.000 | 1768 1768 | 304 304 | 2005-07-19 10:39:36.000 | 1 1 | 2020-12-23 07:16:42 |
| 5795 | 2005-07-10 14:36:29.000 | 3958 3958 | 304 304 | 2005-07-14 13:26:29.000 | 1 1 | 2020-12-23 07:16:42 |
| 6107 | 2005-07-11 07:07:09.000 | 3798 3798 | 304 304 | 2005-07-14 07:32:09.000 | 2 2 | 2020-12-23 07:16:47 |
| 6737 | 2005-07-12 14:16:52.000 | 315 315 | 304 304 | 2005-07-18 19:48:52.000 | 1 1 | 2020-12-23 07:16:56 |
| 7551 | 2005-07-27 21:59:15.000 | 2635 2635 | 304 304 | 2005-07-31 19:54:15.000 | 2 2 | 2020-12-23 07:17:08 |
| 8055 | 2005-07-28 17:02:32.000 | 4162 4162 | 304 304 | 2005-07-31 22:05:32.000 | 2 2 | 2020-12-23 07:17:15 |
| 9930 | 2005-07-31 15:18:03.000 | 4491 4491 | 304 304 | 2005-08-01 12:36:03.000 | 2 2 | 2020-12-23 07:17:43 |
| 9992 | 2005-07-31 17:29:48.000 | 4242 4242 | 304 304 | 2005-08-09 13:02:48.000 | 2 2 | 2020-12-23 07:17:44 |
| 10631 | 2005-08-01 15:35:14.000 | 2712 2712 | 304 304 | 2005-08-03 10:48:14.000 | 1 1 | 2020-12-23 07:17:53 |
| 11983 | 2005-08-17 18:13:55.000 | 2580 2580 | 304 304 | 2005-08-23 18:27:55.000 | 2 2 | 2020-12-23 07:18:11 |
| 12540 | 2005-08-18 14:17:30.000 | 2826 2826 | 304 304 | 2005-08-26 15:33:30.000 | 2 2 | 2020-12-23 07:18:19 |
| 13911 | 2005-08-20 16:31:33.000 | 4400 4400 | 304 304 | 2005-08-28 19:26:33.000 | 2 2 | 2020-12-23 07:18:39 |
| 14023 | 2005-08-20 21:10:32.000 | 2668 2668 | 304 304 | 2005-08-23 20:57:32.000 | 1 1 | 2020-12-23 07:18:41 |
| 14899 | 2005-08-22 04:26:38.000 | 3700 3700 | 304 304 | 2005-08-31 08:36:38.000 | 2 2 | 2020-12-23 07:18:53 |
| 14945 | 2005-08-22 06:05:38.000 | 1567 1567 | 304 304 | 2005-08-29 12:01:38.000 | 1 1 | 2020-12-23 07:18:54 |
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) ;