O'Reilly logo

macromedia® Coldfusion® MX 7 Web Application Construction Kit by Angela Buraglia, Leon Chalnick, Raymond Camden, Ben Forta

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

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