Appendix G. Sample Application Data Files

Sample Application Data Files

“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 Actors Table

The Actors table contains a list of all the actors along with name, address, and other personal information. Actors contains the columns listed in Table G.1.

Table G.1. The Actors Table

COLUMN

DATATYPE

DESCRIPTION

ActorID

Numeric (Auto Number)

Unique actor ID

NameFirst

Text (50 chars)

Actor's (stage) first name

NameLast

Text (50 chars)

Actor's (stage) last name

Age

Numeric

Actor's (stage) age

NameFirstReal

Text (50 chars)

Actor's ...

Get macromedia® Coldfusion® MX 7 Web Application Construction Kit now with O’Reilly online learning.

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