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