Issues with Database structure AND creating new things

So all, I have been moving and a grooving and learning as I go, hit a few snags but overcame… until now. Any help would be MUCH appreciated!

So here is the fictional app…
Companies, have users and have products.
User’s belong to companies and based upon the company can access/create/modify products.
From the products page, each product is given a randomly generated product number which is done via a calculate random string input field, the user can also select the date/time of product creation using the date/time picker. Each product has a set of product attributes, the user can by clicking on a plus sign, open a “hidden group” which via check boxes allows them to select one or many product attributes or type in a custom attribute and hit a add button for it to be added to the list of checkboxes for use now and for future company products (only the company gets the custom attributes they created as options not other companies).

So here are my issues, for some reason I can’t get anything in the page to save (using create new thing) everything shows as good, but DB fields for “products” remains empty… and that was just focusing on the product number and product creation date/time picker - I haven’t even tried to tie in the other stuff yet.

I am sure I am doing the product attributes wrong, I like the checklist approach but right now I just have created them individually and haven’t tied them into the DB - because any product could have multiple attributes… and the potentially custom added ones, should attributes be its own data type or just a field within products? How can you get the new custom ones added and be only available to the company that created them?
Right now products are their own data type and I am only linking them by a field “company” which should be tied to the current user’s company.

To add complexity… and I haven’t done this yet… I would like to add in a few different product categories, and creation modes… meaning when a company first logs in they must select a product category (they can only have one category, they could potentially switch in the future to a different category, which shared attributes would be migrated over, but for the products already created under the previous category, where there new fields that did not exist in the other category we simply provide the user the ability to fill in the data, or we show that this is a migrated product) based upon that category they are provided with specific options withing the page described above, also there is a Easy mode and an expert mode… the easy mode asks the user simple questions about the product which fills in the fields mentioned as they go along…(they can exit out of easy mode to expert mode at any time) expert mode just provides them the raw fields where they can input the information about the products directly.

I’m sorry… I know this is a lot… but hopefully my issues are clear and what I am trying to do is clear?
In other words, this is driving me crazy and any/all help is GREATLY appreciated!

This topic was automatically closed after 70 days. New replies are no longer allowed.