class IBingRen(Interface): """病人: """ id = schema.Int(title=_(u"table primary key"), ) dizhi_id = schema.Int(title=_(u"foreagn key link to wei"), ) xingming = schema.TextLine( title=_(u"xing ming"), required=True, ) xingbie = schema.Choice( title=_(u"xing bie"), vocabulary='Chinese.medical.science.vocabulary.xiebie', required=True, ) shengri = schema.Date(title=_(u"xing ming"), ) dianhua = schema.TextLine(title=_(u"dian hua"), ) dizhi = schema.Object( title=_(u"di zhi"), schema=IDiZhi, ) # all chufangs of bingren chufangs = schema.Object( title=_(u"chu fang"), schema=IChuFang, )
class IJuanZeng(Interface): """donor 记录在某一慈善项目(did决定)下,所有捐赠记录 | id | int(10) unsigned | NO | PRI | NULL | auto_increment | | xiangmu_id | int(10) unsigned | NO | MUL | NULL | | | xingming | varchar(64) | NO | MUL | | | | xianjin | decimal(13,2) | NO | | 0.00 | | | wuzi | varchar(128) | NO | | | | | wuzi_jiazhi | decimal(13,2) | NO | | 0.00 | | | juanzeng_shijian | datetime | NO | | CURRENT_TIMESTAMP | | | openid | varchar(128) | NO | MUL | noweixin | | | status | tinyint(1) | NO | | 0 | """ id = schema.Int(title=_(u"table primary key"), ) xiangmu_id = schema.Choice( title=_(u"juanzeng xiangmu id"), vocabulary='xtcs.policy.vocabulary.donateId', required=True, ) xingming = schema.TextLine(title=_(u"juanzeng zhe"), ) xianjin = schema.Float(title=_(u"xianjin jin e"), required=False) wuzi = schema.TextLine(title=_(u"juanzeng wuping"), required=False) wuzi_jiazhi = schema.Float(title=_(u"wuzi jiazhi"), required=False) juanzeng_shijian = schema.Datetime(title=_(u"juanzeng shi jian"), defaultFactory=nowDateTime) openid = schema.TextLine(title=_(u"weixin openid"), required=False # default = "noweixinpay" ) status = schema.Int(title=_(u"yidong zhifu zhuangtai"), required=False, default=1)
class IModel(Interface): """编号number 记录表 """ modelId = schema.Int(title=_(u"model table primary key"), ) # 型号代码 xhdm = schema.TextLine(title=_(u"model code"), ) #型号名称 xhmc = schema.TextLine(title=_(u"model name"), )
class ICeshishysh(Interface): """测试实验室 """ id = schema.Int(title=_(u"talbe primary key")) name = schema.TextLine(title=_(u"ming cheng")) unit = schema.TextLine(title=_(u"dan wei")) level1 = schema.TextLine(title=_(u"ji bie")) survey = schema.TextLine(title=_(u"gai kuang"))
class IChuFang(Interface): """中药: 人参、白术、甘草 """ id = schema.Int(title=_(u"table primary key"), ) yisheng_id = schema.Int(title=_(u"foreagn key link to yisheng"), ) mingcheng = schema.TextLine(title=_(u"ming cheng"), ) yizhu = schema.TextLine(title=_(u"zhu zhi"), ) jiliang = schema.Int(title=_(u"ji liang"), )
class IBachang(Interface): """靶场 """ id = schema.Int(title=_(u"talbe primary key")) name = schema.TextLine(title=_(u"ba chang ming cheng")) bcdm = schema.TextLine(title=_(u"ba chang dai ma")) location = schema.TextLine(title=_(u"ba chang wei zhi")) length = schema.Float(title=_(u"ba chang chang du")) width = schema.Float(title=_(u"ba chang kuan du")) wk = schema.Int(title=_(u"zhe dang wu ge shu")) ti = schema.Int(title=_(u"gu you fa she ji shu")) landform = schema.TextLine(title=_(u"ba chang di xing tiao jian")) xh = schema.TextLine(title=_(u"ba chang shi he xing hao"))
class ILvboq(Interface): """滤波器 """ id = schema.Int(title=_(u"table primary key"), ) cssbdm = schema.TextLine(title=_(u"cong shu she bei dai ma"), ) cssbmc = schema.TextLine(title=_(u"lv bo qi ming cheng"), ) pcdm = schema.TextLine(title=_(u"zhuang tai pi ci dai ma"), ) location = schema.TextLine(title=_(u"wei zhi"), ) freq = schema.Float(title=_(u"gong zuo pin lv"), ) f_upper = schema.Float(title=_(u"shang bian pin"), ) f_lower = schema.Float(title=_(u"xia bian pin"), ) order1 = schema.Float(title=_(u"lv bo qi ji shu"), ) s21 = schema.Float(title=_(u"lv bo qi cha sun"), )
class IJieshoutx(Interface): """接收天线 """ id = schema.Int(title=_(u"table primary key"), ) cssbdm = schema.TextLine(title=_(u"cong shu she bei dai ma"), ) cssbmc = schema.TextLine(title=_(u"jie shou tian xian ming cheng"), ) pcdm = schema.TextLine(title=_(u"zhuang tai pi ci dai ma"), ) location = schema.TextLine(title=_(u"wei zhi"), ) gain = schema.Float(title=_(u"zeng yi"), ) polarization = schema.TextLine(title=_(u"ji hua"), ) fwbskd = schema.Float(title=_(u"fang wei bo su dai kuan"), ) fybskd = schema.Float(title=_(u"fu yang bo su dai kuan"), ) txzxj = schema.Float(title=_(u"tian xian zhi xiang jiao"), )
class IUserLog(Interface): """管理员操作日志 """ id = schema.Int(title=_(u"the table's primary key"), ) #客体 userid = schema.TextLine(title=_( u"the user id of user which had been processed by administrator"), ) #操作时间 datetime = schema.TextLine(title=_(u"operation time"), ) ip = schema.TextLine(title=_(u"the client's ip address"), ) type = schema.Int(title=_(u"type of the operation"), ) operlevel = schema.Int(title=_(u"level of the operation"), ) description = schema.Text(title=_(u"the operation's detail description"), ) result = schema.Int(title=_(u"result of the operation"), )
class IBranch(Interface): """分系统表 branch """ branchId = schema.Int(title=_(u"branch table primary key"), ) model = schema.Object( title=_(u"Model record"), schema=IModel, ) modelId = schema.Int(title=_(u"branch table foreign key"), ) # 分系统代码 fxtdm = schema.TextLine(title=_(u"branch code"), ) #分系统名称 fxtmc = schema.TextLine(title=_(u"branch name"), ) #分系统类别 fxtlb = schema.TextLine(title=_(u"branch category"), )
class IJieshouj(Interface): """接收机 """ id = schema.Int(title=_(u"table primary key"), ) sbdm = schema.TextLine(title=_(u"she bei dai ma"), ) sbmc = schema.TextLine(title=_(u"jie shou ji ming cheng"), ) pcdm = schema.TextLine(title=_(u"zhuang tai pi ci dai ma"), ) location = schema.TextLine(title=_(u"wei zhi"), ) fb_upper = schema.Float(title=_(u"pin duan shang xian"), ) fb_lower = schema.Float(title=_(u"pin duan xia xian"), ) freq = schema.Float(title=_(u"gongzuo pinlv"), ) f_upper = schema.Float(title=_(u"shang bian pin"), ) f_lower = schema.Float(title=_(u"xia bian pin"), ) bw_receiver = schema.Float(title=_(u"jie shou ji dai kuan"), ) sen_receiver = schema.Float(title=_(u"jie shou ji lin ming du"), ) mf_freq_sign = schema.TextLine(title=_(u"zhong pin fu hao"), ) mf_freq = schema.Float(title=_(u"zhong pin pin lv"), ) lo_freq = schema.Float(title=_(u"ben zhen pin lv"), )
class IDiZhi(Interface): """地址: 中国 湖南 湘潭市 湘潭县云湖桥镇北岸村道林组83号 """ id = schema.Int(title=_(u"table primary key"), ) guojia = schema.TextLine( title=_(u"guo jia"), required=True, default=u"中国", ) sheng = schema.TextLine( title=_(u"sheng(state)"), required=True, ) shi = schema.TextLine( title=_(u"shi (city)"), required=True, ) jiadao = schema.TextLine(title=_(u"jie dao"), )
class IBachangzhdw(Interface): """靶场遮挡物 """ id = schema.Int(title=_(u"talbe primary key")) bcdm = schema.TextLine(title=_(u"ba chang dai ma")) shelter_name = schema.TextLine(title=_(u"zhe dang wu ming cheng")) # zdno = schema.Int( # title=_(u"xiang mu ming cheng") # ) lu_x = schema.Float(title=_(u"zuo shang x zuo biao")) lu_y = schema.Float(title=_(u"zuo shang y zuo biao")) lu_z = schema.Float(title=_(u"zuo shang z zuo biao")) ld_x = schema.Float(title=_(u"zuo xia x zuo biao")) ld_y = schema.Float(title=_(u"zuo xia y zuo biao")) ld_z = schema.Float(title=_(u"zuo xia z zuo biao")) ru_x = schema.Float(title=_(u"you shang x zuo biao")) ru_y = schema.Float(title=_(u"you shang y zuo biao")) ru_z = schema.Float(title=_(u"you shang z zuo biao")) rd_x = schema.Float(title=_(u"you xia x zuo biao")) rd_y = schema.Float(title=_(u"you xia x zuo biao")) rd_z = schema.Float(title=_(u"you xia x zuo biao"))
class IYiSheng(Interface): """余浩: """ id = schema.Int(title=_(u"table primary key"), ) danwei_id = schema.Int(title=_(u"foreagn key link to danwei"), ) xingming = schema.TextLine( title=_(u"xing ming"), required=True, ) xingbie = schema.Choice( title=_(u"xing bie"), vocabulary='Chinese.medical.science.vocabulary.xiebie', required=True, ) shengri = schema.Date(title=_(u"xing ming"), ) dianhua = schema.TextLine(title=_(u"dian hua"), ) danwei = schema.Object( title=_(u"dan wei"), schema=IDanWei, )
class IYao(Interface): """中药: 人参、白术、甘草 """ id = schema.Int(title=_(u"table primary key"), ) yaowei_id = schema.Int(title=_(u"foreagn key link to wei"), ) yaoxing_id = schema.Int(title=_(u"foreagn key link to yao xing"), ) mingcheng = schema.TextLine(title=_(u"ming cheng"), ) zhuzhi = schema.TextLine(title=_(u"zhu zhi"), ) yaowei = schema.Object( title=_(u"gui jing"), schema=IJingLuo, ) yaoxing = schema.Object( title=_(u"gui jing"), schema=IJingLuo, ) guijing = schema.Object( title=_(u"gui jing"), schema=IJingLuo, )
class IBachangfshj(Interface): """靶场发射机 """ id = schema.Int(title=_(u"talbe primary key")) bcdm = schema.Int(title=_(u"ba chang dai ma")) sbmc = schema.TextLine(title=_(u"fa she ji ming cheng")) fsno = schema.Int(title=_(u"fa she ji xu hao")) x = schema.Float(title=_(u"ba chang x zuo biao")) y = schema.Float(title=_(u"ba chang y zuo biao")) z = schema.Float(title=_(u"ba chang z zuo biao")) ft = schema.TextLine(title=_(u"gong zuo pin lv")) pd_u = schema.Float(title=_(u"shang bian pin")) pd_l = schema.Float(title=_(u"xia bian pin")) num = schema.Int(title=_(u"pin lv dian shu")) fu = schema.Float(title=_(u"pin duan shang xian")) fl = schema.Float(title=_(u"pin duan xia xian")) bt = schema.Float(title=_(u"fa she dai kuan")) pt = schema.Float(title=_(u"ji pin gong lv")) tzlx = schema.TextLine(title=_(u"tiao zhi lei xing")) bzf = schema.Float(title=_(u"ben zheng pin lv")) zp = schema.Float(title=_(u"zhong pin")) bz = schema.TextLine(title=_(u"bei zhu"))
class IDanWei(Interface): """单位: 任之堂 """ id = schema.Int(title=_(u"table primary key"), ) dizhi_id = schema.Int(title=_(u"foreagn key link to wei"), ) mingcheng = schema.TextLine( title=_(u"ming cheng"), required=True, ) dizhi = schema.Object( title=_(u"di zhi"), schema=IDiZhi, )
class ICeshiry(Interface): """测试人员 """ id = schema.Int(title=_(u"talbe primary key")) name = schema.TextLine(title=_(u"xing ming")) sex = schema.TextLine(title=_(u"xing bie")) age = schema.Int(title=_(u"nian ling")) edu_level = schema.TextLine(title=_(u"xue li")) post = schema.TextLine(title=_(u"zhi cheng")) certificate_code = schema.TextLine(title=_(u"zheng shu bian hao")) unit = schema.TextLine(title=_(u"dan wei"))
class ICeshiff(Interface): """测试方法 """ id = schema.Int(title=_(u"talbe primary key")) m_id = schema.TextLine(title=_(u"fang fa bian hao")) m_title = schema.TextLine(title=_(u"fang fa biao ti")) range1 = schema.TextLine(title=_(u"shi yong fan wei")) device = schema.TextLine(title=_(u"yi qi she bei")) # diagram = schema.TextLine( # title=_(u"ce shi kuang tu") # ) step = schema.TextLine(title=_(u"ce shi bu zhou")) annotation = schema.TextLine(title=_(u"fu zhu"))
class ICeshixm(Interface): """测试项目 """ id = schema.Int(title=_(u"talbe primary key")) device = schema.TextLine(title=_(u"bei ce jian")) name = schema.TextLine(title=_(u"xiang mu ming cheng")) # diagram = schema.TextLine( # title=_(u"shi yi tu") # ) t_remark = schema.TextLine(title=_(u"ce shi shuo ming")) t_strument = schema.TextLine(title=_(u"ce shi yi qi")) t_value = schema.TextLine(title=_(u"ce shi shu ju")) t_result = schema.TextLine(title=_(u"ce shi jie guo"))
class IXiangMu(Interface): """捐赠项目 mysql> describe xiangmu; id | int(10) unsigned | NO | PRI | NULL | auto_increment | | mingcheng | varchar(64) | NO | MUL | | | | jieshao | varchar(256) | NO | | | | | zhuceshijian | datetime | NO | | CURRENT_TIMESTAMP | | | youxiao | tinyint(1) | NO | | 1 | | +--------------+------------------+------+-----+-------------------+----------------+ """ id = schema.Int(title=_(u"table primary key"), ) mingcheng = schema.TextLine( title=_(u"cishan juanzeng xiangmu mingcheng"), ) jieshao = schema.Text(title=_(u"cishan juanzeng xiangmu beizhu"), required=False) zhuceshijian = schema.Datetime(title=_(u"kaishi shijian"), defaultFactory=nowDateTime) youxiao = schema.Int(title=_(u"shifou keshi?"), default=0)
class IFashej(Interface): """发射机 """ id = schema.Int(title=_(u"table primary key"), ) sbdm = schema.TextLine(title=_(u"she bei dai ma"), ) sbmc = schema.TextLine(title=_(u"fa she ji ming cheng"), ) # 分系统代码 pcdm = schema.TextLine(title=_(u"zhuang tai pi ci dai ma"), ) #分系统名称 location = schema.TextLine(title=_(u"wei zhi"), ) #分系统类别 freq = schema.Float(title=_(u"gongzuo pinlv"), ) pd_upper = schema.Float(title=_(u"shang bian pin"), ) pd_lower = schema.Float(title=_(u"xia bian pin"), ) num = schema.Int(title=_(u"pinlv dian shu"), ) freq_upper = schema.Float(title=_(u"pinlv shang xian"), ) freq_lower = schema.Float(title=_(u"pinlv xia xian"), ) bw = schema.Float(title=_(u"fashe dai kuan"), ) base_power = schema.Float(title=_(u"ji pin gong lv"), ) tzlx = schema.TextLine(title=_(u"tiao zhi lei xing"), ) bzf = schema.Float(title=_(u"ben zhen pin lv"), ) mid_freq = schema.Float(title=_(u"zhong pin"), ) comment1 = schema.TextLine(title=_(u"bei zhu"), )
class IJingLuo(Interface): """经络: 足太阳膀胱经、足少阳胆经等 """ id = schema.Int(title=_(u"table primary key"), ) mingcheng = schema.TextLine(title=_(u"ming cheng"), )
class IYaoXing(Interface): """药性: 大热、热、平、大寒、寒 """ id = schema.Int(title=_(u"table primary key"), ) xing = schema.TextLine(title=_(u"yao xing"), )
class ICeshibg(Interface): """测试报告 """ id = schema.Int(title=_(u"talbe primary key")) t_id = schema.TextLine(title=_(u"ce shi zheng shu bian hao")) bailor = schema.TextLine(title=_(u"wei tuo fang")) address = schema.TextLine(title=_(u"wei tuo fang di zhi")) device = schema.TextLine(title=_(u"bei ce jian")) eut_id = schema.TextLine(title=_(u"EUT bian hao")) eut_type = schema.TextLine(title=_(u"EUT xing hao")) manufacturor = schema.TextLine(title=_(u"zhi zao shang")) t_date = schema.Date(title=_(u"ce shi ri qi")) t_address = schema.TextLine(title=_(u"ce shi di dian")) t_device = schema.TextLine(title=_(u"ce shi she bei")) t_device_type = schema.TextLine(title=_(u"ce shi she bei xing hao")) t_device_id = schema.TextLine(title=_(u"ce shi she bei bian hao")) reference = schema.TextLine(title=_(u"ce shi yi ju")) temp = schema.Float(title=_(u"wen du")) huminitily = schema.Float(title=_(u"shi du")) t_man = schema.TextLine(title=_(u"ce shi ren yuan")) signer = schema.TextLine(title=_(u"qian fa ren")) assessor = schema.TextLine(title=_(u"shen he ren")) t_result = schema.TextLine(title=_(u"ce shi jie guo"))
class IYaoWei(Interface): """wu wei: 酸、苦、甘、辛、咸 """ id = schema.Int(title=_(u"table primary key"), ) wei = schema.TextLine(title=_(u"wu wei qizhong zhi yiwei"), )
class IDianxingtxzyzk(Interface): """典型天线增益子库 """ id = schema.Int(title=_(u"table primary key"), ) type_antennas = schema.TextLine(title=_(u"tian xian lei xing"), ) gain = schema.Int(title=_(u"zeng yi"), )
class IFashejzk(Interface): """发射机子库 """ id = schema.Int(title=_(u"table primary key"), ) lib_code = schema.TextLine(title=_(u"zi ku dai ma"), ) lib_name = schema.TextLine(title=_(u"zi ku ming cheng"), )