Hertz-UTS

Tables (3)

Car (cars.json)

  • Car ID (id) — Number — Primary key
  • Category (category) — String
  • Availability (availability) — Boolean
  • Brand (brand) — String
  • Model (model) — String
  • Model Year (modelYear) — Number
  • Mileage (mileage) — Number
  • Fuel Type (fuelType) — String
  • Seats (seats) — Number
  • Price/Day (pricePerDay) — Number
  • Description (description) — String

Customer Details (CUSTOMER_DETAILS)

  • Delivery Details ID (ID) — int — Primary key — NOT NULL
  • First Name (FIRST_NAME) — varchar(20)
  • Last Name (LAST_NAME) — varchar(20)
  • Address Line 1 (ADDRESS_LINE_1) — varchar(255)
  • Address Line 2 (ADDRESS_LINE_2) — varchar(255)
  • Suburb (SUBURB) — varchar(20)
  • Postcode (POSTCODE) — varchar(4)
  • State (STATE) — varchar(10)
  • Payment Type (PAYMENT_TYPE) — varchar(10)

Renting History (RENTING_HISTORY)

  • Renting History ID (ID) — int — Primary key — NOT NULL
  • Car ID (CAR_ID) — int — Foreign key → Car.Car ID
  • Customer Details ID (CUSTOMER_DETAILS_ID) — int — Foreign key → Customer Details.Delivery Details ID — NOT NULL
  • User Email (USER_EMAIL) — varchar(255)
  • Rent Date (RENT_DATE) — date
  • Return Date (RETURN_DATE) — date
  • Bond Amount (BOND_AMOUNT) — int