Table name
0. County - Regions
-----------
countyCode
countyName
countylon
countylat

1. Location - Places
------------
loctionId
locationName
locationLon
locationLat
   
2.subLocation - Areas
------------
locationId
subLocationId
subLocationName
locationLat
locationLon


----------------- Categories--------------------

Categories
---------------
catId
catName
catDesc
catParent
catPic
catSortOrder

CustomFeatures
----------------
featId
featName
catId
---------------------

CREATE TABLE Cars (
    CarID INT PRIMARY KEY,
    Make VARCHAR(255) NOT NULL,
    Model VARCHAR(255) NOT NULL,
    Year INT NOT NULL,
    Trim VARCHAR(255),
);

CREATE TABLE Categories (
    CategoryID INT PRIMARY KEY,
    CategoryName VARCHAR(255) NOT NULL,
    Description TEXT,
    ParentCategoryID INT,
    FOREIGN KEY (ParentCategoryID) REFERENCES Categories(CategoryID)
);

CREATE TABLE Features (
    FeatureID INT PRIMARY KEY,
    FeatureName VARCHAR(255) NOT NULL,
    Description TEXT,
    StandardOptional VARCHAR(50),
);

CREATE TABLE CarCategories (
    CarCategoryID INT PRIMARY KEY,
    CarID INT,
    CategoryID INT,
    FOREIGN KEY (CarID) REFERENCES Cars(CarID),
    FOREIGN KEY (CategoryID) REFERENCES Categories(CategoryID)
);

CREATE TABLE CarFeatures (
    CarFeatureID INT PRIMARY KEY,
    CarID INT,
    FeatureID INT,
    FOREIGN KEY (CarID) REFERENCES Cars(CarID),
    FOREIGN KEY (FeatureID) REFERENCES Features(FeatureID)
);