account_contact

Contact details for an account in Smile.

Column name Description Data type
account Primary key.

Reference to account.

integer
contact_type Always 0. integer *
contact_name Usually "<contact_title> <family_name>, <given_name>". text *
company_name   text *
trading_name   text *
abn   text *
contact_title   text *
family_name   text *
given_name   text *
date_of_birth   text *
gender
  • M—Male
  • F—Female
  • U—Unspecified
character (1) *
position   text *
phone_home   text *
phone_work   text *
phone_mobile   text *
fax   text *