film_actor

30 rows where actor_id = 103

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
103,5 103 103 AFRICAN EGG 5 2020-12-23 07:14:22
103,118 103 103 CANYON STOCK 118 2020-12-23 07:14:22
103,130 103 103 CELEBRITY HORN 130 2020-12-23 07:14:22
103,197 103 103 CRUSADE HONEY 197 2020-12-23 07:14:22
103,199 103 103 CUPBOARD SINNERS 199 2020-12-23 07:14:22
103,206 103 103 DANCING FEVER 206 2020-12-23 07:14:22
103,215 103 103 DAWN POND 215 2020-12-23 07:14:22
103,221 103 103 DELIVERANCE MULHOLLAND 221 2020-12-23 07:14:22
103,271 103 103 EASY GLADIATOR 271 2020-12-23 07:14:22
103,285 103 103 ENGLISH BULWORTH 285 2020-12-23 07:14:22
103,315 103 103 FINDING ANACONDA 315 2020-12-23 07:14:22
103,318 103 103 FIREHOUSE VIETNAM 318 2020-12-23 07:14:22
103,333 103 103 FREAKY POCUS 333 2020-12-23 07:14:22
103,347 103 103 GAMES BOWFINGER 347 2020-12-23 07:14:22
103,356 103 103 GIANT TROOPERS 356 2020-12-23 07:14:22
103,360 103 103 GLASS DYING 360 2020-12-23 07:14:22
103,378 103 103 GREATEST NORTH 378 2020-12-23 07:14:22
103,437 103 103 HOUSE DYNAMITE 437 2020-12-23 07:14:22
103,585 103 103 MOB DUFFEL 585 2020-12-23 07:14:22
103,609 103 103 MUSCLE BRIGHT 609 2020-12-23 07:14:22
103,639 103 103 OPPOSITE NECKLACE 639 2020-12-23 07:14:22
103,643 103 103 ORIENT CLOSER 643 2020-12-23 07:14:22
103,692 103 103 POTLUCK MIXED 692 2020-12-23 07:14:22
103,735 103 103 ROBBERS JOON 735 2020-12-23 07:14:22
103,822 103 103 SOUP WISDOM 822 2020-12-23 07:14:22
103,895 103 103 TOMORROW HUSTLER 895 2020-12-23 07:14:22
103,903 103 103 TRAFFIC HOBBIT 903 2020-12-23 07:14:22
103,912 103 103 TROJAN TOMORROW 912 2020-12-23 07:14:22
103,942 103 103 VIETNAM SMOOCHY 942 2020-12-23 07:14:22
103,956 103 103 WANDA CHAMBER 956 2020-12-23 07:14:22

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