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

Get Programming ColdFusion 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.