film_actor

28 rows where actor_id = 79

✎ 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
79,32 79 79 APOCALYPSE FLAMINGOS 32 2020-12-23 07:14:12
79,33 79 79 APOLLO TEEN 33 2020-12-23 07:14:12
79,40 79 79 ARMY FLINTSTONES 40 2020-12-23 07:14:12
79,141 79 79 CHICAGO NORTH 141 2020-12-23 07:14:12
79,205 79 79 DANCES NONE 205 2020-12-23 07:14:12
79,230 79 79 DIARY PANIC 230 2020-12-23 07:14:12
79,242 79 79 DOOM DANCING 242 2020-12-23 07:14:12
79,262 79 79 DUMBO LUST 262 2020-12-23 07:14:12
79,267 79 79 EAGLES PANKY 267 2020-12-23 07:14:12
79,269 79 79 EARRING INSTINCT 269 2020-12-23 07:14:12
79,299 79 79 FACTORY DRAGON 299 2020-12-23 07:14:12
79,367 79 79 GOLDMINE TYCOON 367 2020-12-23 07:14:12
79,428 79 79 HOMICIDE PEACH 428 2020-12-23 07:14:12
79,430 79 79 HOOK CHARIOTS 430 2020-12-23 07:14:12
79,473 79 79 JACKET FRISCO 473 2020-12-23 07:14:12
79,607 79 79 MUPPET MILE 607 2020-12-23 07:14:12
79,628 79 79 NORTHWEST POLISH 628 2020-12-23 07:14:12
79,634 79 79 ODDS BOOGIE 634 2020-12-23 07:14:12
79,646 79 79 OUTBREAK DIVINE 646 2020-12-23 07:14:12
79,727 79 79 RESURRECTION SILVERADO 727 2020-12-23 07:14:12
79,750 79 79 RUN PACIFIC 750 2020-12-23 07:14:12
79,753 79 79 RUSH GOODFELLAS 753 2020-12-23 07:14:12
79,769 79 79 SCHOOL JACKET 769 2020-12-23 07:14:12
79,776 79 79 SECRET GROUNDHOG 776 2020-12-23 07:14:13
79,788 79 79 SHIP WONDERLAND 788 2020-12-23 07:14:13
79,840 79 79 STAMPEDE DISTURBING 840 2020-12-23 07:14:13
79,853 79 79 STRANGER STRANGERS 853 2020-12-23 07:14:13
79,916 79 79 TURN STAR 916 2020-12-23 07:14:13

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