film_actor

23 rows where actor_id = 193

✎ 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
193,44 193 193 ATTACKS HATE 44 2020-12-23 07:14:55
193,80 193 193 BLANKET BEVERLY 80 2020-12-23 07:14:55
193,103 193 193 BUCKET BROTHERHOOD 103 2020-12-23 07:14:55
193,109 193 193 BUTTERFLY CHOCOLAT 109 2020-12-23 07:14:55
193,119 193 193 CAPER MOTIONS 119 2020-12-23 07:14:55
193,141 193 193 CHICAGO NORTH 141 2020-12-23 07:14:55
193,164 193 193 COAST RAINBOW 164 2020-12-23 07:14:55
193,291 193 193 EVOLUTION ALTER 291 2020-12-23 07:14:55
193,352 193 193 GATHERING CALENDAR 352 2020-12-23 07:14:55
193,358 193 193 GILMORE BOILED 358 2020-12-23 07:14:55
193,376 193 193 GRAPES FURY 376 2020-12-23 07:14:55
193,412 193 193 HEAVYWEIGHTS BEAST 412 2020-12-23 07:14:55
193,462 193 193 INSIDER ARIZONA 462 2020-12-23 07:14:55
193,689 193 193 POLLOCK DELIVERANCE 689 2020-12-23 07:14:55
193,709 193 193 RACER EGG 709 2020-12-23 07:14:55
193,745 193 193 ROSES TREASURE 745 2020-12-23 07:14:55
193,807 193 193 SLEUTH ORIENT 807 2020-12-23 07:14:55
193,828 193 193 SPIKING ELEMENT 828 2020-12-23 07:14:55
193,834 193 193 SPOILERS HELLFIGHTERS 834 2020-12-23 07:14:55
193,851 193 193 STRAIGHT HOURS 851 2020-12-23 07:14:55
193,937 193 193 VARSITY TRIP 937 2020-12-23 07:14:56
193,953 193 193 WAIT CIDER 953 2020-12-23 07:14:56
193,960 193 193 WARS PLUTO 960 2020-12-23 07:14:56

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