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()