film_actor

25 rows where actor_id = 51

✎ 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
51,5 51 51 AFRICAN EGG 5 2020-12-23 07:14:02
51,63 51 51 BEDAZZLED MARRIED 63 2020-12-23 07:14:02
51,103 51 51 BUCKET BROTHERHOOD 103 2020-12-23 07:14:02
51,112 51 51 CALENDAR GUNFIGHT 112 2020-12-23 07:14:02
51,121 51 51 CAROL TEXAS 121 2020-12-23 07:14:02
51,153 51 51 CITIZEN SHREK 153 2020-12-23 07:14:02
51,395 51 51 HANDICAP BOONDOCK 395 2020-12-23 07:14:02
51,408 51 51 HEAD STRANGER 408 2020-12-23 07:14:02
51,420 51 51 HOLES BRANNIGAN 420 2020-12-23 07:14:02
51,461 51 51 INSECTS STONE 461 2020-12-23 07:14:02
51,490 51 51 JUMANJI BLADE 490 2020-12-23 07:14:02
51,525 51 51 LOATHING LEGALLY 525 2020-12-23 07:14:03
51,627 51 51 NORTH TEQUILA 627 2020-12-23 07:14:03
51,678 51 51 PICKUP DRIVING 678 2020-12-23 07:14:03
51,733 51 51 RIVER OUTLAW 733 2020-12-23 07:14:03
51,734 51 51 ROAD ROXANNE 734 2020-12-23 07:14:03
51,737 51 51 ROCK INSTINCT 737 2020-12-23 07:14:03
51,750 51 51 RUN PACIFIC 750 2020-12-23 07:14:03
51,847 51 51 STOCK GLASS 847 2020-12-23 07:14:03
51,891 51 51 TIMBERLAND SKY 891 2020-12-23 07:14:03
51,895 51 51 TOMORROW HUSTLER 895 2020-12-23 07:14:03
51,940 51 51 VICTORY ACADEMY 940 2020-12-23 07:14:03
51,974 51 51 WILD APOLLO 974 2020-12-23 07:14:03
51,990 51 51 WORLD LEATHERNECKS 990 2020-12-23 07:14:03
51,993 51 51 WRONG BEHAVIOR 993 2020-12-23 07:14:03

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