film_actor

25 rows where actor_id = 114

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
114,13 114 114 ALI FOREVER 13 2020-12-23 07:14:26
114,68 114 114 BETRAYED REAR 68 2020-12-23 07:14:26
114,90 114 114 BOULEVARD MOB 90 2020-12-23 07:14:26
114,162 114 114 CLUELESS BUCKET 162 2020-12-23 07:14:26
114,188 114 114 CRAZY HOME 188 2020-12-23 07:14:26
114,194 114 114 CROW GREASE 194 2020-12-23 07:14:26
114,210 114 114 DARKO DORADO 210 2020-12-23 07:14:26
114,237 114 114 DIVORCE SHINING 237 2020-12-23 07:14:26
114,254 114 114 DRIVER ANNIE 254 2020-12-23 07:14:26
114,305 114 114 FATAL HAUNTED 305 2020-12-23 07:14:26
114,339 114 114 FROGMEN BREAKING 339 2020-12-23 07:14:26
114,420 114 114 HOLES BRANNIGAN 420 2020-12-23 07:14:26
114,425 114 114 HOLY TADPOLE 425 2020-12-23 07:14:26
114,452 114 114 ILLUSION AMELIE 452 2020-12-23 07:14:26
114,538 114 114 LOVERBOY ATTACKS 538 2020-12-23 07:14:26
114,619 114 114 NEIGHBORS CHARADE 619 2020-12-23 07:14:26
114,757 114 114 SAGEBRUSH CLUELESS 757 2020-12-23 07:14:26
114,807 114 114 SLEUTH ORIENT 807 2020-12-23 07:14:26
114,827 114 114 SPICE SORORITY 827 2020-12-23 07:14:26
114,841 114 114 STAR OPERATION 841 2020-12-23 07:14:26
114,861 114 114 SUIT WALLS 861 2020-12-23 07:14:26
114,866 114 114 SUNSET RACER 866 2020-12-23 07:14:26
114,913 114 114 TROOPERS METAL 913 2020-12-23 07:14:26
114,961 114 114 WASH HEAVENLY 961 2020-12-23 07:14:26
114,993 114 114 WRONG BEHAVIOR 993 2020-12-23 07:14:26

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