mpaa_rating
person
customer_account
CUSTOMER_ACCOUNT_ID
CUSTOMER_HOLD_INDIC
DATE_ENROLLED
DATE_TERMINATED
CUSTOMER_DEPOSIT_AMOUNT
CREDIT_CARD_ON_FILE_INDIC
CHILD_RENTAL_ALLOWED_INDIC
customer_account_person
CUSTOMER_ACCOUNT_ID
PERSON_ID
customer_transaction
TRANSACTION_ID
EMPLOYEE_PERSON_ID
CUSTOMER_ACCOUNT_ID
TRANSACTION_DATE
SALES_TAX
employee
PERSON_ID
SUPERVISOR_PERSON_ID
EMPLOYEE_TAX_ID
EMPLOYEE_JOB_CATEGORY
EMPLOYEE_HOURLY_RATE
HIRE_DATE
TERMINATION_DATE
language
LANGUAGE_CODE
LANGUAGE_NAME
movie
MOVIE_ID
MOVIE_GENRE_CODE
MPAA_RATING_CODE
MOVIE_TITLE
RETAIL_PRICE_VHS
RETAIL_PRICE_DVD
YEAR_PRODUCED
movie_copy
MOVIE_ID
COPY_NUMBER
DATE_ACQUIRED
DATE_SOLD
MEDIA_FORMAT
movie_genre
MOVIE_GENRE_CODE
MOVIE_GENRE_DESCRIPTION
movie_language
MOVIE_ID
LANGUAGE_CODE
movie_rental
MOVIE_ID
COPY_NUMBER
TRANSACTION_ID
DUE_DATE
RENTAL_FEE
LATE_OR_LOSS_FEE
RETURNED_DATE
mpaa_rating
MPAA_RATING_CODE
MPAA_RATING_DESCRIPTION
person
PERSON_ID
PERSON_GIVEN_NAME
PERSON_MIDDLE_NAME
PERSON_FAMILY_NAME
PERSON_ADDRESS_1
PERSON_ADDRESS_2
PERSON_ADDRESS_CITY
PERSON_ADDRESS_STATE_PROV
PERSON_ADDRESS_POSTAL_CODE
PERSON_ADDRESS_COUNTRY
PERSON_PHONE
BIRTH_DATE
DEATH_DATE
This group of table is about the customers.
Project DbSchema sample project
Layout AllTables
build using DbSchema
Sample Database Schema
Move the mouse over tables and columns to see the tooltip comments.
Generated using DbSchema.com