RdsDiagram
Employess
ID: BIGINT
first name: BOOLEAN
last name: INTEGER
unit number: INTEGER
street nu mber: INTEGER
street name: INTEGER
phone number: INTEGER
date of birth: INTEGER
email: INTEGER
address id FK: INTEGER
manager id FK: INTEGER
position id: INTEGER
Location ID: BOOLEAN
Address
ID: INTEGER
suburb: INTEGER
state: INTEGER
country: INTEGER
postcode: INTEGER
Managers
ID: INTEGER
first name: INTEGER
last name: INTEGER
unit number: INTEGER
street number: INTEGER
street name: INTEGER
phone number: INTEGER
date of birth: INTEGER
email: INTEGER
address ID: INTEGER
Positons
position id: INTEGER
position name: INTEGER
Vehicles
license number: INTEGER
model: INTEGER
make: INTEGER
year: INTEGER
odometer: INTEGER
initial cost: INTEGER
depreciated cost: INTEGER
year of purchase: INTEGER
Maintenance
ID: INTEGER
date: INTEGER
next scheduled service: INTEGER
maintenance type id FK: INTEGER
EmployeeID FK: BIGINT
Maintenance types
type: INTEGER
Usual cost: INTEGER
Maintenance transactions
vehicle ID FK: INTEGER
MaintenanceID FK: INTEGER
units: INTEGER
Customers
ID: INTEGER
years of service: INTEGER
first name: INTEGER
last name: INTEGER
unit number: INTEGER
street number: INTEGER
street name: INTEGER
company name: INTEGER
phone number: INTEGER
email: INTEGER
discount amount: INTEGER
address ID: INTEGER
Rentals
Rental ID: INTEGER
date of hire: INTEGER
daily rate: INTEGER
number of hire days: INTEGER
deposit amount: INTEGER
get damage insurance: INTEGER
damage insurance amount: INTEGER
Employee ID FK: BIGINT
Customer ID FK: INTEGER
Rental Transactions
Rental ID FK: INTEGER
Vehicle ID FK: INTEGER
Locations
ID: BOOLEAN
name: INTEGER
street number: INTEGER
street name: INTEGER
address ID FK: INTEGER