DB_51Aspx/ifang_chalide.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

-- MySQL dump 10.13  Distrib 5.7.26, for Win64 (x86_64)
--
-- Host: localhost    Database: ifang_chalide
-- ------------------------------------------------------
-- Server version	5.7.26

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!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' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `medicine`
--

DROP TABLE IF EXISTS `medicine`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `medicine` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `medicine_name` varchar(100) NOT NULL COMMENT '鑽搧鍚嶇О',
  `alias` varchar(100) DEFAULT NULL COMMENT '鍒悕',
  `pinyin` varchar(200) DEFAULT NULL COMMENT '鍏ㄦ嫾',
  `short_pinyin` varchar(50) DEFAULT NULL COMMENT '绠€鎷?,
  `unit` varchar(20) DEFAULT '鍏? COMMENT '鍗曚綅',
  `default_amount` decimal(10,2) DEFAULT '10.00' COMMENT '榛樿鏁伴噺',
  `price` decimal(10,2) DEFAULT '0.00' COMMENT '鍙傝€冧环鏍?,
  `count_times` int(11) DEFAULT '0' COMMENT '寮€鍗曡娆?,
  `advice` varchar(255) DEFAULT NULL COMMENT '璇ヨ嵂鍖诲槺',
  PRIMARY KEY (`id`),
  UNIQUE KEY `medicine_name` (`medicine_name`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COMMENT='鑽搧搴?;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `medicine`
--

LOCK TABLES `medicine` WRITE;
/*!40000 ALTER TABLE `medicine` DISABLE KEYS */;
INSERT INTO `medicine` VALUES (1,'榛勮姫','鍖楄姫','huangqi','hq','鍏?,15.00,0.30,0,'鐩婃皵鍥鸿〃锛屽埄姘存秷鑲?),(2,'褰撳綊','','danggui','dg','鍏?,10.00,0.50,0,'琛ヨ娲昏锛岃皟缁忔鐥?),(3,'宸濊妿','','chuanxiong','cx','鍏?,10.00,0.40,0,'娲昏琛屾皵锛岀椋庢鐥?),(4,'鐧借妽','','baishao','bs','鍏?,10.00,0.35,0,'鍏昏鏁涢槾锛屾煍鑲濇鐥?),(5,'鐔熷湴榛?,'鐔熷湴','shudihuang','sdh','鍏?,15.00,0.45,0,'婊嬮槾琛ヨ锛岀泭绮惧～楂?),(6,'鐢熷湴榛?,'鐢熷湴','shengdihuang','sdh','鍏?,15.00,0.40,0,'娓呯儹鍑夎锛屽吇闃寸敓娲?),(7,'鐧芥湳','','baizhu','bz','鍏?,10.00,0.35,0,'鍋ヨ劸鐩婃皵锛岀嚗婀垮埄姘?),(8,'鑼嫇','','fuling','fl','鍏?,10.00,0.30,0,'鍒╂按娓楁箍锛屽仴鑴惧畨绁?),(9,'鐢樿崏','','gancao','gc','鍏?,5.00,0.25,0,'琛ヨ劸鐩婃皵锛屾竻鐑В姣掞紝璋冨拰璇歌嵂'),(10,'闄堢毊','','chenpi','cp','鍏?,10.00,0.30,0,'鐞嗘皵鍋ヨ劸锛岀嚗婀垮寲鐥?),(11,'鏋告潪瀛?,'鏋告潪','gouqizi','gqz','鍏?,10.00,0.50,0,'婊嬭ˉ鑲濊偩锛岀泭绮炬槑鐩?),(12,'灞辫嵂','','shanyao','sy','鍏?,15.00,0.35,0,'琛ヨ劸鍏昏儍锛岀敓娲ョ泭鑲?),(13,'鏉胯摑鏍?,'','banlangen','blg','鍏?,15.00,0.30,0,'娓呯儹瑙ｆ瘨锛屽噳琛€鍒╁捊'),(14,'杩炵繕','','lianqiao','lq','鍏?,10.00,0.40,0,'娓呯儹瑙ｆ瘨锛屾秷鑲挎暎缁?),(15,'閲戦摱鑺?,'','jinyinhua','jyh','鍏?,10.00,0.45,0,'娓呯儹瑙ｆ瘨锛岀枏鏁ｉ鐑?),(16,'妗傛灊','','guizhi','gz','鍏?,10.00,0.35,0,'鍙戞睏瑙ｈ〃锛屾俯閫氱粡鑴?),(17,'澶ф灒','绾㈡灒','dazao','dz','鏋?,5.00,0.20,0,'琛ヤ腑鐩婃皵锛屽吇琛€瀹夌'),(18,'鐢熷','','shengjiang','sj','鍏?,5.00,0.20,0,'鍙戞睏瑙ｈ〃锛屾俯涓鍛?),(19,'鍏氬弬','','dangshen','ds','鍏?,15.00,0.40,0,'琛ヤ腑鐩婃皵锛屽仴鑴剧泭鑲?),(20,'榛勮姪','','huangqin','hq','鍏?,10.00,0.35,0,'娓呯儹鐕ユ箍锛屾郴鐏В姣?),(21,'鏌磋儭','','chaihu','ch','鍏?,10.00,0.40,0,'鐤忚倽瑙ｉ儊锛屽崌闃抽€€鐑?),(22,'鐧借姺','','baizhi','bz','鍏?,10.00,0.30,0,'鍙戞暎椋庡瘨锛岄€氱獚姝㈢棝'),(23,'楹﹀啲','','maidong','md','鍏?,10.00,0.45,0,'鍏婚槾鐢熸触锛屾鼎鑲烘竻蹇?),(24,'澶╅夯','','tianma','tm','鍏?,10.00,0.60,0,'骞宠倽鎭锛岀椋庨€氱粶'),(25,'鍒堕檮鐗?,'闄勭墖','zhifupian','zfp','鍏?,10.00,0.50,0,'鍥為槼鏁戦€嗭紝琛ョ伀鍔╅槼锛屾暎瀵掓鐥?),(26,'鏉滀徊','','duzhong','dz','鍏?,10.00,0.40,0,'琛ヨ倽鑲撅紝寮虹瓔楠紝瀹夎儙'),(27,'娉芥郴','','zexie','zx','鍏?,10.00,0.30,0,'鍒╂按娓楁箍锛屾硠鐑?),(28,'涓瑰弬','','danshen','ds','鍏?,15.00,0.40,0,'娲昏鍖栫榾锛屽噳琛€娑堢棃'),(29,'鐮備粊','','sharen','sr','鍏?,6.00,0.60,0,'鍖栨箍寮€鑳冿紝娓╄劸姝㈡郴'),(30,'钖忚嫛浠?,'钖忕背','yiyiren','yyr','鍏?,15.00,0.25,0,'鍋ヨ劸娓楁箍锛屾竻鐑В姣?),(31,'杞﹀墠瀛?,'','cheqianzi','cqz','鍏?,10.00,0.30,0,'娓呯儹鍒╁翱锛屾槑鐩?),(32,'妗戝彾','','sangye','sy','鍏?,10.00,0.30,0,'鐤忔暎椋庣儹锛屾竻鑲烘鼎鐕?),(33,'鑿婅姳','','juhua','jh','鍏?,10.00,0.35,0,'鐤忛娓呯儹锛屽钩鑲濇槑鐩?),(34,'鍐虫槑瀛?,'','juemingzi','jmz','鍏?,10.00,0.25,0,'娓呰倽鏄庣洰锛屾鼎鑲犻€氫究'),(35,'鐗涜啙','','niuxi','nx','鍏?,10.00,0.40,0,'娲昏閫氱粡锛屽紩琛€涓嬭'),(36,'钂插叕鑻?,'','pugongying','pgy','鍏?,15.00,0.25,0,'娓呯儹瑙ｆ瘨锛屾秷鑲挎暎缁?);
/*!40000 ALTER TABLE `medicine` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `prescription`
--

DROP TABLE IF EXISTS `prescription`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `prescription` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `order_number` varchar(50) NOT NULL COMMENT '璁㈠崟鍙?,