Subversion Repositories SmartDukaan

Rev

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

Rev 609 Rev 621
Line 8... Line 8...
8
from elixir.fields import Field
8
from elixir.fields import Field
9
from sqlalchemy.types import Integer
9
from sqlalchemy.types import Integer
10
from elixir.relationships import OneToMany, ManyToOne
10
from elixir.relationships import OneToMany, ManyToOne
11
import datetime
11
import datetime
12
 
12
 
13
 
-
 
14
 
-
 
15
class BestSellers(Entity):
13
class BestSellers(Entity):
-
 
14
    manufacturer_name = Field(String(100), primary_key=True)
16
    item_id = Field(Integer, primary_key=True)
15
    model_number = Field(String(50), primary_key=True)
17
    priority = Field(Integer)
16
    color = Field(String(20), primary_key=True)
18
    status = Field(Integer)
17
    rank = Field(Integer)
-
 
18
    using_options(shortnames=True)
19
 
19
 
20
class Warehouse(Entity):
20
class Warehouse(Entity):
21
    id = Field(Integer, primary_key=True, autoincrement=True)
21
    id = Field(Integer, primary_key=True, autoincrement=True)
22
    location = Field(String(200))
22
    location = Field(String(200))
23
    status = Field(Integer)
23
    status = Field(Integer)
Line 61... Line 61...
61
    startDate = Field(DateTime)
61
    startDate = Field(DateTime)
62
    retireDate = Field(DateTime)
62
    retireDate = Field(DateTime)
63
    status = Field(Integer)
63
    status = Field(Integer)
64
    bestDealText = Field(String(100))
64
    bestDealText = Field(String(100))
65
    bestDealValue = Field(Integer)
65
    bestDealValue = Field(Integer)
-
 
66
    bestSellingRank = Field(Integer)
66
    currentInventory = OneToMany('CurrentInventorySnapshot')
67
    currentInventory = OneToMany('CurrentInventorySnapshot')
67
    inventoryHistory = OneToMany('ItemInventoryHistory')
68
    inventoryHistory = OneToMany('ItemInventoryHistory')
68
    iteminfo = OneToMany("ItemInfo")
69
    iteminfo = OneToMany("ItemInfo")
69
    statusChangeLog = OneToMany("ItemChangeLog")
70
    statusChangeLog = OneToMany("ItemChangeLog")
70
    
71