# Host: localhost  (Version: 5.5.53)
# Date: 2018-03-16 17:16:25
# Generator: MySQL-Front 5.3  (Build 4.234)

/*!40101 SET NAMES utf8 */;

#
# Structure for table "ssi_door_platesa_product"
#

CREATE TABLE `ssi_door_platesa_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sn` varchar(12) NOT NULL DEFAULT '0' COMMENT 'sn码',
  `name` varchar(50) DEFAULT NULL,
  `height` int(11) DEFAULT '0' COMMENT '高',
  `width` int(11) DEFAULT NULL COMMENT '宽',
  `num` int(11) DEFAULT NULL COMMENT '数量',
  `square` float(11,3) DEFAULT '0.000' COMMENT '平方数',
  `punch` int(11) DEFAULT NULL COMMENT '打孔',
  `style` varchar(20) DEFAULT NULL COMMENT '样式',
  `remark` varchar(50) DEFAULT NULL COMMENT '备注',
  `is_small` int(1) NOT NULL DEFAULT '0' COMMENT '0不是小件  1是小件',
  `status` int(11) DEFAULT '1',
  `door_type` varchar(255) DEFAULT NULL,
  `door_board` varchar(255) DEFAULT NULL,
  `color` varchar(255) DEFAULT NULL,
  `jc_name` varchar(250) NOT NULL,
  `jc_price` int(10) NOT NULL,
  `zm_name` varchar(250) NOT NULL,
  `zm_price` int(10) NOT NULL,
  `bg_name` varchar(250) NOT NULL,
  `bg_price` float NOT NULL,
  `sum_price` float NOT NULL,
  `sum_num_price` float NOT NULL,
  `jc_id` int(11) NOT NULL DEFAULT '0',
  `zm_id` int(11) NOT NULL DEFAULT '0',
  `bg_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=137 DEFAULT CHARSET=utf8 COMMENT='下料单产品';

#
# Data for table "ssi_door_platesa_product"
#

INSERT INTO `ssi_door_platesa_product` VALUES (182,'180316155125',NULL,0,0,5,0.000,NULL,'',NULL,0,1,NULL,'','','111',111,'86a375aacb17606c185d',86,'222',222,460,2300,31,27,32),(183,'180316155125',NULL,0,0,5,0.000,NULL,'',NULL,0,1,NULL,'','','12',12,'222',222,'222',222,456,2280,29,32,32),(184,'180316155125',NULL,0,0,2,0.000,NULL,'',NULL,0,1,NULL,'','','12',12,'222',222,'888',888,1122,2244,29,32,40),(185,'180316155125',NULL,0,0,4,0.000,NULL,'',NULL,0,1,NULL,'','','12',12,'86a375aacb17606c185d',86,'',0,266,1064,29,27,0),(186,'180316155125',NULL,0,0,2,0.000,NULL,'',NULL,0,1,NULL,'','','12',12,'86a375aacb17606c185d',86,'222',222,361,722,29,27,32),(187,'180316155125',NULL,0,0,2,0.000,NULL,'',NULL,0,1,NULL,'','','12',12,'86a375aacb17606c185d',86,'222',222,361,722,29,27,32),(188,'180316155810',NULL,0,0,2,0.000,NULL,'',NULL,0,1,NULL,'','','111',111,'222',222,'222',222,555,1110,31,32,32),(189,'180316155810',NULL,0,0,3,0.000,NULL,'',NULL,0,1,NULL,'','','12',12,'86a375aacb17606c185d',86,'222',222,361,1083,29,27,32),(190,'180316155810',NULL,0,0,3,0.000,NULL,'',NULL,0,1,NULL,'2','','12',12,'86a375aacb17606c185d',86,'222',222,361,1083,29,27,32),(191,'180316155810',NULL,0,0,2,0.000,NULL,'',NULL,0,1,NULL,'','','111',111,'222',222,'222',222,555,1110,31,32,32),(192,'180316155810',NULL,0,0,3,0.000,NULL,'',NULL,0,1,NULL,'','','12',12,'222',222,'222',222,456,1368,29,32,32),(199,'180316160342',NULL,0,0,2,0.000,NULL,'',NULL,0,1,NULL,'','','111',111,'板厂1',0,'',0,111,222,31,23,0),(200,'180316161052',NULL,0,0,5,0.000,NULL,'',NULL,0,1,NULL,'','','12',12,'86a375aacb17606c185d',86,'222',222,361,1805,29,27,32),(203,'180316161052',NULL,0,0,6,0.000,NULL,'',NULL,0,1,NULL,'','','111',11,'222',222,'888',888,1121,6726,39,32,40);