Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
operatorid | INT | 10 | √ | null |
|
|
||||||||
vclogin | VARCHAR | 64 | null |
|
|
|||||||||
vcpassword | VARCHAR | 64 | null |
|
|
|||||||||
vclocalename | VARCHAR | 64 | null |
|
|
|||||||||
vccommonname | VARCHAR | 64 | null |
|
|
|||||||||
vcemail | VARCHAR | 64 | √ | null |
|
|
||||||||
dtmlastvisited | INT | 10 | 0 |
|
|
|||||||||
istatus | INT | 10 | √ | 0 |
|
|
||||||||
idisabled | INT | 10 | √ | 0 |
|
|
||||||||
vcavatar | VARCHAR | 255 | √ | null |
|
|
||||||||
iperm | INT | 10 | √ | 0 |
|
|
||||||||
dtmrestore | INT | 10 | 0 |
|
|
|||||||||
vcrestoretoken | VARCHAR | 64 | √ | null |
|
|
||||||||
code | VARCHAR | 64 | √ |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
operator_s_pk | Primary key | Asc | operatorid |
PRIMARY | Must be unique | Asc | operatorid |