Table stoq_schema.public.product Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents
id uuid 2147483647 uuid_generate_v1()
inventory_item
product
product_attribute
product_component
product_component
product_option_map
product_quality_test
product_supplier_info
production_item
production_material
production_produced_item
storable
sellable
te_id int8 19  √  new_te()
transaction_entry
consignment bool 1 false
location text 2147483647  √  null
part_number text 2147483647  √  null
family text 2147483647  √  null
brand text 2147483647  √  null
model text 2147483647  √  null
ncm text 2147483647  √  null
ex_tipi text 2147483647  √  null
genero text 2147483647  √  null
production_time int4 10  √  0
manage_stock bool 1  √  true
is_composed bool 1  √  false
width numeric 10,2  √  null
height numeric 10,2  √  null
depth numeric 10,2  √  null
weight numeric 10,2  √  null
icms_template_id uuid 2147483647  √  null
product_icms_template
ipi_template_id uuid 2147483647  √  null
product_ipi_template
manufacturer_id uuid 2147483647  √  null
product_manufacturer
is_grid bool 1  √  false
parent_id uuid 2147483647  √  null
product
internal_use bool 1  √  false
pis_template_id uuid 2147483647  √  null
product_pis_template
cofins_template_id uuid 2147483647  √  null
product_cofins_template
is_package bool 1  √  false

Analyzed at Fri Jun 10 16:06 BRT 2016

Indexes:
Column(s) Type Sort Anomalies
id Primary key Asc  
te_id Must be unique Asc This unique column is also nullable

Close relationships  within of separation: