macromedia® Coldfusion® MX 7 Web Application Construction Kit

Appendix G. Sample Application Data Files

IN THIS APPENDIX

Sample Application Data Files 1333

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