1.2.2.5 Table Name: ZGDAB Staff Archive
Description: Personnel Information Table
Field name
Types of
width
Primary key * foreign key @
Value constraint
Control parameters
Note
ID INT 4 * non-empty
The only identification is automatically generated by the program GH CHAR 15
The work number must be the only Name Char 10
Name
Bmname char 30
Department
SEX Char 3
gender
BDATE DATE
date of birth
Whcd char 10
Degree of cultural
GZName Char 30
Target name
ZZMM Char 10
political status
PWD Char 80
Password uses encrypted storage
1.2.2.6 Table Name: STB Test Table
Description: Test information (only two kinds of questions)
Field name
Types of
width
Primary key * foreign key @
Value constraint
Control parameters
Note
ID INT 4 * Non-empty test number The only ID is automatically generated by the program GZNAME CHAR 30
Target name
STLX Char 10
Test type
STNR Char 255
Question
STDA Char 10
Test answer answer
1.2.2.7 Name: DTB answer sheet
Description: answer
Field name
Types of
width
Primary key * foreign key @
Value constraint
Control parameters
Note
ID INT 4 * non-empty
The only identification is automatically generated by the program GH CHAR 15
Job number
Sth char 20
Test number
Ksdate Date
examination time
CJ INT 4
Exam score
Da Char 3
What to do
