SchemaSpy - Table stoq_schema.public.cfop_data

Generated by
SchemaSpy

Legend:

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

id

uuid

2147483647

uuid_generate_v1()

fiscal_book_entry.cfop_id	fiscal_book_entry_cfop_id_fkey R
inventory_item.cfop_data_id	inventory_item_cfop_data_id_fkey R
receiving_order.cfop_id	receiving_order_cfop_id_fkey R
sale.cfop_id	sale_cfop_id_fkey R
sale_item.cfop_id	sale_item_cfop_id_fkey R
sellable.default_sale_cfop_id	sellable_default_sale_cfop_id_fkey R
stock_decrease.cfop_id	stock_decrease_cfop_id_fkey R

te_id

int8

19

√

new_te()

transaction_entry.id

cfop_data_te_id_fkey R

code

text

2147483647

√

null

description

text

2147483647

√

null

Analyzed at Fri Jun 10 16:06 BRT 2016

Indexes:

Column(s)	Type	Sort	Constraint Name	Anomalies
id	Primary key	Asc	cfop_data_pkey
te_id	Must be unique	Asc	cfop_data_te_id_key	This unique column is also nullable