film_actor

24 rows where actor_id = 100

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update, last_update (date)

Link actor_id film_id last_update
100,17 100 100 ALONE TRIP 17 2020-12-23 07:14:20
100,118 100 100 CANYON STOCK 118 2020-12-23 07:14:20
100,250 100 100 DRAGON SQUAD 250 2020-12-23 07:14:20
100,411 100 100 HEAVENLY GUN 411 2020-12-23 07:14:20
100,414 100 100 HELLFIGHTERS SIERRA 414 2020-12-23 07:14:20
100,513 100 100 LEATHERNECKS DWARFS 513 2020-12-23 07:14:20
100,563 100 100 MASSACRE USUAL 563 2020-12-23 07:14:20
100,642 100 100 ORDER BETRAYED 642 2020-12-23 07:14:20
100,714 100 100 RANDOM GO 714 2020-12-23 07:14:20
100,718 100 100 REBEL AIRPORT 718 2020-12-23 07:14:20
100,759 100 100 SALUTE APOLLO 759 2020-12-23 07:14:20
100,779 100 100 SENSE GREEK 779 2020-12-23 07:14:20
100,815 100 100 SNATCHERS MONTEZUMA 815 2020-12-23 07:14:21
100,846 100 100 STING PERSONAL 846 2020-12-23 07:14:21
100,850 100 100 STORY SIDE 850 2020-12-23 07:14:21
100,872 100 100 SWEET BROTHERHOOD 872 2020-12-23 07:14:21
100,877 100 100 TAXI KICK 877 2020-12-23 07:14:21
100,909 100 100 TREASURE COMMAND 909 2020-12-23 07:14:21
100,919 100 100 TYCOON GATHERING 919 2020-12-23 07:14:21
100,944 100 100 VIRGIN DAISY 944 2020-12-23 07:14:21
100,967 100 100 WEEKEND PERSONAL 967 2020-12-23 07:14:21
100,979 100 100 WITCHES PANIC 979 2020-12-23 07:14:21
100,991 100 100 WORST BANGER 991 2020-12-23 07:14:21
100,992 100 100 WRATH MILE 992 2020-12-23 07:14:21

Advanced export

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

CSV options: 

CREATE TABLE film_actor (
  actor_id INT NOT NULL,
  film_id  INT NOT NULL,
  last_update TIMESTAMP NOT NULL,
  PRIMARY KEY  (actor_id,film_id),
  CONSTRAINT fk_film_actor_actor FOREIGN KEY (actor_id) REFERENCES actor (actor_id) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT fk_film_actor_film FOREIGN KEY (film_id) REFERENCES film (film_id) ON DELETE NO ACTION ON UPDATE CASCADE
);
CREATE INDEX idx_fk_film_actor_film ON film_actor(film_id)
;
CREATE INDEX idx_fk_film_actor_actor ON film_actor(actor_id) 
;