account_address

Billing and/or street address details for an account holder in Smile.

Column name Description Data type
account Primary key.

Reference to account.

 integer
address_type
  • 0—for a billing address
  • 1—for a street address
 smallint *
address_name   text *
company_name   text *
address_detail The house/building street number. text *
building_name   text *
sub_unit   text *
floor   text *
lot   text *
postal_delivery_type   text *
street_number   text *
street_name   text *
street_type   text *
suburb   text *
state   text *
postcode   text *
country   text *