film_actor

28 rows where actor_id = 80

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
80,69 80 80 BEVERLY OUTLAW 69 2020-12-23 07:14:13
80,118 80 80 CANYON STOCK 118 2020-12-23 07:14:13
80,124 80 80 CASPER DRAGONFLY 124 2020-12-23 07:14:13
80,175 80 80 CONFUSED CANDLES 175 2020-12-23 07:14:13
80,207 80 80 DANGEROUS UPTOWN 207 2020-12-23 07:14:13
80,212 80 80 DARN FORRESTER 212 2020-12-23 07:14:13
80,260 80 80 DUDE BLINDNESS 260 2020-12-23 07:14:13
80,262 80 80 DUMBO LUST 262 2020-12-23 07:14:13
80,280 80 80 EMPIRE MALKOVICH 280 2020-12-23 07:14:13
80,341 80 80 FROST HEAD 341 2020-12-23 07:14:13
80,342 80 80 FUGITIVE MAGUIRE 342 2020-12-23 07:14:13
80,343 80 80 FULL FLATLINERS 343 2020-12-23 07:14:13
80,362 80 80 GLORY TRACY 362 2020-12-23 07:14:13
80,436 80 80 HOURS RAGE 436 2020-12-23 07:14:13
80,475 80 80 JAPANESE RUN 475 2020-12-23 07:14:13
80,553 80 80 MAKER GABLES 553 2020-12-23 07:14:13
80,619 80 80 NEIGHBORS CHARADE 619 2020-12-23 07:14:13
80,622 80 80 NEWSIES STORY 622 2020-12-23 07:14:13
80,680 80 80 PINOCCHIO SIMON 680 2020-12-23 07:14:13
80,687 80 80 POCUS PULP 687 2020-12-23 07:14:13
80,688 80 80 POLISH BROOKLYN 688 2020-12-23 07:14:13
80,709 80 80 RACER EGG 709 2020-12-23 07:14:13
80,788 80 80 SHIP WONDERLAND 788 2020-12-23 07:14:13
80,807 80 80 SLEUTH ORIENT 807 2020-12-23 07:14:13
80,858 80 80 SUBMARINE BED 858 2020-12-23 07:14:13
80,888 80 80 THIN SAGEBRUSH 888 2020-12-23 07:14:13
80,941 80 80 VIDEOTAPE ARSENIC 941 2020-12-23 07:14:13
80,979 80 80 WITCHES PANIC 979 2020-12-23 07:14:13

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