public.film_category
Documentation | Pagila |
Schema | public |
Name | film_category |
Module | Inventory |
Stores the relationships between films and categories
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | film_id | smallint | public.film | A foreign key identifying the film. | ||||
A foreign key identifying the film. References: public.film |
||||||||
2 | category_id | smallint | public.category | A foreign key identifying the category. | ||||
A foreign key identifying the category. References: public.category |
||||||||
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_category | public.category | public.film_category.category_id = public.category.category_id | film_category_category_id_fkey Foreign key constraint referencing category.category_id |
|
public.film_category.category_id = public.category.category_id Name: film_category_category_id_fkeyForeign key constraint referencing category.category_id |
||||
public.film_category | public.film | public.film_category.film_id = public.film.film_id | film_category_film_id_fkey Foreign key constraint referencing film.film_id |
|
public.film_category.film_id = public.film.film_id Name: film_category_film_id_fkeyForeign key constraint referencing film.film_id |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
film_category_pkey | film_id, category_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_category
|
Used by
Name |
---|
public.film_category
|
Exported: 2018-10-12 17:07, Last imported: 2018-08-06 09:25