film_actor

5,462 rows

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
1,1 1 1 ACADEMY DINOSAUR 1 2020-12-23 07:13:43
1,23 1 1 ANACONDA CONFESSIONS 23 2020-12-23 07:13:43
1,25 1 1 ANGELS LIFE 25 2020-12-23 07:13:43
1,106 1 1 BULWORTH COMMANDMENTS 106 2020-12-23 07:13:43
1,140 1 1 CHEAPER CLYDE 140 2020-12-23 07:13:43
1,166 1 1 COLOR PHILADELPHIA 166 2020-12-23 07:13:43
1,277 1 1 ELEPHANT TROJAN 277 2020-12-23 07:13:43
1,361 1 1 GLEAMING JAWBREAKER 361 2020-12-23 07:13:43
1,438 1 1 HUMAN GRAFFITI 438 2020-12-23 07:13:43
1,499 1 1 KING EVOLUTION 499 2020-12-23 07:13:43
1,506 1 1 LADY STAGE 506 2020-12-23 07:13:43
1,509 1 1 LANGUAGE COWBOY 509 2020-12-23 07:13:43
1,605 1 1 MULHOLLAND BEAST 605 2020-12-23 07:13:43
1,635 1 1 OKLAHOMA JUMANJI 635 2020-12-23 07:13:43
1,749 1 1 RULES HUMAN 749 2020-12-23 07:13:43
1,832 1 1 SPLASH GUMP 832 2020-12-23 07:13:43
1,939 1 1 VERTIGO NORTHWEST 939 2020-12-23 07:13:43
1,970 1 1 WESTWARD SEABISCUIT 970 2020-12-23 07:13:43
1,980 1 1 WIZARD COLDBLOODED 980 2020-12-23 07:13:43
2,3 2 2 ADAPTATION HOLES 3 2020-12-23 07:13:43
2,31 2 2 APACHE DIVINE 31 2020-12-23 07:13:43
2,47 2 2 BABY HALL 47 2020-12-23 07:13:43
2,105 2 2 BULL SHAWSHANK 105 2020-12-23 07:13:44
2,132 2 2 CHAINSAW UPTOWN 132 2020-12-23 07:13:44
2,145 2 2 CHISUM BEHAVIOR 145 2020-12-23 07:13:44
2,226 2 2 DESTINY SATURDAY 226 2020-12-23 07:13:44
2,249 2 2 DRACULA CRYSTAL 249 2020-12-23 07:13:44
2,314 2 2 FIGHT JAWBREAKER 314 2020-12-23 07:13:44
2,321 2 2 FLASH WARS 321 2020-12-23 07:13:44
2,357 2 2 GILBERT PELICAN 357 2020-12-23 07:13:44
2,369 2 2 GOODFELLAS SALUTE 369 2020-12-23 07:13:44
2,399 2 2 HAPPINESS UNITED 399 2020-12-23 07:13:44
2,458 2 2 INDIAN LOVE 458 2020-12-23 07:13:44
2,481 2 2 JEKYLL FROGMEN 481 2020-12-23 07:13:44
2,485 2 2 JERSEY SASSY 485 2020-12-23 07:13:44
2,518 2 2 LIAISONS SWEET 518 2020-12-23 07:13:44
2,540 2 2 LUCKY FLYING 540 2020-12-23 07:13:44
2,550 2 2 MAGUIRE APACHE 550 2020-12-23 07:13:44
2,555 2 2 MALLRATS UNITED 555 2020-12-23 07:13:44
2,561 2 2 MASK PEACH 561 2020-12-23 07:13:44
2,742 2 2 ROOF CHAMPION 742 2020-12-23 07:13:44
2,754 2 2 RUSHMORE MERMAID 754 2020-12-23 07:13:44
2,811 2 2 SMILE EARRING 811 2020-12-23 07:13:44
2,958 2 2 WARDROBE PHANTOM 958 2020-12-23 07:13:44
3,17 3 3 ALONE TRIP 17 2020-12-23 07:13:44
3,40 3 3 ARMY FLINTSTONES 40 2020-12-23 07:13:44
3,42 3 3 ARTIST COLDBLOODED 42 2020-12-23 07:13:44
3,87 3 3 BOONDOCK BALLROOM 87 2020-12-23 07:13:44
3,111 3 3 CADDYSHACK JEDI 111 2020-12-23 07:13:44
3,185 3 3 COWBOY DOOM 185 2020-12-23 07:13:44

Next page

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