Movies
/ Movie
referenced by
Director
,
MovieRole
,
PlotSummary
,
Review
,
Studio
,
Voting
External Name
movie
Class Name
org.wocommunity.movies.model.server.Movie
Attributes
show details
hide non-class
category
CATEGORY
External Type
varchar50 (VARCHAR)
Allows Null?
Yes
Used For Locking?
Yes
Width
50
dateReleased
DATE_RELEASED
External Type
dateTime (DATETIME)
Allows Null?
Yes
Used For Locking?
Yes
movieID [primary key]
MOVIE_ID
External Type
id (INT)
Allows Null?
No
Used For Locking?
Yes
posterName
POSTER_NAME
External Type
varchar255 (VARCHAR)
Allows Null?
Yes
Used For Locking?
Yes
Width
255
rated
RATED
External Type
varchar10 (VARCHAR)
Allows Null?
Yes
Used For Locking?
Yes
Width
10
revenue
REVENUE
External Type
currencyAmount (DECIMAL)
Allows Null?
Yes
Used For Locking?
Yes
Scale
4
Precision
38
studioID
STUDIO_ID
External Type
id (INT)
Allows Null?
No
Used For Locking?
Yes
title
TITLE
External Type
varchar255 (VARCHAR)
Allows Null?
No
Used For Locking?
Yes
Width
255
trailerName
TRAILER_NAME
External Type
varchar255 (VARCHAR)
Allows Null?
Yes
Used For Locking?
Yes
Width
255
Relationships
show details
hide non-class
directors
Talent
via
toDirector
.
toTalent
Type
Flattened To-Many
plotSummary
PlotSummary
Type
Mandatory To-One
Joins
movieID
>
movieID
reviews
Review
Type
To-Many
Joins
movieID
>
movieID
roles
MovieRole
Type
To-Many
Joins
movieID
>
movieID
studio
Studio
Type
Mandatory To-One
Joins
studioID
>
studioID
toDirector
Director
Type
To-Many
Joins
movieID
>
movieID
voting
Voting
Type
Mandatory To-One
Joins
movieID
>
movieID
Fetch Specifications
show details
DeepFetchOneMovie
Qualifier
movieID = $myMovie
Fetch Limit
0
Deep Fetch?
true
Refreshes Refetched?
false
QualifierVariable
Qualifier
studio = $studio or title caseInsensitiveLike $title or studio.name caseInsensitiveLike $studioName or revenue > $revenue
Fetch Limit
0
Deep Fetch?
true
Refreshes Refetched?
false
RawFetchAllMovies
Qualifier
$fetchSpec.qualifier
Sort Orderings
title (asc)
Fetch Limit
0
Deep Fetch?
$fetchSpec.deep
Refreshes Refetched?
false
Entity Indexes
no entity indexes