1.1.1 structure
1.1.1.1 Structure Description Form
Field name
Types of
width
Primary key * foreign key @
Value constraint
Control parameters
Note
1.2 Database Detailed Design
This classification scheme is classified according to the standard range
1.2.1 code control table
Data category
Data table name
Description
Note
Application data sheet
BMB
Department table
WHB
Cultural degree
ZMB
Political appearance
Gzb
Table
ZGDAB
Staff file form
STB
Test table
DTB
Answer sheet
Sysb
System table
1.2.2 Table Structure and Description
Special Note
* Context this table master key
@ 表式 本 本
1.2.2.1 Table Name: BMB Division Code Table
Explanation: Department of Sector Information in this unit
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 BMNAME CHAR 30
Department Name Department Name
1.2.2.2 Table Name: WHB Culture Level
Description: The cultural level information form of this unit
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 for WHCD Char 10
Cultural level
1.2.2.3 Name: ZMB Culture Level
Description: The political view of this unit
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 ZZMM Char 10
Political appearance political look
1.2.2.4 Name: GZB Culture Level
Description: Treatment of this unit
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 GZNAME CHAR 30
TEM Name Treatment Name
