public.film_actor
| Documentation | Pagila |
| Schema | public |
| Name | film_actor |
| Module | Inventory |
Stores the relationships between films and actors
Columns
| Key | Name | Data type | Null | Attributes | References | Description | ||
|---|---|---|---|---|---|---|---|---|
| 1 | actor_id | smallint | public.actor | A foreign key identifying the actor. | ||||
| A foreign key identifying the actor. References: public.actor |
||||||||
| 2 | film_id | smallint | public.film | A foreign key identifying the film. | ||||
| A foreign key identifying the film. References: public.film |
||||||||
| 3 | last_update | timestamp without time zone(6) | Default: now() | The time that the row was created or most recently updated. | ||||
| The time that the row was created or most recently updated. Default: now() |
||||||||
Relations
| Foreign table | Primary table | Join | Title / Name / Description | |
|---|---|---|---|---|
| public.film_actor | public.actor | public.film_actor.actor_id = public.actor.actor_id | film_actor_actor_id_fkey Foreign key constraint referencing actor.actor_id |
|
|
public.film_actor.actor_id = public.actor.actor_id Name: film_actor_actor_id_fkeyForeign key constraint referencing actor.actor_id |
||||
| public.film_actor | public.film | public.film_actor.film_id = public.film.film_id | film_actor_film_id_fkey Foreign key constraint referencing film.film_id |
|
|
public.film_actor.film_id = public.film.film_id Name: film_actor_film_id_fkeyForeign key constraint referencing film.film_id |
||||
Unique keys
| Key name | Columns | Description | |
|---|---|---|---|
| film_actor_pkey | actor_id, film_id | Primary key. | |
| Primary key. | |||
Triggers
| Key name | When | Description | |
|---|---|---|---|
| last_updated | Before Update | The last_updated trigger sets last_update column of table to the current timestamp. | |
| The last_updated trigger sets last_update column of table to the current timestamp. | |||
Uses
| Name |
|---|
|
public.film_actor
|
Used by
| Name |
|---|
|
public.film_actor
|
Exported: 2018-10-12 17:07, Last imported: 2018-08-06 09:25