Subversion Repositories SmartDukaan

class Company(Entity):

    id = Field(Integer, primary_key=True, autoincrement=True)

    name = Field(String(255))

    Address = Field(String(255))

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class WalletForCompany(Entity):

    id = Field(Integer, primary_key=True, autoincrement=True)

    companyId = Field(Integer)

    amount = Field(Float)

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class WalletHistoryForCompany(Entity):

    id = Field(Integer, primary_key=True, autoincrement=True)

    walletId = Field(Integer)

    amount = Field(Float)

    transactionTime = Field(DateTime)

    openingBal = Field(Float)

    closingBal = Field(Float)

    referenceNumber = Field(Integer)

    description = Field(String(255))

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")

class RechargeTransaction(Entity):

    id = Field(Integer, primary_key=True, autoincrement=True)

    storeId = Field(Integer)

    amount = Field(Float)

    transactionTime = Field(DateTime)

    deviceNum = Field(String(64))

    deviceType = Field(Integer)

    isFrc = Field(Boolean)

    email = Field(String(255))

    discount = Field(Float)

    paymentAmount = Field(Float)

    payMethod = Field(Integer)

    status = Field(Integer)

    invoiceNumber = Field(Integer)

    circleId = Field(Integer)

    name = Field(String(255))

    simNum = Field(String(255))

    cafNum = Field(String(255))

    using_options(shortnames=True)

    using_table_options(mysql_engine="InnoDB")