film_actor
32 rows where actor_id = 123
This data as json, xlsx, CSV (advanced)
Suggested facets: last_update (date)
| Link | actor_id | film_id | last_update |
|---|---|---|---|
| 123,3 | 123 123 | ADAPTATION HOLES 3 | 2020-12-23 07:14:29 |
| 123,43 | 123 123 | ATLANTIS CAUSE 43 | 2020-12-23 07:14:29 |
| 123,67 | 123 123 | BERETS AGENT 67 | 2020-12-23 07:14:29 |
| 123,105 | 123 123 | BULL SHAWSHANK 105 | 2020-12-23 07:14:29 |
| 123,148 | 123 123 | CHOCOLATE DUCK 148 | 2020-12-23 07:14:29 |
| 123,151 | 123 123 | CINCINATTI WHISPERER 151 | 2020-12-23 07:14:29 |
| 123,185 | 123 123 | COWBOY DOOM 185 | 2020-12-23 07:14:29 |
| 123,223 | 123 123 | DESIRE ALIEN 223 | 2020-12-23 07:14:29 |
| 123,234 | 123 123 | DISTURBING SCARFACE 234 | 2020-12-23 07:14:29 |
| 123,245 | 123 123 | DOUBLE WRATH 245 | 2020-12-23 07:14:29 |
| 123,246 | 123 123 | DOUBTFIRE LABYRINTH 246 | 2020-12-23 07:14:29 |
| 123,266 | 123 123 | DYNAMITE TARZAN 266 | 2020-12-23 07:14:29 |
| 123,286 | 123 123 | ENOUGH RAGING 286 | 2020-12-23 07:14:29 |
| 123,429 | 123 123 | HONEY TIES 429 | 2020-12-23 07:14:29 |
| 123,442 | 123 123 | HUNTING MUSKETEERS 442 | 2020-12-23 07:14:29 |
| 123,446 | 123 123 | HYSTERICAL GRAIL 446 | 2020-12-23 07:14:29 |
| 123,479 | 123 123 | JEDI BENEATH 479 | 2020-12-23 07:14:29 |
| 123,480 | 123 123 | JEEPERS WEDDING 480 | 2020-12-23 07:14:29 |
| 123,494 | 123 123 | KARATE MOON 494 | 2020-12-23 07:14:29 |
| 123,503 | 123 123 | KRAMER CHOCOLATE 503 | 2020-12-23 07:14:29 |
| 123,530 | 123 123 | LORD ARIZONA 530 | 2020-12-23 07:14:29 |
| 123,576 | 123 123 | MIGHTY LUCK 576 | 2020-12-23 07:14:29 |
| 123,577 | 123 123 | MILE MULAN 577 | 2020-12-23 07:14:29 |
| 123,589 | 123 123 | MODERN DORADO 589 | 2020-12-23 07:14:29 |
| 123,593 | 123 123 | MONTEREY LABYRINTH 593 | 2020-12-23 07:14:29 |
| 123,725 | 123 123 | REQUIEM TYCOON 725 | 2020-12-23 07:14:29 |
| 123,730 | 123 123 | RIDGEMONT SUBMARINE 730 | 2020-12-23 07:14:29 |
| 123,786 | 123 123 | SHEPHERD MIDSUMMER 786 | 2020-12-23 07:14:29 |
| 123,860 | 123 123 | SUICIDES SILENCE 860 | 2020-12-23 07:14:29 |
| 123,892 | 123 123 | TITANIC BOONDOCK 892 | 2020-12-23 07:14:29 |
| 123,926 | 123 123 | UNTOUCHABLES SUNRISE 926 | 2020-12-23 07:14:29 |
| 123,988 | 123 123 | WORKER TARZAN 988 | 2020-12-23 07:14:29 |
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) ;