class ProInfo(Model):
id = IntegerField(primary_key=True)
procode = CharField(db_column='proCode', max_length=20, blank=True, null=True) # Field name made lowercase.
protheme = CharField(db_column='proTheme', max_length=255, blank=True, null=True) # Field name made lowercase.
prounits = CharField(db_column='proUnits', max_length=255, blank=True, null=True) # Field name made lowercase.
proname = CharField(db_column='proName', max_length=30, blank=True, null=True) # Field name made lowercase.
prodomain = CharField(db_column='proDomain', max_length=30, blank=True, null=True) # Field name made lowercase.
pronature = CharField(db_column='proNature', max_length=30, blank=True, null=True) # Field name made lowercase.
procommander = CharField(db_column='proCommander', max_length=15, blank=True, null=True) # Field name made lowercase.
progoal = CharField(db_column='proGoal', max_length=255, blank=True, null=True) # Field name made lowercase.
prostatus = CharField(db_column='proStatus', max_length=1, blank=True, null=True) # Field name made lowercase.
proouridentity = CharField(db_column='proOurIdentity', max_length=1, blank=True, null=True) # Field name made lowercase.
proexpectation = CharField(db_column='proExpectation', max_length=255, blank=True, null=True) # Field name made lowercase.
prostarttime = DateTimeField(db_column='proStartTime', blank=True, null=True) # Field name made lowercase.
propreendtime = DateTimeField(db_column='proPreEndTime', blank=True, null=True) # Field name made lowercase.
proactuallyendtime = DateTimeField(db_column='proActuallyEndTime', blank=True, null=True) # Field name made lowercase.
procase = CharField(db_column='proCase', max_length=255, blank=True, null=True) # Field name made lowercase.
resultprediction = CharField(db_column='resultPrediction', max_length=255, blank=True, null=True) # Field name made lowercase.
profund = DecimalField(db_column='proFund', max_digits=12, decimal_places=0, blank=True, null=True) # Field name made lowercase.
proriskfund = DecimalField(db_column='proRiskFund', max_digits=12, decimal_places=0, blank=True, null=True) # Field name made lowercase.
pronumber = IntegerField(db_column='proNumber', blank=True, null=True) # Field name made lowercase.
promypost = CharField(db_column='proMyPost', max_length=30, blank=True, null=True) # Field name made lowercase.
mainenterpriseid = IntegerField(db_column='mainEnterpriseId', blank=True, null=True) # Field name made lowercase.
mainschoolid = IntegerField(db_column='mainSchoolId', blank=True, null=True) # Field name made lowercase.
userid = IntegerField(db_column='userId', blank=True, null=True) # Field name made lowercase.
__table__ = 'pro_Info'
class UsUserinfo(Model):
id = IntegerField(primary_key=True)
useraccount = CharField(db_column='userAccount', max_length=30) # Field name made lowercase.
userrealname = CharField(db_column='userRealName', max_length=50) # Field name made lowercase.
usercurrentpwd = CharField(db_column='userCurrentPwd', max_length=50) # Field name made lowercase.
usercurrentnickname = CharField(db_column='userCurrentNickname', max_length=20) # Field name made lowercase.
usercurrentsex = IntegerField(db_column='userCurrentSex', blank=True, null=True) # Field name made lowercase.
age = IntegerField(blank=True, null=True)
usercurrentmajormobile = CharField(db_column='userCurrentMajorMobile', max_length=30, blank=True, null=True) # Field name made lowercase.
usercurrentmajoremail = CharField(db_column='userCurrentMajorEmail', max_length=30, blank=True, null=True) # Field name made lowercase.
birthday = DateField(blank=True, null=True)
usercurrentnationality = CharField(db_column='userCurrentNationality', max_length=15, blank=True, null=True) # Field name made lowercase.
usercurrentethnicity = CharField(db_column='userCurrentEthnicity', max_length=15, blank=True, null=True) # Field name made lowercase.
usercurrenthighesteducation = CharField(db_column='userCurrentHighestEducation', max_length=10, blank=True, null=True) # Field name made lowercase.
usercurrentmajorwork = CharField(db_column='userCurrentMajorWork', max_length=20, blank=True, null=True) # Field name made lowercase.
usercurrentposition = CharField(db_column='userCurrentPosition', max_length=20, blank=True, null=True) # Field name made lowercase.
usercurrentmajoraddress = CharField(db_column='userCurrentMajorAddress', max_length=50, blank=True, null=True) # Field name made lowercase.
usercurrentmajorwechat = CharField(db_column='userCurrentMajorWeChat', max_length=30, blank=True, null=True) # Field name made lowercase.
usercurrentmajorqq = CharField(db_column='userCurrentMajorQQ', max_length=30, blank=True, null=True) # Field name made lowercase.
usercurrentmajorsinablog = CharField(db_column='userCurrentMajorSinaBlog', max_length=30, blank=True, null=True) # Field name made lowercase.
usercurrentweight = DecimalField(db_column='userCurrentWeight', max_digits=10, decimal_places=0, blank=True, null=True) # Field name made lowercase.
usercurrentheight = DecimalField(db_column='userCurrentHeight', max_digits=10, decimal_places=0, blank=True, null=True) # Field name made lowercase.
usercurrentsgb = IntegerField(db_column='userCurrentSGB', blank=True, null=True) # Field name made lowercase.
generationtime = DateTimeField(db_column='generationTime', blank=True, null=True) # Field name made lowercase.
modificationtime = DateTimeField(db_column='modificationTime', blank=True, null=True) # Field name made lowercase.
__table__ = 'us_userinfo'
class HisSleep(Model):
id = IntegerField(primary_key=True)
gotobed = DateTimeField(db_column='goToBed', blank=True, null=True) # Field name made lowercase.
getup = DateTimeField(db_column='getUp', blank=True, null=True) # Field name made lowercase.
userid = IntegerField(db_column='userId', blank=True, null=True) # Field name made lowercase.
__table__ = 'his_sleep'
class HisName(Model):
id = IntegerField(primary_key=True)
name = CharField(max_length=20, blank=True, null=True)
generationtime = DateTimeField(db_column='generationTime', blank=True, null=True) # Field name made lowercase.
disusetime = DateTimeField(db_column='disuseTime', blank=True, null=True) # Field name made lowercase.
userid = IntegerField(db_column='userId', blank=True, null=True) # Field name made lowercase.
__table__ = 'his_name'
class HisMobile(Model):
id = IntegerField(primary_key=True)
mobilenumber = CharField(db_column='mobileNumber', max_length=15, blank=True, null=True) # Field name made lowercase.
operator = CharField(max_length=1, blank=True, null=True)
generationtime = DateTimeField(db_column='generationTime', blank=True, null=True) # Field name made lowercase.
disusetime = DateTimeField(db_column='disuseTime', blank=True, null=True) # Field name made lowercase.
userid = IntegerField(db_column='userId', blank=True, null=True) # Field name made lowercase.
__table__ = 'his_mobile'
class ProNode(Model):
id = IntegerField(primary_key=True)
nodecode = CharField(db_column='nodeCode', max_length=20, blank=True, null=True) # Field name made lowercase.
nodename = CharField(db_column='nodeName', max_length=30, blank=True, null=True) # Field name made lowercase.
nodetargettask = CharField(db_column='nodeTargetTask', max_length=255, blank=True, null=True) # Field name made lowercase.
nodetype = CharField(db_column='nodeType', max_length=1, blank=True, null=True) # Field name made lowercase.
nodeexpectationproduce = CharField(db_column='nodeExpectationProduce', max_length=255, blank=True, null=True) # Field name made lowercase.
nodecommander = CharField(db_column='nodeCommander', max_length=30, blank=True, null=True) # Field name made lowercase.
nodestarttime = DateTimeField(db_column='nodeStartTime', blank=True, null=True) # Field name made lowercase.
nodeendtime = DateTimeField(db_column='nodeEndTime', blank=True, null=True) # Field name made lowercase.
nodestatus = CharField(db_column='nodeStatus', max_length=1, blank=True, null=True) # Field name made lowercase.
proinfoid = IntegerField(db_column='proInfoId', blank=True, null=True) # Field name made lowercase.
userid = IntegerField(db_column='userId', blank=True, null=True) # Field name made lowercase.
__table__ = 'pro_node'
class ZhaoPinJobs(Model):
__table__ = 'ZhaoPinJobs'
id = IntegerField(primary_key=True)
source = StringField(ddl='varchar(30)')
jobkey = StringField(ddl='varchar(30)')
jobid = StringField(ddl='varchar(30)')
jobtitle = StringField(ddl='varchar(100)')
salarystr = StringField(ddl='varchar(100)')
salary_month_min = IntegerField()
salary_year_min = IntegerField()
salary_month_max = IntegerField()
salary_year_max = IntegerField()
address = StringField(ddl='varchar(300)')
education = StringField(ddl='varchar(100)')
workexperience = StringField(ddl='varchar(50)')
release_time = StringField(ddl='varchar(100)')
response_time = StringField(ddl='varchar(100)')
companyname = StringField(ddl='varchar(200)')
industry = StringField(ddl='varchar(200)')
financing_situation = StringField(ddl='varchar(100)')
numberofpeople = StringField(ddl='varchar(100)')
welfare1 = StringField(ddl='varchar(100)')
welfare2 = StringField(ddl='varchar(100)')
welfare3 = StringField(ddl='varchar(100)')
welfare4 = StringField(ddl='varchar(100)')
welfare5 = StringField(ddl='varchar(100)')
created_at = DateTimeField()
class ZhihuHot(Model):
__table__ = 'ZhihuHot'
id = IntegerField(primary_key=True)
hotid = StringField(ddl='varchar(30)')
collapse_no = StringField(ddl='varchar(20)')
collapse_no_ref = StringField(ddl='varchar(20)')
feedsourcetag = StringField(ddl='varchar(100)')
feedsourceurl = StringField(ddl='varchar(300)')
userimgnumber = IntegerField()
userimgsrcurl = StringField(ddl='varchar(300)')
userimgurl = StringField(ddl='varchar(300)')
username = StringField(ddl='varchar(100)')
userinfo = StringField(ddl='varchar(300)')
newsimgnumber = IntegerField()
newsimgsrcurl = StringField(ddl='varchar(300)')
newsimgurl = StringField(ddl='varchar(300)')
isvideo = StringField(ddl='varchar(5)')
title = StringField(ddl='varchar(300)')
titleurl = StringField(ddl='varchar(300)')
newscontent = StringField(ddl='varchar(1000)')
infavorqty = StringField(ddl='varchar(20)')
comment_url = StringField(ddl='varchar(300)')
comment_title = StringField(ddl='varchar(300)')
share_url = StringField(ddl='varchar(300)')
created_at = DateTimeField()
class HisVersion(Model):
id = IntegerField(primary_key=True)
version = CharField(max_length=10)
generationtime = DateTimeField(db_column='generationTime') # Field name made lowercase.
userid = IntegerField(db_column='userId', blank=True, null=True) # Field name made lowercase.
__table__ = 'his_version'
class HotMatchNews(Model):
__table__ = 'HotMatchNews'
id = IntegerField(primary_key=True)
title1 = StringField(ddl='varchar(300)')
title2 = StringField(ddl='varchar(300)')
title3 = StringField(ddl='varchar(300)')
title1url = StringField(ddl='varchar(300)')
title2url = StringField(ddl='varchar(300)')
title3url = StringField(ddl='varchar(300)')
imgsrcurl = StringField(ddl='varchar(300)')
imgurl = StringField(ddl='varchar(300)')
line1 = StringField(ddl='varchar(300)')
line2 = StringField(ddl='varchar(300)')
line3 = StringField(ddl='varchar(300)')
line4 = StringField(ddl='varchar(300)')
line5 = StringField(ddl='varchar(300)')
line6 = StringField(ddl='varchar(300)')
line7 = StringField(ddl='varchar(300)')
line8 = StringField(ddl='varchar(300)')
line9 = StringField(ddl='varchar(300)')
line1url = StringField(ddl='varchar(300)')
line2url = StringField(ddl='varchar(300)')
line3url = StringField(ddl='varchar(300)')
line4url = StringField(ddl='varchar(300)')
line5url = StringField(ddl='varchar(300)')
line6url = StringField(ddl='varchar(300)')
line7url = StringField(ddl='varchar(300)')
line8url = StringField(ddl='varchar(300)')
line9url = StringField(ddl='varchar(300)')
created_at = DateTimeField()
class HisWeight(Model):
id = IntegerField(primary_key=True)
weight = DecimalField(max_digits=10, decimal_places=0, blank=True, null=True)
generationtime = DateTimeField(db_column='generationTime', blank=True, null=True) # Field name made lowercase.
userid = IntegerField(db_column='userId', blank=True, null=True) # Field name made lowercase.
__table__ = 'his_weight'
class SinaCarousel(Model):
__table__ = 'SinaCarousel'
id = IntegerField(primary_key=True)
title = StringField(ddl='varchar(300)')
url = StringField(ddl='varchar(300)')
img_url = StringField(ddl='varchar(300)')
created_at = DateTimeField()
class HisSina(Model):
id = IntegerField(primary_key=True)
sinaaccount = CharField(db_column='sinaAccount', max_length=20, blank=True, null=True) # Field name made lowercase.
sinatype = CharField(db_column='sinaType', max_length=1, blank=True, null=True) # Field name made lowercase.
generationtime = DateTimeField(db_column='generationTime', blank=True, null=True) # Field name made lowercase.
userid = IntegerField(db_column='userId', blank=True, null=True) # Field name made lowercase.
__table__ = 'his_sina'
class HisWechat(Model):
id = IntegerField(primary_key=True)
wechat = CharField(max_length=20)
wechattype = CharField(db_column='wechatType', max_length=1) # Field name made lowercase.
generationtime = DateTimeField(db_column='generationTime') # Field name made lowercase.
userid = IntegerField(db_column='userId', blank=True, null=True) # Field name made lowercase.
__table__ = 'his_wechat'
class IndexCarouselItems(Model):
__table__ = 'IndexCarouselItems'
id = IntegerField(primary_key=True)
title = StringField(ddl='varchar(300)')
url = StringField(ddl='varchar(300)')
img_url = StringField(ddl='varchar(300)')
item_class = StringField(ddl='varchar(10)')
created_at = DateTimeField()
class JobPostlevel(Model):
id = IntegerField(primary_key=True)
postname = CharField(db_column='postName', max_length=15, blank=True, null=True) # Field name made lowercase.
postdescribe = CharField(db_column='postDescribe', max_length=255, blank=True, null=True) # Field name made lowercase.
parentid = IntegerField(db_column='parentId', blank=True, null=True) # Field name made lowercase.
enterpriseid = IntegerField(db_column='enterpriseId') # Field name made lowercase.
generatetime = DateTimeField(db_column='generateTime', blank=True, null=True) # Field name made lowercase.
userid = IntegerField(db_column='userId', blank=True, null=True) # Field name made lowercase.
__table__ = 'job_postlevel'
unique_together = (('id', 'enterpriseid'),)
class ZhihuHotContent(Model):
__table__ = 'ZhihuHot_Content'
id = IntegerField(primary_key=True)
hotid = StringField(ddl='varchar(30)')
partno = IntegerField()
parttype = StringField(ddl='varchar(30)')
imgurl = StringField(ddl='varchar(300)')
imgnumber = IntegerField()
videourl = StringField(ddl='varchar(300)')
text = TextField()
created_at = DateTimeField()
class JobEnterprise(Model):
id = IntegerField(primary_key=True)
nameofenterprise = CharField(db_column='nameOfEnterprise', max_length=30, blank=True, null=True) # Field name made lowercase.
codeofenterprise = CharField(db_column='codeOfEnterprise', max_length=20, blank=True, null=True) # Field name made lowercase.
typeofenterprise = CharField(db_column='TypeOfEnterprise', max_length=1, blank=True, null=True) # Field name made lowercase.
chairmanofenterprise = CharField(db_column='chairmanOfEnterprise', max_length=30, blank=True, null=True) # Field name made lowercase.
ceoofenterprise = CharField(db_column='ceoOfEnterprise', max_length=15, blank=True, null=True) # Field name made lowercase.
scaleofenterprise = IntegerField(db_column='scaleOfEnterprise', blank=True, null=True) # Field name made lowercase.
addressofenterprise = CharField(db_column='addressOfEnterprise', max_length=100, blank=True, null=True) # Field name made lowercase.
genaratetime = DateTimeField(db_column='genarateTime', blank=True, null=True) # Field name made lowercase.
userid = IntegerField(db_column='userId', blank=True, null=True) # Field name made lowercase.
__table__ = 'job_enterprise'
class NbaNews(Model):
__table__ = 'NbaNews'
id = IntegerField(primary_key=True)
imgsrcurl = StringField(ddl='varchar(300)')
imgurl = StringField(ddl='varchar(300)')
isvideo = StringField(ddl='varchar(5)')
title = StringField(ddl='varchar(300)')
titleurl = StringField(ddl='varchar(300)')
newstime = DateTimeField()
comment_url = StringField(ddl='varchar(300)')
tag1 = StringField(ddl='varchar(300)')
tag2 = StringField(ddl='varchar(300)')
tag3 = StringField(ddl='varchar(300)')
tag4 = StringField(ddl='varchar(300)')
tag5 = StringField(ddl='varchar(300)')
tag1url = StringField(ddl='varchar(300)')
tag2url = StringField(ddl='varchar(300)')
tag3url = StringField(ddl='varchar(300)')
tag4url = StringField(ddl='varchar(300)')
tag5url = StringField(ddl='varchar(300)')
created_at = DateTimeField()
class SchoolTeacher(Model):
id = IntegerField(primary_key=True)
teachername = CharField(db_column='teacherName', max_length=10, blank=True, null=True) # Field name made lowercase.
sex = CharField(max_length=1, blank=True, null=True)
term = CharField(max_length=10, blank=True, null=True)
teacherlevel = CharField(db_column='teacherLevel', max_length=1, blank=True, null=True) # Field name made lowercase.
teachertype = CharField(db_column='teacherType', max_length=1, blank=True, null=True) # Field name made lowercase.
evaluate = CharField(max_length=255, blank=True, null=True)
generationtime = DateTimeField(db_column='generationTime', blank=True, null=True) # Field name made lowercase.
schoolid = IntegerField(db_column='schoolId', blank=True, null=True) # Field name made lowercase.
courseid = IntegerField(db_column='courseId', blank=True, null=True) # Field name made lowercase.
userid = IntegerField(db_column='userId', blank=True, null=True) # Field name made lowercase.
__table__ = 'school_teacher'
class SchoolCourse(Model):
id = IntegerField(primary_key=True)
coursename = CharField(db_column='courseName', max_length=20, blank=True, null=True) # Field name made lowercase.
courseteacher = CharField(db_column='courseTeacher', max_length=20, blank=True, null=True) # Field name made lowercase.
coursecontent = CharField(db_column='courseContent', max_length=255, blank=True, null=True) # Field name made lowercase.
coursebook = CharField(db_column='courseBook', max_length=255, blank=True, null=True) # Field name made lowercase.
classroom = CharField(max_length=20, blank=True, null=True)
coursescore = DecimalField(db_column='courseScore', max_digits=10, decimal_places=0, blank=True, null=True) # Field name made lowercase.
term = CharField(max_length=10, blank=True, null=True)
courseevaluate = CharField(db_column='courseEvaluate', max_length=255, blank=True, null=True) # Field name made lowercase.
remark = CharField(max_length=255, blank=True, null=True)
generationtime = DateTimeField(db_column='generationTime', blank=True, null=True) # Field name made lowercase.
userid = IntegerField(db_column='userId', blank=True, null=True) # Field name made lowercase.
__table__ = 'school_course'
class SchoolClass(Model):
id = IntegerField(primary_key=True)
classname = CharField(db_column='className', max_length=10, blank=True, null=True) # Field name made lowercase.
classsong = CharField(db_column='classSong', max_length=10, blank=True, null=True) # Field name made lowercase.
classdeclaration = CharField(db_column='classDeclaration', max_length=255, blank=True, null=True) # Field name made lowercase.
classlable = CharField(db_column='classLable', max_length=255, blank=True, null=True) # Field name made lowercase.
classmonitor = CharField(db_column='classMonitor', max_length=15, blank=True, null=True) # Field name made lowercase.
term = CharField(max_length=15, blank=True, null=True)
generatetime = DateTimeField(db_column='generateTime', blank=True, null=True) # Field name made lowercase.
schoolid = IntegerField(db_column='schoolId', blank=True, null=True) # Field name made lowercase.
teachername = CharField(db_column='teacherName', max_length=15, blank=True, null=True) # Field name made lowercase.
teacherid = IntegerField(db_column='teacherId', blank=True, null=True) # Field name made lowercase.
userid = IntegerField(db_column='userId', blank=True, null=True) # Field name made lowercase.
__table__ = 'school_class'
class ZhihuHotComment(Model):
__table__ = 'ZhihuHot_Comment'
id = IntegerField(primary_key=True)
commentid = StringField(ddl='varchar(30)')
hotid = StringField(ddl='varchar(30)')
userimgnumber = IntegerField()
userimgsrcurl = StringField(ddl='varchar(300)')
userimgurl = StringField(ddl='varchar(300)')
username = StringField(ddl='varchar(100)')
replytouser = StringField(ddl='varchar(100)')
replytouserurl = StringField(ddl='varchar(300)')
replytime = StringField(ddl='varchar(50)')
content = StringField(ddl='varchar(1000)')
infavorqty = StringField(ddl='varchar(20)')
created_at = DateTimeField()
class SchoolInfo(Model):
id = IntegerField(primary_key=True)
schoolname = CharField(db_column='schoolName', max_length=50, blank=True, null=True) # Field name made lowercase.
schooltype = CharField(db_column='schoolType', max_length=1, blank=True, null=True) # Field name made lowercase.
schooladdress = CharField(db_column='schoolAddress', max_length=50, blank=True, null=True) # Field name made lowercase.
collegetype = CharField(db_column='collegeType', max_length=1, blank=True, null=True) # Field name made lowercase.
collegename = CharField(db_column='collegeName', max_length=20, blank=True, null=True) # Field name made lowercase.
major = CharField(max_length=30, blank=True, null=True)
majortype = CharField(db_column='majorType', max_length=1, blank=True, null=True) # Field name made lowercase.
grade = IntegerField(blank=True, null=True)
class_field = IntegerField(db_column='class', blank=True, null=True) # Field renamed because it was a Python reserved word.
generationtime = DateTimeField(db_column='generationTime', blank=True, null=True) # Field name made lowercase.
remark = CharField(max_length=255, blank=True, null=True)
userid = IntegerField(db_column='userId', blank=True, null=True) # Field name made lowercase.
__table__ = 'school_info'
class Stock_tiger(Model): __table__ = 'stock_tiger' ''' __fk_table__ = 'stock_type' __fk_field__ = 'type' __fk_table_field__ = 'name' ''' id = IntegerField(primary_key=True) deal_num = IntegerField() type = StringField(ddl='varchar(45)') occur_date = DateTimeField() occur_amount = FloatField() balance = FloatField() stock_balance = IntegerField() stock_code = StringField(ddl='varchar(45)') deal_price = FloatField() commission = FloatField()
class JobInfo(Model):
id = IntegerField(primary_key=True)
jobname = CharField(db_column='jobName', max_length=15, blank=True, null=True) # Field name made lowercase.
jobtype = CharField(db_column='jobType', max_length=1, blank=True, null=True) # Field name made lowercase.
enterpriseid = IntegerField(db_column='enterpriseId') # Field name made lowercase.
occupationallevelfirst = IntegerField(db_column='occupationalLevelFirst') # Field name made lowercase.
occupationallevelscond = IntegerField(db_column='occupationalLevelScond') # Field name made lowercase.
occupationallevelthird = IntegerField(db_column='occupationalLevelThird') # Field name made lowercase.
domainclassification = IntegerField(db_column='domainClassification') # Field name made lowercase.
jobdescription = CharField(db_column='jobDescription', max_length=255) # Field name made lowercase.
evaluate = CharField(max_length=255, blank=True, null=True)
enterpriceid = IntegerField(db_column='enterpriceId', blank=True, null=True) # Field name made lowercase.
postid = IntegerField(db_column='postId', blank=True, null=True) # Field name made lowercase.
userid = IntegerField(db_column='userId', blank=True, null=True) # Field name made lowercase.
genaratetime = DateTimeField(db_column='genarateTime', blank=True, null=True) # Field name made lowercase.
__table__ = 'job_info'
class HotMatches(Model):
__table__ = 'HotMatches'
id = IntegerField(primary_key=True)
type = StringField(ddl='varchar(50)')
livecast_id = StringField(ddl='varchar(100)')
title = StringField(ddl='varchar(300)')
team1 = StringField(ddl='varchar(50)')
team2 = StringField(ddl='varchar(50)')
score1 = StringField(ddl='varchar(5)')
score2 = StringField(ddl='varchar(5)')
matchdate = StringField(ddl='varchar(100)')
matchtime = StringField(ddl='varchar(100)')
newsurl = StringField(ddl='varchar(300)')
liveurl = StringField(ddl='varchar(300)')
match_url = StringField(ddl='varchar(300)')
created_at = DateTimeField()
class IndexNews(Model):
__table__ = 'IndexNews'
id = IntegerField(primary_key=True)
close_target_id = StringField(ddl='varchar(20)')
close_target_id_ref = StringField(ddl='varchar(20)')
title = StringField(ddl='varchar(300)')
url = StringField(ddl='varchar(300)')
news_summary = StringField(ddl='varchar(300)')
user_img_url = StringField(ddl='varchar(300)')
user_name = StringField(ddl='varchar(50)')
news_date = StringField(ddl='varchar(100)')
news_label = StringField(ddl='varchar(50)')
news_reads = IntegerField()
news_comments = IntegerField()
hate_emails = StringField(ddl='varchar(3000)')
user_url = StringField(ddl='varchar(300)')
label_url = StringField(ddl='varchar(300)')
comment_url = StringField(ddl='varchar(300)')
created_at = DateTimeField()
class Stock_citic(Model): __table__ = 'stock_citic' ''' __fk_table__ = 'stock_type' __fk_field__ = 'type' __fk_table_field__ = 'name' ''' id = IntegerField(primary_key=True) deal_num = IntegerField() type = StringField(ddl='varchar(45)') occur_date = DateTimeField() occur_amount = FloatField() balance = FloatField() stock_balance = IntegerField() stock_code = StringField(ddl='varchar(45)') deal_price = FloatField() stamp_tax = FloatField() transfer_fee = FloatField() other_fee = FloatField() commission = FloatField() charge_fee = FloatField() stock_name = StringField(ddl='varchar(45)') memo = StringField(ddl='varchar(45)')
class TaobaoProducts(Model):
__table__ = 'TaobaoProducts'
id = IntegerField(primary_key=True)
keyword = StringField(ddl='varchar(30)')
product_id = StringField(ddl='varchar(100)')
product_type = StringField(ddl='varchar(100)')
imgsrcurl = StringField(ddl='varchar(300)')
imgurl = StringField(ddl='varchar(300)')
imgnumber = IntegerField()
samestyleurl = StringField(ddl='varchar(300)')
similarurl = StringField(ddl='varchar(300)')
product_price = StringField(ddl='varchar(20)')
payednum = StringField(ddl='varchar(20)')
title = StringField(ddl='varchar(300)')
title1 = StringField(ddl='varchar(300)')
title2 = StringField(ddl='varchar(300)')
titlehaskey = StringField(ddl='varchar(10)')
titleurl = StringField(ddl='varchar(300)')
shopname = StringField(ddl='varchar(100)')
shopurl = StringField(ddl='varchar(300)')
shopaddress = StringField(ddl='varchar(20)')
shoplevelzuanqty = IntegerField()
shoplevelguanqty = IntegerField()
shoplevelxinqty = IntegerField()
shopleveljingguanqty = IntegerField()
istmall = StringField(ddl='varchar(10)')
iconkey1 = StringField(ddl='varchar(100)')
icontitle1 = StringField(ddl='varchar(100)')
iconurl1 = StringField(ddl='varchar(300)')
iconkey2 = StringField(ddl='varchar(100)')
icontitle2 = StringField(ddl='varchar(100)')
iconurl2 = StringField(ddl='varchar(300)')
iconkey3 = StringField(ddl='varchar(100)')
icontitle3 = StringField(ddl='varchar(100)')
iconurl3 = StringField(ddl='varchar(300)')
iconkey4 = StringField(ddl='varchar(100)')
icontitle4 = StringField(ddl='varchar(100)')
iconurl4 = StringField(ddl='varchar(300)')
iconkey5 = StringField(ddl='varchar(100)')
icontitle5 = StringField(ddl='varchar(100)')
iconurl5 = StringField(ddl='varchar(300)')
subiconclass1 = StringField(ddl='varchar(100)')
subicontitle1 = StringField(ddl='varchar(100)')
subiconcontent1 = StringField(ddl='varchar(300)')
subiconclass2 = StringField(ddl='varchar(100)')
subicontitle2 = StringField(ddl='varchar(100)')
subiconcontent2 = StringField(ddl='varchar(300)')
subiconclass3 = StringField(ddl='varchar(100)')
subicontitle3 = StringField(ddl='varchar(100)')
subiconcontent3 = StringField(ddl='varchar(300)')
subiconclass4 = StringField(ddl='varchar(100)')
subicontitle4 = StringField(ddl='varchar(100)')
subiconcontent4 = StringField(ddl='varchar(300)')
subiconclass5 = StringField(ddl='varchar(100)')
subicontitle5 = StringField(ddl='varchar(100)')
subiconcontent5 = StringField(ddl='varchar(300)')
shoptotalrate = StringField(ddl='varchar(20)')
shopdescscore = StringField(ddl='varchar(20)')
shopdescscorediff = StringField(ddl='varchar(20)')
shopdesccompare = StringField(ddl='varchar(20)')
shopdeliveryscore = StringField(ddl='varchar(20)')
shopdeliveryscorediff = StringField(ddl='varchar(20)')
shopdeliverycompare = StringField(ddl='varchar(20)')
shopservicescore = StringField(ddl='varchar(20)')
shopservicescorediff = StringField(ddl='varchar(20)')
shopservicecompare = StringField(ddl='varchar(20)')
product_price_float = FloatField()
product_sales_qty = IntegerField()
shop_ave_score = FloatField()
created_at = DateTimeField()
