Table openpetra_trunk.public.p_banking_details
Any bank details for a partner can be stored in this table

 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
p_banking_details_key_i int4 10
a_account.p_banking_details_key_i a_account_fk4 R
a_ep_account.a_banking_details_key_i a_ep_account_fk1 R
a_ep_statement.a_bank_account_key_i a_ep_statement_fk1 R
p_partner_banking_details.p_banking_details_key_i p_partner_banking_link_fk2 R
A sequence key for the banking details.
p_banking_type_i int4 10
p_banking_type.p_id_i p_banking_details_fk3 R
The type of banking: BANK ACCOUNT, CREDIT CARD, etc.
p_account_name_c varchar 160  √  null The full name used for authorizing a transaction with this banking entity.
p_title_c varchar 64  √  null
p_first_name_c varchar 64  √  null
p_middle_name_c varchar 64  √  null
p_last_name_c varchar 64  √  null
p_bank_key_n numeric 10
p_bank.p_partner_key_n p_banking_details_fk4 R
Link to p_bank to see what details the bank has.
p_bank_account_number_c varchar 40  √  null The account number in the bank
p_iban_c varchar 128  √  null The IBAN (International Bank Account Number). IBAN is a standardised international format for entering account details which consists of the country code, the local bank code, the (payee) account number and a control number.
p_security_code_c varchar 24  √  null Credit Card Security Code
p_valid_from_date_d date 13  √  null When the credit card is valid from
p_expiry_date_d date 13  √  null When this expires
p_comment_c varchar 510  √  null This is the finance details comment.
s_date_created_d date 13  √  ('now'::text)::date
s_created_by_c varchar 20  √  null
s_user.s_user_id_c p_banking_details_fkcr R
s_date_modified_d date 13  √  null
s_modified_by_c varchar 20  √  null
s_user.s_user_id_c p_banking_details_fkmd R
s_modification_id_c varchar 150  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
p_banking_details_key_i Primary key Asc p_banking_details_pk
p_bank_account_number_c Performance Asc inx_p_banking_details_account1
p_banking_type_i Performance Asc inx_p_banking_details_fk3_key1
p_bank_key_n Performance Asc inx_p_banking_details_fk4_key2
s_created_by_c Performance Asc inx_p_banking_details_fkcr_key3
s_modified_by_c Performance Asc inx_p_banking_details_fkmd_key4
p_iban_c Performance Asc inx_p_banking_details_iban2
p_account_name_c Performance Asc inx_p_banking_details_name0
p_banking_details_key_i Must be unique Asc inx_p_banking_details_pk0

Close relationships  within of separation: