drug.sql · 沈七/drug - Gitee.com

来自 : gitee.com/shen_qi/drug/blob/ma 发布时间：2021-03-25

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196

/* Navicat MySQL Data Transfer Source Server : mysql Source Server Version : 50723 Source Host : localhost:3306 Source Database : drug Target Server Type : MYSQL Target Server Version : 50723 File Encoding : 65001 Date: 2019-04-18 12:39:10 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for druginfo -- ---------------------------- DROP TABLE IF EXISTS `druginfo`; CREATE TABLE `druginfo` ( `drugname` varchar(50) DEFAULT NULL, `changshang` varchar(50) DEFAULT NULL, `beizhu` varchar(100) DEFAULT NULL, `location` varchar(100) DEFAULT NULL, `unit` varchar(50) DEFAULT NULL, `guige` varchar(50) DEFAULT NULL, `tiaoxingma` varchar(50) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for ghs -- ---------------------------- DROP TABLE IF EXISTS `ghs`; CREATE TABLE `ghs` ( `gonghuoshang` varchar(80) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for jinhuo -- ---------------------------- DROP TABLE IF EXISTS `jinhuo`; CREATE TABLE `jinhuo` ( `drugname` varchar(50) DEFAULT NULL, `changshang` varchar(50) DEFAULT NULL, `beginprice` varchar(50) DEFAULT NULL, `price` varchar(50) DEFAULT NULL, `amount` varchar(50) DEFAULT NULL, `sum` varchar(50) DEFAULT NULL, `begindate` varchar(50) DEFAULT NULL, `date` varchar(50) DEFAULT NULL, `pihao` varchar(50) DEFAULT NULL, `beizhu` varchar(100) DEFAULT NULL, `location` varchar(100) DEFAULT NULL, `unit` varchar(50) DEFAULT NULL, `guige` varchar(50) DEFAULT NULL, `tiaoxingma` varchar(50) DEFAULT NULL, `jinhuo_time` varchar(100) DEFAULT NULL, `gonghuoshang` varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for jinhuorecords -- ---------------------------- DROP TABLE IF EXISTS `jinhuorecords`; CREATE TABLE `jinhuorecords` ( `drugname` varchar(50) DEFAULT NULL, `changshang` varchar(50) DEFAULT NULL, `beginprice` varchar(50) DEFAULT NULL, `price` varchar(50) DEFAULT NULL, `amount` varchar(50) DEFAULT NULL, `sum` varchar(50) DEFAULT NULL, `begindate` varchar(50) DEFAULT NULL, `date` varchar(50) DEFAULT NULL, `pihao` varchar(50) DEFAULT NULL, `beizhu` varchar(100) DEFAULT NULL, `location` varchar(100) DEFAULT NULL, `unit` varchar(50) DEFAULT NULL, `guige` varchar(50) DEFAULT NULL, `tiaoxingma` varchar(50) DEFAULT NULL, `jinhuo_time` varchar(100) DEFAULT NULL, `gonghuoshang` varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for manager -- ---------------------------- DROP TABLE IF EXISTS `manager`; CREATE TABLE `manager` ( `user` varchar(50) DEFAULT NULL, `password` varchar(50) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for rxdrug -- ---------------------------- DROP TABLE IF EXISTS `rxdrug`; CREATE TABLE `rxdrug` ( `time` varchar(50) NOT NULL, `drugname` varchar(80) NOT NULL, `changshang` varchar(80) NOT NULL, `date` varchar(80) NOT NULL, `pihao` varchar(50) NOT NULL, `count` varchar(50) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for rxperson -- ---------------------------- DROP TABLE IF EXISTS `rxperson`; CREATE TABLE `rxperson` ( `time` varchar(50) NOT NULL, `name` varchar(50) DEFAULT NULL, `gendar` varchar(20) DEFAULT NULL, `age` varchar(20) DEFAULT NULL, `phone` varchar(50) DEFAULT NULL, `location` varchar(80) DEFAULT NULL, `hospital` varchar(80) DEFAULT NULL, `htime` varchar(80) DEFAULT NULL, `yz` varchar(80) DEFAULT NULL, `ysname` varchar(80) DEFAULT NULL, `zdys` varchar(80) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for sell -- ---------------------------- DROP TABLE IF EXISTS `sell`; CREATE TABLE `sell` ( `drugname` varchar(100) DEFAULT NULL, `changshang` varchar(100) DEFAULT NULL, `price` varchar(100) DEFAULT NULL, `date` varchar(100) DEFAULT NULL, `pihao` varchar(100) DEFAULT NULL, `beizhu` varchar(100) DEFAULT NULL, `count` varchar(100) DEFAULT NULL, `unit` varchar(100) DEFAULT NULL, `guige` varchar(100) DEFAULT NULL, `amount` varchar(100) DEFAULT NULL, `sum` varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for sellover -- ---------------------------- DROP TABLE IF EXISTS `sellover`; CREATE TABLE `sellover` ( `drugname` varchar(50) DEFAULT NULL, `changshang` varchar(50) DEFAULT NULL, `price` varchar(50) DEFAULT NULL, `date` varchar(50) DEFAULT NULL, `pihao` varchar(50) DEFAULT NULL, `beizhu` varchar(100) DEFAULT NULL, `count` varchar(50) DEFAULT NULL, `unit` varchar(50) DEFAULT NULL, `guige` varchar(50) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for sellrecords -- ---------------------------- DROP TABLE IF EXISTS `sellrecords`; CREATE TABLE `sellrecords` ( `drugname` varchar(100) DEFAULT NULL, `changshang` varchar(100) DEFAULT NULL, `price` varchar(100) DEFAULT NULL, `date` varchar(100) DEFAULT NULL, `pihao` varchar(100) DEFAULT NULL, `beizhu` varchar(100) DEFAULT NULL, `unit` varchar(100) DEFAULT NULL, `guige` varchar(100) DEFAULT NULL, `amount` varchar(100) DEFAULT NULL, `sum` varchar(100) DEFAULT NULL, `selltime` varchar(100) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Table structure for store -- ---------------------------- DROP TABLE IF EXISTS `store`; CREATE TABLE `store` ( `drugname` varchar(50) DEFAULT NULL, `changshang` varchar(50) DEFAULT NULL, `beginprice` varchar(50) DEFAULT NULL, `price` varchar(50) DEFAULT NULL, `begindate` varchar(50) DEFAULT NULL, `date` varchar(50) DEFAULT NULL, `pihao` varchar(50) DEFAULT NULL, `beizhu` varchar(100) DEFAULT NULL, `location` varchar(100) DEFAULT NULL, `count` varchar(50) DEFAULT NULL, `unit` varchar(50) DEFAULT NULL, `guige` varchar(50) DEFAULT NULL, `tiaoxingma` varchar(50) DEFAULT NULL ) ENGINE=InnoDB DEFAULT CHARSET=gb2312;