How to add new companies

How to add new companies

Background

The current company system is build upon three tables:

companies
Stores information about it's Website, logo, information text to students

company_involvement
Stores information if and how a company is active in a given year

company_map_location
Stores information where in Nymble companies are located

Step by step

• Get access to phpMyAdmin of this website.
• If companyX you want to add do not already exist in the companies table, add it with basic information.
• Add companyX involvement by specifying if the company is a sponsor, exhibitor or a main sponsor for a given year in the company_involvement table. Remember that the year specified must exist in the exhibit_dates table.
• Add or edit the companies location in the company_map_location. This can be done later.
• Done!