Database table structure
Web Access Recorder has install script and it contains ddl to make database table used in this application.
- Location of the Install Script
- Source code of each ddl
The isntall script is in the "[ALINOUS_HOME]/install/" folder.
The "install.alns" is the main module and it execute other script including ddls.
The ddls are classified by the functions. The Web Access Recorder has functions below.
- Web Archive
- Generate Heat Map
- Log website visitor's actions
The ddl of the web archiver is written at "archveddl.alns". The source code is below.
archive_page" table store the html of the page, and the "
The ddl of the Heat map is written at "archveddl.alns" The source code is below.
The Web Access Recorder has 2 type of heat maps. The mouse move heat map and window scroll heat map.
The mouse move heat map uses
The window scroll heat map uses
Both heatmap stores the result image into the "hm_raster_line" or "hm_scroll_result_image". Then the image is encoded in the Base64 format.
The ddl of the user action log is written at "archveddl.alns" The source code is below.