Table actor
This table lists information for all actors. The table is joined to the film table by means of the film_actor table.
Schema
This table belongs to schema sakila.
Columns
This table contains 4 columns.
actor_id
-
smallint
·NOT NULL
A surrogate primary key used to uniquely identify each actor in the table.
first_name
-
character varying(45)
·NOT NULL
The actor first name.
last_name
-
character varying(45)
·NOT NULL
The actor last name.
last_update
-
timestamp(0) without time zone
·NOT NULL
·CURRENT_TIMESTAMP
When 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_pkey
-
actor_id
idx_actor_last_name
-
last_name