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.

Note

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 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.