Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ServerID | INT | 10 | √ | null |
|
|
||
| ComputerID | INT UNSIGNED | 10 | √ | null |
|
|
||
| AppAccessAddress | VARCHAR | 1024 | null |
|
|
|||
| WebAccessAddress | VARCHAR | 1024 | √ | null |
|
|
||
| Roles | BIGINT | 19 | null |
|
|
|||
| Password | CHAR | 255 | null |
|
|
|||
| Version | VARCHAR | 255 | null |
|
|
|||
| FriendlyName | VARCHAR | 255 | √ | null |
|
|
This column can only be set at the moment from the Web Servers Advance config window and it is used for quickly identifiying the different web servers deployed |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | ServerID |
Diagram producer might be missing
No diagrams were produced please see application output for any errors