film_actor

25 rows where actor_id = 2

✎ 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
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

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