film_actor

21 rows where actor_id = 69

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
69,15 69 69 ALIEN CENTER 15 2020-12-23 07:14:09
69,88 69 69 BORN SPINAL 88 2020-12-23 07:14:09
69,111 69 69 CADDYSHACK JEDI 111 2020-12-23 07:14:09
69,202 69 69 DADDY PITTSBURGH 202 2020-12-23 07:14:09
69,236 69 69 DIVINE RESURRECTION 236 2020-12-23 07:14:09
69,292 69 69 EXCITEMENT EVE 292 2020-12-23 07:14:09
69,300 69 69 FALCON VOLUME 300 2020-12-23 07:14:09
69,306 69 69 FEATHERS METAL 306 2020-12-23 07:14:09
69,374 69 69 GRAFFITI LOVE 374 2020-12-23 07:14:09
69,396 69 69 HANGING DEEP 396 2020-12-23 07:14:09
69,452 69 69 ILLUSION AMELIE 452 2020-12-23 07:14:09
69,466 69 69 INTOLERABLE INTENTIONS 466 2020-12-23 07:14:09
69,529 69 69 LONELY ELEPHANT 529 2020-12-23 07:14:09
69,612 69 69 MUSSOLINI SPOILERS 612 2020-12-23 07:14:09
69,720 69 69 REDEMPTION COMFORTS 720 2020-12-23 07:14:09
69,722 69 69 REEF SALUTE 722 2020-12-23 07:14:09
69,761 69 69 SANTA PARIS 761 2020-12-23 07:14:09
69,791 69 69 SHOW LORD 791 2020-12-23 07:14:09
69,864 69 69 SUNDANCE INVASION 864 2020-12-23 07:14:09
69,877 69 69 TAXI KICK 877 2020-12-23 07:14:09
69,914 69 69 TROUBLE DATE 914 2020-12-23 07:14:09

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