mpaa_rating
person
customer_account
CUSTOMER_ACCOUNT_ID : INT(11)
CUSTOMER_HOLD_INDIC : CHAR(1)
DATE_ENROLLED : DATE
DATE_TERMINATED : DATE
CUSTOMER_DEPOSIT_AMOUNT : DECIMAL(5)
CREDIT_CARD_ON_FILE_INDIC : CHAR(1)
CHILD_RENTAL_ALLOWED_INDIC : CHAR(1)
customer_account_person
CUSTOMER_ACCOUNT_ID : INT(11)
PERSON_ID : INT(11)
customer_transaction
TRANSACTION_ID : INT(11)
EMPLOYEE_PERSON_ID : INT(11)
CUSTOMER_ACCOUNT_ID : INT(11)
TRANSACTION_DATE : DATE
SALES_TAX : DECIMAL(5)
employee
PERSON_ID : INT(11)
SUPERVISOR_PERSON_ID : INT(11)
EMPLOYEE_TAX_ID : VARCHAR(15)
EMPLOYEE_JOB_CATEGORY : CHAR(1)
EMPLOYEE_HOURLY_RATE : DECIMAL(5)
HIRE_DATE : DATE
TERMINATION_DATE : DATE
language
LANGUAGE_CODE : CHAR(2)
LANGUAGE_NAME : VARCHAR(40)
movie
MOVIE_ID : INT(11)
MOVIE_GENRE_CODE : CHAR(5)
MPAA_RATING_CODE : CHAR(5)
MOVIE_TITLE : VARCHAR(100)
RETAIL_PRICE_VHS : DECIMAL(5)
RETAIL_PRICE_DVD : DECIMAL(5)
YEAR_PRODUCED : CHAR(4)
movie_copy
MOVIE_ID : INT(11)
COPY_NUMBER : INT(11)
DATE_ACQUIRED : DATE
DATE_SOLD : DATE
MEDIA_FORMAT : CHAR(1)
movie_genre
MOVIE_GENRE_CODE : CHAR(5)
MOVIE_GENRE_DESCRIPTION : VARCHAR(100)
movie_language
MOVIE_ID : INT(11)
LANGUAGE_CODE : CHAR(2)
movie_rental
MOVIE_ID : INT(11)
COPY_NUMBER : INT(11)
TRANSACTION_ID : INT(11)
DUE_DATE : DATE
RENTAL_FEE : DECIMAL(7)
LATE_OR_LOSS_FEE : DECIMAL(5)
RETURNED_DATE : DATE
mpaa_rating
MPAA_RATING_CODE : CHAR(5)
MPAA_RATING_DESCRIPTION : VARCHAR(100)
person
PERSON_ID : INT(11)
PERSON_GIVEN_NAME : VARCHAR(25)
PERSON_MIDDLE_NAME : VARCHAR(25)
PERSON_FAMILY_NAME : VARCHAR(25)
PERSON_ADDRESS_1 : VARCHAR(100)
PERSON_ADDRESS_2 : VARCHAR(100)
PERSON_ADDRESS_CITY : VARCHAR(40)
PERSON_ADDRESS_STATE_PROV : CHAR(2)
PERSON_ADDRESS_POSTAL_CODE : VARCHAR(10)
PERSON_ADDRESS_COUNTRY : CHAR(2)
PERSON_PHONE : VARCHAR(15)
BIRTH_DATE : DATE
DEATH_DATE : DATE
Informations about movies
This is a group of tables
Data about a person
Layout AllTables
Project DbSchema sample project
Generated at 19 Jul 2010 using
DbSchema