O'Reilly logo

Programming ColdFusion MX, 2nd Edition by Rob Brooks-Bilson

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

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 Microsoft SQL Server, Oracle, DB2, Informix, Sybase, MySQL, or PostgreSQL. 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 ...

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