Table dellstore2.public.products Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
prod_id serial 10  √  nextval('products_prod_id_seq'::regclass)
category int4 10
title varchar 50
actor varchar 50
price numeric 12,2
special int2 5  √  null
common_prod_id int4 10

Table contained 10,000 rows at Tue May 24 11:41 EDT 2016

Indexes:
Column(s) Type Sort Constraint Name
prod_id Primary key Asc products_pkey
category Performance Asc ix_prod_category
special Performance Asc ix_prod_special