film_actor

24 rows where actor_id = 182

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update, last_update (date)

Link actor_id film_id last_update
182,33 182 182 APOLLO TEEN 33 2020-12-23 07:14:51
182,160 182 182 CLUB GRAFFITI 160 2020-12-23 07:14:51
182,301 182 182 FAMILY SWEET 301 2020-12-23 07:14:51
182,324 182 182 FLINTSTONES HAPPINESS 324 2020-12-23 07:14:51
182,346 182 182 GALAXY SWEETHEARTS 346 2020-12-23 07:14:51
182,362 182 182 GLORY TRACY 362 2020-12-23 07:14:51
182,391 182 182 HALF OUTFIELD 391 2020-12-23 07:14:51
182,413 182 182 HEDWIG ALTER 413 2020-12-23 07:14:51
182,421 182 182 HOLIDAY GAMES 421 2020-12-23 07:14:51
182,437 182 182 HOUSE DYNAMITE 437 2020-12-23 07:14:51
182,590 182 182 MONEY HAROLD 590 2020-12-23 07:14:51
182,639 182 182 OPPOSITE NECKLACE 639 2020-12-23 07:14:51
182,668 182 182 PEAK FOREVER 668 2020-12-23 07:14:51
182,677 182 182 PIANIST OUTFIELD 677 2020-12-23 07:14:51
182,679 182 182 PILOT HOOSIERS 679 2020-12-23 07:14:51
182,695 182 182 PRESIDENT BANG 695 2020-12-23 07:14:52
182,714 182 182 RANDOM GO 714 2020-12-23 07:14:52
182,720 182 182 REDEMPTION COMFORTS 720 2020-12-23 07:14:52
182,819 182 182 SONG HEDWIG 819 2020-12-23 07:14:52
182,828 182 182 SPIKING ELEMENT 828 2020-12-23 07:14:52
182,845 182 182 STEPMOM DREAM 845 2020-12-23 07:14:52
182,864 182 182 SUNDANCE INVASION 864 2020-12-23 07:14:52
182,940 182 182 VICTORY ACADEMY 940 2020-12-23 07:14:52
182,990 182 182 WORLD LEATHERNECKS 990 2020-12-23 07:14:52

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