Table openpetra_trunk.public.a_currency
Unit of money for various countries.

 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
a_currency_code_c varchar 16
a_account.a_foreign_currency_code_c a_account_fk3 R
a_ap_supplier.a_currency_code_c a_ap_supplier_fk2 R
a_ar_article_price.a_currency_code_c ar_article_price_fk2 R
a_ar_discount.a_currency_code_c ar_discount_fk1 R
a_ar_invoice.a_currency_code_c a_ar_invoice_fk3 R
a_ar_invoice_detail.a_currency_code_c a_ar_invoice_detail_fk3 R
a_corporate_exchange_rate.a_from_currency_code_c a_corporate_exchange_rate_fk1 R
a_corporate_exchange_rate.a_to_currency_code_c a_corporate_exchange_rate_fk2 R
a_currency_language.a_currency_code_c a_currency_language_fk1 R
a_daily_exchange_rate.a_from_currency_code_c a_daily_exchange_rate_fk1 R
a_daily_exchange_rate.a_to_currency_code_c a_daily_exchange_rate_fk2 R
a_ep_statement.a_currency_code_c a_ep_statement_fk2 R
a_gift_batch.a_currency_code_c a_gift_batch_fk4 R
a_journal.a_transaction_currency_c a_journal_fk4 R
a_ledger.a_base_currency_c a_ledger_fk3 R
a_ledger.a_intl_currency_c a_ledger_fk4 R
a_prev_year_corp_ex_rate.a_from_currency_code_c a_prev_year_corp_ex_rate_fk1 R
a_prev_year_corp_ex_rate.a_to_currency_code_c a_prev_year_corp_ex_rate_fk2 R
a_previous_year_journal.a_base_currency_c a_previous_year_journal_fk5 R
a_previous_year_journal.a_transaction_currency_c a_previous_year_journal_fk4 R
a_recurring_gift_batch.a_currency_code_c a_recurring_gift_batch_fk4 R
a_recurring_journal.a_transaction_currency_c a_recurring_journal_fk4 R
a_recurring_transaction.a_base_currency_c a_recurring_transaction_fk5 R
a_recurring_transaction.a_transaction_currency_c a_recurring_transaction_fk4 R
a_this_year_old_journal.a_transaction_currency_c a_this_year_old_journal_fk4 R
p_data_label.p_currency_code_c p_data_label_fk1 R
p_publication_cost.p_currency_code_c p_publication_cost_fk2 R
p_unit.p_outreach_cost_currency_code_c p_unit_fk4 R
p_venue.a_currency_code_c p_venue_fk2 R
pc_conference.a_currency_code_c pc_conference_fk2 R
pm_general_application.pm_gen_app_currency_code_c pm_general_application_fk8 R
um_unit_cost.a_local_currency_code_c um_unit_cost_fk2 R
This defines which currency is being used
a_currency_name_c varchar 64 This is the name of the currency
a_currency_symbol_c varchar 8 This is the symbol used to show a currency. Eg $US or £
p_country_code_c varchar 8
p_country.p_country_code_c a_currency_fk1 R
Country code
a_display_format_c varchar 40 '->>>,>>>,>>>,>>9.99'::character varying The format in which to display and accept input on a currency (decimal values)
a_in_emu_l bool 1 false Indicates whether currency is part of the european exchange rate mechanism/ European Monetary Union
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c a_currency_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c a_currency_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 84 rows at Mi Nov 09 18:02 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name
a_currency_code_c Primary key Asc a_currency_pk
p_country_code_c Performance Asc inx_a_currency_fk1_key1
s_created_by_c Performance Asc inx_a_currency_fkcr_key2
s_modified_by_c Performance Asc inx_a_currency_fkmd_key3
a_currency_code_c Must be unique Asc inx_a_currency_pk0

Close relationships  within of separation: