Table openpetra_trunk.public.a_currency_language
Describes what is to be displayed for a currency and language combination when displaying the amount as text.

 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_currency.a_currency_code_c a_currency_language_fk1 R
This defines which currency is being used
p_language_code_c varchar 20
p_language.p_language_code_c a_currency_language_fk2 R
This is the code used to identify a language.
a_unit_label_singular_c varchar 32  √  null The currency unit label when the amount is 1
a_unit_label_plural_c varchar 32  √  null The currency unit label when the amount is > 1
a_special_code_c varchar 32  √  null This is needed to determine the gender in some languages.
a_decimal_options_c varchar 24  √  null Describes what to do with the decimal when representing it as text. Not to display, display as text or as a numeric
a_decimal_label_singular_c varchar 32  √  null The currency decimal label when the amount is 1
a_decimal_label_plural_c varchar 32  √  null The currency decimal label when the amount is > 1
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c a_currency_language_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c a_currency_language_fkmd R
s_modification_id_c varchar 150  √  null

Table contained 0 rows at Do Nov 10 18:00 MEZ 2011

Indexes:
Column(s) Type Sort Constraint Name
a_currency_code_c + p_language_code_c Primary key Asc/Asc a_currency_language_pk
a_currency_code_c Performance Asc inx_a_currency_language_fk1_key1
p_language_code_c Performance Asc inx_a_currency_language_fk2_key2
s_created_by_c Performance Asc inx_a_currency_language_fkcr_key3
s_modified_by_c Performance Asc inx_a_currency_language_fkmd_key4
a_currency_code_c + p_language_code_c Must be unique Asc/Asc inx_a_currency_language_pk0

Close relationships  within of separation: