Sunday, May 2, 2010

Social Network Database Design Sample - MySQL

sample database for a social network project – a mysql database schema
Database Engine: InnoDB (edit the mwb file if you need to change it to MyISAM or any other.)
the aspects of a social network i tried to cover in this database:
- user profile
- friends
- friends list
- status updates
- thumbs up/down status (these can be easily ported to other entities)
- bookmark saving
- rss/atom feeds saving
- notifications
- chat
- blog, site level not user level


- privacy
you can use these files for beginning a social n/w type projects in PHP/MySQL development environment.
when i was doing social network project, i searched here & there for database design of a social network, but what i found in the internet were not useful. they provided a introductory sketch about social network database structure but but as i had a limited  time frame for my project, those materials were not useful. i have analyzed most of the basic requirements for a  social network database structure, and sharing this with you so that it would save some of your time to start out your project. 
statusthe database is not completely normalized yet but you can edit it as per your needs. don't waste to much time on what  fields should i use for profile or for a status representation, these entity sets in the design will suffice in most of the cases. You can add entities for pictures, video, music sharing or anything you like. Just use the workbench design file.

Here are few books i'd recommend if you are willing to dive deep into MySQL and database designs

1. Beginning MySQL Database Design and Optimization: From Novice to Professional
2. High Performance MySQL: Optimization, Backups, and Replication

files included
following files are included
sns.7.0-.mwb - MySql WorkBench Design
sns.7.0.png - exported PNG from MySql workbench
sns7.0.sql - exported SQL from MySql Workbench
sns.yml - Doctrine Generated schema in YAML
you can use the MySQL WorkBench Designer available Open Source at & begin with the mwb file,
change it for your need, export to sql & use it for your project.
Download MySQL Social Network Database Design – Sample

Update 11/14/2011:
Many readers have requested how the project ended up in look.
So, here goes the slide we presented to Tribhuvan University (with formal details cut out).
Thanks for reading this post.

TimiHami a Nepali Social Network


  1. I read that Post and got it fine and informative. Please share more like that... smm panel

  2. A few marketers are having difficulties starting a business in social media marketing. If you are a marketer just go through our SMM Panel for everything. Thanks!

  3. Buy IG Followers,buy instagram followers cheap,buy instagram
    followers cheap,buy real instagram followers,buy facebook likes,buy instagram
    followers and likes
    if you are looking
    Buy Instagram Followersfor the best SMM panel online? Want to buy Instagram followers? Check
    out our website and learn more about how you can increase your followers today

  4. We add new presentation designs bi-weekly! This month, we added a variety of widescreen
    PowerPoint templates focused on 2021, business concepts and abstract animated designs.
    business presentation templates


  5. Fr. George Rutler was born in 1945 and raised an Episcopalian in New Jersey and New York. He served as an Episcopal priest for nine years and was the youngest Episcopal rector in the country when he headed the Church of the Good Shepherd in Rosemont, Pennsylvania.
    father george rutler

  6. He was received into the Catholic Church in 1979. He attended seminary at the North American College in Rome, was ordained to the diaconate by His Eminence William Cardinal Baum in 1980, and received priestly ordination in St. Patrick's Cathedral by His Eminence Terence Cardinal Cooke in 1981.
    father george rutler

  7. London, United Kingdom, Sept. 09, 2021 (GLOBE NEWSWIRE) -- Queens gate Investments recently decided to boost its website traffic, and build more brand awareness. This private investment firm based in London has primarily focused on supporting its investors and managing over $3 million worth of assets. Since its incredible team comprises of investment experts, financial advisors, and accountants, the company needed to hire an external team to take Queens gate to the next level.

  8. This year, Queens gate Investments hired Pearl Lemon, an award-winning SEO agency based in London. Pearl Lemon is a white-minority business with remote employees in Germany, India, the US, Uganda, and the Philippines. This international agency could give Queens gate Investments a fresh perspective on SEO and digital marketing strategies. This will be a lovely addition to the great talent within the Queens gate team.

  9. Although originally touted as a business mechanism to encourage self-employment for minorities, franchising has not lived up to initial expectations. While minority ownership in franchising in the USA has shown considerable growth over the last two decades, this has not been the case for Indigenous Australians. Indigenous business ownership in franchising remains low, even though a majority of franchisors are willing to recruit Indigenous employees and franchisees. This chapter aims to open a dialogue on the relative merits of utilizing a transitional self-employment pathway for Indigenous Australians through franchising.
    Maurice Rousetty

  10. We argue that such a hybridized approach may ameliorate systemic disadvantages that many Indigenous Australians face when considering entering small business. Data was gathered from a series of interviews with Indigenous business owners, franchise (third-party) advisors, Indigenous government agency representatives, franchisors and franchising educators. Our results highlight the pressing need to better address areas of disadvantage that have been raised in prior Indigenous Entrepreneurship and small business studies. Overall, our GROWTH-pathway approach and recommended courses of action, answer calls to encourage private sector involvement in Indigenous employment, so as to repair economic and social damage caused by the introduction of a Western enterprising culture.
    Maurice Rousetty

  11. Nice & Informative Blog! I would like to say thank you for the efforts you had made for writing this awesome article. This article inspired me to read more your blogs. keep it up. Visit cheapest smm panel for any kind of Social Media Marketing Services.

  12. Nice Post!
    Really Great Information. It will be supportive to anyone who utilizes it, including me. Thanks for sharing such a helpful article. Visit best smm panel for any kind of SMM Services.

  13. This comment has been removed by the author.

  14. The best smm panel will help you reach your goals faster.

  15. This comment has been removed by the author.

  16. Thanks for sharing a lot of information. This article inspired me to read more your blogs. keep it up. Visit buy ig like for any kind of Social Media Marketing Services.

  17. Are you looking for a good marketing method that is SMM Panel. Just try it and examine the result.