inventory

4,581 rows

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: store_id, last_update (date)

inventory_id ▼ film_id store_id last_update
1 ACADEMY DINOSAUR 1 1 1 2020-12-23 07:12:45
2 ACADEMY DINOSAUR 1 1 1 2020-12-23 07:12:45
3 ACADEMY DINOSAUR 1 1 1 2020-12-23 07:12:45
4 ACADEMY DINOSAUR 1 1 1 2020-12-23 07:12:45
5 ACADEMY DINOSAUR 1 2 2 2020-12-23 07:12:45
6 ACADEMY DINOSAUR 1 2 2 2020-12-23 07:12:45
7 ACADEMY DINOSAUR 1 2 2 2020-12-23 07:12:45
8 ACADEMY DINOSAUR 1 2 2 2020-12-23 07:12:45
9 ACE GOLDFINGER 2 2 2 2020-12-23 07:12:45
10 ACE GOLDFINGER 2 2 2 2020-12-23 07:12:45
11 ACE GOLDFINGER 2 2 2 2020-12-23 07:12:45
12 ADAPTATION HOLES 3 2 2 2020-12-23 07:12:45
13 ADAPTATION HOLES 3 2 2 2020-12-23 07:12:45
14 ADAPTATION HOLES 3 2 2 2020-12-23 07:12:45
15 ADAPTATION HOLES 3 2 2 2020-12-23 07:12:45
16 AFFAIR PREJUDICE 4 1 1 2020-12-23 07:12:45
17 AFFAIR PREJUDICE 4 1 1 2020-12-23 07:12:45
18 AFFAIR PREJUDICE 4 1 1 2020-12-23 07:12:45
19 AFFAIR PREJUDICE 4 1 1 2020-12-23 07:12:45
20 AFFAIR PREJUDICE 4 2 2 2020-12-23 07:12:45
21 AFFAIR PREJUDICE 4 2 2 2020-12-23 07:12:45
22 AFFAIR PREJUDICE 4 2 2 2020-12-23 07:12:45
23 AFRICAN EGG 5 2 2 2020-12-23 07:12:45
24 AFRICAN EGG 5 2 2 2020-12-23 07:12:45
25 AFRICAN EGG 5 2 2 2020-12-23 07:12:45
26 AGENT TRUMAN 6 1 1 2020-12-23 07:12:45
27 AGENT TRUMAN 6 1 1 2020-12-23 07:12:45
28 AGENT TRUMAN 6 1 1 2020-12-23 07:12:45
29 AGENT TRUMAN 6 2 2 2020-12-23 07:12:45
30 AGENT TRUMAN 6 2 2 2020-12-23 07:12:45
31 AGENT TRUMAN 6 2 2 2020-12-23 07:12:45
32 AIRPLANE SIERRA 7 1 1 2020-12-23 07:12:45
33 AIRPLANE SIERRA 7 1 1 2020-12-23 07:12:45
34 AIRPLANE SIERRA 7 2 2 2020-12-23 07:12:45
35 AIRPLANE SIERRA 7 2 2 2020-12-23 07:12:45
36 AIRPLANE SIERRA 7 2 2 2020-12-23 07:12:45
37 AIRPORT POLLOCK 8 2 2 2020-12-23 07:12:45
38 AIRPORT POLLOCK 8 2 2 2020-12-23 07:12:45
39 AIRPORT POLLOCK 8 2 2 2020-12-23 07:12:45
40 AIRPORT POLLOCK 8 2 2 2020-12-23 07:12:45
41 ALABAMA DEVIL 9 1 1 2020-12-23 07:12:45
42 ALABAMA DEVIL 9 1 1 2020-12-23 07:12:45
43 ALABAMA DEVIL 9 1 1 2020-12-23 07:12:45
44 ALABAMA DEVIL 9 2 2 2020-12-23 07:12:45
45 ALABAMA DEVIL 9 2 2 2020-12-23 07:12:45
46 ALADDIN CALENDAR 10 1 1 2020-12-23 07:12:45
47 ALADDIN CALENDAR 10 1 1 2020-12-23 07:12:45
48 ALADDIN CALENDAR 10 1 1 2020-12-23 07:12:45
49 ALADDIN CALENDAR 10 1 1 2020-12-23 07:12:45
50 ALADDIN CALENDAR 10 2 2 2020-12-23 07:12:45

Next page

Advanced export

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

CSV options: 

CREATE TABLE inventory (
  inventory_id INT NOT NULL,
  film_id INT NOT NULL,
  store_id INT NOT NULL,
  last_update TIMESTAMP NOT NULL,
  PRIMARY KEY  (inventory_id),
  CONSTRAINT fk_inventory_store FOREIGN KEY (store_id) REFERENCES store (store_id) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT fk_inventory_film FOREIGN KEY (film_id) REFERENCES film (film_id) ON DELETE NO ACTION ON UPDATE CASCADE
);
CREATE INDEX idx_fk_film_id ON inventory(film_id)
;
CREATE INDEX idx_fk_film_id_store_id ON inventory(store_id,film_id)
;