Field Name field type field description
Id integer ID
Depart varchar (45) department name
Ename varchar (45) employee name
Pcname varchar (45) PC name
Ipaddr varchar (45) IP Address
Pcmodel varchar (45) PC model
Pcsn varchar (45) PC serial number
Displaymodel varchar (45) display model
Displaysn varchar (45) display serial number
Assetno varchar (45) fixed asset no.
Status varchar (45) device status
Memo varchar (255) Remarks
Location varchar (45) device location
Osver varchar (45) operating system version
Ostckey varchar (60) Operating System cdkey
Msover varchar (45) Office version
Msocdkey varchar (60) officecdkey
SW01 tinyint (1) software 01
SW02 tinyint (1) software 02
Sw03 tinyint (1) software 03
Sw04 tinyint (1) software 04
SW05 tinyint (1) software 05
Sw06 tinyint (1) software 06
SW07 tinyint (1) software 07
Sw08 tinyint (1) software 08
Sw09 tinyint (1) software 09
Sw10 tinyint (1) software 10
Sw11 tinyint (1) software 11
Sw12 tinyint (1) software 12
Sw13 tinyint (1) software 13
Time_stamp Timestamp
By sunec
