I need a DB expert for realizing a schema I will give to right developer.
You can use mysql.
The DB will accept a lot of data simultaneasly, let's a lot of user registration, uploading photo etc, so should be implemented some indexes or partition for increase the accessess.
I need a .mysql the creates the DB with all tables, foreign key, indexes and all stuff you have to consider. The schema is quite simple.