Dbpatterns is a service that allows you to create, share, explore database models on the web.

Public Newsfeed

ernestohs forked a pattern

Social Network

  • profile
  • id
  • name
  • username
  • email
  • ...
  • media
  • id
  • type
  • filename
  • is_explicit
  • ...
  • album
  • id
  • title
  • is_private
  • profile_id
  • relationship
  • id
  • type
  • profile_id
  • target_profile_id
  • ...

iamromanh commented on a pattern

Question: for your table association of post_tags should it instead be posts_tags vs post_tags? I am still new to DB modeling with SQL.