QX/T 435-2018 农业气象数据库设计规范

QX/T 435-2018 QX/T 435-2018 Agricultural Meteorological Database Design Specification

行业标准-气象 简体中文 现行 页数:36页 | 格式:PDF

基本信息

标准号
QX/T 435-2018
标准类型
行业标准-气象
标准状态
现行
中国标准分类号(CCS)
国际标准分类号(ICS)
发布日期
2018-07-11
实施日期
2018-12-01
发布单位/组织
中国气象局
归口单位
全国农业气象标准化技术委员会
适用范围
本标准规定了农业气象数据库设计的基本原则、数据库实例与对象命名规则、数据库字段设计规则,给出了数据库表结构说明。 本标准适用于农业气象数据库的设计、开发与应用。

发布历史

研制信息

起草单位:
国家气象中心、武汉区域气候中心、贵州省气候中心、国家气象信息中心
起草人:
庄立伟、吴门新、王颖、刘可群、徐永灵、李轩、姜月清
出版信息:
页数:36页 | 字数:- | 开本: -

内容描述

!"#!"#!$!

$%&

:;<!'%(")"*!%(

,-./0123$4"56

5678'()"*!%&

!"#$%&'()*+

#%&'()('*+(,-,)*./,0&+&,/,1,.('*12*+*3*4&2&4(.-

*!%&+!"+%%89*!%&+%*+!%=>

,2#$789

!"!#!"#"$%&'

!!!"

!"########################################!

!!$%#######################################!

"!&$'()*+##################################!

#!,-./#####################################!

$!0123456&/################################!

%!0127856&/################################!

&!0129:;<&/################################"

'!012=>?@A##################################

BC(!DE'BC"!FGH8012IJKL56M4##################$

BC)!&$'BC"!FGH8NO012=56#####################%

BC*!DE'BC"!PQH8NOR0STHUV012=56##############+

BC,!&$'BC"!FGH8WXYZ#########################-

BC.!&$'BC"!FGH801=>?@A#####################!#

[\*]########################################

"

!"!#!"#"$%&'

#!!$

!!-^_`a/)#0!1!$"22-bcd&/ef%

-^_ghiFGH8^_jklmno!3(*#0*%#-"pcqrs%

-^_eftu&ivH8wx'yz{|H}wx'~€H}wx'ivH8‚wx%

-^_ƒWef„&…†‡'ˆ‰Š'‹Œ'Ž'‘’'“”'•–—%

!

!"!#!"#"$%&'

%&'()*+,-./

&!/0

-^_&˜™FGH8012;<d,-./'01234R7856&/'0129:;<&

/(bc™012=>?@A%

-^_š)›FGH8012d;<'œRž)%

$!./12345

Ÿ

*+7›-*+dž)¡¢£Ž¤d%¥¡¦§¨d()*+(©¦§¨dª-š)›-*

+%¥¡£¦§¨d()*+(«¬Šª-!­®¯°d±²t"š)›-*+%

45#0!##$"2!!!H8WX³´RµZ

45#0"##$"2!$!H8012IJKL56

45#0"-"$"2!%!FGH8NODE¶·*+¸¹

"!6789

º)»¼012;<kl(½¾01201¿À(ÁÂÃÄ$¹!678679:;<=:>?@A=:>(ÅÆ#BC"

&˜d;<WÇ%

:#ÃÄ$¹WÇÈÉ01=w£­ÊËÌ«Í=wË­Êd΃»Ï9‚%

!!)*+;<=>.9

FGH80123456`a45#0"##$"2!$wÃ%Ðd&˜ÑÒ(FGH8012ÓÔYZ

Õ)(/D.,)*%

FGH80123456M4[ÖBC(d(1!%

#!)*+?(=>.9

0127856`a45#0"##$"2!$wÃ+Ðd&˜ÑÒ(רÙ001278d^ÚZÕ

)CEB*%

FGH8NODE³´ÛYZ[a45#0!2"$"22-w%1'd&˜µÜ(FGH8NODEÝÞ

ß'³´ÛYZÖ=!%

°»FGH8012=56`a45#0"##$"2!$wÃ&Ðd&˜ÑÒ%«w(FGH8NO0

12=56ÖBC)+à»dPQH8NOR0STHUV012=56[ÖBC*%

!

!"!#!"#"$%&'

@&!%&'(ABCDEFG1HIJKL

ÝÞß'³´YZ@A

áâãäå'æçãäè'æçéâêëè'æç³ìíéâêëè'áâ

áâWX*FGHîèïX'áâîè>?'»ÏFðñò'óô,-õö÷ø'óôãåùö

÷ø'áâîèúûü

ýþú*âLÓ''ýþà7ÿ!'ýþëèÊú"'ýþ#$Êúè'ýþ

ýþú³WX3GIJ°%ú³&Iè'ýþú³'&Iè'ýþ(>R)('éý*RPŸúu'

+ú,-R./ü

01â}WX3.(3æâ}234Ûòââ}¨'H8ú*58ü

7få¨'7fãä8!'7ff*8!'7f³9îè'7f:;!<v

67H8WXH(306º=!',><?,>@!'v6AõüB÷ø'v6CDë÷ø'6,

-õö÷ø'7ðñò÷øü

Fô'ÓFFG';GFGüHPH*wdIJ'KHL!Ûÿ!'M'NO

FGEH}WX(D*J

jP(Q<ýþL!Ûÿ!ü

R>WXCFG.R>â}'ãäùö(Q<SRT>?'UTâü

VWWXCFEIVWâ}'ãäùö'îè'Xêü

YZWXK./.YZå¨'ãäùöü

[\]GWXCI3L[\úQã^_`a+(Q<[\78dãäbø'îè³c'ãîñòü

FGH8deNOR÷ø'7fde'v6de'æâde'SRH8de'

FGH8deWX,I3(

SRfdü

ghãâWX,.3GghdFáâ'f-æâ'>-æâÛghæiãäùöü

jkRÿPWXM.0Jjklmæâd5Iè'nBãîo(ÿPæâ'òâ(Q<ú_`ü

ýþú³0òNOWX(3Dýþà7ÿ!'ýþëèÊú"'ýþ#$Êúè'ýþ°%ú³&Ièü

áâå¨'áâp*8!'áâãäùö'æç:;!!@!"'áâÓÔq

áâãäå0òNOWX(*H

(!)*+MN,-.9

(1&!MNIO#P.9

!!FGH801278à»9:(º)QK'4'*Û,ü9sáÕ!t()Q=M«01´u(Ö="%

@$!MNIO#PQR

9:´u!t9:01´uÊv

KJGB/!w0u01"+BED).F!E0u01"

4àžK´u9:dêèxÜ:

*K(F*L(F!yä9zu01"+*L(F!˜ä9zu01"

,,(0.!§¨u01"

"

!"!#!"#"$%&'

(1$!'(STUVMN=>

H8WXYZg%u09{|(=MÕ55NNN%

55ÕWX´uZ(FGH8WX´uZÕ)$+*(NNNÕWXZ%FGH8WXYZÖBC,w

=,1!}=,1%%

«ÍH8WXYZÁa45#0!##$"2!!wÃ$Ðd&˜ÑÒ%

FGH8WX9:6Æg9:´u!tÛWXYZ{|(«WX9:56M4[ÖBC(d

(1"%

(1"!'(STWXMN=>

H8WXQ~d«ÍWX9:º)€!H?OP?@"56&/ÑÒ(‚ƒy06ÛÙ¹6Æ¡g„

Ʌ„ÉQ†t9‡>ÌÈe(ˆ?|d‰Èڊ9:‹(ՙŒy0ÛÙ¹dŽŽ'(t9£

žQK¸‘œ…‡’“!"'”•!,"‡>(ÃÈÉt9–9sº)ó—9s(˜™t9d–9sš)ó

—9s(›ÈÉt9d–9sœº)ó—9sd56¸¹%

H8WXQ~9:56M4[ÖBC(d(1#%

)!)*+@YZQR

)1&!%&'(AB)*

)1&1&!FGH8„NO­®áâ'ýþú³'01â}'67H8'FGH8dež´WX(NODE

ÝÞÖ45#0"-"$"2!%w$1"d&˜(«01=>?ÖBC.w=.1!}=.1#%%

)1&1$!FGH80òNO­®áâãäåÛýþú³WX(«01=>?ÖBC.w=.1#&Û=

.1#'%

)1$!AB[!6\]L

FGH8NOŸ

,¡µZ01=IJáâ6Æ'òæâ6ÆQ<NOŸ

üWXd°»µZ0

1(«01=>?ÖBC.w=.1#+}=.1%%%

#

!"!#!"#"$%&'

^!_!$

$CD1^_%

%&'()*+`abc=>d<

$%&!%&'()*+;<=>d<

)ivH8wxFGH8012*56Õ)B,)()Q,3,(/D.,)*+

)j¢€FGH8012*56Õ)H,)*ML,3,(/D.,)*%

$%$!%&'(STMN=>d<

)áâ6Æ*56Õ)*$+222*+

)7f6Æ*56Õ)*$+#22*+

),£¤!*56Õ)K$+2!%*%

$%"!'(STWXMN=>d<

)¥6*Õ)3P98<69A9PB?>8*+

)ú**Õ)LR;:*+

)ú*586Æ*Õ)LR;:B?>8*%

$

!"!#!"#"$%&'

^!_!&

$./1^_%

%&'(AB)*+@=>

&%&!%&'(efAB)*@

=)1!bc™áâ'ýþú³'01â}'67H8ÛFGH8deü„NO01=—t%

@&%&!%&'(efAB)*@gh

w*=6=^Ú@A

áâãäå(/D.,*LB,*FGH,,.K.JGHIJáâãäå01

æçãäè(/D.,*LB,*FGH,/FGM0LIJáâãäè໳c01

æçéâêëè(/D.,*LB,*FGH,CIJJIB/IJæç¦§ë'¨§,£¤!ü01

æç³ìíéâêëè(/D.,*LB,*FGH,,FNIJæç³ìíéâêOè01

áâîèïX(/D.,*LB,*FGH,C(*0GF3IJáâîèïX01

áâîè>?(/D.,*LB,*FGH,30FE*0EF.IJáâîè>?01

»ÏFðñò(/D.,*LB,*FGH,C(FDIB/IJ»ÏFðñò01

óô,-õö÷ø(/D.,*LB,*FGH,)(3.IJóô,-õö÷ø01

óôãåùö÷ø(/D.,*LB,*FGH,CI.J,IJóôãåùö÷ø01

áâîèúû(/D.,*LB,*FGH,NI.J,IJO©Ûªáâîèúû01

ýþú*âLÓ'(/D.,*LB,3GIJ,*GB30(B0IJýþú*âLÓ'01

ýþà7ÿ!=(/D.,*LB,3GIJ,FLIJýþà7ÿ!01

ýþú³'&Iè(/D.,*LB,3GIJ,0M*IJú³'&Iè01

ýþ°%ú³&Iè(/D.,*LB,3GIJ,(M*IJ°%ú³&Iè01

ýþëèÊú"(/D.,*LB,3GIJ,MD*IJýþëèÊú"01

ýþ(>R)((/D.,*LB,3GIJ,CF..S.IJýþ(>R)(01

éý*RPŸúu(/D.,*LB,3GIJ,,3JIJéý*«!ÛPŸúu¬!01

+ú,-R./(/D.,*LB,3GIJ,FIIIJ+ú',-è…./¬!01

æâ}234Ûòââ}¨(/D.,*LB,3.(3,HL.BGIJòæââ}¨01

H8ú*58(/D.,*LB,3.(3,LN,FGIJH8'ú*5801

7få¨(/D.,*LB,H(30,/FGM0LIJ7få¨01

7fãä8!(/D.,*LB,H(30,L.I/LIJ7fãä8!01

7f³9îè(/D.,*LB,H(30,NI.J,IJ7f³X9îè01

7f:;!<v6º=!(/D.,*LB,H(30,*GK.FIJ7f:;!<­7®v6º=!01

,><?,>@!(/D.,*LB,H(30,,.B3I0NIJ,>'?,>@!01

v6AõüB÷ø(/D.,*LB,H(30,/F(,.IJv6AõüB÷ø01

%

!"!#!"#"$%&'

@&%&!%&'(efAB)*@gh!™"

w*=6=^Ú@A

v6CDë÷ø(/D.,*LB,H(30,QI.N(B/IJv6CDë÷ø01

6,-õö÷ø(/D.,*LB,H(30,)(3.IJ6,-õö÷ø01

7ðñò÷ø(/D.,*LB,H(30,(*0IKI0NIJ7ðñò÷ø01

7ff*8!(/D.,*LB,H(30,/JLIJ8'¯*f8!01

FGH8deNO(/D.,*LB,,I3(,G)3.IJFGH8deNO01

FGH8de÷ø(/D.,*LB,,I3(,IBK.3IJFGH8de÷ø01

7fde(/D.,*LB,,I3(,H(30IJ7fde01

v6de(/D.,*LB,,I3(,JIK.30G*TIJv6de01

æâde(/D.,*LB,,I3(,HJ(B0IJæâde01

&%$!%&'(ijAB)*@

=)1"bc™áâãäåÛýþú³0òNO01=—t%

@&%$!%&'(ijAB)*@gh

w*=6=^Ú@A

IJáâå¨'p*8!'æç:;!!@!"ü

áâãäå0òNO01(/D.,*LB,(*H,,.K.JGH

01

ýþú³0òNO01(/D.,*LB,(3D,LGFIJ›E‹ýþú³01

&%"!%&'(AB[!6\]L@

=)1#bc™FGH8NOŸ

,¡µZ01=—t%

@&%"!%&'(AB[!6\]L)*@gh

w*=6=^Ú@A

áâ6ƵZ(/D.,*LB,H(F(,*FGH,B(D.,*G,IJáâ6ƵZ

7f6ƵZ(/D.,*LB,H(F(,H(30,B(D.,*G,IJ7f6ƵZ

æâ<òâ6ƵZ(/D.,*LB,H(F(,HJ(B0,B(D.,*G,IJæâ'}2'34Ûòâ6ƵZ

de6ƵZ(/D.,*LB,H(F(,,I3(,*G,IJde6ƵZ

H8ú*58µZ(/D.,*LB,H(F(,LN,F,*G,IJH8'ú*58µZ

áâîèïXµZ(/D.,*LB,H(F(,C(*0GF,*G,IJáâîèïXµZ

áâîè>?µZ(/D.,*LB,H(F(,30FE*0EF.,*G,IJáâîè>?µZ

ôáŸ

µZ(/D.,*LB,H(F(,C(FDIB/,*G,IJôáŸ

µZ

&

!"!#!"#"$%&'

@&%"!%&'(AB[!6\]L)*@gh!™"

w*=6=^Ú@A

áâå¨µZ(/D.,*LB,H(F(,,.K.JGH,*G,IJáâå¨µZ

â}¨µZ(/D.,*LB,H(F(,HL.BG,*G,IJâ}¨µZ

P:´uµZ(/D.,*LB,H(F(,3GIJ,JG(*0IGB,*G,IJP:´uµZ

ý*ù^µZ(/D.,*LB,H(F(,3GIJ,30(0E3,*G,IJý*ù^µZ

U<7îèd°±µZ(/D.,*LB,H(F(,GE0HE0,.CC.*0,*G,IJU<7îè°±µZ

67deüBµZ(/D.,*LB,H(F(,JIK.30G*T,,I3(,*G,IJ67deüBµZ

f*ùö²³µZ(/D.,*LB,H(F(,H(30,.K(JE(0.,*G,IJf*ùö²³µZ

v6º=!µZ(/D.,*LB,H(F(,H(30,,./F..,*G,IJv6º=!µZ

v6AõüBµZ(/D.,*LB,H(F(,JIK.30G*T,,./F..,*G,IJv6AõüBµZ

76ñòŸ

µZ(/D.,*LB,H(F(,JIK.30G*T,(*0IKI0,*G,IJ76ñòŸ

µZ

'

!"!#!"#"$%&'

^!_!'

$CD1^_%

kl'(ABJ)mn'op)*+@=>

'%&!kl'(AB)*

=*1!bc™PQH8NO01=—t%

@'%&!kl'(AB)*@gh

w*=6=^Ú@A

wiPQ§S013EFC,*LB,DEJ,,(Nwi´§PQH801

wiPQµ¶§S013EFC,*LB,DEJ,,(N,DDE0wi#2¶H}^_´§PQH801

wiPQ´E‹013EFC,*LB,DEJ,LGFwi´E‹PQH801

wiPQ§a013EFC,*LB,33,,LGFwi´E‹§a‹001

wiýþL!013EFC,*LB,/30,LGFwi´E‹ýþL!01

h·PQ§S013EFC,/J),DEJ,,(Nh·´§PQH801

'%$!)mn'op)*

=*1"bc™0STHUV01=—t%

@'%$!)mn'op)*@gh

w*=6=^Ú@A

DG30STHUV01B(C,,*LB,DG3,CGF›T2+‹'"2‹eV¸¹'Tdº»jUVîX

+

!"!#!"#"$%&'

^!_!(

$./1^_%

%&'(STKL

=,1!}=,1%bc™áâ'ýþú³'01â}'67H8ÛFGH8deWXYZ%

VW'R>'[\]G'FGEH}Ûã^H8WXYZÕ%22#+--(«w&

$$$%22#%$-&VW'R>WX+

$$$%%2#%--&[\]GWX+

$$$&22#&$-&FGEH}WX+

$$$&%2#+--&ã^H8WX+

)¼0gרdWXYZÕ-22#---%

@(%&!qrSTKL

WXYZ

WX6Æ

55NNN

$+222áâ6Æ

$+22!å¨

$+22"áâNOQ$

$+22#ãäè

$+22$å¨½û

$+22%æç8!

$+22&ãäùö

$+22'æç@!

$+22+æç:;"!:;!"

$+22-å¨¾³"

$+2!2¿Q$À0

$+2!!¨§Êú"

$+2!"ìí…ç!Á"Êú"

$+2!#ãä"

$+2!$¦§ë

$+2!%,£¤!

$+2!&îèïX

$+2!'îè>?

$+2!+Fðñò6Æ

$+2!-ôáGêè

$+2"2FðñòÂÃ۝Ä

$+2"!óôúû

-

!"!#!"#"$%&'

@(%&!qrSTKL!™"

WXYZ

WX6Æ

55NNN

$+2""óôtî

$+2"#O©tî

$+2"$ªûÅtî

$+2"%ªîèŒÆî¾³"

$+2"&ìí6Æ

$+2"'ç!Á"Çë

$+2"+ç!Á"éë

$+2"-ûÂÈç!Á"Çë

$+2#2ûÂÈç!Á"éë

$+2#!áâp*8!

$+2#"áâÓÔqr

$+2##áâÓÔqr¸¹

@(%$!stuHSTKL

WXYZ

WX6Æ

55NNN

$+!22ýþú³NOP:´u

$+!2!ý*¬!

$+!2"ý*ù^

$+!2#éý*«!

$+!2$PŸúu¬!

$+!2%+ú,-è…./¬!

$+!2&+ú,-…./c5‹:

$+!2'ýþÞë

$+!2+UÉÿ!

$+!2-ôÊúè

$+!!2ýþà7ÿ!

$+!!!ýþëèÊú"

$+!!"ýþ#$Êúè

$+!!#ýþú³'&Iè

$+!!$ýþ°%ú³&Iè

$+!!%ýþËÌè

$+!!&,-…+ú^Í

!2

!"!#!"#"$%&'

@(%"!ivrwSTKL

WXYZ

WX6Æ

55NNN

$+"22>-æâ'f-æâ'}2'34Ûòâ6Æ

$+"2!f-æâ6Æ

$+"2">-æâ6Æ

$+"2#}2!34"6Æ

$+"2$òâ6Æ

$+"2%â}¨6Æ

$+"2&H8ú*58

@(%!!xy'(STKL

WXYZ

WX6Æ

55NNN

$+#227f6Æ

$+#2!7få¨

$+#2"7få¾³"

$+#2#7fãä!f*"8!

$+#2$®P´u

$+#2%f*´u

$+#2&7féë

$+#2'7fÇë

$+#2+7féÇÎ

$+#2-7f:;!

$+#!2f*ùö²³

$+#!!v6º=!

$+#!"v6º="

$+#!#›ÏÐç!Ñ"0

$+#!$›ÏÐ'ç!Ñ"0

$+#!%AõüB

$+#!&|6Ò0

$+#!'Ó6Ò0

$+#!+CD#ë

$+#!-CDûÅ#ë

$+#"27ðñò6Æ

!!

!"!#!"#"$%&'

@(%!!xy'(STKL!™"

WXYZ

定制服务

    相似标准推荐

    更多>