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