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	ARCHAR	1024	N/A	N/A
LogMajorVersion	VARCHAR	10	2	N/A
LogMinorVersion	VARCHAR	10	2	N/A

Primary Keys:

CallID

Foreign keys relationships:

Foreign key	Reference table	Reference key
LogPath

Column Descriptions and Constraints:

CallID
Description:Autoincrementing Primary key for the table.
Constraint Name:UNIQUE
Constraint Description:PRIMARY KEY

CallDate
Description:The date and time the call took place.
Constraint Name:N/A
Constraint Description:N/A

CallGuid
Description: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.
Constraint Name:UNIQUE
Constraint Description:Each call identifier must be unique.

LogPath
Description:The path to the source log file, if one exists.
Constraint Name:
Constraint Description:

LogFname
Description:The source log file name, if one exists.
Constraint Name:N/A
Constraint Description:N/A

LogMajorVersion
Description:The major version number of the log file.
Constraint Name:N/A
Constraint Description:N/A

LogMinorVersion
Description:The minor version number of the log file.
Constraint Name:N/A
Constraint Description:N/A