my-pic

平面地图MAPID: intWIDTH: intHEIGHT: intMAPNAME: varchar(50)MAPFILENAME: varchar(100)DEFAULTMAP: intPARENT_ID: intMAP_IMAGE: imageLNG: varchar(20)LAT: varchar(20)USER_INFO: varchar(60)ADDR_INFO: varchar(200)USER_PHONE: varchar(20)DELETED: bit

系统编码ROLEID: intROLE_FLAG: varchar(200)IS_HALF: intGB_NODE_FLAG: varchar(20)TRADE_CODE: varchar(2)\t

角色-平面地图ROLE_ID: intMAP_ID: int\t

锁定摄像头日志信息 VIDEOID: intBEGINTIME: varchar(20)ENDTIME: varchar(20)CREATETIME: datetimeLOCKUSER: varchar(50)

用户信息表USER_CODE: varchar(100)USER_NAME: varchar(100)PASSWORD: varchar(100)SEX: intDEPT_CODE: varchar(100)DEPT_NAME: varchar(100)ADDRESS: varchar(200)DUTY: varchar(200)USER_DESC: varchar(200)IDCARD: varchar(100)USER_TYPE: varchar(20)POLICE_ID: varchar(100)OFFICE_PHONE: varchar(100)TELEPHONE: varchar(100)LEADER: varchar(100)POLICE_TYPE: varchar(100)CREATOR: varchar(60)TOKENID: varchar(100)IP_ADDRESS: varchar(200)MAC_ADDRESS: varchar(200)IS_IP_MAC_AUTO_LOGIN: intCAID: varchar(100)CREATE_TIME: varchar(20)EFFECT_BEGIN: varchar(20)EFFECT_END: varchar(20)LOCK_STATUS: intDEPT_ASSET_CODE: varchar(100)LAST_LOGIN_TIME: varchar(20)USER_PIC_PATH: varchar(256)

控制权限信息 ID: intVIDEOID: intUSERCODE: varchar(50)

用户-角色信息表 ROLEID: intUSER_CODE: varchar(50)\t

角色-系统编码SYS_FLAG_LENGTH: intDEVICE_FLAG_LENGTH: intSYS_STANDARD: int\t

角色信息 ROLEID: intROLENAME: varchar(50)