film_actor
19 rows where actor_id = 1
This data as json, xlsx, CSV (advanced)
Suggested facets: last_update (date)
| Link | actor_id | film_id | last_update |
|---|---|---|---|
| 1,1 | 1 1 | ACADEMY DINOSAUR 1 | 2020-12-23 07:13:43 |
| 1,23 | 1 1 | ANACONDA CONFESSIONS 23 | 2020-12-23 07:13:43 |
| 1,25 | 1 1 | ANGELS LIFE 25 | 2020-12-23 07:13:43 |
| 1,106 | 1 1 | BULWORTH COMMANDMENTS 106 | 2020-12-23 07:13:43 |
| 1,140 | 1 1 | CHEAPER CLYDE 140 | 2020-12-23 07:13:43 |
| 1,166 | 1 1 | COLOR PHILADELPHIA 166 | 2020-12-23 07:13:43 |
| 1,277 | 1 1 | ELEPHANT TROJAN 277 | 2020-12-23 07:13:43 |
| 1,361 | 1 1 | GLEAMING JAWBREAKER 361 | 2020-12-23 07:13:43 |
| 1,438 | 1 1 | HUMAN GRAFFITI 438 | 2020-12-23 07:13:43 |
| 1,499 | 1 1 | KING EVOLUTION 499 | 2020-12-23 07:13:43 |
| 1,506 | 1 1 | LADY STAGE 506 | 2020-12-23 07:13:43 |
| 1,509 | 1 1 | LANGUAGE COWBOY 509 | 2020-12-23 07:13:43 |
| 1,605 | 1 1 | MULHOLLAND BEAST 605 | 2020-12-23 07:13:43 |
| 1,635 | 1 1 | OKLAHOMA JUMANJI 635 | 2020-12-23 07:13:43 |
| 1,749 | 1 1 | RULES HUMAN 749 | 2020-12-23 07:13:43 |
| 1,832 | 1 1 | SPLASH GUMP 832 | 2020-12-23 07:13:43 |
| 1,939 | 1 1 | VERTIGO NORTHWEST 939 | 2020-12-23 07:13:43 |
| 1,970 | 1 1 | WESTWARD SEABISCUIT 970 | 2020-12-23 07:13:43 |
| 1,980 | 1 1 | WIZARD COLDBLOODED 980 | 2020-12-23 07:13:43 |
Advanced export
JSON shape: default, array, newline-delimited, object
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) ;