Table jdahlin.public.cfop_data Generated by
SchemaSpy
Related columns Constraint names Comments Legend
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
Dashed lines show
implied relationships
< n > number of related tables
Please support this project 
Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19  √  nextval('cfop_data_id_seq'::regclass)
fiscal_book_entry.cfop_id fiscal_book_entry_cfop_id_fkey
inventory_item.cfop_data_id inventory_item_cfop_data_id_fkey
receiving_order.cfop_id receiving_order_cfop_id_fkey
sale.cfop_id sale_cfop_id_fkey
sale_item.cfop_id sale_item_cfop_id_fkey
sellable.default_sale_cfop_id sellable_default_sale_cfop_id_fkey
stock_decrease.cfop_id stock_decrease_cfop_id_fkey
te_created_id int8 19  √  null
transaction_entry.id cfop_data_te_created_id_fkey
te_modified_id int8 19  √  null
transaction_entry.id cfop_data_te_modified_id_fkey
code text 2147483647  √  null
description text 2147483647  √  null

Table contained 4 rows at Sex Jun 10 16:28 BRT 2011

Indexes:
Column(s) Type Sort Constraint Name Anomalies
id Primary key Asc cfop_data_pkey  
te_created_id Must be unique Asc cfop_data_te_created_id_key This unique column is also nullable
te_modified_id Must be unique Asc cfop_data_te_modified_id_key This unique column is also nullable


SchemaSpy was unable to generate a graphical representation of table relationships.
SchemaSpy requires Graphviz version 2.2.1 or versions greater than 2.4 from www.graphviz.org.