film_actor

26 rows where actor_id = 124

✎ 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
124,22 124 124 AMISTAD MIDSUMMER 22 2020-12-23 07:14:29
124,64 124 124 BEETHOVEN EXORCIST 64 2020-12-23 07:14:29
124,106 124 124 BULWORTH COMMANDMENTS 106 2020-12-23 07:14:29
124,113 124 124 CALIFORNIA BIRDS 113 2020-12-23 07:14:29
124,190 124 124 CREEPERS KANE 190 2020-12-23 07:14:29
124,246 124 124 DOUBTFIRE LABYRINTH 246 2020-12-23 07:14:29
124,260 124 124 DUDE BLINDNESS 260 2020-12-23 07:14:29
124,263 124 124 DURHAM PANKY 263 2020-12-23 07:14:29
124,289 124 124 EVE RESURRECTION 289 2020-12-23 07:14:29
124,306 124 124 FEATHERS METAL 306 2020-12-23 07:14:29
124,312 124 124 FIDDLER LOST 312 2020-12-23 07:14:29
124,322 124 124 FLATLINERS KILLER 322 2020-12-23 07:14:29
124,343 124 124 FULL FLATLINERS 343 2020-12-23 07:14:29
124,449 124 124 IDENTITY LOVER 449 2020-12-23 07:14:29
124,468 124 124 INVASION CYCLONE 468 2020-12-23 07:14:29
124,539 124 124 LUCK OPUS 539 2020-12-23 07:14:29
124,601 124 124 MOULIN WAKE 601 2020-12-23 07:14:29
124,726 124 124 RESERVOIR ADAPTATION 726 2020-12-23 07:14:29
124,742 124 124 ROOF CHAMPION 742 2020-12-23 07:14:29
124,775 124 124 SEATTLE EXPECATIONS 775 2020-12-23 07:14:29
124,785 124 124 SHAWSHANK BUBBLE 785 2020-12-23 07:14:29
124,814 124 124 SNATCH SLIPPER 814 2020-12-23 07:14:29
124,858 124 124 SUBMARINE BED 858 2020-12-23 07:14:30
124,882 124 124 TENENBAUMS COMMAND 882 2020-12-23 07:14:30
124,987 124 124 WORDS HUNTER 987 2020-12-23 07:14:30
124,997 124 124 YOUTH KICK 997 2020-12-23 07:14:30

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