film_actor

32 rows where actor_id = 45

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
45,18 45 45 ALTER VICTORY 18 2020-12-23 07:14:00
45,65 45 45 BEHAVIOR RUNAWAY 65 2020-12-23 07:14:00
45,66 45 45 BENEATH RUSH 66 2020-12-23 07:14:00
45,115 45 45 CAMPUS REMEMBER 115 2020-12-23 07:14:00
45,117 45 45 CANDLES GRAPES 117 2020-12-23 07:14:00
45,164 45 45 COAST RAINBOW 164 2020-12-23 07:14:00
45,187 45 45 CRANES RESERVOIR 187 2020-12-23 07:14:00
45,198 45 45 CRYSTAL BREAKING 198 2020-12-23 07:14:00
45,219 45 45 DEEP CRUSADE 219 2020-12-23 07:14:00
45,330 45 45 FORRESTER COMANCHEROS 330 2020-12-23 07:14:00
45,407 45 45 HAWK CHILL 407 2020-12-23 07:14:00
45,416 45 45 HIGHBALL POTTER 416 2020-12-23 07:14:00
45,463 45 45 INSTINCT AIRPORT 463 2020-12-23 07:14:00
45,467 45 45 INTRIGUE WORST 467 2020-12-23 07:14:00
45,484 45 45 JERK PAYCHECK 484 2020-12-23 07:14:00
45,502 45 45 KNOCK WARLOCK 502 2020-12-23 07:14:00
45,503 45 45 KRAMER CHOCOLATE 503 2020-12-23 07:14:00
45,508 45 45 LAMBS CINCINATTI 508 2020-12-23 07:14:00
45,537 45 45 LOVER TRUMAN 537 2020-12-23 07:14:00
45,680 45 45 PINOCCHIO SIMON 680 2020-12-23 07:14:00
45,714 45 45 RANDOM GO 714 2020-12-23 07:14:00
45,767 45 45 SCALAWAG DUCK 767 2020-12-23 07:14:00
45,778 45 45 SECRETS PARADISE 778 2020-12-23 07:14:00
45,797 45 45 SILENCE KANE 797 2020-12-23 07:14:00
45,810 45 45 SLUMS DUCK 810 2020-12-23 07:14:00
45,895 45 45 TOMORROW HUSTLER 895 2020-12-23 07:14:00
45,900 45 45 TOWN ARK 900 2020-12-23 07:14:00
45,901 45 45 TRACY CIDER 901 2020-12-23 07:14:00
45,920 45 45 UNBREAKABLE KARATE 920 2020-12-23 07:14:00
45,925 45 45 UNITED PILOT 925 2020-12-23 07:14:00
45,975 45 45 WILLOW TRACY 975 2020-12-23 07:14:00
45,978 45 45 WISDOM WORKER 978 2020-12-23 07:14:00

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