rental

27 rows where customer_id = 190

✎ View and edit SQL

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
430 2005-05-27 16:22:10.000 1920 1920 190 190 2005-06-05 13:10:10.000 1 1 2020-12-23 07:15:25
693 2005-05-29 01:42:31.000 635 635 190 190 2005-06-03 02:29:31.000 2 2 2020-12-23 07:15:29
1319 2005-06-15 10:39:05.000 4296 4296 190 190 2005-06-18 05:25:05.000 1 1 2020-12-23 07:15:37
1347 2005-06-15 12:43:43.000 374 374 190 190 2005-06-16 09:55:43.000 1 1 2020-12-23 07:15:38
2057 2005-06-17 15:31:58.000 2803 2803 190 190 2005-06-25 09:39:58.000 1 1 2020-12-23 07:15:48
2568 2005-06-19 04:09:03.000 3032 3032 190 190 2005-06-24 23:24:03.000 1 1 2020-12-23 07:15:55
3386 2005-06-21 14:21:06.000 1224 1224 190 190 2005-06-24 08:32:06.000 2 2 2020-12-23 07:16:06
4005 2005-07-07 00:22:26.000 3677 3677 190 190 2005-07-15 04:34:26.000 2 2 2020-12-23 07:16:16
4140 2005-07-07 08:19:10.000 1897 1897 190 190 2005-07-14 07:27:10.000 2 2 2020-12-23 07:16:18
6867 2005-07-12 20:06:47.000 3354 3354 190 190 2005-07-19 16:59:47.000 1 1 2020-12-23 07:16:58
7175 2005-07-27 08:03:22.000 568 568 190 190 2005-08-01 02:47:22.000 2 2 2020-12-23 07:17:02
7386 2005-07-27 15:52:10.000 3569 3569 190 190 2005-08-04 15:13:10.000 1 1 2020-12-23 07:17:05
7404 2005-07-27 16:24:43.000 2359 2359 190 190 2005-07-29 11:40:43.000 2 2 2020-12-23 07:17:06
8498 2005-07-29 09:07:38.000 4468 4468 190 190 2005-08-04 07:01:38.000 1 1 2020-12-23 07:17:22
11082 2005-08-02 07:30:19.000 3037 3037 190 190 2005-08-07 05:20:19.000 2 2 2020-12-23 07:17:59
11158 2005-08-02 09:58:28.000 530 530 190 190 2005-08-10 13:54:28.000 2 2 2020-12-23 07:18:00
11276 2005-08-02 14:28:46.000 4226 4226 190 190 2005-08-04 14:00:46.000 1 1 2020-12-23 07:18:01
11312 2005-08-02 15:56:51.000 1093 1093 190 190 2005-08-07 20:56:51.000 2 2 2020-12-23 07:18:02
11750 2005-08-17 09:07:00.000 665 665 190 190 2005-08-23 08:16:00.000 2 2 2020-12-23 07:18:08
11950 2005-08-17 17:13:16.000 4412 4412 190 190 2005-08-26 21:25:16.000 1 1 2020-12-23 07:18:11
12270 2005-08-18 04:32:05.000 2456 2456 190 190 2005-08-21 01:37:05.000 2 2 2020-12-23 07:18:15
12381 2005-08-18 08:31:43.000 3651 3651 190 190 2005-08-23 12:24:43.000 2 2 2020-12-23 07:18:16
14065 2005-08-20 22:40:47.000 3758 3758 190 190 2005-08-24 01:47:47.000 1 1 2020-12-23 07:18:42
14141 2005-08-21 02:07:22.000 4527 4527 190 190 2005-08-30 07:32:22.000 1 1 2020-12-23 07:18:43
14166 2005-08-21 02:59:31.000 2457 2457 190 190 2005-08-24 23:19:31.000 2 2 2020-12-23 07:18:43
14650 2005-08-21 19:24:51.000 1274 1274 190 190 2005-08-25 13:58:51.000 2 2 2020-12-23 07:18:50
15167 2006-02-14 15:16:03.000 973 973 190 190   2 2 2020-12-23 07:18:57

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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)
;