MySQL data source table structure diagram_PHP tutorial

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 number
status varchar(45) Equipment status
memo varchar(255) Remarks
location varchar(45) Equipment location
osver varchar(45) Operating system version
oscdkey 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 timestamp

Author: Sunec

http://www.bkjia.com/PHPjc/318958.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/318958.htmlTechArticleField name Field type Field description idintegerID departvarchar(45)Department name enamevarchar(45)Employee name pcnamevarchar(45)PC Name ipaddrvarchar(45) IP address pcmodelvarchar(45) PC model...