the usual solution for "friends" here is a many-to-many table, not really a "self referencing FK" as that would allow a user to only be "owned" by one parent.
As it turns out this has been asked about twice in the past 6 weeks: http://groups.google.com/group/sqlalchemy/browse_thread/thread/635f09ee31c72658# http://groups.google.com/group/sqlalchemy/browse_thread/thread/b4eaef1bdf132cdc# On Mar 29, 2012, at 1:28 PM, John Anderson wrote: > I have my User table currently and I want to allow User's to have the ability > to follow other users. > > So I need 2 columns, people the user follows and people who follow the user. > > How would you structure something like this in declarative? > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
