AddressBook

From Species File Help
Jump to: navigation, search

tblAddressBook is an auxiliary table associated with tblPeople which contains contact information.

  • PersonID, integer, 4 bytes, = tblPeople.PersonID
  • Affiliation, text, 75 unicode characters maximum, person's affiliation - usually a professional or education organization.
  • PhoneNum, text, 30 unicode characters maximum, person's phone number.
  • StreetAddr, text, 70 unicode characters maximum, person's street address (';' are translated into carriage returns in the display.)
  • CityName, text, 50 unicode characters maximum, the name of the city in the person's address.
  • StateProvName, text, 50 unicode characters maximum, the name of the state in the person's address. Selected from a value in tblAddrStates.
  • CountryName, text, 50 unicode characters maximum, the name of the country in the person's address. Selected from a value in tblAddrCountries.
  • ZipCode, text, 50 unicode characters maximum, The zip or postal code in the person's address.
  • Email, text, 50 unicode characters maximum, The person's Email address.
  • LastUpdate, smalldatetime, date and time row last updated
  • ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
  • CreatedOn, smalldatetime, date and time row was created
  • CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox