eCommerce vs Starter Database(s)
How much overlap is there between these two "products"?
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.
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??