would this work? users = Table("users", metadata, Column("id", Integer, primary_key=True), Column("username", String(50), unique=True, nullable=False), Column("password", String(255)), Column("email", String(255), unique=True, nullable=False), Column("firstname", String(255)), Column("lastname", String(255)),
Column("modifiedby_id", Integer, ForeignKey("users.id")) Column("modifiedon", DateTime(timezone=True), default=func.now()), On Sep 3, 6:50 pm, voltron <[EMAIL PROTECTED]> wrote: > Excuse the newbie question, how does one declare a sef-referencing > key? I would like to have fields "modified_by" and "created_by" in my > users table, the field should refer back to the user id or user name > in the same table. > > Thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---