Table Structure Diagram of the Mysql Data Source

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.