O'Reilly logo

Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started by Charlie Arehart, Raymond Camden, Ben Forta

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

The Contacts Table

The Contacts table (Table 5.10) contains a list of all contacts (including customers).

Table 5.10. The Contacts Table
ColumnData TypeDescription and Size
ContactIDNumericUnique ID for each contact; can be populated manually when rows are inserted or automatically (if defined as an Auto Number field)
FirstNameTextContact first name
LastNameTextContact last name
AddressTextContact address
CityTextContact city
StateTextContact state (or province)
ZipTextContact ZIP code (or postal code)
CountryTextContact country
EmailTextContact email address
PhoneTextContact phone number
UserLoginTextContact login name
UserPasswordTextContact login password
MailingListBit or Yes/NoFlag specifying whether this contact is on the mailing list
UserRoleIDNumeric ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required