Subversion Repositories SmartDukaan

Rev

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

Rev 9949 Rev 10097
Line 182... Line 182...
182
class BannerUriMapping(Entity):
182
class BannerUriMapping(Entity):
183
    bannerName = Field(String(100))
183
    bannerName = Field(String(100))
184
    uri = Field(String(100))
184
    uri = Field(String(100))
185
    isActive = Field(Boolean)
185
    isActive = Field(Boolean)
186
    bannerType = Field(Integer)
186
    bannerType = Field(Integer)
-
 
187
    target = Field(Boolean)
187
    using_options(shortnames=True)
188
    using_options(shortnames=True)
188
    using_table_options(mysql_engine="InnoDB")
189
    using_table_options(mysql_engine="InnoDB")
189
 
190
 
190
class Campaign(Entity):
191
class Campaign(Entity):
191
    id = Field(Integer,primary_key=True)
192
    id = Field(Integer,primary_key=True)
Line 323... Line 324...
323
    shippingTime = Field(Integer)
324
    shippingTime = Field(Integer)
324
    priceUpdatedBy = Field(String(255))
325
    priceUpdatedBy = Field(String(255))
325
    using_options(shortnames=True)
326
    using_options(shortnames=True)
326
    using_table_options(mysql_engine="InnoDB")
327
    using_table_options(mysql_engine="InnoDB")
327
 
328
 
328
class SnapdealItemUpdateHistory(Entity):
329
class MarketPlaceUpdateHistory(Entity):
329
    id  = Field(Integer, primary_key=True, autoincrement = True)
330
    id  = Field(Integer, primary_key=True, autoincrement = True)
330
    item_id = Field(Integer)
331
    item_id = Field(Integer)
-
 
332
    source = Field(Integer)
331
    isListedOnSnapdeal = Field(Boolean)
333
    isListedOnSource = Field(Boolean)
332
    exceptionPrice = Field(Float)
334
    exceptionPrice = Field(Float)
333
    warehouseId = Field(Integer)
335
    warehouseId = Field(Integer)
334
    transferPrice = Field(Float)
336
    transferPrice = Field(Float)
335
    sellingPrice = Field(Float)
337
    sellingPrice = Field(Float)
336
    courierCost =  Field(Float)
338
    courierCost =  Field(Float)
337
    commission  =  Field(Float)
339
    commission  =  Field(Float)
338
    serviceTax  =  Field(Float)
340
    serviceTax  =  Field(Float)
339
    suppressPriceFeed = Field(Boolean)
341
    suppressPriceFeed = Field(Boolean)
340
    suppressInventoryFeed = Field(Boolean)
342
    suppressInventoryFeed = Field(Boolean)
341
    maxNlc = Field(Float)
343
    maxNlc = Field(Float)
342
    skuAtSnapdeal = Field(String(255))
344
    skuAtSource = Field(String(255))
343
    updatedOn = Field(DateTime)
345
    updatedOn = Field(DateTime)
344
    supc = Field(String(255))
346
    marketPlaceSerialNumber = Field(String(255))
345
    priceUpdatedBy = Field(String(255))
347
    priceUpdatedBy = Field(String(255))
346
    using_options(shortnames=True)
348
    using_options(shortnames=True)
347
    using_table_options(mysql_engine="InnoDB")
349
    using_table_options(mysql_engine="InnoDB")
348
 
350
 
349
class MarketplaceItems(Entity):
351
class MarketplaceItems(Entity):
Line 408... Line 410...
408
    returnProvision = Field(Float)
410
    returnProvision = Field(Float)
409
    commission = Field(Float)
411
    commission = Field(Float)
410
    competitorCommissionAccessory = Field(Float)
412
    competitorCommissionAccessory = Field(Float)
411
    competitorCommissionOther = Field(Float)
413
    competitorCommissionOther = Field(Float)
412
    serviceTax = Field(Float)
414
    serviceTax = Field(Float)
-
 
415
    startDate = Field(DateTime, primary_key=True, autoincrement=False)
-
 
416
    expiryDate = Field(DateTime)
-
 
417
    using_options(shortnames=True)
-
 
418
    using_table_options(mysql_engine="InnoDB")
-
 
419
    
-
 
420
class SourceCategoryPercentage(Entity):
-
 
421
    category_id = Field(Integer, primary_key=True, autoincrement=False)
-
 
422
    source = Field(Integer, primary_key=True, autoincrement=False)
-
 
423
    emiFee = Field(Float)
-
 
424
    closingFee = Field(Float)
-
 
425
    returnProvision = Field(Float)
-
 
426
    commission = Field(Float)
-
 
427
    competitorCommissionAccessory = Field(Float)
-
 
428
    competitorCommissionOther = Field(Float)
-
 
429
    serviceTax = Field(Float)
-
 
430
    startDate = Field(DateTime, primary_key=True, autoincrement=False)
-
 
431
    expiryDate = Field(DateTime)
413
    using_options(shortnames=True)
432
    using_options(shortnames=True)
414
    using_table_options(mysql_engine="InnoDB")
433
    using_table_options(mysql_engine="InnoDB")
415
    
434
    
416
class MarketPlaceHistory(Entity):
435
class MarketPlaceHistory(Entity):
417
    item_id = Field(Integer, primary_key=True, autoincrement=False)
436
    item_id = Field(Integer, primary_key=True, autoincrement=False)
Line 466... Line 485...
466
    maxNlc = Field(Float)
485
    maxNlc = Field(Float)
467
    skuAtFlipkart = Field(String(255))
486
    skuAtFlipkart = Field(String(255))
468
    isListedOnFlipkart = Field(Boolean)
487
    isListedOnFlipkart = Field(Boolean)
469
    suppressPriceFeed = Field(Boolean)
488
    suppressPriceFeed = Field(Boolean)
470
    suppressInventoryFeed = Field(Boolean)
489
    suppressInventoryFeed = Field(Boolean)
-
 
490
    flipkartSerialNumber = Field(String(255))
471
    updatedOn = Field(DateTime)
491
    updatedOn = Field(DateTime)
472
    updatedBy = Field(String(255))
492
    updatedBy = Field(String(255))
473
    using_options(shortnames=True)
493
    using_options(shortnames=True)
474
    using_table_options(mysql_engine="InnoDB")
494
    using_table_options(mysql_engine="InnoDB")
475
 
495