film_actor

30 rows where actor_id = 128

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
128,26 128 128 ANNIE IDENTITY 26 2020-12-23 07:14:31
128,82 128 128 BLOOD ARGONAUTS 82 2020-12-23 07:14:31
128,119 128 128 CAPER MOTIONS 119 2020-12-23 07:14:31
128,168 128 128 COMANCHEROS ENEMY 168 2020-12-23 07:14:31
128,212 128 128 DARN FORRESTER 212 2020-12-23 07:14:31
128,238 128 128 DOCTOR GRAIL 238 2020-12-23 07:14:31
128,299 128 128 FACTORY DRAGON 299 2020-12-23 07:14:31
128,312 128 128 FIDDLER LOST 312 2020-12-23 07:14:31
128,326 128 128 FLYING HOOK 326 2020-12-23 07:14:31
128,336 128 128 FRENCH HOLIDAY 336 2020-12-23 07:14:31
128,345 128 128 GABLES METROPOLIS 345 2020-12-23 07:14:31
128,407 128 128 HAWK CHILL 407 2020-12-23 07:14:31
128,462 128 128 INSIDER ARIZONA 462 2020-12-23 07:14:31
128,485 128 128 JERSEY SASSY 485 2020-12-23 07:14:31
128,516 128 128 LEGEND JEDI 516 2020-12-23 07:14:31
128,564 128 128 MASSAGE IMAGE 564 2020-12-23 07:14:31
128,614 128 128 NAME DETECTIVE 614 2020-12-23 07:14:31
128,650 128 128 PACIFIC AMISTAD 650 2020-12-23 07:14:31
128,665 128 128 PATTON INTERVIEW 665 2020-12-23 07:14:31
128,671 128 128 PERDITION FARGO 671 2020-12-23 07:14:31
128,693 128 128 POTTER CONNECTICUT 693 2020-12-23 07:14:31
128,696 128 128 PRIDE ALAMO 696 2020-12-23 07:14:31
128,759 128 128 SALUTE APOLLO 759 2020-12-23 07:14:31
128,774 128 128 SEARCHERS WAIT 774 2020-12-23 07:14:31
128,814 128 128 SNATCH SLIPPER 814 2020-12-23 07:14:31
128,899 128 128 TOWERS HURRICANE 899 2020-12-23 07:14:31
128,912 128 128 TROJAN TOMORROW 912 2020-12-23 07:14:31
128,944 128 128 VIRGIN DAISY 944 2020-12-23 07:14:31
128,949 128 128 VOLCANO TEXAS 949 2020-12-23 07:14:31
128,965 128 128 WATERSHIP FRONTIER 965 2020-12-23 07:14:31

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