film_actor

23 rows where actor_id = 96

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
96,8 96 96 AIRPORT POLLOCK 8 2020-12-23 07:14:19
96,36 96 96 ARGONAUTS TOWN 36 2020-12-23 07:14:19
96,40 96 96 ARMY FLINTSTONES 40 2020-12-23 07:14:19
96,54 96 96 BANGER PINOCCHIO 54 2020-12-23 07:14:19
96,58 96 96 BEACH HEARTBREAKERS 58 2020-12-23 07:14:19
96,66 96 96 BENEATH RUSH 66 2020-12-23 07:14:19
96,134 96 96 CHAMPION FLATLINERS 134 2020-12-23 07:14:19
96,209 96 96 DARKNESS WAR 209 2020-12-23 07:14:19
96,244 96 96 DORADO NOTTING 244 2020-12-23 07:14:19
96,320 96 96 FLAMINGOS CONNECTICUT 320 2020-12-23 07:14:19
96,430 96 96 HOOK CHARIOTS 430 2020-12-23 07:14:19
96,452 96 96 ILLUSION AMELIE 452 2020-12-23 07:14:19
96,486 96 96 JET NEIGHBORS 486 2020-12-23 07:14:19
96,572 96 96 METROPOLIS COMA 572 2020-12-23 07:14:19
96,590 96 96 MONEY HAROLD 590 2020-12-23 07:14:19
96,661 96 96 PAST SUICIDES 661 2020-12-23 07:14:19
96,778 96 96 SECRETS PARADISE 778 2020-12-23 07:14:19
96,832 96 96 SPLASH GUMP 832 2020-12-23 07:14:19
96,846 96 96 STING PERSONAL 846 2020-12-23 07:14:19
96,874 96 96 TADPOLE PARK 874 2020-12-23 07:14:19
96,945 96 96 VIRGINIAN PLUTO 945 2020-12-23 07:14:19
96,968 96 96 WEREWOLF LOLA 968 2020-12-23 07:14:19
96,987 96 96 WORDS HUNTER 987 2020-12-23 07:14:19

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