Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started

The Contacts Table

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

Table 5.10. The Contacts Table

Column	Data Type	Description and Size
ContactID	Numeric	Unique ID for each contact; can be populated manually when rows are inserted or automatically (if defined as an Auto Number field)
FirstName	Text	Contact first name
LastName	Text	Contact last name
Address	Text	Contact address
City	Text	Contact city
State	Text	Contact state (or province)
Zip	Text	Contact ZIP code (or postal code)
Country	Text	Contact country
Email	Text	Contact email address
Phone	Text	Contact phone number
UserLogin	Text	Contact login name
UserPassword	Text	Contact login password
MailingList	Bit or Yes/No	Flag specifying whether this contact is on the mailing list
UserRoleID	Numeric ...