威尔迪3000指纹门禁二次开发数据接口.docVIP

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