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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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"), )
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 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 IYaoWei(Interface):
"""wu wei:
酸、苦、甘、辛、咸
"""
id = schema.Int(title=_(u"table primary key"), )
wei = schema.TextLine(title=_(u"wu wei qizhong zhi yiwei"), )
