Model Referenced Models Entities
Movies Director, Movie, MovieRole, PlotSummary, Review, Studio, Talent, TalentPhoto, Voting
Rentals Movies CreditCard, Customer, Fee, FeeType, Rental, RentalTerms, Unit, User, Video



Movies

Connection Dictionary
Key Value
databaseEncoding ISO Latin-1
URL jdbc:openbase://127.0.0.1/WOMovies
LC_ALL iso_1
Adaptor Name JDBC


Entities
Name Table Class Name
Director DIRECTOR EOGenericRecord
Movie MOVIE EOGenericRecord
MovieRole MOVIE_ROLE webobjectsexamples.businesslogic.movies.common.MovieRole
PlotSummary PLOT_SUMMARY EOGenericRecord
Review REVIEW EOGenericRecord
Studio STUDIO webobjectsexamples.businesslogic.movies.server.Studio
Talent TALENT webobjectsexamples.businesslogic.movies.common.Talent
TalentPhoto TALENT_PHOTO webobjectsexamples.businesslogic.movies.common.TalentPhoto
Voting VOTING webobjectsexamples.businesslogic.movies.common.Voting



Entity: Director

Model Movies
Class Inheritance EOGenericRecord
External Name DIRECTOR


Attributes
Properties Database Definition
Name         Value Class Column Ext. Type Value Type
movieID         Number MOVIE_ID long(9) i
talentID         Number TALENT_ID long(9) i


Relationships
Property Join Options
Name   Destination Source Attrs Destination Attrs Req Delete Propagate PK Owns Dest Batch Fault
toMovie     Movie movieID movieID   Nullify    
toTalent     Talent talentID talentID   Nullify    


Entity: Movie

Model Movies
Class Inheritance EOGenericRecord
External Name MOVIE


Attributes
Properties Database Definition
Name         Value Class Column Ext. Type Value Type
category         String CATEGORY char(20)
dateReleased         NSTimestamp DATE_RELEASED datetime
movieID         Number MOVIE_ID long(9) i
posterName         String POSTER_NAME char(255)
rated         String RATED char(10)
revenue         BigDecimal REVENUE money(10,2) B
studioID         Number STUDIO_ID long i
title         String TITLE char(255)
trailerName         String TRAILER_NAME char(255)


Relationships
Property Join Options
Name   Destination Source Attrs Destination Attrs Definition Req Delete Propagate PK Owns Dest Batch Fault
directors     Talent toDirector.toTalent   Nullify    
plotSummary     PlotSummary movieID movieID   Cascade    
reviews     Review movieID movieID   Cascade    
roles     MovieRole movieID movieID   Cascade     20
studio     Studio studioID studioID   Nullify    
toDirector     Director movieID movieID   Cascade    
voting     Voting movieID movieID   Cascade    


Fetch Specifications
Name Qualifier Bindings Sort Orderings Prefetching Deep Raw
DeepFetchOneMovie (movieID = $myMovie) Number myMovie roles
roles.talent
roles.talent.photo
directors
plotSummary
reviews
studio
voting		    
QualifierVariable ((studio = $studio) or (title caseInsensitiveLike $title) or (studio.name caseInsensitiveLike $studioName) or (revenue > $revenue)) String title,
webobjectsexamples.businesslogic.movies.server.Studio studio,
BigDecimal revenue,
String studioName		    
RawFetchAllMovies
title
    


Entity: MovieRole

Model Movies
Class Inheritance webobjectsexamples.businesslogic.movies.common.MovieRole
External Name MOVIE_ROLE


Attributes
Properties Database Definition
Name         Value Class Column Ext. Type Value Type
movieID         Number MOVIE_ID long(9) i
roleName         String ROLE_NAME char(30)
talentID         Number TALENT_ID long(9) i


Relationships
Property Join Options
Name   Destination Source Attrs Destination Attrs Req Delete Propagate PK Owns Dest Batch Fault
movie     Movie movieID movieID   Nullify    
talent     Talent talentID talentID   Nullify    


Entity: PlotSummary

Model Movies
Class Inheritance EOGenericRecord
External Name PLOT_SUMMARY


Attributes
Properties Database Definition
Name         Value Class Column Ext. Type Value Type
movieID         Number MOVIE_ID long(9) i
summary         String SUMMARY object


Relationships
Property Join Options
Name   Destination Source Attrs Destination Attrs Req Delete Propagate PK Owns Dest Batch Fault
movie     Movie movieID movieID   Nullify    


Entity: Review

Model Movies
Class Inheritance EOGenericRecord
External Name REVIEW


Attributes
Properties Database Definition
Name         Value Class Column Ext. Type Value Type
movieID         Number MOVIE_ID long(9) i
review         String REVIEW object
reviewID         Number REVIEW_ID long(9) i
reviewer         String REVIEWER char(50)


Relationships
Property Join Options
Name   Destination Source Attrs Destination Attrs Req Delete Propagate PK Owns Dest Batch Fault
movie     Movie movieID movieID   Nullify    


Entity: Studio

Model Movies
Class Inheritance webobjectsexamples.businesslogic.movies.server.Studio
External Name STUDIO


Attributes
Properties Database Definition
Name         Value Class Column Ext. Type Value Type
budget         BigDecimal BUDGET money(15,2) B
name         String NAME char(40)
studioID         Number STUDIO_ID long(9) i


Relationships
Property Join Options
Name   Destination Source Attrs Destination Attrs Req Delete Propagate PK Owns Dest Batch Fault
movies     Movie studioID studioID   Nullify    


Fetch Specifications
Name Qualifier Bindings Sort Orderings Raw
RawFetchAllStudios  


Entity: Talent

Model Movies
Class Inheritance webobjectsexamples.businesslogic.movies.common.Talent
External Name TALENT


Attributes
Properties Database Definition
Name         Value Class Column Ext. Type Value Type
firstName         String FIRST_NAME char(20)
lastName         String LAST_NAME char(30)
talentID         Number TALENT_ID long(9) i


Relationships
Property Join Options
Name   Destination Source Attrs Destination Attrs Definition Req Delete Propagate PK Owns Dest Batch Fault
moviesDirected     Movie toDirector.toMovie   Nullify    
photo     TalentPhoto talentID talentID   Cascade    
roles     MovieRole talentID talentID   Deny     20
toDirector     Director talentID talentID   Deny     20


Entity: TalentPhoto

Model Movies
Class Inheritance webobjectsexamples.businesslogic.movies.common.TalentPhoto
External Name TALENT_PHOTO


Attributes
Properties Database Definition
Name         Value Class Column Ext. Type Value Type
photo         NSData PHOTO object
talentID         Number TALENT_ID long(9) i


Relationships
Property Join Options
Name   Destination Source Attrs Destination Attrs Req Delete Propagate PK Owns Dest Batch Fault
talent     Talent talentID talentID   Nullify    


Entity: Voting

Model Movies
Class Inheritance webobjectsexamples.businesslogic.movies.common.Voting
External Name VOTING


Attributes
Properties Database Definition
Name         Value Class Column Ext. Type Value Type
movieID         Number MOVIE_ID long(9) i
numberOfVotes         Number NUMBER_OF_VOTES long(9) i
runningAverage         Number RUNNING_AVERAGE float(9,20) d


Relationships
Property Join Options
Name   Destination Source Attrs Destination Attrs Req Delete Propagate PK Owns Dest Batch Fault
movie     Movie movieID movieID   Nullify    


Rentals

Connection Dictionary
Key Value
databaseEncoding ISO Latin-1
URL jdbc:openbase://127.0.0.1/WOMovies
LC_ALL iso_1
Referenced Models Movies
Adaptor Name JDBC


Entities
Name Table Class Name
CreditCard CREDIT_CARD webobjectsexamples.businesslogic.rentals.common.CreditCard
Customer CUSTOMER webobjectsexamples.businesslogic.rentals.common.Customer
Fee FEE webobjectsexamples.businesslogic.rentals.common.Fee
FeeType FEE_TYPE webobjectsexamples.businesslogic.rentals.common.FeeType
Rental RENTAL webobjectsexamples.businesslogic.rentals.common.Rental
RentalTerms RENTAL_TERMS webobjectsexamples.businesslogic.rentals.common.RentalTerms
Unit UNIT webobjectsexamples.businesslogic.rentals.common.Unit
User RENTALS_USER webobjectsexamples.businesslogic.rentals.common.User
Video VIDEO webobjectsexamples.businesslogic.rentals.common.Video



Entity: CreditCard

Model Rentals
Class Inheritance webobjectsexamples.businesslogic.rentals.common.CreditCard
External Name CREDIT_CARD


Attributes
Properties Database Definition
Name         Value Class Column Ext. Type Value Type
authorizationDate         NSTimestamp AUTHORIZATION_DATE datetime
authorizationNum         String AUTHORIZATION_NUM char(10)
cardNumber         String CARD_NUMBER char(25)
customerID         Number CUSTOMER_ID long(9) i
expirationDate         NSTimestamp EXPIRATION_DATE datetime
limit         BigDecimal CLIMIT money(10,2) B


Relationships
Property Join Options
Name   Destination Source Attrs Destination Attrs Req Delete Propagate PK Owns Dest Batch Fault
customer     Customer customerID customerID   Nullify    


Entity: Customer

Model Rentals
Class Inheritance webobjectsexamples.businesslogic.rentals.common.Customer
External Name CUSTOMER


Attributes
Properties Database Definition
Name         Value Class Column Ext. Type Value Type
city         String CITY char(20)
customerID         Number CUSTOMER_ID long(9) i
firstName         String FIRST_NAME char(20)
lastName         String LAST_NAME char(30)
memberSince         NSTimestamp MEMBER_SINCE datetime
phone         String PHONE char(10)
state         String STATE char(2)
streetAddress         String STREET_ADDRESS char(50)
zip         String ZIP char(10)


Relationships
Property Join Options
Name   Destination Source Attrs Destination Attrs Definition Req Delete Propagate PK Owns Dest Batch Fault
creditCard     CreditCard customerID customerID   Cascade    
outRentals     Rental customerID customerID   Deny     5
rentals     Rental customerID customerID   Deny     5
unpaidFees     Fee rentals.fees   Nullify    


Entity: Fee

Model Rentals
Class Inheritance webobjectsexamples.businesslogic.rentals.common.Fee
External Name FEE


Attributes
Properties Database Definition
Name         Value Class Column Ext. Type Value Type
amount         BigDecimal AMOUNT money(10,2) B
datePaid         NSTimestamp DATE_PAID datetime
feeID         Number FEE_ID long(9) i
feeTypeID         Number FEE_TYPE_ID long(9) i
rentalID         Number RENTAL_ID long(9) i


Relationships
Property Join Options
Name   Destination Source Attrs Destination Attrs Req Delete Propagate PK Owns Dest Batch Fault
feeType     FeeType feeTypeID feeTypeID   Nullify    
rental     Rental rentalID rentalID   Nullify    


Entity: FeeType

Model Rentals
Class Inheritance webobjectsexamples.businesslogic.rentals.common.FeeType
External Name FEE_TYPE


Attributes
Properties Database Definition
Name         Value Class Column Ext. Type Value Type
enabled         Number ENABLED long(9) i
feeType         String FEE_TYPE char(15)
feeTypeID         Number FEE_TYPE_ID long(9) i
orderBy         Number ORDER_BY long(9) i


Relationships
Property Join Options
Name   Destination Source Attrs Destination Attrs Req Delete Propagate PK Owns Dest Batch Fault
fees     Fee feeTypeID feeTypeID   Nullify    


Entity: Rental

Model Rentals
Class Inheritance webobjectsexamples.businesslogic.rentals.common.Rental
External Name RENTAL


Attributes
Properties Database Definition
Name         Value Class Column Ext. Type Value Type
customerID         Number CUSTOMER_ID long(9) i
dateOut         NSTimestamp DATE_OUT datetime
dateReturned         NSTimestamp DATE_RETURNED datetime
rentalID         Number RENTAL_ID long(9) i
unitID         Number UNIT_ID long(9) i


Relationships
Property Join Options
Name   Destination Source Attrs Destination Attrs Req Delete Propagate PK Owns Dest Batch Fault
customer     Customer customerID customerID   Nullify    
fees     Fee rentalID rentalID   Cascade    
unit     Unit unitID unitID   Nullify    


Entity: RentalTerms

Model Rentals
Class Inheritance webobjectsexamples.businesslogic.rentals.common.RentalTerms
External Name RENTAL_TERMS


Attributes
Properties Database Definition
Name         Value Class Column Ext. Type Value Type
checkOutLength         Number CHECK_OUT_LENGTH long i
cost         BigDecimal COST money(10,2) B
depositAmount         BigDecimal DEPOSIT_AMOUNT money(10,2) B
name         String NAME char(20)
rentalTermsID         Number RENTAL_TERM_ID long(9) i


Relationships
Property Join Options
Name   Destination Source Attrs Destination Attrs Req Delete Propagate PK Owns Dest Batch Fault
videos     Video rentalTermsID rentalTermsID   Deny    


Entity: Unit

Model Rentals
Class Inheritance webobjectsexamples.businesslogic.rentals.common.Unit
External Name UNIT


Attributes
Properties Database Definition
Name         Value Class Column Ext. Type Value Type
dateAcquired         NSTimestamp DATE_ACQUIRED datetime
notes         String NOTES char(255)
unitID         Number UNIT_ID long(9) i
videoID         Number VIDEO_ID long(9) i


Relationships
Property Join Options
Name   Destination Source Attrs Destination Attrs Req Delete Propagate PK Owns Dest Batch Fault
rentals     Rental unitID unitID   Deny     20
video     Video videoID videoID   Nullify    


Fetch Specifications
Name Qualifier Bindings Sort Orderings Prefetching Deep
prefetchVideoMovie video
video.movie
rentals		  


Entity: User

Model Rentals
Class Inheritance webobjectsexamples.businesslogic.rentals.common.User
External Name RENTALS_USER


Attributes
Properties Database Definition
Name         Value Class Column Ext. Type Value Type
accessLevel         Number ACCESS_LEVEL long(9) i
customerID         Number CUSTOMER_ID long(9) i
password         String PASSWORD char(20)
userID         Number USER_ID long(9) i
username         String LOGIN char(20)


Relationships
Property Join Options
Name   Destination Source Attrs Destination Attrs Req Delete Propagate PK Owns Dest Batch Fault
customer     Customer customerID customerID   Nullify    


Fetch Specifications
Name Qualifier Bindings Sort Orderings Deep
login ((username = $user) and (password = $password)) String user,
String password		  


Entity: Video

Model Rentals
Class Inheritance webobjectsexamples.businesslogic.rentals.common.Video
External Name VIDEO


Attributes
Properties Database Definition
Name         Value Class Column Ext. Type Value Type
movieID         Number MOVIE_ID long(9) i
rentalTermsID         Number RENTAL_TERMS_ID long(9) i
videoID         Number VIDEO_ID long(9) i


Relationships
Property Join Options
Name   Destination Source Attrs Destination Attrs Req Delete Propagate PK Owns Dest Batch Fault
movie     Movie (Movies) movieID movieID   Nullify    
rentalTerms     RentalTerms rentalTermsID rentalTermsID   Nullify    
units     Unit videoID videoID   Deny