Table ACTOR
This table lists information for all actors. The table is joined to the FILM table by means of the FILM_ACTOR table.
Columns
This table contains 4 columns.
ACTOR_ID-
INTEGER·NOT NULLA surrogate primary key used to uniquely identify each actor in the table.
FIRST_NAME-
VARCHAR(45)·NOT NULLThe actor first name.
LAST_NAME-
VARCHAR(45)·NOT NULLThe actor last name.
LAST_UPDATE-
TIMESTAMP·NOT NULL·DEFAULT CURRENT_TIMESTAMPWhen the row was created or most recently updated.
Primary key
This table has a primary key.
ACTOR-
ACTOR_ID
Indices
This table has 2 indices.
ACTOR_IDX_LAST_NAME-
LAST_NAME RDB$PRIMARY1-
ACTOR_ID