Research on Trigger’s Serial Numbers of Database Tables
Biqing Huang · 2006
Regarding a serial number as a primary key in the database tables of the logistics information system can increase efficiency.On the one hand,that creating triggers is chosen to fulfill automotive increase of the serial number could rollback,on the other hand,the serial number may be a number type,a char type and a string type and fit respectively for database tables where data records increasing rapidly and slowly,and those serial numbers need padding on the left.It is proved that the design is available and feasible.