Product Creation - Githubissues

As an employee, C-Suite Executive, or admin, I want to:

[x] be able to see all current products with all public and private properties belonging thereto
[x] be able to amend beginning and end dates for existing products
[x] be able to add and configure new products, including custom columns for them; be able to save drafts of products and continue configurations later
[x] as an admin, be able to see others' drafts as well; else, only the user's own drafts
[x] be able to see product categories and subcategories
[x] be able to add new product ~~categories and~~ subcategories (Note: there is an API for category creation, but because categories are directly related to images and contracts, they will be better done through a CR)
[x] make categories and subcategories visible

Additional db/config changes:

[x] change the product_categories and product_subcategories tables to include a column for visibility (connected to 7)
[x] change config for product_statuses.order_no, so that the completed statuses are last, applications are first, and everything else is in-between
[x] in the product_status_updates add column prime_uid which is a primary key and auto increments
[x] ~~add a product_notes column which refers to the product_status_updates.prime_uid~~
[x] change the picture, so that it does not have to be recorded in the repo but is dynamically loaded
[x] if the monetary amount or the percentage label is null, then don't display it
[x] the percentage_amount should not be decimalized
[x] in the product_custom_column_def table, add a column available_before

[!IMPORTANT] I have added a Foreign Key relationship for the product_custom_column_def.available_before column

In latest commit, I have done the following. The stricken down requirement is de-prioritized for now.

[x] change the product_categories and product_subcategories tables to include a column for visibility (connected to 7)
[ ] change config for product_statuses.order_no, so that the completed statuses are last, applications are first, and everything else is in-between
[x] in the product_status_updates add column prime_uid which is a primary key and auto increments
[ ] ~~add a product_notes column which refers to the product_status_updates.prime_uid~~
[x] change the picture, so that it does not have to be recorded in the repo but is dynamically loaded
[ ] if the monetary amount or the percentage label is null, then don't display it
[x] the percentage_amount should not be decimalized
[x] in the product_custom_column_def table, add a column available_before

[!IMPORTANT] I have added a Foreign Key relationship for the available_before column

alexander-yord / alex-bank