Database Table: LMSERVER

This table holds the LikeMinds server information.

Column Name Column Type Column Description
HOSTNAME VARCHAR (128)
NOT NULL
The host name of the LikeMinds server.
LMENGINENAME VARCHAR (64)
NOT NULL
The name of the LikeMinds engine.
LMENGINETYPE VARCHAR (64)
NOT NULL
The type of LikeMinds engine, for example ClickstreamEngine.
LMSERVER_ID INTEGER
NOT NULL
The ID of the LikeMinds server.
LMSETNAME VARCHAR (64)
NOT NULL
The name of the transaction set used on the LikeMinds server.
PORT INTEGER
NOT NULL, DEFAULT 2620
The port number of the LikeMinds server.
STOREENT_ID INTEGER
NOT NULL
The ID of the store with which this server is associated.
Indexes:
Index Name Indexed Column Names Index Type
I0000147 HOSTNAME, PORT, LMENGINENAME Unique Index
I0000311 LMENGINETYPE, STOREENT_ID Non-Unique Index
SQL030416034953560 LMSERVER_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_421 STOREENT_ID STOREENT STOREENT_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable