eCommerce vs Starter Database(s)
How much overlap is there between these two "products"?
For reference
eCommerce Databse - ecommerce-database/
Database Starter Kit PHP - database-for-php/
I see a lot of similarities but also some differences that I was wondering why they weren't in the Free eCommerce Database whether we want to use them or not. It would be nice to just download a DB where we didn't have to add Columns for:
Company Name (userCompany)
Username (to login with something other than an email address)
userLevel (to allow certain permissions based on level)
productType (for physical or digital)
productImage 2/3/4 (for additional product images)
productThumb 2/3/4 (for the respective thumbnails)
productImageAltText 2/3/4 (for respective alternative text)
productHits (to track product views)
UserUnique (track unique/new users per day)
Please correct me if they are included somewhere and I missed it. I am still very much new to databases.
Now looking at the Free Starter Kit Database the Physical Goods database has a "visitors" table (which I believe is the "users" table) but it has both Billable and nonBillable options such as VisitorFirstName and VisitorBillName. Then it has a States_Provinces table that the eCommerce database does not.
The digital goods database has an itemDownload (store file name) and detailDownload (number of times downloaded per order) column.
6
It seems like these items should be the norm in a database. How should I successful implement these (along with the event_registration database) into the eCommerce DB??