CREATE TABLE `user` (
`userId` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户ID',
`userName` varchar(255) NOT NULL COMMENT '用户名',
`account` varchar(255) NOT NULL COMMENT '账号',
`password` varchar(255) NOT NULL COMMENT '密码',
`createtime` datetime NOT NULL COMMENT '创建时间',
PRIMARY KEY (`userId`),
KEY `userName` (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `userinformation` (
`userName` varchar(255) NOT NULL COMMENT '用户名',
`Name` varchar(255) NOT NULL COMMENT '真实姓名',
`gender` varchar(255) NOT NULL DEFAULT '男' COMMENT '性别',
`datetime` datetime NOT NULL COMMENT '出生日期',
`age` int(11) NOT NULL COMMENT '年龄',
`address` varchar(255) NOT NULL COMMENT '家庭住址',
`phone` varchar(255) NOT NULL COMMENT '手机号',
PRIMARY KEY (`userName`),
CONSTRAINT `userName` FOREIGN KEY (`userName`) REFERENCES `user` (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `order` (
`orderId` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单ID',
`userName` varchar(255) NOT NULL COMMENT '用户名',
`drugName` varchar(255) NOT NULL COMMENT '药品名称',
`drugQuantity` varchar(255) NOT NULL COMMENT '药品数量',
`drugtotal` varchar(255) NOT NULL COMMENT '药品价格',
PRIMARY KEY (`orderId`),
KEY `order` (`userName`),
KEY `drugName` (`drugName`),
CONSTRAINT `order` FOREIGN KEY (`userName`) REFERENCES `user` (`userName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `orderjournal` (
`drugName` varchar(255) NOT NULL COMMENT '药品名称',
`drugtotal` varchar(255) NOT NULL COMMENT '药品价格',
`paymentState` varchar(255) NOT NULL COMMENT '支付状态',
`createTime` datetime NOT NULL COMMENT '创建时间',
`payTime` datetime NOT NULL COMMENT '支付时间',
PRIMARY KEY (`drugName`),
CONSTRAINT `name` FOREIGN KEY (`drugName`) REFERENCES `order` (`drugName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `drug` (
`drugId` int(11) NOT NULL COMMENT '药品ID',
`drugName` varchar(255) NOT NULL COMMENT '药品名称',
`drugprice` decimal(10,2) NOT NULL COMMENT '药品单价',
PRIMARY KEY (`drugId`),
KEY `nametwo` (`drugName`),
CONSTRAINT `nametwo` FOREIGN KEY (`drugName`) REFERENCES `order` (`drugName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `druginformation` (
`drugName` varchar(255) NOT NULL COMMENT '药品名称',
`drugtype` varchar(255) NOT NULL COMMENT '药品种类',
`drugexpirationdate` datetime NOT NULL COMMENT '药品保质期',
`drugproducetime` datetime NOT NULL COMMENT '药品生产日期',
`druginventory` varchar(255) NOT NULL COMMENT '药品库存',
`drugeffect` varchar(255) NOT NULL COMMENT '药品作用',
PRIMARY KEY (`drugName`),
CONSTRAINT `drugname` FOREIGN KEY (`drugName`) REFERENCES `drug` (`drugName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
内容仅供参考