The Actors Table

The Actors table (Table 5.6) contains the list of actors. This table is related to the Films table via the FilmsActors table.

Table 5.6. The Actors Table
ColumnData TypeDescription and Size
ActorIDNumericUnique ID for each actor; can be populated manually when rows are inserted or automatically (if defined as an Auto Number field)
NameFirstTextActor’s first name
NameLastTextActor’s last name
AgeNumericActor’s age
NameFirstRealTextActor’s real first name
NameLastRealTextActor’s real last name
AgeRealNumericActor’s real age (this one actually increases each year)
IsEgomaniacBit or Yes/NoFlag specifying whether actor is an egomaniac
IsTotalBabeBit or Yes/NoFlag specifying whether actor is a total babe
GenderTextActor’s gender (M or F)

The ...

Get Adobe ColdFusion 8 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.