Programming ColdFusion

Appendix C. Example Database Tables

The examples used throughout this book reference several database tables. The schemas and data for these tables are listed in this appendix. Because of its low cost, wide availability, and ease of use, all tables were designed using Microsoft Access. Because Access is a desktop database, I don’t recommend using it in production environments, especially where many concurrent users are expected to use the database. Access isn’t designed for heavy concurrent use and may experience scalability and performance issues if placed under load. Additionally, there are limits on the amount of data that can reliably be stored in an Access database.

For production applications, I recommend you use an enterprise-level database, such as MS SQL Server, Oracle, DB2, Informix, or Sybase. These databases provide advanced features and functionality, such as stored procedures and triggers, and are specially tuned for handling multiple concurrent requests and massive amounts of data.

Table C-1 lists the schema for the EmployeeDirectory table that is used throughout the book, while Table C-2 lists the actual data.

Table C-1. EmployeeDirectory Table Schema

Field Name	Field Type	Max Length
ID (primary key)	AutoNumber	N/A
Name	Text	255
Title	Text	255
Department	Memo	N/A
Email	Date/Time	N/A
PhoneExt	Number (long int)	N/A
Salary	Number (double, two decimal places)	N/A
Picture	Memo	N/A

Table C-2. EmployeeDirectory Table Data

ID	Name	Title