film_actor

30 rows where actor_id = 53

✎ 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
53,1 53 53 ACADEMY DINOSAUR 1 2020-12-23 07:14:03
53,9 53 53 ALABAMA DEVIL 9 2020-12-23 07:14:03
53,51 53 53 BALLOON HOMEWARD 51 2020-12-23 07:14:03
53,58 53 53 BEACH HEARTBREAKERS 58 2020-12-23 07:14:03
53,109 53 53 BUTTERFLY CHOCOLAT 109 2020-12-23 07:14:03
53,122 53 53 CARRIE BUNCH 122 2020-12-23 07:14:03
53,126 53 53 CASUALTIES ENCINO 126 2020-12-23 07:14:03
53,181 53 53 CONTACT ANONYMOUS 181 2020-12-23 07:14:03
53,256 53 53 DROP WATERFRONT 256 2020-12-23 07:14:03
53,268 53 53 EARLY HOME 268 2020-12-23 07:14:03
53,285 53 53 ENGLISH BULWORTH 285 2020-12-23 07:14:03
53,307 53 53 FELLOWSHIP AUTUMN 307 2020-12-23 07:14:03
53,358 53 53 GILMORE BOILED 358 2020-12-23 07:14:03
53,386 53 53 GUMP DATE 386 2020-12-23 07:14:03
53,447 53 53 ICE CROSSING 447 2020-12-23 07:14:03
53,465 53 53 INTERVIEW LIAISONS 465 2020-12-23 07:14:03
53,490 53 53 JUMANJI BLADE 490 2020-12-23 07:14:03
53,492 53 53 JUNGLE CLOSER 492 2020-12-23 07:14:03
53,508 53 53 LAMBS CINCINATTI 508 2020-12-23 07:14:03
53,518 53 53 LIAISONS SWEET 518 2020-12-23 07:14:03
53,573 53 53 MICROCOSMOS PARADISE 573 2020-12-23 07:14:03
53,576 53 53 MIGHTY LUCK 576 2020-12-23 07:14:03
53,577 53 53 MILE MULAN 577 2020-12-23 07:14:03
53,697 53 53 PRIMARY GLASS 697 2020-12-23 07:14:03
53,725 53 53 REQUIEM TYCOON 725 2020-12-23 07:14:03
53,727 53 53 RESURRECTION SILVERADO 727 2020-12-23 07:14:03
53,937 53 53 VARSITY TRIP 937 2020-12-23 07:14:03
53,947 53 53 VISION TORQUE 947 2020-12-23 07:14:03
53,961 53 53 WASH HEAVENLY 961 2020-12-23 07:14:03
53,980 53 53 WIZARD COLDBLOODED 980 2020-12-23 07:14:04

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