AddressBook
From Species File Help
(Difference between revisions)
(created page) |
|||
(One intermediate revision by one user not shown) | |||
Line 1: | Line 1: | ||
'''tblAddressBook''' is an auxiliary table associated with tblPeople which contains contact information. | '''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 | |
[[Category:CiteRelatedTables]] | [[Category:CiteRelatedTables]] | ||
+ | [[Category:Tables]] |
Latest revision as of 12:39, 8 September 2012
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