film_actor

27 rows where actor_id = 190

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
190,38 190 190 ARK RIDGEMONT 38 2020-12-23 07:14:54
190,54 190 190 BANGER PINOCCHIO 54 2020-12-23 07:14:54
190,62 190 190 BED HIGHBALL 62 2020-12-23 07:14:54
190,87 190 190 BOONDOCK BALLROOM 87 2020-12-23 07:14:54
190,173 190 190 CONFESSIONS MAGUIRE 173 2020-12-23 07:14:54
190,234 190 190 DISTURBING SCARFACE 234 2020-12-23 07:14:54
190,253 190 190 DRIFTER COMMANDMENTS 253 2020-12-23 07:14:54
190,278 190 190 ELF MURDER 278 2020-12-23 07:14:54
190,310 190 190 FEVER EMPIRE 310 2020-12-23 07:14:54
190,374 190 190 GRAFFITI LOVE 374 2020-12-23 07:14:54
190,411 190 190 HEAVENLY GUN 411 2020-12-23 07:14:54
190,426 190 190 HOME PITY 426 2020-12-23 07:14:54
190,472 190 190 ITALIAN AFRICAN 472 2020-12-23 07:14:54
190,549 190 190 MAGNOLIA FORRESTER 549 2020-12-23 07:14:54
190,562 190 190 MASKED BUBBLE 562 2020-12-23 07:14:54
190,606 190 190 MUMMY CREATURES 606 2020-12-23 07:14:54
190,623 190 190 NEWTON LABYRINTH 623 2020-12-23 07:14:54
190,679 190 190 PILOT HOOSIERS 679 2020-12-23 07:14:54
190,682 190 190 PITTSBURGH HUNCHBACK 682 2020-12-23 07:14:54
190,693 190 190 POTTER CONNECTICUT 693 2020-12-23 07:14:54
190,695 190 190 PRESIDENT BANG 695 2020-12-23 07:14:54
190,705 190 190 PURPLE MOVIE 705 2020-12-23 07:14:54
190,708 190 190 QUILLS BULL 708 2020-12-23 07:14:54
190,802 190 190 SKY MIRACLE 802 2020-12-23 07:14:54
190,806 190 190 SLEEPY JAPANESE 806 2020-12-23 07:14:54
190,874 190 190 TADPOLE PARK 874 2020-12-23 07:14:54
190,959 190 190 WARLOCK WEREWOLF 959 2020-12-23 07:14:54

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