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 [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
-~----------~----~----~----~------~----~------~--~---
