liu jiaxu.txt

来自「服务器tomcat 数据库mysql Hospital Managemen」· 文本 代码 · 共 56 行

# Host: localhost
# Database: hms
# Table: 'discard'
# 
CREATE TABLE `discard` (
  `EquipNo` int(11) NOT NULL default '0',
  `DiscardDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `DiscardReason` varchar(100) NOT NULL default '',
  `Dr_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`EquipNo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 


# Host: localhost
# Database: hms
# Table: 'equipment'
# 
CREATE TABLE `equipment` (
  `EquipNo` int(11) NOT NULL auto_increment,
  `EquipName` varchar(100) NOT NULL default '',
  `BouDate` date NOT NULL default '0000-00-00',
  `DeptBelong` varchar(100) NOT NULL default '',
  `EquipPurchaser` int(11) NOT NULL default '0',
  `Dr_id` int(11) NOT NULL default '0',
  `EquipRoomNo` int(11) NOT NULL default '0',
  `EquipDetails` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`EquipNo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='The base information of the equipments'; 


# Host: localhost
# Database: hms
# Table: 'equipmentusing'
# 
CREATE TABLE `equipmentusing` (
  `UsingDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `EquipNo` int(11) NOT NULL default '0',
  `Dr_id` int(11) NOT NULL default '0',
  PRIMARY KEY  (`UsingDate`,`EquipNo`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 


# Host: localhost
# Database: hms
# Table: 'maintain'
# 
CREATE TABLE `maintain` (
  `MaintEquipNo` int(11) NOT NULL default '0',
  `MaintDate` datetime NOT NULL default '0000-00-00 00:00:00',
  `MaintCost` float NOT NULL default '0',
  `Dr_id` int(11) NOT NULL default '0',
  `MaintType` int(11) NOT NULL default '0',
  PRIMARY KEY  (`MaintEquipNo`,`MaintDate`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;