SLXWEBSERVER Table

The SLXWEBSERVER table stores information on the configuration details for each Web Server on which the Web Host runs.

Table Relationships

The SLXWEBSERVER table has a (Many) to (Zero or One) relationship with the BRANCHOPTIONS table.

CreateUser and ModifyUser are foreign keys referencing UserID in the USERINFO table.

Legend
 

Field Datatype (Length) Allow Nulls Indexes

SLXWEBSERVERID (PK)

STANDARDID(12)

NOT NULL

SLXWEBSERVER_SLXWEBSERVERID_PK (CA)

PROFILEID(FK)

STANDARDID(12)

NULLS

SLXWEBSERVER (IE)

MACHINE

varchar(64)

NULLS

 

NAME

varchar(64)

NULLS

 

BINDINGS

varchar(64)

NULLS

 

SITECODE(FK)

STANDARDID(12)

NULLS

 

DATA

TEXTBLOB(16)

NULLS

 

CREATEUSER (FK)

STANDARDID(12)

NULLS

 

CREATEDATE

datetime(8)

NULLS

 

MODIFYUSER (FK)

STANDARDID(12)

NULLS

 

MODIFYDATE

datetime(8)

NULLS