rental
25 rows where customer_id = 308
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 |
|---|---|---|---|---|---|---|
| 589 | 2005-05-28 12:27:50.000 | 4231 4231 | 308 308 | 2005-06-03 07:15:50.000 | 2 2 | 2020-12-23 07:15:27 |
| 2037 | 2005-06-17 13:54:20.000 | 2582 2582 | 308 308 | 2005-06-20 14:49:20.000 | 2 2 | 2020-12-23 07:15:47 |
| 2094 | 2005-06-17 18:18:56.000 | 2205 2205 | 308 308 | 2005-06-18 19:36:56.000 | 1 1 | 2020-12-23 07:15:48 |
| 2168 | 2005-06-17 23:53:24.000 | 802 802 | 308 308 | 2005-06-20 01:11:24.000 | 1 1 | 2020-12-23 07:15:49 |
| 2346 | 2005-06-18 12:08:16.000 | 2575 2575 | 308 308 | 2005-06-27 15:02:16.000 | 1 1 | 2020-12-23 07:15:52 |
| 2448 | 2005-06-18 19:13:45.000 | 1642 1642 | 308 308 | 2005-06-27 14:43:45.000 | 1 1 | 2020-12-23 07:15:53 |
| 4002 | 2005-07-07 00:08:18.000 | 2790 2790 | 308 308 | 2005-07-14 01:29:18.000 | 2 2 | 2020-12-23 07:16:15 |
| 4285 | 2005-07-07 15:34:35.000 | 511 511 | 308 308 | 2005-07-15 09:43:35.000 | 2 2 | 2020-12-23 07:16:20 |
| 5946 | 2005-07-10 22:57:29.000 | 1629 1629 | 308 308 | 2005-07-12 00:08:29.000 | 1 1 | 2020-12-23 07:16:44 |
| 8869 | 2005-07-30 00:06:32.000 | 4353 4353 | 308 308 | 2005-07-31 20:49:32.000 | 2 2 | 2020-12-23 07:17:27 |
| 9479 | 2005-07-30 23:22:09.000 | 3461 3461 | 308 308 | 2005-07-31 22:26:09.000 | 2 2 | 2020-12-23 07:17:36 |
| 9746 | 2005-07-31 09:16:48.000 | 1459 1459 | 308 308 | 2005-08-07 06:36:48.000 | 2 2 | 2020-12-23 07:17:40 |
| 10571 | 2005-08-01 13:25:30.000 | 3660 3660 | 308 308 | 2005-08-02 16:43:30.000 | 2 2 | 2020-12-23 07:17:52 |
| 10797 | 2005-08-01 22:02:51.000 | 1731 1731 | 308 308 | 2005-08-03 23:07:51.000 | 1 1 | 2020-12-23 07:17:55 |
| 10819 | 2005-08-01 22:52:57.000 | 983 983 | 308 308 | 2005-08-06 00:08:57.000 | 1 1 | 2020-12-23 07:17:55 |
| 11765 | 2005-08-17 09:55:28.000 | 4311 4311 | 308 308 | 2005-08-19 15:53:28.000 | 2 2 | 2020-12-23 07:18:08 |
| 11972 | 2005-08-17 17:55:46.000 | 1282 1282 | 308 308 | 2005-08-22 15:31:46.000 | 2 2 | 2020-12-23 07:18:11 |
| 12567 | 2005-08-18 15:14:36.000 | 2931 2931 | 308 308 | 2005-08-26 18:56:36.000 | 1 1 | 2020-12-23 07:18:19 |
| 12590 | 2005-08-18 16:11:35.000 | 2624 2624 | 308 308 | 2005-08-23 10:35:35.000 | 1 1 | 2020-12-23 07:18:19 |
| 12838 | 2005-08-19 01:51:50.000 | 1207 1207 | 308 308 | 2005-08-27 23:12:50.000 | 1 1 | 2020-12-23 07:18:23 |
| 13843 | 2005-08-20 14:30:01.000 | 3058 3058 | 308 308 | 2005-08-27 10:06:01.000 | 2 2 | 2020-12-23 07:18:38 |
| 14946 | 2005-08-22 06:07:10.000 | 1395 1395 | 308 308 | 2005-08-28 05:25:10.000 | 1 1 | 2020-12-23 07:18:54 |
| 15243 | 2005-08-22 17:48:28.000 | 4408 4408 | 308 308 | 2005-08-31 13:22:28.000 | 1 1 | 2020-12-23 07:18:58 |
| 15493 | 2005-08-23 02:20:53.000 | 3521 3521 | 308 308 | 2005-08-25 23:02:53.000 | 1 1 | 2020-12-23 07:19:02 |
| 15820 | 2005-08-23 15:03:13.000 | 4553 4553 | 308 308 | 2005-08-25 20:12:13.000 | 1 1 | 2020-12-23 07:19:07 |
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) ;