new project 20060625 1603.sql

java医院应用包含门诊挂号收费住院等应用比较好用

-- MySQL Administrator dump 1.4
--
-- ------------------------------------------------------
-- Server version	4.1.15-nt


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;


--
-- Create schema hospital
--

CREATE DATABASE /*!32312 IF NOT EXISTS*/ hospital;
USE hospital;

--
-- Table structure for table `hospital`.`charge`
--

DROP TABLE IF EXISTS `charge`;
CREATE TABLE `charge` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `chargeid` varchar(45) NOT NULL default '',
  `regid` varchar(45) NOT NULL default '',
  `name` varchar(45) NOT NULL default '',
  `money` double unsigned NOT NULL default '0',
  `chargetime` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `hospital`.`charge`
--

/*!40000 ALTER TABLE `charge` DISABLE KEYS */;
INSERT INTO `charge` (`id`,`chargeid`,`regid`,`name`,`money`,`chargetime`) VALUES 
 (1,'0001','0002','周',12.2,'2006-5-31 10:57:31'),
 (2,'0002','0001','周',29.1,'2006-5-31 11:04:55'),
 (3,'0003','0001','周',29.1,'2006-6-3 13:28:51'),
 (4,'0004','0001','周',29.1,'2006-6-3 13:51:21'),
 (5,'0005','0001','周',29.1,'2006-6-3 14:03:40'),
 (6,'0006','0001','周',29.1,'2006-6-3 14:14:35'),
 (7,'0007','0001','周',29.1,'2006-6-3 14:57:44'),
 (8,'0008','0001','周',29.1,'2006-6-3 14:59:49'),
 (9,'0009','0001','周',29.1,'2006-6-3 15:02:10'),
 (10,'0010','0001','周',29.1,'2006-6-3 15:03:10'),
 (11,'0011','0001','周',29.1,'2006-6-3 15:04:37'),
 (12,'0012','0002','周',34.4,'2006-6-6 22:27:26');
/*!40000 ALTER TABLE `charge` ENABLE KEYS */;


--
-- Table structure for table `hospital`.`charge_list`
--

DROP TABLE IF EXISTS `charge_list`;
CREATE TABLE `charge_list` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `regid` varchar(45) NOT NULL default '',
  `drugid` varchar(45) NOT NULL default '',
  `uprice` double unsigned NOT NULL default '0',
  `price` double unsigned NOT NULL default '0',
  `num` int(10) unsigned NOT NULL default '0',
  `name` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `hospital`.`charge_list`
--

/*!40000 ALTER TABLE `charge_list` DISABLE KEYS */;
INSERT INTO `charge_list` (`id`,`regid`,`drugid`,`uprice`,`price`,`num`,`name`) VALUES 
 (1,'0001','0001',2.55,5.1,2,'红霉素'),
 (2,'0002','0002',3.55,7.1,2,'青霉素'),
 (3,'0002','0001',2.55,5.1,2,'红霉素'),
 (4,'0002','0001',2.55,5.1,2,'红霉素'),
 (5,'0002','0003',6,12,2,'螺旋霉素'),
 (6,'0001','0003',6,24,4,'螺旋霉素'),
 (7,'0002','0001',2.55,5.1,2,'红霉素');
/*!40000 ALTER TABLE `charge_list` ENABLE KEYS */;


--
-- Table structure for table `hospital`.`drug`
--

DROP TABLE IF EXISTS `drug`;
CREATE TABLE `drug` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `drugid` varchar(45) NOT NULL default '',
  `name` varchar(45) NOT NULL default '',
  `standard` varchar(45) NOT NULL default '',
  `num` int(10) unsigned NOT NULL default '0',
  `uprice` double unsigned NOT NULL default '0',
  `remark` text NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `hospital`.`drug`
--

/*!40000 ALTER TABLE `drug` DISABLE KEYS */;
INSERT INTO `drug` (`id`,`drugid`,`name`,`standard`,`num`,`uprice`,`remark`) VALUES 
 (1,'0001','红霉素','100*3',142,2.55,'无'),
 (2,'0002','青霉素','100*2',198,3.55,'无'),
 (4,'0003','螺旋霉素','100*5',294,6,'无');
/*!40000 ALTER TABLE `drug` ENABLE KEYS */;


--
-- Table structure for table `hospital`.`news`
--

DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `title` varchar(45) NOT NULL default '',
  `content` text NOT NULL,
  `time` varchar(45) NOT NULL default '',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

--
-- Dumping data for table `hospital`.`news`
--

/*!40000 ALTER TABLE `news` DISABLE KEYS */;
INSERT INTO `news` (`id`,`title`,`content`,`time`) VALUES 
 (2,'医院管理系统','医院管理系统今天正式应用于我院!','2006-6-4 12:27:07'),