def project_table(client_table): client_column = Column(u"client", MetaData()) client_column.foreign_keys = [ForeignKey(client_table.columns[u"id"])] project_table = Table(u"project", MetaData(), Column(u"id", Integer()), Column(u"name", String(50)), client_column) client_foreign = ForeignKey(client_table.columns[u"id"]) client_foreign.parent = project_table.columns[u"client"] project_table.foreign_keys = [client_foreign] return project_table
def client_table(): client_table = Table(u"client", MetaData(), Column(u"id", Integer()), Column(u"name", String(50))) client_table.foreign_keys = [] return client_table