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.
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 |
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 ... |
Get Adobe ColdFusion 8 Web Application Construction Kit, Volume 1: Getting Started now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.