1 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 CUSTOMER_ACCOUNT_ID EMPLOYEE_PERSON_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 is the main layout, with all tables. The other layouts are layouts are focused on a specific part of the schema. One table may appear in multiple layouts. You can edit a table, column, etc. by double-clicking it. Layouts are saved in the disk project file and will be reopened by next application restart. Layout All Tables Layout Project DbSchema Sample Project by DbSchema

Table CUSTOMER_ACCOUNT
Diagrams are great
CUSTOMER_ACCOUNT_ID INTEGER NOT NULL
CUSTOMER_HOLD_INDIC CHAR( 1 ) NOT NULL DEFO N
DATE_ENROLLED DATE NOT NULL
DATE_TERMINATED DATE
CUSTOMER_DEPOSIT_AMOUNT NUMERIC( 5, 2 )
CREDIT_CARD_ON_FILE_INDIC CHAR( 1 ) NOT NULL
CHILD_RENTAL_ALLOWED_INDIC CHAR( 1 ) NOT NULL
Indexes
SQL091125142320572 primary key ( CUSTOMER_ACCOUNT_ID)


Table CUSTOMER_ACCOUNT_PERSON
CUSTOMER_ACCOUNT_ID INTEGER NOT NULL
PERSON_ID INTEGER NOT NULL
Indexes
SQL091125142321960 primary key ( CUSTOMER_ACCOUNT_ID, PERSON_ID)
SQL091125142321961 ( PERSON_ID)
SQL091125142321962 ( CUSTOMER_ACCOUNT_ID)
Foreign Keys
SQL091125142321962 ( CUSTOMER_ACCOUNT_ID ) ref CUSTOMER_ACCOUNT ( CUSTOMER_ACCOUNT_ID )
SQL091125142321961 ( PERSON_ID ) ref PERSON ( PERSON_ID )


Table CUSTOMER_TRANSACTION
TRANSACTION_ID INTEGER NOT NULL
CUSTOMER_ACCOUNT_ID INTEGER NOT NULL
EMPLOYEE_PERSON_ID INTEGER NOT NULL
TRANSACTION_DATE DATE NOT NULL
SALES_TAX NUMERIC( 5, 2 ) NOT NULL
Indexes
SQL091125142322110 primary key ( TRANSACTION_ID)
SQL091125142322111 ( EMPLOYEE_PERSON_ID)
SQL091125142322112 ( CUSTOMER_ACCOUNT_ID)
Foreign Keys
SQL091125142322112 ( CUSTOMER_ACCOUNT_ID ) ref CUSTOMER_ACCOUNT ( CUSTOMER_ACCOUNT_ID ) Foreign Keys can be created by dragging the Primary column over other table or column
SQL091125142322111 ( EMPLOYEE_PERSON_ID ) ref EMPLOYEE ( PERSON_ID )


Table EMPLOYEE
PERSON_ID INTEGER NOT NULL
SUPERVISOR_PERSON_ID INTEGER
EMPLOYEE_TAX_ID VARCHAR( 15 ) NOT NULL
EMPLOYEE_JOB_CATEGORY CHAR( 1 ) NOT NULL
EMPLOYEE_HOURLY_RATE NUMERIC( 5, 2 ) NOT NULL
HIRE_DATE DATE NOT NULL
TERMINATION_DATE DATE
Indexes
SQL091125142321731 primary key ( PERSON_ID)
SQL091125142321733 ( SUPERVISOR_PERSON_ID)
Foreign Keys
SQL091125142321733 ( SUPERVISOR_PERSON_ID ) ref EMPLOYEE ( PERSON_ID )
SQL091125142321732 ( PERSON_ID ) ref PERSON ( PERSON_ID )


Table LANGUAGE
LANGUAGE_CODE CHAR( 2 ) NOT NULL
LANGUAGE_NAME VARCHAR( 40 ) NOT NULL
Indexes
SQL091125142320850 primary key ( LANGUAGE_CODE)


Table MOVIE
This is a group of tables. For each table you can see the columns and the foreign keys. From the menu you can switch the foreign key drawing between joined to column and join to table. By moving the mouse cursor over columns you can see the tables and columns tooltips.
MOVIE_ID INTEGER NOT NULL
MOVIE_GENRE_CODE CHAR( 5 ) NOT NULL
MPAA_RATING_CODE CHAR( 5 ) NOT NULL
MOVIE_TITLE VARCHAR( 100 ) NOT NULL
RETAIL_PRICE_VHS NUMERIC( 5, 2 )
RETAIL_PRICE_DVD NUMERIC( 5, 2 )
YEAR_PRODUCED CHAR( 4 )
Indexes
SQL091125142321170 primary key ( MOVIE_ID)
IX_MOVIE_TITLE ( MOVIE_TITLE)
SQL091125142321171 ( MOVIE_GENRE_CODE)
SQL091125142321180 ( MPAA_RATING_CODE)
Foreign Keys
SQL091125142321171 ( MOVIE_GENRE_CODE ) ref MOVIE_GENRE ( MOVIE_GENRE_CODE )
SQL091125142321180 ( MPAA_RATING_CODE ) ref MPAA_RATING ( MPAA_RATING_CODE )


Table MOVIE_COPY
MOVIE_ID INTEGER NOT NULL
COPY_NUMBER INTEGER NOT NULL
DATE_ACQUIRED DATE NOT NULL
DATE_SOLD DATE
MEDIA_FORMAT CHAR( 1 ) NOT NULL
Indexes
SQL091125142321431 primary key ( MOVIE_ID, COPY_NUMBER)
SQL091125142321432 ( MOVIE_ID)
Foreign Keys
SQL091125142321432 ( MOVIE_ID ) ref MOVIE ( MOVIE_ID )


Table MOVIE_GENRE
MOVIE_GENRE_CODE CHAR( 5 ) NOT NULL
MOVIE_GENRE_DESCRIPTION VARCHAR( 100 ) NOT NULL
Indexes
SQL091125142320940 primary key ( MOVIE_GENRE_CODE)


Table MOVIE_LANGUAGE
MOVIE_ID INTEGER NOT NULL
LANGUAGE_CODE CHAR( 2 ) NOT NULL
Indexes
SQL091125142321550 primary key ( MOVIE_ID, LANGUAGE_CODE)
SQL091125142321551 ( LANGUAGE_CODE)
SQL091125142321552 ( MOVIE_ID)
Foreign Keys
SQL091125142321551 ( LANGUAGE_CODE ) ref LANGUAGE ( LANGUAGE_CODE )
SQL091125142321552 ( MOVIE_ID ) ref MOVIE ( MOVIE_ID )


Table MOVIE_RENTAL
MOVIE_ID INTEGER NOT NULL
COPY_NUMBER INTEGER NOT NULL
TRANSACTION_ID INTEGER NOT NULL This icon indicates the presence of a foreign key to/from this column. Add the table from the other end of the foreign key to the layout by clicking the icon.
DUE_DATE DATE
RENTAL_FEE NUMERIC( 7, 2 )
LATE_OR_LOSS_FEE NUMERIC( 5, 2 )
RETURNED_DATE DATE
Indexes
SQL091125142322330 primary key ( MOVIE_ID, COPY_NUMBER, TRANSACTION_ID)
SQL091125142322331 ( MOVIE_ID, COPY_NUMBER)
SQL091125142322332 ( TRANSACTION_ID)
Foreign Keys
SQL091125142322332 ( TRANSACTION_ID ) ref CUSTOMER_TRANSACTION ( TRANSACTION_ID )
SQL091125142322331 ( MOVIE_ID , COPY_NUMBER ) ref MOVIE_COPY ( MOVIE_ID , COPY_NUMBER )


Table MPAA_RATING
MPAA_RATING_CODE CHAR( 5 ) NOT NULL
MPAA_RATING_DESCRIPTION VARCHAR( 100 ) NOT NULL
Indexes
SQL091125142320980 primary key ( MPAA_RATING_CODE)


Table PERSON
PERSON_ID INTEGER NOT NULL
PERSON_GIVEN_NAME VARCHAR( 25 ) NOT NULL
PERSON_MIDDLE_NAME VARCHAR( 25 )
PERSON_FAMILY_NAME VARCHAR( 25 ) NOT NULL
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
Indexes
SQL091125142321090 primary key ( PERSON_ID)