MySQL data source table structure diagram _php Foundation

Field Name field type fields description
ID Integer ID
Depart varchar (45) Department name
ename varchar (45) Employee name
Pcname varchar (PC) name
ipaddr varchar (IP) address
Pcmodel varchar (PC) model
PCSN varchar PC Serial number
Displaymodel varchar (45) Display model
DISPLAYSN varchar (45) Monitor serial number
Assetno varchar (45) Fixed asset number
Status varchar (45) Device status
Memo varchar (255) Remark
Location varchar (45) Device location
Osver varchar (45) Operating system version
Oscdkey varchar (60) operating system Cdkey
Msover varchar Office Version
Msocdkey varchar (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 time Stamp

Author: Sunec