StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
7805719
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2011-10-18T10:20:51.290
FavoriteCount
0
LastActivityDate
2011-10-18T10:20:51.290
LastEditDate
LastEditorUserId
0
OwnerUserId
179332
ParentId
2373262
PostTypeId
2
Score
7
ViewCount
0
LastEditorDisplayName
text
Body
Just adding to John Topley's answer, I did a bit of research and found some of DHH's thoughts on the topic, which make for an interesting read: <ul> <li>(Jun 2006) <a href="http://trak3r.blogspot.com/2006/06/should-we-drink-dhhs-kool-aid.html?showComment=1151474340000#c115147437049115574">DHH replies</a> to Teflon Ted's blog post <a href="http://trak3r.blogspot.com/2006/06/should-we-drink-dhhs-kool-aid.html">Should we drink DHH's Kool-Aid?</a></li> <li>(Feb 2006) <a href="http://discuss.joelonsoftware.com/default.asp?joel.3.309321.4">DHH replies in the comments</a> (search for 'Good rant') to someone's rant about Rails</li> <li>(May 2006) <a href="http://article.gmane.org/gmane.comp.lang.ruby.rails/73020/match=foreign+keys">DHH replies to someone's request for migrations to support foreign keys</a></li> <li>(Jan 2006) <a href="http://thread.gmane.org/gmane.comp.lang.ruby.rails/39371/focus=39474">DHH explains why model associations don't belong in schema.rb</a></li> </ul> I couldn't find DHH referring to the database as a "giant hash", so maybe John is paraphrasing a different quote. I'd love to read a more up-to-date version of DHH's opinion. I didn't find too many opinions from other people written in the last couple of years. Here are the ones I found: <ul> <li>(July 2011) <a href="http://www.codegenesys.com/consulting/2011/07/rails-foreign-keys/">CodeGenesys explain why and how they use foreign keys in Rails</a></li> <li>(Jan 2008) a blog post entitled <a href="http://blog.weiskotten.com/2008/01/you-should-use-foreign-key-constraints-in-rails.html">You Should Use Foreign Key Constraints in Rails</a></li> <li>(Nov 2007) <a href="http://www.thirdbit.net/articles/2007/11/02/database-constraints-stereotypes-rails-culture-talmud-gender-minaswan-religion-but-absolutely-no-bondage-play/">a useful blog post which contains more useful research on the pros and cons of foreign keys</a></li> </ul>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POAre foreign keys in Rails generally avoided?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USAdam Spiers
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
3. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.