Database structure
The xbee_multi_programmer database has five tables:
The following tables provide information about the contents of the database tables.
profile_xbmp
The profile_xbmp table contains information about the profiles used in the tool.
| Column | Type | Description |
|---|---|---|
|
file_md5 |
char(32) |
Primary key. MD5 hash of the profile zip package. |
|
file_path |
varchar(255) |
Profile path. |
|
firmware_info |
varchar(255) |
Firmware information. |
|
hardware_version |
varchar(10) |
Hardware information. |
|
flash_policy |
varchar(35) |
Flash policy. |
|
reset_settings |
varchar(10) |
Reset settings. |
|
description |
varchar(255) |
Profile description. |
|
fs_summary |
varchar(512) |
File system summary. |
|
pre_script_cmd |
varchar(1024) |
Pre-script command. |
|
post_script_cmd |
varchar(1024) |
Post-script command. |
profile_settings_xbmp
The profile_settings_xbmp table contains the different settings associated to the profiles.
| Column | Type | Description |
|---|---|---|
|
profile_id |
char(32) |
Primary key. References to the file_md5 column of profile_xbmp. |
|
at_command |
char(2) |
Primary key. AT command. |
|
at_value |
varchar(40) |
Primary key. AT command value. |
user_xbmp
The user_xbmp table contains information about the users of the tool.
| Column | Type | Description |
|---|---|---|
|
mac |
varchar(16) |
Primary key. MAC address of the user's computer. |
|
name_pc |
varchar(255) |
Computer name. |
session_xbmp
The session_xbmp table contains information about the sessions.
| Column | Type | Description |
|---|---|---|
|
profile_id |
char(32) |
Primary key. References to the file_md5 column of profile_xbmp. |
|
user_mac |
varchar(16) |
Primary key. References to the mac column of user_xbmp. |
|
start_date |
datetime |
Primary key. Date and time when the session started. |
|
end_date |
datetime |
Date and time when the session finished. |
|
num_modules |
int(11) |
Number of devices programmed successfully. |
|
num_errors |
int(11) |
Number of devices not programmed due to an error. |
|
time_per_module |
int(11) |
Average programming time per device. |
programming_task_xbmp
The programming_task_xbmp table contains information about the programming tasks.
| Column | Type | Description |
|---|---|---|
|
profile_id |
char(32) |
Primary key. References to the file_md5 column of profile_xbmp. |
|
user_mac |
varchar(16) |
Primary key. References to the mac column of user_xbmp. |
|
session_date |
datetime |
Primary key. References to the start_date column of session_xbmp. |
|
task_id |
int(11) |
Primary key. Index identifier of the programming task. |
|
task_status |
varchar(10) |
Status of the programming task. |
|
start_date |
datetime |
Complete date at which the programming task started. |
|
board_slot |
varchar(20) |
XBee Multi Programmer board index and socket ID of the device. |
|
elapsed |
int(11) |
Total time (in seconds) elapsed since the programming task started until finished. |
|
mac_address |
varchar(16) |
MAC address of the XBee device corresponding to the task. |
|
details |
varchar(255) |
Information about the error in case the programming task failed. |
PDF
