停车场系统主要数据表

1、智能停车场一卡通数据字典表1:ERECORD（车辆入场表）表2:MYCARGOOUTRECORD（车辆出场表）序号字段名称字段说明字段类型字段大小是否主键允许空默认值(1)卡片号码varchar30(2)车牌号码varchar20Y()(3)卡片种类varchar20Y()(4)入场时间datetime8Y(5)出场时间datetime8Y(6)入场名称varchar100Y()(7)出场名称varchar100Y()(8)入场操作varchar30Y()(9)出场操作varchar30Y(10)入场操作员varchar50Y()(11)出场操作员varchar50Y(12)入场varchar

2、255Y()(13)入场varchar255Y()(14)出场varchar255Y(15)出场varchar255Y(16)证件varchar255Y()(17)金额money8Y(0)(18)卡上余额money8Y(0)(19)应收金额money8Y(0)(20)时间datetime8Y(21)varchar50Y()(22)varchar30Y()(23)口名varchar100Y()(24)超时标志varchar10Y()(25)超时时间datetime8Y(26)超时金额money8Y(0)(27)车场4Y(0)(28)大小标识4Y(0)(29)免费原因varchar100Y()表3

3、: MYFAXINGE（卡片表）序号字段名称字段说明字段类型字段大小是否主键允许空默认值(1)卡片号码varchar30PK(2)varchar30序号字段名称字段说明字段类型字段大小是否主键允许空默认值(1)卡片号码varchar30(2)车牌号码varchar20Y()(3)卡片种类varchar20Y()(4)入场时间datetime8Y(5)出场时间datetime8Y(6)入场名称varchar100Y()(7)出场名称varchar100Y()(8)入场操作varchar30Y()(9)出场操作varchar30Y(10)入场操作员varchar50Y()(11)出场操作员varc

4、har50Y(12)入场varchar255Y()(13)入场varchar255Y()(14)出场varchar255Y()(15)出场varchar255Y()(16)证件varchar255Y()(17)金额money8Y(0)(18)卡上余额money8Y(0)(19)应收金额money8Y(0)(20)时间datetime8Y(21)varchar50Y()(22)varchar30Y()(23)口名varchar100Y()(24)超时标志varchar10Y()(25)超时时间datetime8Y(26)超时金额money8Y(0)(27)车场4Y(0)(28)大小标识4Y(0)

5、(29)免费原因varchar100Y()(3)卡片状态char1Y(0)(4)发卡押金money8Y(0)(5)开通子系统varchar5Y(00000)(6)车场卡类varchar20Y(space(1)(7)车场日期datetime8Y(8)车场人varchar30Y()(9)卡上余额money8Y(0)(10)车场有效起日datetime8Y(11)车场有效止日datetime8Y(12)车牌号码varchar20Y(space(1)(13)车辆颜色big8Y(0)(14)车辆型号varchar100Y(space(1)(15)车场车位varchar100Y(space(1)(16)车

6、场退卡日期datetime8Y(17)车场退卡人varchar30Y()(18)车场有效机号varchar256Y(replicate(F,256)(19)车场有效区号varchar16Y(replicate(0,16)(20)车场备注varchar255Y(space(1)(21)门禁卡类varchar20Y(space(1)(22)门禁日期datetime8Y(23)门禁人varchar30Y()(24)门禁结束日期datetime8Y(getdate()(25)有效开始时间char2Y(00)(26)有效结束时间char2Y(24)(27)门禁有效机号varchar256Y(replic

7、ate(F,256)(28)门禁退卡日期datetime8Y(29)门禁退卡人varchar30Y()(30)门禁备注varchar255Y(space(1)(31)日期datetime8Y(getdate()(32)退卡日期datetime8Y(33)人varchar30Y()(34)退卡人varchar30Y()(35)挂失日期datetime8Y(36)挂失人varchar30Y()(37)卡片物理号varchar30Y(space(0)(38)标识varchar50Y(000000000000000)表4: MYJIBENZILIAO（人事基本资料表）序号字段名称字段说明字段类型字段大

8、小是否主键允许空默认值(1)varchar10PK(2)varchar50Y(space(1)(3)varchar4Y(男)(4)家庭住址varchar200Y()(5)部门名称varchar200Y()(6)职务varchar200Y()(7)入职日期datetime8Y(8)出生日期datetime8Y(9)号varchar50Y()(10)婚否varchar10Y()(11)最高学历varchar50Y()(12)政治面貌varchar50Y()(13)路径varchar256Y()(14)学校varchar50Y()(15)专业varchar50Y()(16)所学外语varchar20Y()(17)特长varchar50Y()(18)号码varchar40Y()(19)号码varchar40Y()(20)varchar30Y()(21)籍贯varchar200Y()(22)车牌号码varchar20Y()(23)车辆型号varc