Database driven website to collect survey data

A website for creating and collecting survey data. Different roles and tasks as below. Admin backend Corporate data target entity – Name, Bloomberg Ticker, Country, Bloomberg sub GICS sector code, Exchange, Financial year end, Price Currency, Financials Currency, dummy 1, dummy 2, dummy 3, dummy 4 Default Collection datapoints – Frequency – Annual, Semi annual, Quarterly Financial year end – March 31, June 30, Sep 30, Dec 31 Default Collection datapoints – Annual Default Collection datapoints – Quarterly Analysts assigned for survey – Assign, edit, delete Buyside subscriber Firm Firm Name Sub entity name Subscriber Email Password Data inputting analyst Firm name Analyst name – login password Site editor – Add, modify and delete data for any analyst Permissions table – Assign access for a particular person across a matrix of corporates and Data Inputting Analysts Editor Buyside subscriber firm Request a new entity Request a new data input analyst Request access for a new member Add additional data points to a company – Assign the data points to specific analyst pool Data inputting analyst Add an estimate – Company name or ticker, Common data points Specific data points Change specific to common Email Templates Remind data inputting analysts for incomplete data with link and periodically Reporting Dashboard of which analysts have provided or not provided estimates Completion rate Data storage all confirmed entries are recorded and logged. Historic changes to data too. less