SchemaSpy Analysis of jdahlin.public - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Tue Sep 23 20:54 GMT-03:00 2008
Legend: SourceForge.net
Primary key columns
Columns with indexes
Please support this project 

Related columns Constraint names Comments Legend
jdahlin.public contains 758 columns:
Column Table Type Size Nulls Auto Default Children Parents Comments
account bank_account text 2147483647  √  null
account_id payment_destination int8 19  √  null
bank_account.id payment_destination_account_id_fkey
actual_quantity inventory_item numeric 10,2  √  null
address sale_item_adapt_to_delivery text 2147483647  √  null
admission_date person_adapt_to_employee timestamp 29,6  √  null
app_dir_name profile_settings text 2147483647  √  null
asellable_id commission_source int8 19  √  null
asellable.id commission_source_asellable_id_fkey
attendant_id calls int8 19  √  null
person_adapt_to_user.id calls_attendant_id_fkey
bank_account_id person_adapt_to_employee int8 19  √  null
bank_account.id person_adapt_to_employee_bank_account_id_fkey
bank_data_id check_data int8 19  √  null
bank_account.id check_data_bank_data_id_fkey
bank_id bank_account int4 10  √  null
bank_id person_adapt_to_bank_branch int8 19  √  null
bank.id person_adapt_to_bank_branch_bank_id_fkey
barcode asellable text 2147483647  √  null
base_cost product_supplier_info numeric 10,2  √  null
base_cost purchase_item numeric 10,2  √  null
base_price sale_item numeric 10,2  √  null
base_sellable_info_id asellable int8 19  √  null
base_sellable_info.id asellable_base_sellable_info_id_fkey
base_value payment numeric 10,2  √  null
began employee_role_history timestamp 29,6  √  null
birth_date person_adapt_to_individual timestamp 29,6  √  null
birth_location_id person_adapt_to_individual int8 19  √  null
city_location.id person_adapt_to_individual_birth_location_id_fkey
branch bank_account text 2147483647  √  null
branch_id branch_station int8 19  √  null
person_adapt_to_branch.id branch_station_branch_id_fkey
branch_id branch_synchronization int8 19  √  null
person_adapt_to_branch.id branch_synchronization_branch_id_fkey
branch_id fiscal_book_entry int8 19  √  null
person_adapt_to_branch.id abstract_fiscal_book_entry_branch_id_fkey
branch_id inventory int8 19
person_adapt_to_branch.id inventory_branch_id_fkey
branch_id payment_destination int8 19  √  null
person_adapt_to_branch.id payment_destination_branch_id_fkey
branch_id product_history int8 19  √  null
person_adapt_to_branch.id product_history_branch_id_fkey
branch_id product_stock_item int8 19  √  null
person_adapt_to_branch.id abstract_stock_item_branch_id_fkey
branch_id purchase_order int8 19  √  null
person_adapt_to_branch.id purchase_order_branch_id_fkey
branch_id receiving_order int8 19  √  null
person_adapt_to_branch.id receiving_order_branch_id_fkey
branch_id sale int8 19  √  null
person_adapt_to_branch.id sale_branch_id_fkey
branch_id till_fiscal_operations_view int8 19  √  null
branch_name purchase_order_view text 2147483647  √  null
brand device_settings text 2147483647  √  null
cancel_date abstract_payment_group timestamp 29,6  √  null
cancel_date payment timestamp 29,6  √  null
cancel_date sale timestamp 29,6  √  null
cancel_date sale_view timestamp 29,6  √  null
category military_data text 2147483647  √  null
category_id asellable int8 19  √  null
sellable_category.id asellable_category_id_fkey
category_id commission_source int8 19  √  null
sellable_category.id commission_source_category_id_fkey
category_id payment int8 19  √  null
payment_category.id payment_category_id_fkey
category_id sellable_category int8 19  √  null
sellable_category.id asellable_category_category_id_fkey
cfop_data_id inventory_item int8 19  √  null
cfop_data.id inventory_item_cfop_data_id_fkey
cfop_id fiscal_book_entry int8 19  √  null
cfop_data.id abstract_fiscal_book_entry_cfop_id_fkey
cfop_id product_retention_history int8 19  √  null
cfop_data.id product_retention_history_cfop_id_fkey
cfop_id receiving_order int8 19  √  null
cfop_data.id receiving_order_cfop_id_fkey
cfop_id sale int8 19  √  null
cfop_data.id sale_cfop_id_fkey
change_date payment_change_history timestamp 29,6  √  null
change_reason payment_change_history text 2147483647  √  null
child_name abstract_payment_group varchar 255  √  null
child_name asellable varchar 255  √  null
child_name inheritable_model varchar 255  √  null
child_name inheritable_model_adapter varchar 255  √  null
child_name payment_method_details varchar 255  √  null
city city_location text 2147483647  √  null
city_location_id address int8 19  √  null
city_location.id address_city_location_id_fkey
client_id sale int8 19  √  null
person_adapt_to_client.id sale_client_id_fkey
client_id sale_view int8 19  √  null
client_name sale_view text 2147483647  √  null
close_date abstract_payment_group timestamp 29,6  √  null
close_date inventory timestamp 29,6  √  null
close_date sale timestamp 29,6  √  null
close_date sale_view timestamp 29,6  √  null
closing_date till timestamp 29,6  √  null
closing_day card_installment_settings int4 10  √  null
closing_day payment_method int4 10  √  null
cnpj person_adapt_to_company text 2147483647  √  null
code cfop_data text 2147483647  √  null
code fiscal_day_tax text 2147483647  √  null
color payment_category text 2147483647  √  null
comission person_adapt_to_sales_person numeric 10,2  √  null
comission_type person_adapt_to_sales_person int4 10  √  null
commission base_sellable_info numeric 10,2  √  null
commission payment_method_details numeric 10,2  √  null
commission_type commission int4 10
compensation_code bank text 2147483647  √  null
complement address text 2147483647  √  null
completion_date sale_item timestamp 29,6  √  null
component_id product_component int8 19  √  null
product.id product_component_component_id_fkey
confirm_date purchase_order timestamp 29,6  √  null
confirm_date purchase_order_view timestamp 29,6  √  null
confirm_date receiving_order timestamp 29,6  √  null
confirm_date sale timestamp 29,6  √  null
confirm_date sale_view timestamp 29,6  √  null
constant_enum device_constant int4 10  √  null
constant_name device_constant text 2147483647  √  null
constant_type device_constant int4 10  √  null
constant_value device_constant numeric 10,2  √  null
coo fiscal_sale_history int4 10  √  null
cost asellable numeric 10,2  √  null
cost purchase_item numeric 10,2  √  null
cost receiving_order_item numeric 10,2  √  null
country city_location text 2147483647  √  null
coupon_end fiscal_day_history int4 10  √  null
coupon_id sale int4 10  √  null
coupon_id sale_view int4 10  √  null
coupon_start fiscal_day_history int4 10  √  null
cpf person_adapt_to_individual text 2147483647  √  null
cro fiscal_day_history int4 10  √  null
crz fiscal_day_history int4 10  √  null
daily_penalty payment_method numeric 10,2  √  null
date calls timestamp 29,6  √  null
date fiscal_book_entry timestamp 29,6  √  null
date till_entry timestamp 29,6  √  null
date till_fiscal_operations_view timestamp 29,6  √  null
days_late person_adapt_to_client int4 10  √  null
delivery_id delivery_item int8 19  √  null
sale_item_adapt_to_delivery.id delivery_item_delivery_id_fkey
dependent_person_number person_adapt_to_employee int4 10  √  null
description base_sellable_info text 2147483647  √  null
description cfop_data text 2147483647  √  null
description invoice_layout varchar 2147483647
description invoice_printer varchar 2147483647
description payment text 2147483647  √  null
description payment_destination text 2147483647  √  null
description payment_method text 2147483647  √  null
description sellable_category text 2147483647  √  null
description sellable_tax_constant text 2147483647  √  null
description sellable_unit text 2147483647  √  null
description till_entry text 2147483647  √  null
description till_fiscal_operations_view text 2147483647  √  null
destination_branch_id transfer_order int8 19
person_adapt_to_branch.id transfer_order_destination_branch_id_fkey
destination_id payment int8 19  √  null
payment_destination.id payment_destination_id_fkey
destination_id payment_method int8 19  √  null
payment_destination.id apayment_method_destination_id_fkey
destination_id payment_method_details int8 19  √  null
payment_destination.id payment_method_details_destination_id_fkey
destination_responsible_id transfer_order int8 19
person_adapt_to_employee.id transfer_order_destination_responsible_id_fkey
device device_settings int4 10  √  null
device_name invoice_printer varchar 2147483647
device_settings_id device_constant int8 19  √  null
device_settings.id device_constant_device_settings_id_fkey
device_value device_constant bytea 2147483647  √  null
direct_value commission_source numeric 10,2
discount payment numeric 10,2  √  null
discount_value purchase_order numeric 10,2  √  null
discount_value purchase_order_view numeric 10,2  √  null
discount_value receiving_order numeric 10,2  √  null
discount_value sale numeric 10,2  √  null
discount_value sale_view numeric 10,2  √  null
district address text 2147483647  √  null
document fiscal_sale_history text 2147483647  √  null
document_counter fiscal_sale_history int4 10  √  null
document_type fiscal_sale_history int4 10  √  null
drawee_id fiscal_book_entry int8 19  √  null
person.id abstract_fiscal_book_entry_drawee_id_fkey
due_date payment timestamp 29,6  √  null
education_level person_adapt_to_employee text 2147483647  √  null
email person text 2147483647  √  null
emission_date fiscal_day_history date 13  √  null
employee_id employee_role_history int8 19  √  null
person_adapt_to_employee.id employee_role_history_employee_id_fkey
ended employee_role_history timestamp 29,6  √  null
entry_type fiscal_book_entry int4 10  √  null
estimated_fix_date sale_item timestamp 29,6  √  null
expected_pay_date purchase_order timestamp 29,6  √  null
expected_pay_date purchase_order_view timestamp 29,6  √  null
expected_receival_date purchase_order timestamp 29,6  √  null
expected_receival_date purchase_order_view timestamp 29,6  √  null
expense_value receiving_order numeric 10,2  √  null
expire_vacation person_adapt_to_employee timestamp 29,6  √  null
fancy_name person_adapt_to_company text 2147483647  √  null
father_name person_adapt_to_individual text 2147483647  √  null
fax_number person text 2147483647  √  null
field_name invoice_field varchar 2147483647
field_name parameter_data text 2147483647
field_value parameter_data text 2147483647  √  null
final_cash_amount till numeric 10,2  √  null
fiscal_day_history_id fiscal_day_tax int8 19  √  null
fiscal_day_history.id fiscal_day_tax_fiscal_day_history_id_fkey
freight purchase_order numeric 10,2  √  null
freight purchase_order_view numeric 10,2  √  null
freight_percentage person_adapt_to_transporter numeric 10,2  √  null
freight_total receiving_order numeric 10,2  √  null
freight_type purchase_order int4 10  √  null
gender person_adapt_to_individual int4 10  √  null
generation system_table int4 10  √  null
group_id credit_provider_group_data int8 19  √  null
abstract_payment_group.id credit_provider_group_data_group_id_fkey
group_id payment int8 19  √  null
abstract_payment_group.id payment_group_id_fkey
group_id quotation int8 19  √  null
quote_group.id purchase_order_adapt_to_quote_group_id_fkey
has_permission profile_settings bool 1  √  null
height invoice_field int8 19
height invoice_layout int8 19
icms product_supplier_info numeric 10,2  √  null
icms_total receiving_order numeric 10,2  √  null
icms_value fiscal_book_entry numeric 10,2  √  null
id abstract_payment_group bigserial 19  √  nextval('abstract_payment_group_id_seq'::regclass)
credit_provider_group_data.group_id credit_provider_group_data_group_id_fkey
fiscal_book_entry.payment_group_id abstract_fiscal_book_entry_payment_group_id_fkey
payment.group_id payment_group_id_fkey
id address bigserial 19  √  nextval('address_id_seq'::regclass)
id asellable bigserial 19  √  nextval('asellable_id_seq'::regclass)
commission_source.asellable_id commission_source_asellable_id_fkey
delivery_item.sellable_id delivery_item_sellable_id_fkey
product_history.sellable_id product_history_sellable_id_fkey
purchase_item.sellable_id purchase_item_sellable_id_fkey
receiving_order_item.sellable_id receiving_order_item_sellable_id_fkey
sale_item.sellable_id asellable_item_sellable_id_fkey
transfer_order_item.sellable_id transfer_order_item_sellable_id_fkey
id bank bigserial 19  √  nextval('bank_id_seq'::regclass)
person_adapt_to_bank_branch.bank_id person_adapt_to_bank_branch_bank_id_fkey
id bank_account bigserial 19  √  nextval('bank_account_id_seq'::regclass)
check_data.bank_data_id check_data_bank_data_id_fkey
payment_destination.account_id payment_destination_account_id_fkey
person_adapt_to_employee.bank_account_id person_adapt_to_employee_bank_account_id_fkey
id base_sellable_info bigserial 19  √  nextval('base_sellable_info_id_seq'::regclass)
asellable.base_sellable_info_id asellable_base_sellable_info_id_fkey
id branch_station bigserial 19  √  nextval('branch_station_id_seq'::regclass)
device_settings.station_id device_settings_station_id_fkey
fiscal_day_history.station_id fiscal_day_history_station_id_fkey
invoice_printer.station_id invoice_printer_station_id_fkey
till.station_id till_station_id_fkey
transaction_entry.station_id transaction_entry_station_id_fkey
id branch_synchronization bigserial 19  √  nextval('branch_synchronization_id_seq'::regclass)
id calls bigserial 19  √  nextval('calls_id_seq'::regclass)
id card_installment_settings bigserial 19  √  nextval('card_installment_settings_id_seq'::regclass)
card_installments_provider_details.installment_settings_id card_installments_provider_details_installment_settings_id_fkey
card_installments_store_details.installment_settings_id card_installments_store_details_installment_settings_id_fkey
credit_card_details.installment_settings_id credit_card_details_installment_settings_id_fkey
id card_installments_provider_details bigserial 19  √  nextval('card_installments_provider_details_id_seq'::regclass)
id card_installments_store_details bigserial 19  √  nextval('card_installments_store_details_id_seq'::regclass)
id cfop_data bigserial 19  √  nextval('cfop_data_id_seq'::regclass)
fiscal_book_entry.cfop_id abstract_fiscal_book_entry_cfop_id_fkey
inventory_item.cfop_data_id inventory_item_cfop_data_id_fkey
product_retention_history.cfop_id product_retention_history_cfop_id_fkey
receiving_order.cfop_id receiving_order_cfop_id_fkey
sale.cfop_id sale_cfop_id_fkey
id check_data bigserial 19  √  nextval('check_data_id_seq'::regclass)
id city_location bigserial 19  √  nextval('city_location_id_seq'::regclass)
address.city_location_id address_city_location_id_fkey
person_adapt_to_individual.birth_location_id person_adapt_to_individual_birth_location_id_fkey
id commission bigserial 19  √  nextval('commission_id_seq'::regclass)
id commission_source bigserial 19  √  nextval('commission_source_id_seq'::regclass)
id credit_card_details bigserial 19  √  nextval('credit_card_details_id_seq'::regclass)
id credit_provider_group_data bigserial 19  √  nextval('credit_provider_group_data_id_seq'::regclass)
id debit_card_details bigserial 19  √  nextval('debit_card_details_id_seq'::regclass)
id delivery_item bigserial 19  √  nextval('delivery_item_id_seq'::regclass)
id device_constant bigserial 19  √  nextval('device_constant_id_seq'::regclass)
id device_settings bigserial 19  √  nextval('device_settings_id_seq'::regclass)
device_constant.device_settings_id device_constant_device_settings_id_fkey
id employee_role bigserial 19  √  nextval('employee_role_id_seq'::regclass)
employee_role_history.role_id employee_role_history_role_id_fkey
person_adapt_to_employee.role_id person_adapt_to_employee_role_id_fkey
id employee_role_history bigserial 19  √  nextval('employee_role_history_id_seq'::regclass)
id fiscal_book_entry bigserial 19  √  nextval('abstract_fiscal_book_entry_id_seq'::regclass)
id fiscal_day_history bigserial 19  √  nextval('fiscal_day_history_id_seq'::regclass)
fiscal_day_tax.fiscal_day_history_id fiscal_day_tax_fiscal_day_history_id_fkey
id fiscal_day_tax bigserial 19  √  nextval('fiscal_day_tax_id_seq'::regclass)
id fiscal_sale_history bigserial 19  √  nextval('paulista_invoice_id_seq'::regclass)
id inheritable_model bigserial 19  √  nextval('inheritable_model_id_seq'::regclass)
id inheritable_model_adapter bigserial 19  √  nextval('inheritable_model_adapter_id_seq'::regclass)
id installed_plugin bigserial 19  √  nextval('installed_plugin_id_seq'::regclass)
id inventory bigserial 19  √  nextval('inventory_id_seq'::regclass)
inventory_item.inventory_id inventory_item_inventory_id_fkey
id inventory_item bigserial 19  √  nextval('inventory_item_id_seq'::regclass)
id invoice_field bigserial 19  √  nextval('invoice_field_id_seq'::regclass)
id invoice_layout bigserial 19  √  nextval('invoice_layout_id_seq'::regclass)
invoice_field.layout_id invoice_field_layout_id_fkey
invoice_printer.layout_id invoice_printer_layout_id_fkey
id invoice_printer bigserial 19  √  nextval('invoice_printer_id_seq'::regclass)
id liaison bigserial 19