为用户配置文件创建mysql数据库

I need to create a database in which there are 3 tables one is FRIENDS second is USERS third is PICTURES. I have one to many relatioship between users and friends. There is one to many relationship between users and pictures table. I have red a question here with heading structuring a database for user profiles but it was lilbit confusing. They have userid as foreign key but i think picture id should be foreign key in users table.I need to create a database in which there are