Stage 2:
need ability to add inspector
need ability to add frequency

# PlantBasedCertification

Table1 Company
company_id(pk)
company_code
commpany_name
company_address1
company_address2
company_city
company_province
company_postal_code
company_country
company_phone
company_fax
company_email
company_website
company_note
product_id(fk)
ingredient_id(fk)
private_label_id(fk)
facility_id(fk)
contact_id(fk)


Table2 Contact
contact_id (pk)
first_name
last_name
title
contact_phone (format should allow for extension)
contact_email
contact_password
company_id(fk)

Table3 Product
product_id(pk)
product_name
brand
ingredient_id(fk)?
company_id(fk)
product_eval_status (boolean)
product_eval_date
product_note
user_id(fk)
facility_id(fk)
pl_id(fk)

Table4 Ingredient
ingredient_id(pk)
ingredient_name
ingredient_eval_status
ingredient_eval_date
ingredient_note
user_id(fk)
product_id(fk)?
company_id(fk)
facility_id(fk)
pl_id(fk)


Table5 Facility
facility_id(pk)
facility_name
facility_address1
facility_address2
facility_city
facility_province
facility_postal_code
facility_country
facility_phone
company_id(fk)
product_id(fk)
ingredient_id(fk)

Table6 Private Label Company
pl_id(pk)
pl_name
pl_address1
pl_address2
pl_city
pl_province
pl_postal_code
pl_country
pl_phone
pl_fax
pl_email
pl_website
company_id(fk)
facility_id(fk)
contact_id(fk)

Table7 Users
user_id
username
password

tokens (see other project)


po

