1.2.2.8 Table Name: UserB user table
Description: User information table
Field name
Types of
width
Primary key * foreign key @
Value constraint
Control parameters
Note
ID INT 4 * non-empty
Unique identifier is automatically generated by the program Uname Char 4
user name
Ujb charr
User level is divided into administrators and ordinary users two UPWD Char 8
User password uses encrypted storage JSKIN INT 4
Procedure
JBMP Char 4
Program background
TDA CHAR 4
Archive rights are divided into read-only, reading and writing and unreadable. TJCK Char 4
Basic library TSTK Char 4
Question Bank
1.2.2.9 Table Name: SYSB System Table
Description: Save touch screen and system parameters, etc.
Field name
Types of
width
Primary key * foreign key @
Value constraint
Control parameters
Note
ID INT 4 * non-empty
The unique identifier is automatically generated by the program COMPANY CHAR 50
Using unit name
Sn char 80
Registration Number
TBMP Char 255
Touch screen background
TSTL INT 4
Monthly answer quantity
TDTT INT 4
Each question
TSKIN INT 4
Touch screen interface style
TPWD Char 80
Password when exiting the touch screen
