public.products
Documentation | Dell DVD Store |
Schema | public |
Name | products |
Module | Dell DVD Store database diagram |
Stores product data.
Columns
Key | Name | Data type | Null | Attributes | References | Description | ||
---|---|---|---|---|---|---|---|---|
1 | prod_id | integer |
Identity / Auto increment column
Default: nextval('products_prod_id_seq'::regclass) |
public.inventory | Product identification number. | |||
Product identification number. Identity / Auto increment column Default: nextval('products_prod_id_seq'::regclass) References: public.inventory |
||||||||
2 | category | smallint | public.categories | Product category identification number. | ||||
Product category identification number. References: public.categories |
||||||||
3 | title | text | The title of the film. | |||||
The title of the film. |
||||||||
4 | actor | text | The name of the actor. | |||||
The name of the actor. |
||||||||
5 | price | numeric | Selling price. | |||||
Selling price. |
||||||||
6 | special | smallint | ||||||
7 | common_prod_id | integer | Common product identification number. | |||||
Common product identification number. |
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 |
||||
public.products | public.inventory | public.products.prod_id = public.inventory.prod_id | fk_products_inventory Foreign key constraint referencing inventory.product_id |
|
public.products.prod_id = public.inventory.prod_id Name: fk_products_inventoryForeign key constraint referencing inventory.product_id |
||||
public.orderlines | public.products | public.orderlines.prod_id = public.products.prod_id | fk_orderlines_products Foreign key constraint referencing products.product_id |
|
public.orderlines.prod_id = public.products.prod_id Name: fk_orderlines_productsForeign key constraint referencing products.product_id |
||||
public.reorder | public.products | public.reorder.prod_id = public.products.prod_id | fk_reorder_products | |
public.reorder.prod_id = public.products.prod_id Name: fk_reorder_products |
Unique keys
Key name | Columns | Description | |
---|---|---|---|
products_pkey | prod_id | Primary key. | |
Primary key. |
Uses
Name |
---|
public.products
|
Used by
Name |
---|
public.products
|
Exported: 2018-11-09 16:14, Last imported: 2018-08-06 09:39