public.categories
Documentation | Dell DVD Store |
Schema | public |
Name | categories |
Module | Dell DVD Store database diagram |
Stores film’s categories.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | category | integer |
Identity / Auto increment column
Default: nextval('categories_category_seq'::regclass) |
Category identification number. Primary key for categories table. | ||||
Category identification number. Primary key for categories table. Identity / Auto increment column Default: nextval('categories_category_seq'::regclass) |
||||||||
2 | categoryname | character varying(50) | The name of the category. | |||||
The name of the category. |
Relations
Foreign table | Primary table | Join | Title / Name / Description | |
---|---|---|---|---|
public.products | public.categories | public.products.category = public.categories.category | fk_products_categories Foreign key constraint referencing categories.category |
|
public.products.category = public.categories.category Name: fk_products_categoriesForeign key constraint referencing categories.category |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
categories_pkey | category | Primary key. | |
Primary key. |
Used by
Name |
---|
public.categories
|
Exported: 2018-11-09 16:14, Last imported: 2018-08-06 09:39