film_actor

19 rows where actor_id = 63

✎ View and edit SQL

This data as json, xlsx, CSV (advanced)

Suggested facets: last_update (date)

Link actor_id film_id last_update
63,73 63 63 BINGO TALENTED 73 2020-12-23 07:14:07
63,134 63 63 CHAMPION FLATLINERS 134 2020-12-23 07:14:07
63,167 63 63 COMA HEAD 167 2020-12-23 07:14:07
63,208 63 63 DARES PLUTO 208 2020-12-23 07:14:07
63,225 63 63 DESTINATION JERK 225 2020-12-23 07:14:07
63,248 63 63 DOZEN LION 248 2020-12-23 07:14:07
63,249 63 63 DRACULA CRYSTAL 249 2020-12-23 07:14:07
63,278 63 63 ELF MURDER 278 2020-12-23 07:14:07
63,392 63 63 HALL CASSIDY 392 2020-12-23 07:14:07
63,517 63 63 LESSON CLEOPATRA 517 2020-12-23 07:14:07
63,633 63 63 OCTOBER SUBMARINE 633 2020-12-23 07:14:07
63,763 63 63 SATISFACTION CONFIDENTIAL 763 2020-12-23 07:14:07
63,781 63 63 SEVEN SWARM 781 2020-12-23 07:14:07
63,809 63 63 SLIPPER FIDELITY 809 2020-12-23 07:14:07
63,893 63 63 TITANS JERK 893 2020-12-23 07:14:07
63,932 63 63 VALLEY PACKER 932 2020-12-23 07:14:07
63,944 63 63 VIRGIN DAISY 944 2020-12-23 07:14:07
63,945 63 63 VIRGINIAN PLUTO 945 2020-12-23 07:14:07
63,981 63 63 WOLVES DESIRE 981 2020-12-23 07:14:07

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