Story #70 Update database to store vehicle information | Technical Documentation - cseseniordesign/reservations GitHub Wiki

Technical Documentation

Database

• Changes within the database:
  • Added new table vehicles to hold vehicles. It contains the following fields.
    • id INT NOT NULL,
    • license_plate VARCHAR(255) NULL,
    • state VARCHAR(255) NULL,
    • make VARCHAR(255) NULL,
    • model VARCHAR(255) NULL,
    • user_id INT(11) NULL, (Foreign Key connected to 'users' table to connect the vehicle to the user)