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 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
ColumnDatatypeDescription
ContactIDNumeric (Identity)Unique contact ID
FirstNameText (50 chars)Contact first name
LastNameText (50 chars)Contact last name
AddressText (100 chars)Contact address
CityText (50 chars)Contact city
StateText (5 chars)Contact state
ZipText (10 chars)Contact ZIP
CountryText (50 chars)Contact country
EmailText (100 chars)Contact email address
PhoneText (50 chars)Contact phone number
UserLoginText (50 chars)Contact user login
UserPasswordText (50 chars)Contact login password
MailingListSmall IntegerMailing list flag
UserRoleIDNumericID of ...

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