actor
| Documentation | Sakila |
| Name | actor |
| Module | Inventory |
The actor table lists information for all actors.
The actor table is joined to the film table by means of the film_actor table.
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | actor_id | unsigned smallint(5, 0) | Identity / Auto increment column | A surrogate primary key used to uniquely identify each actor in the table. | ||||
| A surrogate primary key used to uniquely identify each actor in the table. Identity / Auto increment column |
||||||||
| 2 | first_name | varchar(45) | The actor's first name. | |||||
| The actor's first name. |
||||||||
| 3 | last_name | varchar(45) | The actor's last name. | |||||
| The actor's last name. |
||||||||
| 4 | last_update | timestamp | Default: CURRENT_TIMESTAMP | The time that the row was created or most recently updated. | ||||
| The time that the row was created or most recently updated. Default: CURRENT_TIMESTAMP |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| film_actor | actor | film_actor.actor_id = actor.actor_id | fk_film_actor_actor Foreign key constraint referencing actor.actor_id |
|
|
film_actor.actor_id = actor.actor_id Name: fk_film_actor_actorForeign key constraint referencing actor.actor_id |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| PRIMARY | actor_id | Primary key. | |
| Primary key. | |||
Used by
| Name |
|---|
|
actor
|
Exported: 2018-10-12 17:43, Last imported: 2018-08-06 10:44