film_actor

27 rows where actor_id = 16

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
16,80 16 16 BLANKET BEVERLY 80 2020-12-23 07:13:49
16,87 16 16 BOONDOCK BALLROOM 87 2020-12-23 07:13:49
16,101 16 16 BROTHERHOOD BLANKET 101 2020-12-23 07:13:49
16,121 16 16 CAROL TEXAS 121 2020-12-23 07:13:49
16,155 16 16 CLEOPATRA DEVIL 155 2020-12-23 07:13:49
16,177 16 16 CONNECTICUT TRAMP 177 2020-12-23 07:13:49
16,218 16 16 DECEIVER BETRAYED 218 2020-12-23 07:13:49
16,221 16 16 DELIVERANCE MULHOLLAND 221 2020-12-23 07:13:49
16,267 16 16 EAGLES PANKY 267 2020-12-23 07:13:49
16,269 16 16 EARRING INSTINCT 269 2020-12-23 07:13:49
16,271 16 16 EASY GLADIATOR 271 2020-12-23 07:13:49
16,280 16 16 EMPIRE MALKOVICH 280 2020-12-23 07:13:49
16,287 16 16 ENTRAPMENT SATISFACTION 287 2020-12-23 07:13:49
16,345 16 16 GABLES METROPOLIS 345 2020-12-23 07:13:49
16,438 16 16 HUMAN GRAFFITI 438 2020-12-23 07:13:49
16,453 16 16 IMAGE PRINCESS 453 2020-12-23 07:13:49
16,455 16 16 IMPOSSIBLE PREJUDICE 455 2020-12-23 07:13:49
16,456 16 16 INCH JET 456 2020-12-23 07:13:49
16,503 16 16 KRAMER CHOCOLATE 503 2020-12-23 07:13:49
16,548 16 16 MAGNIFICENT CHITTY 548 2020-12-23 07:13:49
16,582 16 16 MIRACLE VIRTUAL 582 2020-12-23 07:13:49
16,583 16 16 MISSION ZOOLANDER 583 2020-12-23 07:13:49
16,717 16 16 REAR TRADING 717 2020-12-23 07:13:49
16,758 16 16 SAINTS BRIDE 758 2020-12-23 07:13:49
16,779 16 16 SENSE GREEK 779 2020-12-23 07:13:49
16,886 16 16 THEORY MERMAID 886 2020-12-23 07:13:49
16,967 16 16 WEEKEND PERSONAL 967 2020-12-23 07:13:49

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