|
楼主 |
发表于 2016-7-4 09:02
|
显示全部楼层
/*
Navicat MySQL Data Transfer
Source Server : root
Source Server Version : 50537
Source Host : localhost:3306
Source Database : jjd
Target Server Type : MYSQL
Target Server Version : 50537
File Encoding : 65001
Date: 2016-07-04 09:02:08
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `总表`
-- ----------------------------
DROP TABLE IF EXISTS `总表`;
CREATE TABLE `总表` (
`计费日期` date NOT NULL,
`锁定` enum('N','Y') NOT NULL DEFAULT 'N',
`托运人id` smallint(6) NOT NULL,
`航次id` int(11) NOT NULL,
`总表id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`总表id`),
KEY `航次id` (`航次id`),
KEY `ads` (`托运人id`),
CONSTRAINT `总表_ibfk_1` FOREIGN KEY (`托运人id`) REFERENCES `托运人` (`托运人id`),
CONSTRAINT `总表_ibfk_2` FOREIGN KEY (`航次id`) REFERENCES `航次` (`航次id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of 总表
-- ----------------------------
INSERT INTO `总表` VALUES ('2014-06-02', 'N', '3', '3', '12');
INSERT INTO `总表` VALUES ('2014-06-23', 'N', '1', '1', '13');
INSERT INTO `总表` VALUES ('2014-07-01', 'N', '2', '6', '15');
-- ----------------------------
-- Table structure for `托运人`
-- ----------------------------
DROP TABLE IF EXISTS `托运人`;
CREATE TABLE `托运人` (
`托运人id` smallint(6) NOT NULL AUTO_INCREMENT,
`托运人全称` varchar(20) NOT NULL,
`托运人简称` varchar(15) NOT NULL,
`联系人` varchar(10) DEFAULT NULL,
`电话` varchar(20) DEFAULT NULL,
`地址` varchar(50) DEFAULT NULL,
`税号` varchar(20) DEFAULT NULL,
PRIMARY KEY (`托运人id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of 托运人
-- ----------------------------
INSERT INTO `托运人` VALUES ('1', '天津君宝物流贸易有限公司', '天津君宝', '李军', '13508451254', '天津市大平区53号', '451 125 459 112');
INSERT INTO `托运人` VALUES ('2', '广州明天物流国际贸易有限公司', '广州明天物流', null, null, null, null);
INSERT INTO `托运人` VALUES ('3', '广州麒麟物资贸易有限公司', '广州麒麟', '王军', '123456789', null, null);
-- ----------------------------
-- Table structure for `明细表`
-- ----------------------------
DROP TABLE IF EXISTS `明细表`;
CREATE TABLE `明细表` (
`货名` varchar(10) NOT NULL,
`货运量` double NOT NULL,
`单价` double DEFAULT NULL,
`收入` decimal(10,2) DEFAULT NULL,
`总表id` int(11) NOT NULL,
`明细表id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`明细表id`),
KEY `总表id` (`总表id`),
CONSTRAINT `明细表_ibfk_1` FOREIGN KEY (`总表id`) REFERENCES `总表` (`总表id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of 明细表
-- ----------------------------
INSERT INTO `明细表` VALUES ('陶瓷', '151', '1515', '228765.00', '12', '13');
INSERT INTO `明细表` VALUES ('钢材', '546', '52', '28392.00', '12', '14');
INSERT INTO `明细表` VALUES ('冷卷', '514.457', '80', '41156.56', '15', '15');
INSERT INTO `明细表` VALUES ('酸洗卷', '100.478', '90', '9043.02', '13', '16');
INSERT INTO `明细表` VALUES ('中板', '4578.478', '72.5', '331939.66', '13', '17');
-- ----------------------------
-- Table structure for `用户`
-- ----------------------------
DROP TABLE IF EXISTS `用户`;
CREATE TABLE `用户` (
`用户` varchar(10) NOT NULL,
`密码` varchar(10) NOT NULL,
`权限` enum('查询','商务','操作','admin') NOT NULL,
PRIMARY KEY (`用户`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of 用户
-- ----------------------------
INSERT INTO `用户` VALUES ('admin', 'a', 'admin');
INSERT INTO `用户` VALUES ('b', 'b', '查询');
INSERT INTO `用户` VALUES ('c', 'c', '商务');
INSERT INTO `用户` VALUES ('d', 'd', '操作');
-- ----------------------------
-- Table structure for `航次`
-- ----------------------------
DROP TABLE IF EXISTS `航次`;
CREATE TABLE `航次` (
`船名` varchar(10) NOT NULL,
`航次` varchar(10) NOT NULL,
`起运港` varchar(10) NOT NULL,
`到达港` varchar(10) NOT NULL,
`航次id` int(11) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`航次id`),
UNIQUE KEY `船名航次起运港到达港不能重复` (`船名`,`航次`,`起运港`,`到达港`) USING BTREE,
CONSTRAINT `航次_ibfk_1` FOREIGN KEY (`船名`) REFERENCES `船名` (`船名`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of 航次
-- ----------------------------
INSERT INTO `航次` VALUES ('碧海宝珠', '1401', '京唐', '广州', '6');
INSERT INTO `航次` VALUES ('碧海宝珠', '1401', '京唐', '新沙', '7');
INSERT INTO `航次` VALUES ('碧海宝珠', '1401', '天津', '广州', '3');
INSERT INTO `航次` VALUES ('碧海金珠', '1401', '大连', '青岛', '1');
INSERT INTO `航次` VALUES ('碧海金珠', '新增', '新增', '新增', '4');
INSERT INTO `航次` VALUES ('碧海金珠', '新增1', '新增1', '新增1', '5');
INSERT INTO `航次` VALUES ('碧海银珠', '1401', '天津', '汕头', '2');
-- ----------------------------
-- Table structure for `船名`
-- ----------------------------
DROP TABLE IF EXISTS `船名`;
CREATE TABLE `船名` (
`船名` varchar(10) NOT NULL,
PRIMARY KEY (`船名`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;
-- ----------------------------
-- Records of 船名
-- ----------------------------
INSERT INTO `船名` VALUES (' 7-11');
INSERT INTO `船名` VALUES ('a');
INSERT INTO `船名` VALUES ('a1');
INSERT INTO `船名` VALUES ('a2');
INSERT INTO `船名` VALUES ('aaa');
INSERT INTO `船名` VALUES ('b2');
INSERT INTO `船名` VALUES ('碧海宝珠');
INSERT INTO `船名` VALUES ('碧海金珠');
INSERT INTO `船名` VALUES ('碧海银珠');
|
|