AddressBook
From Species File Help
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