iro/model/schema.py
branchdevel
changeset 215 5bacdb7e94d1
parent 211 3fc1f400c107
child 219 4e9d79c35088
equal deleted inserted replaced
214:bacf50bc46bf 215:5bacdb7e94d1
    76     id = Column(Integer, Sequence('message_id_seq'), primary_key=True)
    76     id = Column(Integer, Sequence('message_id_seq'), primary_key=True)
    77     recipient = Column(String(100))
    77     recipient = Column(String(100))
    78     isBilled = Column(Boolean)
    78     isBilled = Column(Boolean)
    79     date = Column(DateTime)
    79     date = Column(DateTime)
    80     price = Column(Numeric(8,4))
    80     price = Column(Numeric(8,4))
       
    81     count = Column(Integer)
       
    82     exID = Column(String(100))
    81     job_id = Column("job", String(40), ForeignKey('job.id'))
    83     job_id = Column("job", String(40), ForeignKey('job.id'))
    82     job = relationship("Job", backref=backref('messages'))
    84     job = relationship("Job", backref=backref('messages'))
    83     offer_id = Column("offer",String(100), ForeignKey('offer.name'))
    85     offer_id = Column("offer",String(100), ForeignKey('offer.name'))
    84     offer = relationship("Offer", backref=backref('messages'))
    86     offer = relationship("Offer", backref=backref('messages'))
    85 
    87