tblLVST_Calls
Table Description:
tblLVST_Calls is the top level table of the entire database. It determines what format of call log file, the call guid.
Table structure:
| Column Name |
Data Type |
Data Length |
Default Value |
See Also |
| CallID |
INTEGER |
N/A |
N/A |
N/A |
| CallDate |
TIMESTAMP |
N/A |
N/A |
N/A |
| CallGuid |
VARCHAR |
50 |
N/A |
N/A |
| LogPath |
INTEGER |
N/A |
N/A |
N/A |
| LogFname |
VARCHAR |
1024 |
N/A |
N/A |
| LogMajorVersion |
VARCHAR |
10 |
2 |
N/A |
| LogMinorVersion |
VARCHAR |
10 |
2 |
N/A |
Primary Keys:
CallID
| Foreign Key |
Reference Table |
Reference Key |
| LogPath |
N/A |
N/A |
Column Descriptions and Constraints:
| Column |
Description |
Constraint Name |
Constraint Description |
| CallID |
Autoincrementing Primary key for the table. |
UNIQUE |
PRIMARY KEY |
| CallDate |
The date and time the call took place. |
N/A |
N/A |
| CallGuid |
Unique identifier for a particular call. For LumenVox files, the logs are already created
with a globally unique identifier (GUID); converted files from other systems will require
either a (Windows-style) GUID, or create some other kind of unique label for each call.
|
N/A |
N/A |
| LogPath |
The path to the source log file, if one exists. |
N/A |
N/A |
| LogFname |
The source log file name, if one exists. |
N/A |
N/A |
| LogMajorVersion |
The major version number of the log file. |
N/A |
N/A |
| LogMinorVersion |
The minor version number of the log file. |
N/A |
N/A |