We are looking for a programmer to create a web database that will allow us to manage all of our clients' social media accounts which will include the following fields:
Date of Creation
Account Genre (will will include the following drop downs. Only one can be selected)
Account Type (which will include the following)
Account Name which will include a drop down of the appropriate social media sites for each of the account types above. This could also be a check box so that we could select multiple sites that happen to share the same userid/passwords.
For each of the above accounts/sites we will need to record the credentials which will include a userid and password.
Since the accounts selected may have the same creds on every account we need to make this data input very easy with perhaps the option to select.
We need to have the ability for the application to add new accounts, new social media sites as they are created, and to modify existing accounts.
We also would like to be able to sort the data by the following variables.
Sort by Genre and find all accounts in a given genre
Extract a list of accounts by type of account (social network, article directory, social bookmarking).
Extract all accounts, regardless of genre, by their type of account (i.e. social bookmarking).
The last module is two pronged. We want to be able to write the activities that have been created in each account, what client site was used, what tasks were done, and with what account. We'd like to be able to produce this information in a report format, and what tasks were done on each social account. This last bit would be for that we're looking for a programmer who can also create.