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