film_actor

28 rows where actor_id = 141

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
141,43 141 141 ATLANTIS CAUSE 43 2020-12-23 07:14:36
141,67 141 141 BERETS AGENT 67 2020-12-23 07:14:36
141,188 141 141 CRAZY HOME 188 2020-12-23 07:14:36
141,191 141 141 CROOKED FROGMEN 191 2020-12-23 07:14:36
141,207 141 141 DANGEROUS UPTOWN 207 2020-12-23 07:14:36
141,223 141 141 DESIRE ALIEN 223 2020-12-23 07:14:36
141,341 141 141 FROST HEAD 341 2020-12-23 07:14:36
141,358 141 141 GILMORE BOILED 358 2020-12-23 07:14:36
141,380 141 141 GREEK EVERYONE 380 2020-12-23 07:14:36
141,395 141 141 HANDICAP BOONDOCK 395 2020-12-23 07:14:36
141,467 141 141 INTRIGUE WORST 467 2020-12-23 07:14:36
141,491 141 141 JUMPING WRATH 491 2020-12-23 07:14:36
141,589 141 141 MODERN DORADO 589 2020-12-23 07:14:36
141,607 141 141 MUPPET MILE 607 2020-12-23 07:14:36
141,673 141 141 PERSONAL LADYBUGS 673 2020-12-23 07:14:36
141,740 141 141 ROLLERCOASTER BRINGING 740 2020-12-23 07:14:36
141,752 141 141 RUNNER MADIGAN 752 2020-12-23 07:14:36
141,768 141 141 SCARFACE BANG 768 2020-12-23 07:14:36
141,772 141 141 SEA VIRGIN 772 2020-12-23 07:14:36
141,787 141 141 SHINING ROSES 787 2020-12-23 07:14:36
141,821 141 141 SORORITY QUEEN 821 2020-12-23 07:14:36
141,829 141 141 SPINAL ROCKY 829 2020-12-23 07:14:36
141,840 141 141 STAMPEDE DISTURBING 840 2020-12-23 07:14:36
141,849 141 141 STORM HAPPINESS 849 2020-12-23 07:14:36
141,862 141 141 SUMMER SCARFACE 862 2020-12-23 07:14:36
141,863 141 141 SUN CONFESSIONS 863 2020-12-23 07:14:36
141,909 141 141 TREASURE COMMAND 909 2020-12-23 07:14:36
141,992 141 141 WRATH MILE 992 2020-12-23 07:14:36

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