Mysql to create a general equipment Management Information System database _mysql

Below through an illustrated way to introduce the general equipment Management Information System database creation process, details please see below.

Equipment table: ID, name, category, model, date of shipment, date of purchase, manufacturing unit, quantity, unit of measurement, use Department, installation
Location, product pictures, technical data, notes;

Defect table: ID, Device ID, defect description, handling situation, handling personnel;

Accident table: ID, Equipment ID, accident description, handling situation, handling personnel;

Maintenance category table: ID, category name, maintenance content, cycle (days)

Device category table: ID, category name;

Department table: ID, department name;

Device status table: ID, status name

Device status: Specifies the status of the device, its status data are: On-line, sealed, idle, scrap, to repair, standby

Maintenance personnel table: ID, name, Department, title, title;

Spare Parts table: ID, name, quantity, unit of measure, use, on-hand inventory, minimum stock;

Tool table: ID, name, quantity, unit of measure, use;

Maintenance record sheet: ID, maintenance category ID, equipment ID, maintenance personnel, maintenance, maintenance time, material consumption;

Equipment Inspection table: ID, equipment ID, inspection date, inspection personnel, inspection, inspection methods;

Create Database devmng; 

CREATE TABLE Equipment 
( 
Equipmentid int not null auto_increment, 
devtypeid int, 
devname varchar (50), C5/>modnum varchar, 
touyundate date, 
gourudate date, zhidaodw 
varchar (m), 
quantity int, 
Unit varchar (8), 
usedepartment varchar (m), 
storeplace varchar, picture 
varchar (256), 
Technicaldata varchar (256), 
remark varchar (256), 
primary KEY (Equipmentid) 

CREATE TABLE Devbug 
( 
bugid int not null auto_increment, 
devid int, 
bugcontent varchar (256), 
Chuliqk varchar (MB), 
chuliren varchar (), 
primary KEY (BugID) 
); 
CREATE TABLE Devfault 
( 
faultid int not null auto_increment, 
devid int, 
faultcontent varchar (256), 
chuliqk varchar (MB), 
chuliren varchar, 
primary KEY (Faultid) 

CREATE TABLE RepairType 
( 
rtid int not null auto_increment, 
rtname varchar (), 
rtcontent varchar (256) , 
cycle int, 
primary KEY (Rtid) 
); 
CREATE TABLE Devtype 
( 
dtid int not null auto_increment, 
dtname varchar ( 
), primary key (Dtid) 
); 
CREATE TABLE Part 
( 
ptid int not null auto_increment, 
partname varchar (), 
primary KEY (Ptid) 

CREATE TABLE Devstatus 
( 
dsid int not null auto_increment, 
dsname varchar (), 
primary KEY (DSID) c25/>); 
INSERT into devstatus values (1, "online"); 
INSERT into Devstatus values (2, "sealed"); 
INSERT into Devstatus values (3, "idle"); 
INSERT into Devstatus values (4, "scrap"); 
INSERT into Devstatus values (5, "to be repaired"); 

CREATE TABLE Repairpl 
( 
rpid int not null auto_increment, 
ptid int, 
rpname varchar (), 
Zhiwu varchar (), 
Zhich varchar (), 
primary KEY (Rpid) 
); 
CREATE TABLE BPBJ 
( 
bbid int not null auto_increment, 
bbname varchar (+), 
num int, 
unit varchar (8), 
purpose varchar (256), 
xianyounum int, minnum 
int, 
primary KEY (Bbid) 

Note: use is a keyword; cannot be used as a field name;

CREATE TABLE Tools 
( 
TID int not null auto_increment, 
tname varchar (+), 
num int, Unit 
varchar (8), 
purpose varchar (256), 
primary KEY (TID) 
); 
CREATE TABLE Rprecords 
( 
rrid int not null auto_increment, 
rtid int, 
equipmentid int, 
Rpren varchar, 
rpcontent varchar (+), 
rpdate date, 
Wuliao varchar (m), 
primary KEY (Rrid) 

CREATE TABLE Checkrecords 
( 
crid int not null auto_increment, 
equipmentid int, 
checkdate date, 
Checkren varchar, checkcontent varchar (MB), Checktype varchar (primary) 
); 

Adds a Device status column for the device table;

Database Resource Downloads

Http://pan.baidu.com/s/1bpnx1YR

The above content is for MySQL to create a general equipment management Information System database of all the content, I hope to help!