Subversion Repositories SmartDukaan

Rev

Rev 18591 | Rev 18634 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 18591 Rev 18592
Line 652... Line 652...
652
 
652
 
653
class UserSanction(Entity):
653
class UserSanction(Entity):
654
    id = Field(Integer, primary_key=True, autoincrement=True)
654
    id = Field(Integer, primary_key=True, autoincrement=True)
655
    user_id = Field(Integer)
655
    user_id = Field(Integer)
656
    creditor_id = Field(Integer)
656
    creditor_id = Field(Integer)
657
    user_ref_id = String(24)
657
    user_ref_id = Field(String(24))
658
    credit_limit = Field(Float)
658
    credit_limit = Field(Float)
659
    credit_blocked = Field(Float)
659
    credit_blocked = Field(Float)
660
    loan = Field(Float)
660
    loan = Field(Float)
661
    active = Field(Boolean)
661
    active = Field(Boolean)
662
    updated = Field(DateTime, onupdate=datetime.datetime.now)
662
    updated = Field(DateTime, onupdate=datetime.datetime.now)
Line 666... Line 666...
666
    
666
    
667
class CreditHistory(Entity):
667
class CreditHistory(Entity):
668
    id = Field(Integer, primary_key=True, autoincrement=True)
668
    id = Field(Integer, primary_key=True, autoincrement=True)
669
    user_id = Field(Integer)
669
    user_id = Field(Integer)
670
    creditor_id = Field(Integer)
670
    creditor_id = Field(Integer)
671
    payment_id = Field(String)
671
    payment_id = Field(String(20))
672
    amount = Field(Float)
672
    amount = Field(Float)
673
    credit_type = Field(Enum('BLOCKED', 'BLOCKED_REVERSED', 'LOAN', 'LOAN_PAID', 'DEFAULTED'))
673
    credit_type = Field(Enum('BLOCKED', 'BLOCKED_REVERSED', 'LOAN', 'LOAN_PAID', 'DEFAULTED'))
674
    shipping_id = Field(String)
674
    shipping_id = Field(String(20))
675
    loan_id = Field(String)
675
    loan_id = Field(String(20))
676
    due_date = Field(DateTime)
676
    due_date = Field(DateTime)
677
    updated = Field(DateTime, onupdate=datetime.datetime.now)
677
    updated = Field(DateTime, onupdate=datetime.datetime.now)
678
    created = Field(DateTime,default = datetime.datetime.now)
678
    created = Field(DateTime,default = datetime.datetime.now)
679
    using_options(shortnames=True)
679
    using_options(shortnames=True)
680
    using_table_options(mysql_engine="InnoDB")
680
    using_table_options(mysql_engine="InnoDB")