film_actor

30 rows where actor_id = 191

✎ 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
191,16 191 191 ALLEY EVOLUTION 16 2020-12-23 07:14:54
191,39 191 191 ARMAGEDDON LOST 39 2020-12-23 07:14:55
191,84 191 191 BOILED DARES 84 2020-12-23 07:14:55
191,185 191 191 COWBOY DOOM 185 2020-12-23 07:14:55
191,219 191 191 DEEP CRUSADE 219 2020-12-23 07:14:55
191,293 191 191 EXORCIST STING 293 2020-12-23 07:14:55
191,296 191 191 EXPRESS LONELY 296 2020-12-23 07:14:55
191,378 191 191 GREATEST NORTH 378 2020-12-23 07:14:55
191,410 191 191 HEAVEN FREEDOM 410 2020-12-23 07:14:55
191,420 191 191 HOLES BRANNIGAN 420 2020-12-23 07:14:55
191,461 191 191 INSECTS STONE 461 2020-12-23 07:14:55
191,544 191 191 MADISON TRAP 544 2020-12-23 07:14:55
191,551 191 191 MAIDEN HOME 551 2020-12-23 07:14:55
191,596 191 191 MOONSHINE CABIN 596 2020-12-23 07:14:55
191,638 191 191 OPERATION OPERATION 638 2020-12-23 07:14:55
191,668 191 191 PEAK FOREVER 668 2020-12-23 07:14:55
191,692 191 191 POTLUCK MIXED 692 2020-12-23 07:14:55
191,775 191 191 SEATTLE EXPECATIONS 775 2020-12-23 07:14:55
191,801 191 191 SISTER FREDDY 801 2020-12-23 07:14:55
191,819 191 191 SONG HEDWIG 819 2020-12-23 07:14:55
191,827 191 191 SPICE SORORITY 827 2020-12-23 07:14:55
191,830 191 191 SPIRIT FLINTSTONES 830 2020-12-23 07:14:55
191,834 191 191 SPOILERS HELLFIGHTERS 834 2020-12-23 07:14:55
191,849 191 191 STORM HAPPINESS 849 2020-12-23 07:14:55
191,858 191 191 SUBMARINE BED 858 2020-12-23 07:14:55
191,914 191 191 TROUBLE DATE 914 2020-12-23 07:14:55
191,958 191 191 WARDROBE PHANTOM 958 2020-12-23 07:14:55
191,969 191 191 WEST LION 969 2020-12-23 07:14:55
191,971 191 191 WHALE BIKINI 971 2020-12-23 07:14:55
191,993 191 191 WRONG BEHAVIOR 993 2020-12-23 07:14:55

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