film_actor

29 rows where actor_id = 192

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
192,16 192 192 ALLEY EVOLUTION 16 2020-12-23 07:14:55
192,69 192 192 BEVERLY OUTLAW 69 2020-12-23 07:14:55
192,117 192 192 CANDLES GRAPES 117 2020-12-23 07:14:55
192,155 192 192 CLEOPATRA DEVIL 155 2020-12-23 07:14:55
192,166 192 192 COLOR PHILADELPHIA 166 2020-12-23 07:14:55
192,179 192 192 CONQUERER NUTS 179 2020-12-23 07:14:55
192,214 192 192 DAUGHTER MADIGAN 214 2020-12-23 07:14:55
192,361 192 192 GLEAMING JAWBREAKER 361 2020-12-23 07:14:55
192,367 192 192 GOLDMINE TYCOON 367 2020-12-23 07:14:55
192,426 192 192 HOME PITY 426 2020-12-23 07:14:55
192,465 192 192 INTERVIEW LIAISONS 465 2020-12-23 07:14:55
192,470 192 192 ISHTAR ROCKETEER 470 2020-12-23 07:14:55
192,475 192 192 JAPANESE RUN 475 2020-12-23 07:14:55
192,485 192 192 JERSEY SASSY 485 2020-12-23 07:14:55
192,541 192 192 LUKE MUMMY 541 2020-12-23 07:14:55
192,578 192 192 MILLION ACE 578 2020-12-23 07:14:55
192,592 192 192 MONSTER SPARTACUS 592 2020-12-23 07:14:55
192,614 192 192 NAME DETECTIVE 614 2020-12-23 07:14:55
192,618 192 192 NECKLACE OUTBREAK 618 2020-12-23 07:14:55
192,622 192 192 NEWSIES STORY 622 2020-12-23 07:14:55
192,674 192 192 PET HAUNTING 674 2020-12-23 07:14:55
192,677 192 192 PIANIST OUTFIELD 677 2020-12-23 07:14:55
192,680 192 192 PINOCCHIO SIMON 680 2020-12-23 07:14:55
192,682 192 192 PITTSBURGH HUNCHBACK 682 2020-12-23 07:14:55
192,708 192 192 QUILLS BULL 708 2020-12-23 07:14:55
192,711 192 192 RAGING AIRPLANE 711 2020-12-23 07:14:55
192,747 192 192 ROXANNE REBEL 747 2020-12-23 07:14:55
192,763 192 192 SATISFACTION CONFIDENTIAL 763 2020-12-23 07:14:55
192,819 192 192 SONG HEDWIG 819 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) 
;