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

/*!40101 SET NAMES utf8 */;

#
# Structure for table "ssi_door_platesa"
#

CREATE TABLE `ssi_door_platesa` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `uid` int(11) DEFAULT NULL,
  `sn` varchar(20) DEFAULT NULL,
  `title` varchar(50) NOT NULL DEFAULT '' COMMENT '下料单标题',
  `company` varchar(255) DEFAULT NULL COMMENT '订货单位',
  `number` varchar(220) NOT NULL DEFAULT '' COMMENT '编号',
  `style` varchar(255) DEFAULT NULL COMMENT '造型',
  `frame` varchar(250) DEFAULT NULL COMMENT '边框',
  `deep` int(11) DEFAULT NULL COMMENT '槽深',
  `middle` int(11) DEFAULT NULL COMMENT '中横',
  `color` varchar(50) DEFAULT NULL COMMENT '颜色',
  `create_user` varchar(20) DEFAULT NULL COMMENT '制单人',
  `money` int(11) NOT NULL DEFAULT '0' COMMENT '金额',
  `packing_info` varchar(50) DEFAULT NULL COMMENT '包装时注明',
  `core_board_finish_time` int(11) DEFAULT NULL COMMENT '芯板单完成日期',
  `small_items_finsh_time` int(11) DEFAULT NULL COMMENT '小件完成日期',
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '0删除1正常2流程未定义',
  `paynum` int(11) NOT NULL DEFAULT '0' COMMENT '已支付金额',
  `discountnum` int(11) NOT NULL DEFAULT '0' COMMENT '优惠金额',
  `arrearnum` int(11) NOT NULL DEFAULT '0' COMMENT '欠款金额',
  `arrears` int(11) NOT NULL DEFAULT '0' COMMENT '0未审核、1无欠款通过、2有欠款审核通过',
  `sstatus` int(3) NOT NULL DEFAULT '0' COMMENT '0未开始1已开始未完成2已完成',
  `tstatus` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0未超时1已超时',
  `nstatus` tinyint(3) NOT NULL DEFAULT '0' COMMENT '0正常1加急',
  `starttime` int(11) NOT NULL DEFAULT '0' COMMENT '开始时间',
  `endtime` int(11) NOT NULL DEFAULT '0' COMMENT '结束时间',
  `logistics_number` varchar(50) NOT NULL DEFAULT '' COMMENT '货运单号',
  `logistics_tel` varchar(20) NOT NULL DEFAULT '' COMMENT '收货人电话',
  `logistics_count` tinyint(3) NOT NULL DEFAULT '0' COMMENT '件数',
  `memberid` varchar(250) NOT NULL DEFAULT '0' COMMENT '关联用户id',
  `member_name` varchar(255) DEFAULT NULL,
  `saler_id` varchar(250) NOT NULL DEFAULT '0',
  `saler_name` varchar(255) DEFAULT NULL,
  `accept_time` int(11) NOT NULL DEFAULT '0' COMMENT '接单日期',
  `square` double NOT NULL DEFAULT '0' COMMENT '总平方数',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=185 DEFAULT CHARSET=utf8 COMMENT='下料单';

#
# Data for table "ssi_door_platesa"
#

INSERT INTO `ssi_door_platesa` VALUES (181,1,'180316155125','美家板生产单',NULL,'',NULL,NULL,NULL,NULL,'','大Boss',4808,NULL,NULL,NULL,2,0,0,0,0,0,0,0,1521187090,0,'','',0,'4',NULL,'2',NULL,0,0),(182,1,'180316155810','美家板生产单',NULL,'',NULL,NULL,NULL,NULL,NULL,'大Boss',5754,NULL,NULL,NULL,2,0,0,0,0,0,0,0,1521187421,0,'','',0,'0',NULL,'0',NULL,0,0),(183,1,'180316160342','美家板生产单',NULL,'',NULL,NULL,NULL,NULL,'','大Boss',7349,NULL,NULL,NULL,2,0,0,0,0,0,0,0,1521187851,0,'','',0,'0',NULL,'0',NULL,0,0),(184,1,'180316161052','美家板生产单',NULL,'',NULL,NULL,NULL,NULL,NULL,'大Boss',8531,NULL,NULL,NULL,2,0,0,0,0,0,0,0,1521191495,0,'','',0,'3','测试用户2','2','2',0,0),(185,1,'180316171135','',NULL,'',NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,0,0,0,0,0,0,0,0,0,0,'','',0,'0',NULL,'0',NULL,0,0);