“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.
Actors table contains a list of all the actors along with name, address, and other personal information.