MySQL：油品代码表、油品规格代码表设计

油品代码表

/*
Navicat MySQL Data Transfer

Source Server         : 192.168.1.201(yyxt)
Source Server Version : 50168
Source Host           : 192.168.1.201:3306
Source Database       : gas_web_bg

Target Server Type    : MYSQL
Target Server Version : 50168
File Encoding         : 65001

Date: 2019-11-07 14:54:50
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for dm_yp
-- ----------------------------
DROP TABLE IF EXISTS `dm_yp`;
CREATE TABLE `dm_yp` (
  `yp_dm` char(2) NOT NULL DEFAULT '' COMMENT '油品代码',
  `yp_mc` varchar(100) DEFAULT NULL COMMENT '油品名称',
  `yxbz` char(1) DEFAULT NULL COMMENT '有效标志',
  `pxh` int(2) DEFAULT NULL COMMENT '排序号',
  PRIMARY KEY (`yp_dm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT '油品代码表';

-- ----------------------------
-- Records of dm_yp
-- ----------------------------
INSERT INTO `dm_yp` VALUES ('10', '汽油', '1', '1');
INSERT INTO `dm_yp` VALUES ('11', '无铅汽油', '1', '2');
INSERT INTO `dm_yp` VALUES ('12', '乙醇汽油', '1', '3');
INSERT INTO `dm_yp` VALUES ('13', '航空汽油', '1', '4');
INSERT INTO `dm_yp` VALUES ('20', '柴油', '1', '5');
INSERT INTO `dm_yp` VALUES ('21', '轻柴油', '1', '6');
INSERT INTO `dm_yp` VALUES ('22', '重柴油', '1', '7');
INSERT INTO `dm_yp` VALUES ('23', '军用柴油', '1', '8');
INSERT INTO `dm_yp` VALUES ('30', '煤油', '1', '9');
INSERT INTO `dm_yp` VALUES ('40', '机油', '1', '10');
INSERT INTO `dm_yp` VALUES ('50', 'CNG', '1', '11');
INSERT INTO `dm_yp` VALUES ('60', 'LNG', '1', '12');
INSERT INTO `dm_yp` VALUES ('70', 'LPG', '1', '13');

油品规格代码表

/*
Navicat MySQL Data Transfer

Source Server         : 192.168.1.201(yyxt)
Source Server Version : 50168
Source Host           : 192.168.1.201:3306
Source Database       : gas_web_bg

Target Server Type    : MYSQL
Target Server Version : 50168
File Encoding         : 65001

Date: 2019-11-07 14:54:44
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for dm_gg
-- ----------------------------
DROP TABLE IF EXISTS `dm_gg`;
CREATE TABLE `dm_gg` (
  `gg_dm` char(4) NOT NULL DEFAULT '' COMMENT '油品规格代码',
  `gg_mc` varchar(100) DEFAULT NULL COMMENT '油品规格名称',
  `yp_dm` char(2) DEFAULT NULL COMMENT '油品代码',
  `yxbz` char(1) DEFAULT NULL COMMENT '有效标志',
  `pxh` int(2) DEFAULT NULL COMMENT '排序号',
  PRIMARY KEY (`gg_dm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT '油品规格代码表';

-- ----------------------------
-- Records of dm_gg
-- ----------------------------
INSERT INTO `dm_gg` VALUES ('1001', '90#', '10', '1', '1');
INSERT INTO `dm_gg` VALUES ('1002', '92#', '10', '1', '2');
INSERT INTO `dm_gg` VALUES ('1003', '93#', '10', '1', '3');
INSERT INTO `dm_gg` VALUES ('1004', '95#', '10', '1', '4');
INSERT INTO `dm_gg` VALUES ('1005', '97#', '10', '1', '5');
INSERT INTO `dm_gg` VALUES ('1006', '98#', '10', '1', '6');
INSERT INTO `dm_gg` VALUES ('1007', '120#', '10', '1', '7');
INSERT INTO `dm_gg` VALUES ('1008', '101#', '10', '1', '8');
INSERT INTO `dm_gg` VALUES ('1101', '90#', '11', '1', '1');
INSERT INTO `dm_gg` VALUES ('1102', '92#', '11', '1', '2');
INSERT INTO `dm_gg` VALUES ('1103', '93#', '11', '1', '3');
INSERT INTO `dm_gg` VALUES ('1104', '95#', '11', '1', '4');
INSERT INTO `dm_gg` VALUES ('1105', '97#', '11', '1', '5');
INSERT INTO `dm_gg` VALUES ('1106', '98#', '11', '1', '6');
INSERT INTO `dm_gg` VALUES ('1107', '120#', '11', '1', '7');
INSERT INTO `dm_gg` VALUES ('1108', '101#', '11', '1', '8');
INSERT INTO `dm_gg` VALUES ('1201', '90#', '12', '1', '1');
INSERT INTO `dm_gg` VALUES ('1202', '92#', '12', '1', '2');
INSERT INTO `dm_gg` VALUES ('1203', '93#', '12', '1', '3');
INSERT INTO `dm_gg` VALUES ('1204', '95#', '12', '1', '4');
INSERT INTO `dm_gg` VALUES ('1205', '97#', '12', '1', '5');
INSERT INTO `dm_gg` VALUES ('1206', '98#', '12', '1', '6');
INSERT INTO `dm_gg` VALUES ('1207', '120#', '12', '1', '7');
INSERT INTO `dm_gg` VALUES ('1208', '101#', '12', '1', '8');
INSERT INTO `dm_gg` VALUES ('1301', '75#', '13', '1', '1');
INSERT INTO `dm_gg` VALUES ('1302', '95#', '13', '1', '2');
INSERT INTO `dm_gg` VALUES ('1303', '100#', '13', '1', '3');
INSERT INTO `dm_gg` VALUES ('2001', '10#', '20', '1', '1');
INSERT INTO `dm_gg` VALUES ('2002', '5#', '20', '1', '2');
INSERT INTO `dm_gg` VALUES ('2003', '0#', '20', '1', '3');
INSERT INTO `dm_gg` VALUES ('2004', '-5#', '20', '1', '4');
INSERT INTO `dm_gg` VALUES ('2005', '-10#', '20', '1', '5');
INSERT INTO `dm_gg` VALUES ('2006', '-15#', '20', '1', '6');
INSERT INTO `dm_gg` VALUES ('2007', '-20#', '20', '1', '7');
INSERT INTO `dm_gg` VALUES ('2008', '-30#', '20', '1', '8');
INSERT INTO `dm_gg` VALUES ('2009', '-35#', '20', '1', '9');
INSERT INTO `dm_gg` VALUES ('2010', '-50#', '20', '1', '10');
INSERT INTO `dm_gg` VALUES ('2011', '20#', '20', '1', '11');
INSERT INTO `dm_gg` VALUES ('2201', '10#', '22', '1', '1');
INSERT INTO `dm_gg` VALUES ('2202', '20#', '22', '1', '2');
INSERT INTO `dm_gg` VALUES ('2301', '-10#', '23', '1', '1');