- 15
- 0
- 约1.05万字
- 约 6页
- 2016-04-08 发布于安徽
- 举报
威尔迪3000指纹门禁二次开发数据接口.doc
Second Server DB Table Organization
数据库用户:fdmsusr 密码:fdmsamho
1. ACCESS (MS Access, MS SQL Server)
Item number does as 4 positions, contents of number store to all Intel system.
VarChar is surly approval as Null.
Char, as Varchar, number is all sentence type, English is a capital letter.(formal thing is Default)
Field Type is Key, essential input, empty space indicate approval information.
- in Varbin ,could express form is as following.
. data Format : count + { data (max , size) }
. count (4Byte) : display sink of data all.
. max : Display maximum repeat sink of data
. size : Display size of Data
. { } : It is sign of repetition , Do repeat possibility as much as count
. () : exact value
Registration group information table (tgroup) : Group Information
Type Field Name Type Length Explanation Y-Y- Id Short 2 Group id (reservation to 9 times, 0:no appointment, 1:all appointment,
10: after this use) N-N-Y Name Varchar 30 Group name N-Y-N Reg_date Char 12 Registration time (YYYYMMDDHHMM) N-Y-N Timelimit Char 8 Time limit for accessing (HHMMHHMM) N-Y-N Gate_id VarBin 40004 Registration Gate Id in group. No Gate_Id in group id (0,1)
*Format: count + { gateid(max:10000, size:4) } N-N-Y Remark Varchar 50 Other matters
Registered entrance door table (tgate) : terminal information
Type Field Name Type Length Explanation Y-Y- Id Long 4 Terminal id N-N-Y Name Varchar 30 Terminal name N-Y-N Reg_date Char 12 Registration time (YYYYMMDDHHMM) N-N- Floor Long 4 Installation floor (B1=-1 / 1 floor=1) N-N-Y Place Varchar 30 Installation place N-N-Y Block Char 1 If lock setting up (0:cancellation, 1: setting ) N-Y-N UserCtrl Char 1 door open for user Flag (0: limit entrance 1: open entrance)
When door open for user, entrance door cann’t be included in group. N-Y-N PassTime Char 8 When door open for user, time of entrance permission (HHMMHHMM) N-N-Y Version Char 4 Program version of terminal N-Y-N Admin Varbin 404 Manager list
*Format : count + { ad
原创力文档

文档评论(0)