Build a Website

The is a mapping website program interface: 1. End-user interface for user login and out. The user interface to Create an account with password 2. When a user logs in they create a project. 3. The user will create a project 4. Once the project is created the user will create a location, excel spreadsheet will be provided of what the mysql structure for a location will look like. There can be multiple locations in a project which the end-user can define. End_users can create multiple tables (dimesions) within a location, for example table 1 mapping structure of source to target, table 2 business_unit structure source to target, table 3 product structure source to target etc… 5. The SQL structure within these dimentions should be joined so for example: In location SAP_01 with target account 2345675, is joined to Business_unit 100 on table business_unit. This relational structure needs to be defined on all tables (dimensions) within the location and project. 6. The users should be able to select if the location is a one to many or a many to one data model. Attached is excel worksheet which should explain the structure. 7. Download option where users can define the order and which columns from each dimension e.g. accounts, products, business_unit to a txt or csv file format. (download from individual dimensions not together)