Appendix B. Sample Application Data Files

Sample Database Tables

“Orange Whip Studios” is a fictitious company used in the examples throughout this book. The various examples and applications use a total of 12 database tables, as described in the following sections.


The sample applications use Apache Derby as a database (this database engine is included with ColdFusion). Because of limitations in the data types supported by Apache Derby, all money or currency fields are represented as real types, and all bit fields are represented by single character types.

The Actors Table

The Actors table contains a list of all the actors along with name, address, and other personal information. Actors ...

Get Adobe® ColdFusion® 9 Web Application Construction Kit, Volume 1: Getting Started now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.