| Line 23... |
Line 23... |
| 23 |
warehouse_id = Field(Integer,primary_key=True,autoincrement=False)
|
23 |
warehouse_id = Field(Integer,primary_key=True,autoincrement=False)
|
| 24 |
item_id = Field(Integer,primary_key=True,autoincrement=False)
|
24 |
item_id = Field(Integer,primary_key=True,autoincrement=False)
|
| 25 |
using_options(shortnames=True)
|
25 |
using_options(shortnames=True)
|
| 26 |
using_table_options(mysql_engine="InnoDB")
|
26 |
using_table_options(mysql_engine="InnoDB")
|
| 27 |
|
27 |
|
| - |
|
28 |
class StateMaster(Entity):
|
| - |
|
29 |
id = Field(Integer, primary_key=True, autoincrement=False)
|
| - |
|
30 |
name= Field(String(100))
|
| - |
|
31 |
using_options(shortnames=True)
|
| - |
|
32 |
using_table_options(mysql_engine="InnoDB")
|
| - |
|
33 |
|
| 28 |
class Warehouse(Entity):
|
34 |
class Warehouse(Entity):
|
| 29 |
id = Field(Integer, primary_key=True, autoincrement=True)
|
35 |
id = Field(Integer, primary_key=True, autoincrement=True)
|
| 30 |
displayName = Field(String(50))
|
36 |
displayName = Field(String(50))
|
| 31 |
location = Field(String(200))
|
37 |
location = Field(String(200))
|
| 32 |
status = Field(Integer)
|
38 |
status = Field(Integer)
|
| Line 36... |
Line 42... |
| 36 |
pincode = Field(String(10))
|
42 |
pincode = Field(String(10))
|
| 37 |
vendorString = Field(String(50))
|
43 |
vendorString = Field(String(50))
|
| 38 |
badInventory = OneToMany('BadInventorySnapshot')
|
44 |
badInventory = OneToMany('BadInventorySnapshot')
|
| 39 |
inventory = OneToMany('CurrentInventorySnapshot')
|
45 |
inventory = OneToMany('CurrentInventorySnapshot')
|
| 40 |
inventoryHistory = OneToMany('ItemInventoryHistory')
|
46 |
inventoryHistory = OneToMany('ItemInventoryHistory')
|
| - |
|
47 |
state = ManyToOne('StateMaster')
|
| 41 |
logisticsLocation = Field(Integer)
|
48 |
logisticsLocation = Field(Integer)
|
| 42 |
vendor = ManyToOne('Vendor')
|
49 |
vendor = ManyToOne('Vendor')
|
| 43 |
billingType = Field(Integer)
|
50 |
billingType = Field(Integer)
|
| 44 |
inventoryType = Field(Enum('GOOD', 'BAD', 'VIRTUAL'))
|
51 |
inventoryType = Field(Enum('GOOD', 'BAD', 'VIRTUAL'))
|
| 45 |
warehouseType = Field(Enum('OURS', 'THIRD_PARTY'))
|
52 |
warehouseType = Field(Enum('OURS', 'THIRD_PARTY'))
|