class LitemallUser(BaseModel):
__tablename__ = 'litemall_user'
username = orm.String(length=63)
password = orm.String(length=63)
gender = orm.TinyInteger(length=3)
birthday = orm.Datetime()
last_login_time = orm.Datetime()
last_login_ip = orm.String(length=63)
nickname = orm.String(length=63)
mobile = orm.String(length=20)
avatar = orm.String(length=255)
status = orm.TinyInteger(length=3)
class LitemallAddress(BaseModel):
__tablename__ = 'litemall_address'
name = orm.String(length=63)
user_id = orm.Integer()
address = orm.String(length=127)
mobile = orm.String(length=20)
is_default = orm.TinyInteger(length=1)
class LitemallComment(BaseModel):
__tablename__ = 'litemall_comment'
content = orm.String(length=1023)
user_id = orm.Integer()
good_id = orm.Integer()
has_picture = orm.TinyInteger(length=1)
pic_urls = orm.String(length=1023)
star = orm.Integer()
class LitemallCategory(BaseModel):
__tablename__ = 'litemall_category'
name = orm.String(length=63)
keywords = orm.String(length=1023)
description = orm.String(length=255)
pid = orm.Integer()
icon_url = orm.String(length=255)
pic_url = orm.String(length=255)
level = orm.String(length=255)
sort_order = orm.TinyInteger(length=3)
class LitemallCart(BaseModel):
__tablename__ = 'litemall_cart'
user_id = orm.Integer()
goods_id = orm.Integer()
goods_sn = orm.String(length=63)
goods_name = orm.String(length=127)
product_id = orm.Integer()
price = orm.Float()
number = orm.Integer()
checked = orm.TinyInteger(length=1)
pic_url = orm.String(length=255)
class LitemallGoods(BaseModel):
__tablename__ = 'litemall_goods'
goods_sn = orm.String(length=63)
name = orm.String(length=127)
category_id = orm.Integer()
brand_id = orm.Integer()
gallery = orm.String(length=1023)
keywords = orm.String(length=255)
brief = orm.String(length=255)
is_on_sale = orm.TinyInteger(length=1)
sort_order = orm.Integer()
pic_url = orm.String(length=255)
unit = orm.String(length=31)
retail_price = orm.Float()
detail = orm.Text()