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

The Contacts Table

The Contacts table stores all contacts, including mailing list members and online store customers. Contacts contains the columns listed in Table B.2.

Table B.2. The Contacts Table

Column	Datatype	Description
ContactID	Numeric (Identity)	Unique contact ID
FirstName	Text (50 chars)	Contact first name
LastName	Text (50 chars)	Contact last name
Address	Text (100 chars)	Contact address
City	Text (50 chars)	Contact city
State	Text (5 chars)	Contact state
Zip	Text (10 chars)	Contact ZIP
Country	Text (50 chars)	Contact country
Email	Text (100 chars)	Contact email address
Phone	Text (50 chars)	Contact phone number
UserLogin	Text (50 chars)	Contact user login
UserPassword	Text (50 chars)	Contact login password
MailingList	Small Integer	Mailing list flag
UserRoleID	Numeric	ID of ...