pdestmask2Sourcemask2actio
图33防火墙规则表ER图
umEthoutE
ableEthi
NameSourceipSourceip2Destip
Destipmasksourceservice
fwd
at
sourcei
terfac
ewebFilter
3fws
atSNAT表ER图如图34所示
Idtimeflagtimestartdayssourceservicesourcei
terfaceNameSourceipSourceip2DestipDestipmask
fws
at
timestopDestip2selectdestip
webFilter
E
ableEthi

selectsourceipSourcemask2destmask2actio
um
Ethout
图34防火墙规则表ER图
9
f4fwip
IP表ER图如图35所示
ame
Id
virtualip
eth
um
fwip
mask图35防火墙规则表ER图
5fwipmacIPMAC绑定表ER图如图36所示
ip
id
fwipmac
图36防火墙规则表ER图
mac
6fwservice服务表ER图如图37所示
ameprotocolports
Id
fwservice
icmptypes
图37防火墙规则表ER图
322数据表设计
1Firewall表设计表31Firewall字段名id
ame中文序号名称类型长度是否为空主键bigi
t20NOTNULL主键char20NULL
10
fsourceipsourceip2destipdestmaskserviceapplicatio
webFilteractio
e
ableethi
umethoutsourcemask2destmask2selectsourceipselectdestipdestip2timeflagtimestarttimestopdays2fwd
at表设计2
源地址1源地址2目的地址1目的地址2服务应用过滤表动作是否启用数据进口编号数据出口源地址子网掩码2目的地址子网掩码选择的源地址选择的目的地址目的地址2是否启用时间开始时间结束时间星期x
char20NULLchar20NULLchar20NULLchar20NULLchar40NULLchar20NULLchar1NULLchar10NULLchar1NULLchar5NULLi
t10NULLchar5NULLchar20NULLchar20NULLchar1NULLchar1NULLchar20NULLchar1NULLchar1NULLchar1NULLchar1NULL表32Fwd
at
字段id
amesourcei
terfacewiresourceipi
eri
terfacedestipsourceservicedestservicestate
umsourceip2sourcemask2
中文序号名称源接口接口源地址数据进口目的地址源服务目的服务状态编号源地址2源地址子网掩码2
类型长度是否为空主键bigi
t20NULL主键char20NULLchar20NULLchar20NULLchar20NULLchar20NULLchar20NULLchar20NULLchar20NULLchar1NULLi
t10NULLchar20NULLchar20NULL
11
fdestip2destmask2selectsourceipselectdestipipmacipmacidstimeflagtimestarttimestopdaysactio
ethi
ethout
目的地址2目的地址子网掩码2选择的源地址选择的目的地址是否启用Ipmac绑定Ipmac绑定是否启用时间开始时间结束时间星期x动作数据进口数据出口
char20NULLchar20NULLchar1NULLchar1NULLchar1NULLchar10NULLchar10NULLchar10NULLchar10NULLchar10NULLchar10NULLchar10NULLchar10NULL
3fws
at表设计表33Fws
at
字段id
amesourcei
terfacewiresourceipi
eri
terfacedestipsourceservicedestservicestate
umsourceip2sourcemask2destip2dr