复杂查询

2018/05/17 11:41
阅读数 12

表结构:

/*
Navicat MySQL Data Transfer

Source Server         : company
Source Server Version : 50721
Source Host           : 192.168.50.17:3306
Source Database       : sp_sspt

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

Date: 2018-05-17 11:18:57
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for sspt_aj
-- ----------------------------
DROP TABLE IF EXISTS `sspt_aj`;
CREATE TABLE `sspt_aj` (
  `ajid` varchar(32) NOT NULL COMMENT '案件id',
  `ah` varchar(50) DEFAULT NULL COMMENT '案号',
  `qrcode` varchar(255) DEFAULT NULL COMMENT '二维码路径',
  `cbr` varchar(50) DEFAULT NULL COMMENT '承办人',
  `ysfy` varchar(50) DEFAULT NULL COMMENT '原审法院',
  `jsfy` varchar(50) DEFAULT NULL COMMENT '接收法院',
  `ajlb` varchar(20) DEFAULT NULL COMMENT '案件类别',
  `sqlx` varchar(20) DEFAULT NULL COMMENT '申请类型',
  `sqrlx` varchar(20) DEFAULT NULL COMMENT '申请人类型',
  `sqrid` varchar(255) DEFAULT NULL COMMENT '申请人编号',
  `dlrlx` varchar(20) DEFAULT NULL COMMENT '代理人类型(申请类型为本人申请时为空)',
  `ajms` varchar(100) DEFAULT NULL COMMENT '案件描述',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`ajid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='案件';

-- ----------------------------
-- Records of sspt_aj
-- ----------------------------
INSERT INTO `sspt_aj` VALUES ('2c0dd5395a8a4a50aa0d5bc330bfed2e', '11', '/qrcode/92a0fe7e046c45ae93ac752918c06209.png', null, null, 'bvfbb136e5a74b168bddaf747eeacc34', 'ZX', 'SQZX', 'WTRSQ', null, 'FYXKDQ', null, '2018-05-16 09:07:17', '2018-05-16 09:07:17', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_aj` VALUES ('711d06f34c0b44288a8041d612ed67b8', null, '/qrcode/92a0fe7e046c45ae93ac752918c06209.png', null, null, 'dfgbb136e5a74b168bddaf747eeacc34', 'MS', 'QS', 'WBRSQ', null, null, null, '2018-05-16 19:56:23', '2018-05-16 19:56:23', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_aj` VALUES ('a640dd7edf2442fdaa92e99072c4b4a7', null, '/qrcode/92a0fe7e046c45ae93ac752918c06209.png', null, null, 'rrrbb136e5a74b168bddaf747eeacc34', 'ZX', 'SQZX', 'WTRSQ', null, 'JHR', null, '2018-05-16 13:52:27', '2018-05-16 13:52:27', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_aj` VALUES ('adadb63341414108b3ac445145098ecf', null, '/qrcode/92a0fe7e046c45ae93ac752918c06209.png', null, null, 'bvfbb136e5a74b168bddaf747eeacc34', 'MS', 'QS', 'WBRSQ', null, null, null, '2018-05-16 19:58:06', '2018-05-16 19:58:06', 'archibald_witwicky', 'archibald_witwicky');

-- ----------------------------
-- Table structure for sspt_ajzt
-- ----------------------------
DROP TABLE IF EXISTS `sspt_ajzt`;
CREATE TABLE `sspt_ajzt` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `ajid` varchar(32) DEFAULT NULL COMMENT '案件id',
  `ajzt` varchar(50) DEFAULT NULL COMMENT '案件状态(DTJ待提交,DSH待审核,SHBTG审核不通过,SHTG审核通过,SQSX申请失效,YLA已立案 , SLZ审理中,YJA已结案)',
  `lalczt` varchar(50) DEFAULT NULL COMMENT '立案流程状态(1编辑网上立案,2上传诉讼材料,3预览和提交,4提交成功)',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='案件状态';

-- ----------------------------
-- Records of sspt_ajzt
-- ----------------------------
INSERT INTO `sspt_ajzt` VALUES ('08866d2cbd2f4ee89ab454cd74597e11', 'eb1259f6c8b441b3b314a4206b2a5e53', 'DSH', 'SCSSCL', '2018-05-16 13:35:40', '2018-05-16 13:35:43', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('08c5dd898e824fcd817cdc5573372e91', '0680f3c93bda4596b449b2d9f6a0a05e', 'DSH', 'SCSSCL', '2018-05-16 19:58:06', '2018-05-16 19:58:13', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('08e4cb8dbc784c3eaef7f291d5eb8fa4', 'd2f5d39aa07a401bbad653add1a1e58d', 'DSH', 'BJWSLA', '2018-05-16 19:52:58', '2018-05-16 19:52:58', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('0c263c743a2144d4a3f69c9515ce85dd', '9ac6d4f070b4400398206f1d45d8b2ac', 'DSH', 'BJWSLA', '2018-05-14 17:32:51', '2018-05-14 17:32:51', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('1285693fdb8b4133bd739af2b0b8c117', '352cee6bb5cf4e56bb554e68e5e19442', 'DSH', '2', '2018-05-04 17:03:15', '2018-05-04 17:02:51', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('135c59f9aae74abca4b8e3a60aecc8f7', '704f710e62ce40249227f102c7e85cd1', '1', '1', '2018-05-05 13:54:49', '2018-05-05 13:54:49', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('13eff3a3ddce49cda4f9e421b3652c59', 'adadb63341414108b3ac445145098ecf', 'DSH', 'BJWSLA', '2018-05-17 10:14:19', '2018-05-17 10:14:19', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('145d86568dc244d8978803ab490f875a', '830ce4be086d44769a3f89ae1339d151', 'DSH', 'BJWSLA', '2018-05-14 16:08:34', '2018-05-14 16:08:34', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('1593ff333c3a48b4ad9a3f150cf2e632', 'e3b348049d5a4fb18e79b707516e26a6', 'DSH', 'SCSSCL', '2018-05-14 11:27:16', '2018-05-14 11:27:33', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('16184047ba65482e8a143d32caee874a', '29d079b91d3542409404abb1b35375b5', 'DSH', 'BJWSLA', '2018-05-14 16:04:15', '2018-05-14 16:04:15', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('16ee49ba5c224902bbbf4dc6d0ff62d6', '1220b4f2350a4d8582837e8e35595183', 'DSH', '2', '2018-05-04 15:57:55', '2018-05-04 17:00:42', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('17634e594134428a8cfafc32d4bc686d', 'ed967117730f401f8b883061b0c04842', 'DSH', 'BJWSLA', '2018-05-14 17:35:29', '2018-05-14 17:35:29', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('1a1cec00e9ea4d0cb989aece69cb7ad0', 'ed7c97f440db4ba1bfcb7dfd24809e00', 'DSH', 'BJWSLA', '2018-05-17 10:09:25', '2018-05-17 10:09:25', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('1f3f0ef86d2240779e24ada6fc6dfc6f', 'f7b78573ba174cb1b346cf9eeb42a730', 'DSH', 'BJWSLA', '2018-05-14 13:35:11', '2018-05-14 13:35:11', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('22e3bc9d91b14597bb43025b6e148796', 'e90cf53f1c0d40d08ab0c6885b83961b', 'DSH', 'TJCG', '2018-05-16 20:00:42', '2018-05-16 20:00:54', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('2306ebb033b54b67a6cfc662cdee4eae', '82d8e212d7a443cd9938e76c48a2999d', 'DSH', '1', '2018-05-04 15:56:05', '2018-05-04 15:56:05', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('24c09ed06fa0444091fc08beccadc683', 'e5bf074400c84ac09e05a5c52480c2d0', 'DSH', 'BJWSLA', '2018-05-16 09:13:24', '2018-05-16 09:13:24', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('2518bfea2a4c4dd3bc296414b395d390', '68eaa90866344604acb55ddaca8b335f', 'DSH', 'BJWSLA', '2018-05-16 19:22:16', '2018-05-16 19:22:16', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('253f45f01f9040c6bc08dbe2e930ed8b', 'a640dd7edf2442fdaa92e99072c4b4a7', 'DSH', 'BJWSLA', '2018-05-17 10:44:33', '2018-05-17 10:44:33', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('2e6dd1cb6773432c87f84ecb68716396', '5d1dffb2ef234f7eb48d8ebeae5624a2', 'DSH', 'BJWSLA', '2018-05-14 11:37:47', '2018-05-14 11:37:47', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('2eef70ede25a457eacb62b3a7766ca39', 'b95ba6f2467d44199d16c2cc980aaddf', 'DSH', 'TJCG', '2018-05-16 18:26:50', '2018-05-16 18:27:21', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('3058bfa854c9473084a3798b7a07e9ab', 'de7738537824403a8e03a6d69e769d9e', 'DSH', 'BJWSLA', '2018-05-14 16:02:13', '2018-05-14 16:02:13', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('314cfc11e04141d4ad1a75d61fafe8e3', '817d9dad97084450bf7b027b9c886524', 'DSH', 'BJWSLA', '2018-05-14 17:29:12', '2018-05-14 17:29:12', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('315a2c66fa6b4a769d7b66fd249cd033', '2e0ccc6d7cc04fab9b954086a0b02a77', 'DSH', 'BJWSLA', '2018-05-14 16:18:37', '2018-05-14 16:18:37', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('3418b19a19e6474ea49b5d091c85cbe6', '711d06f34c0b44288a8041d612ed67b8', 'DSH', 'BJWSLA', '2018-05-17 10:13:14', '2018-05-17 10:13:14', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('365c6865ac7541dfa5e1b47f85b04793', '887bdd656b524fc385e22c5b784b90b4', 'DSH', '1', '2018-05-04 13:57:02', '2018-05-04 13:57:02', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('3a06f66c4d044802ad9e402ddac170ac', '35a4242c3b294522b0fe383ee5d7e5df', 'DSH', 'BJWSLA', '2018-05-14 13:31:43', '2018-05-14 13:31:43', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('3ae3c87b989743cfaefe3dd9e077c143', 'c06a14f27121482ca163c5e39a4c1b91', 'DSH', 'BJWSLA', '2018-05-16 09:13:43', '2018-05-16 09:13:43', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('4034bc0db8754ef0a8c92e7b3f9488e3', '87a3f94426b640e6aff013af1ea5abe8', 'DSH', 'BJWSLA', '2018-05-14 16:01:16', '2018-05-14 16:01:16', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('42b63639a7c442728be489359810c420', '92a0fe7e046c45ae93ac752918c06209', 'DSH', 'TJCG', '2018-05-16 19:51:14', '2018-05-16 19:51:24', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('44d4511a35d4476f809899d80d437edf', 'deb74959c9254ec3bbc0a90e151b02f1', 'DSH', 'BJWSLA', '2018-05-14 13:33:58', '2018-05-14 13:33:58', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('45fe92b3cb31462fb5c2e88fbeb1c6b7', '1ce145d9110e441b992d3bb353cfcf2d', 'DSH', 'BJWSLA', '2018-05-16 19:54:36', '2018-05-16 19:54:36', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('475445e3585d4dc9bdd2147774b2b8c4', '20e88d3ea4a1495b9820f8d35da441db', 'DSH', 'BJWSLA', '2018-05-17 10:10:16', '2018-05-17 10:10:16', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('4c9b4706ae96423b812a62f301c92e30', 'f282853d82f34a72b155671b5420afd3', 'DSH', 'BJWSLA', '2018-05-14 11:37:18', '2018-05-14 11:37:18', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('4d903ca18e8c4332bfc811d13360ee6a', '23a5445049194e78bb67c98a4074d610', 'DSH', 'BJWSLA', '2018-05-14 16:12:19', '2018-05-14 16:12:19', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('4e65a5c48f2a4433a8d9c946f41663af', '2c0dd5395a8a4a50aa0d5bc330bfed2e', 'DSH', 'TJCG', '2018-05-17 10:13:42', '2018-05-17 10:14:08', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('5231659835cb453ca5af438da883e4a0', '0d327083ac75476d9096832890a4bc33', 'DSH', 'BJWSLA', '2018-05-16 09:07:17', '2018-05-16 09:07:17', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('54c685a0cba04c77b8e188e7e9b1a230', 'eef4d0e7f9884a4193741a5724f565a7', 'DSH', '2', '2018-05-04 14:02:45', '2018-05-04 14:02:13', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('55071837587544519337e7a21fdc5403', '83d495e3fc214a3098fd53ccfa9bb512', 'DSH', 'TJCG', '2018-05-17 09:12:44', '2018-05-17 09:13:15', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('55f6ee9ead464fd0b89c0d79aa426410', '43b567c4e64441b4adb77d2e1bea1079', 'DSH', 'BJWSLA', '2018-05-17 09:58:53', '2018-05-17 09:58:53', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('56474a85d85c44869c9415a9bcd21b4f', '5d923fa8dd1c4383bb38c59a32105678', 'DSH', 'SCSSCL', '2018-05-11 12:00:01', '2018-05-14 11:36:34', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('57c572f3b92344bc828830b3685868ce', 'c17389d3701648659651a5de903d716a', 'DSH', 'BJWSLA', '2018-05-14 17:36:51', '2018-05-14 17:36:51', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('5926c23f86684e599e01824ebe50985d', 'dfaee40a181f48e3847382e1fc80a54d', 'DSH', 'TJCG', '2018-05-11 09:31:55', '2018-05-11 09:32:05', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('5b0452570635471fbf884e0048fb17fd', 'ef6e785ea3e74e4aa0195ec2b41d1895', 'DSH', 'BJWSLA', '2018-05-14 17:37:43', '2018-05-14 17:37:43', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('5bd3bf6669b144ac9dc843e1086ed0bc', '1a793164a2234667b763a437ab07f69f', 'DSH', 'TJCG', '2018-05-11 09:59:53', '2018-05-11 10:00:31', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('5be1c5f31ca844cb980164d210f9d19f', '9b3a68b7335040c48759bb167f729a41', 'DSH', 'TJCG', '2018-05-11 15:24:29', '2018-05-11 15:25:10', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('5e526443d9044debad76f0c549100930', '5777a59845f14271a538dd5344075e73', 'DSH', 'TJCG', '2018-05-11 09:55:14', '2018-05-11 09:55:45', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('5f2476430c2145888230a8c1207cceba', 'd4131edf16ab434b95516af05bf28a08', 'DSH', 'SCSSCL', '2018-05-14 11:29:32', '2018-05-14 11:29:35', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('625e3daedfaf42ab916cab9d86284d27', '20a5db2c1ba840dba4a4e2d4c12449fd', 'DSH', 'BJWSLA', '2018-05-07 15:36:21', '2018-05-07 15:36:21', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('6286b8cf833248d09054e8892eedc7b8', '2eb6fc2c701041ed9efd82ca96d478fc', 'DSH', 'BJWSLA', '2018-05-07 15:36:20', '2018-05-07 15:36:20', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('636516d95201435b80c8d3f715d343b3', '91b3688eb6a14aff879a6aabe2cd0b45', 'DSH', '2', '2018-05-07 09:22:18', '2018-05-07 11:15:04', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('646f19ba064343a88d8c18e7a6152d71', 'd7b47f398b154192ba94d646d0e39261', 'DSH', '2', '2018-05-04 14:07:30', '2018-05-04 14:07:34', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('665c920832254a03a7f49a6fafa64069', '6190551862644a23b86c0f4b49ad34cd', 'DSH', 'BJWSLA', '2018-05-08 11:02:26', '2018-05-08 11:02:26', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('6aa7320613704314a02e4033d926337f', 'dfcac12e15924ee088d74359adf922fe', 'DSH', '1', '2018-05-04 12:21:56', '2018-05-04 12:21:56', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('6d6970ea00fe4ae880ee33aa959e516b', 'eeb2158afc904e9e818c1b1ca388466e', 'DSH', '4', '2018-05-07 13:43:25', '2018-05-07 13:44:56', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('6ef1ce6ca16344fa9d330715effc8afd', 'fc40b1b11b55492aac582d5a16d194ae', 'DSH', 'TJCG', '2018-05-15 19:29:10', '2018-05-15 19:29:21', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('701abb7bf60e44319b0e55ac448195f5', '948d6afb39e849e3938d54cde3328a26', 'DSH', 'BJWSLA', '2018-05-14 17:37:22', '2018-05-14 17:37:22', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('7293822654e347f1b4db11dd2246d58e', '8747a70e6f5f40578f7868611f5ea3cf', 'DSH', 'BJWSLA', '2018-05-08 09:59:52', '2018-05-08 09:59:52', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('73711df2f6b547b291a89216b035bb75', '37c33dd11dd74d4a81cbcdafd59159cd', 'DSH', '1', '2018-05-04 15:52:27', '2018-05-04 15:52:27', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('7459ad5736d44c8a8f52d679e97b1d77', '114e27999b8f46d9a2aeffa1cc73583b', 'DSH', 'BJWSLA', '2018-05-07 14:24:53', '2018-05-07 14:24:53', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('77eee87ca4fb41a98065ac008fe6ead7', '8beabaf7e4a1462387cec881a34f43be', 'DSH', 'BJWSLA', '2018-05-14 16:22:32', '2018-05-14 16:22:32', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('7d683c2c5a444b2f968bb00a52e22e47', 'b322fc3b462747988cc85870681b822b', 'DSH', '2', '2018-05-07 09:16:54', '2018-05-07 11:22:42', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('7e65c8626e3d46d5af64c741ac57dd0a', '59b5d7a0e90e4414960c24073eb0097a', 'DSH', 'BJWSLA', '2018-05-17 09:59:34', '2018-05-17 09:59:34', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('7e80ddb2b5b74cb6a377a2acba3adb5a', '1cb49d92fd5c4a6ab8b0b547c8a437ef', 'DSH', 'BJWSLA', '2018-05-14 16:12:39', '2018-05-14 16:12:39', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('802bfae4582641369f0ebffce9aa81e3', '8a4189ceca25450f8fca05bdfb40410e', 'DSH', 'BJWSLA', '2018-05-14 19:51:26', '2018-05-14 19:51:26', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('8276df66b84742af8a766fa0626388c1', '3439c0fb390f4766b2cc399c094e518b', 'DSH', 'SCSSCL', '2018-05-09 15:27:41', '2018-05-09 15:53:30', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('84af663804db4b0d925a496451c058ca', '4cf222b243464d79979b326a2117972d', 'DSH', 'BJWSLA', '2018-05-11 09:51:03', '2018-05-11 09:51:03', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('863ce73038a444af8924d36c6b08c7b3', 'c7447f4634e24b9c84606214bef7252a', 'DSH', '1', '2018-05-04 15:52:27', '2018-05-04 15:52:27', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('877a82fbb3f14919ab1d9c7aa0d1b8ae', 'e7fe1d74f70b4bd7871fda9a575f3c26', 'DSH', 'BJWSLA', '2018-05-16 09:30:07', '2018-05-16 09:30:07', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('87e8e82936ed4b45820fc5a2264dd56c', '49ef23ad4e774a589526f7ffb271a6b5', 'DSH', 'BJWSLA', '2018-05-14 17:30:25', '2018-05-14 17:30:25', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('8b99a813a69f4ac2aeb6556a1dc7898c', '5199d54412de495483f764c14e1371b1', 'DSH', '2', '2018-05-05 14:07:27', '2018-05-05 16:32:35', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('8cbf3bbd43114f1b8214d277a1e96143', '7576ecbf5a41449abfdd1ac11c37c270', 'DSH', 'BJWSLA', '2018-05-11 12:00:02', '2018-05-11 12:00:02', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('8d336e6f3a644b6abcc04b0ed4e16551', '8ba58b9e3a0842069352ec3d50698aba', 'DSH', '4', '2018-05-05 10:31:50', '2018-05-05 10:32:08', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('905e3a33fd8448729c84c20e4bf432ab', '98c9974ba2c3449aa8351315b02e98b8', 'DSH', 'BJWSLA', '2018-05-14 15:57:26', '2018-05-14 15:57:26', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('933c44e1b41c4df4babb587960a36ff2', '49e06a6c59fc4ec2ab46d4c2d7703565', 'DSH', 'SCSSCL', '2018-05-15 20:18:55', '2018-05-15 20:19:19', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('957816f323b1447e8007ed991e1f4fef', '039f87680ef64762bd5e05cd62310b58', 'DSH', 'YLHTJ', '2018-05-04 17:07:09', '2018-05-10 18:37:56', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('9ef42f30dd5b4682bcfa1184d5358514', '99a198ae5be54868ac9bd5749ddd385d', 'DSH', 'BJWSLA', '2018-05-14 17:38:38', '2018-05-14 17:38:38', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('a4ceefb85ffa4f52b088278fdf42989e', '65f777fde86640e8b1485515d00dc44b', 'DSH', 'BJWSLA', '2018-05-07 15:36:20', '2018-05-07 15:36:20', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('a4df7bab83f6468f96c4c4c4663fd61b', 'abf41e5c3b2a4b0aa4a79f47be647008', 'DSH', 'BJWSLA', '2018-05-14 19:29:25', '2018-05-14 19:29:25', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('a59e0d18cf7c4c27a6f0cd549bad0d40', '6974eaafddc74e8fbcc4322d8d6402ec', 'DSH', 'BJWSLA', '2018-05-14 17:36:51', '2018-05-14 17:36:51', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('a60ce32922164bef88e63ff8ba86d947', '052fc1f92cdb48208449c5e3b0e1ea5a', 'DSH', 'SCSSCL', '2018-05-16 13:52:27', '2018-05-16 14:27:27', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('a885f61930484542a24a2878463aa258', 'b70b9efe79164c31b5db8bd910a6f00c', 'DSH', '1', '2018-05-04 17:18:31', '2018-05-04 17:18:31', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('ac2e394051e14deaa615e8abb193577b', '1da8e685947f45e7ba8e64d9c588b89d', 'DSH', 'SCSSCL', '2018-05-16 11:21:40', '2018-05-16 11:38:57', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('ac3cdacffa854a30b431c74b93a98f91', '7b4a54748ef2480e90e3556cdebd4cb0', 'DSH', '2', '2018-05-04 14:15:21', '2018-05-04 14:15:26', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('b41dacd0851b4c5baaf0c8828f4b6202', '3841770c008745209fd704fbc8570520', 'DSH', 'BJWSLA', '2018-05-17 10:00:01', '2018-05-17 10:00:01', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('b5714de827fc4597aa0c1235c3ac3f79', 'ec97360740c54205a3359a90dcc907e1', 'DSH', 'BJWSLA', '2018-05-14 13:30:08', '2018-05-14 13:30:08', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('ba2224c7346841078552e2be65da0328', 'd9efc919ccbe46db968282cde4d32067', 'DSH', 'BJWSLA', '2018-05-17 10:09:41', '2018-05-17 10:09:41', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('baf5d7b1ccba42cb9f1e76b7edf69a29', '1affc28f4c6e4c4082e81fe9d9ed172d', 'DSH', 'BJWSLA', '2018-05-16 19:56:23', '2018-05-16 19:56:23', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('bdee6e5c3fb84590a567be3ca52bb0a7', 'b7895988648f4abeaaa6898f904c20ac', 'DSH', 'BJWSLA', '2018-05-14 16:10:51', '2018-05-14 16:10:51', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('c34e03816f32436f8cdcc9ac06ef3307', '40ab9537c63c4c198d9850774cb3a555', 'DSH', 'YLHTJ', '2018-05-11 12:09:54', '2018-05-11 12:10:11', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('c460437a87dc4595bcbec6f7c3ce1639', 'a25aa3f82519412baf5f9dd4f5ebe019', 'DSH', 'BJWSLA', '2018-05-14 16:03:14', '2018-05-14 16:03:14', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('c47d90b9889646f983a8e6601147d060', 'cfc87b854088421993a0a614a8bbb327', 'DSH', 'BJWSLA', '2018-05-11 12:09:27', '2018-05-11 12:09:27', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('c485d623e95b4d7c9ad76bb237e0d6e6', 'e1b7c71d8b1643b29b1336acc528f64a', 'DSH', '3', '2018-05-04 17:26:14', '2018-05-05 18:38:27', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('c4f61c97bd564d25b8a6999df702c73c', '64a993c756144f158a0c51e8f8566696', 'DSH', '2', '2018-05-04 15:31:14', '2018-05-04 15:31:29', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('c5672d735ddd4d12975d01bab5db084b', '3ef60be8bc6640e4a1bd1579bc9e37d4', 'DSH', '1', '2018-05-04 15:56:38', '2018-05-04 15:56:38', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('c70b517b1c3a43d8af03e16bec5b6cc4', '3a6d37e6b3e8499aa4053ad0ee02786c', 'DSH', 'BJWSLA', '2018-05-16 11:13:38', '2018-05-16 11:13:38', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('cbc7166835df475e97d4ae854c2ba3bd', '6572f5b2fac2454da19e8151e8d13592', 'DSH', 'BJWSLA', '2018-05-07 15:36:21', '2018-05-07 15:36:21', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('cd56308a92684274bd1a14a819dc80d5', '886ec372aa8f43fa933693564d079328', 'DSH', '1', '2018-05-05 09:39:03', '2018-05-05 09:39:03', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('cf05bc131ee24202a9773c770f636381', 'dc40b32a583244e5b98d21b8a9e37d45', 'DSH', 'BJWSLA', '2018-05-05 14:46:45', '2018-05-05 14:46:45', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('d09755a7aa28458ea528b3da8bf5a92a', 'f756a25877784a8abda346c96cb09288', 'DSH', 'BJWSLA', '2018-05-10 17:03:16', '2018-05-10 17:03:16', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('d361347434f5443c96ccef2f800f3696', 'e171496d723b460ba7dcbd627188c938', 'DSH', 'TJCG', '2018-05-15 09:05:01', '2018-05-16 17:07:03', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('d3ae0c483db64019bf31d69ac45df9d6', '0487e079bb9d4ead9a6913abb6f66c0f', 'DSH', 'SCSSCL', '2018-05-11 09:39:42', '2018-05-11 09:39:45', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('d43ae8ae4b614fe3abf4095c678692ea', '48db1609685e434299cb00fa996048cb', 'DSH', 'YLHTJ', '2018-05-11 09:46:49', '2018-05-11 09:46:55', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('d45d452ff68d4128a6e1d93b2380bb17', 'a8624aafe5714ddc994bbec1e472f6bb', 'DSH', 'BJWSLA', '2018-05-14 09:23:25', '2018-05-14 09:23:25', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('d50df27619e04e6f9bab855fe6e19e15', 'b8475589957949218033c5db95ed2205', 'DSH', '1', '2018-05-04 17:09:54', '2018-05-04 17:09:54', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('d67f2441fb874460bbdbf6d2786a6c91', 'd31757cdbb3a464ab5911f8aa63cc57e', 'DSH', 'BJWSLA', '2018-05-07 15:36:21', '2018-05-07 15:36:21', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('d71b700bf3d046a08808fd7ce091781c', '416fe3a9e3cd48adb6255c71cfc69c9c', 'DSH', '1', '2018-05-04 17:09:41', '2018-05-04 17:09:41', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('e4e1bcf825934e2e9f3ca61852d47f9c', '4a514205857640598338ee66410e7869', 'DSH', 'BJWSLA', '2018-05-17 09:21:25', '2018-05-17 09:21:25', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('e53f6d9bd98a410eaaa95e6133bd47d8', '3d8f315b794d4090b93429785cca7fed', 'DSH', '2', '2018-05-05 16:40:33', '2018-05-05 18:35:06', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('e5bca5116c1a45ceb1979581e01a446d', '200275e313f1488b9288139314bc4141', 'DSH', 'BJWSLA', '2018-05-16 19:22:29', '2018-05-16 19:22:29', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('ec6d986b149443a09498d3609db55cc4', '8c09b827a07e4b54a81a886f92af93af', 'DSH', 'BJWSLA', '2018-05-14 13:26:53', '2018-05-14 13:26:53', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('f03b0505aac44fe483b4d6eeb46b2278', 'ecf75df2c02947acb9a89c5f4af27756', 'DSH', 'TJCG', '2018-05-14 10:43:18', '2018-05-14 11:00:29', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('f0515e3e87f342e8b7c33766609ab096', '1a231f26b8b149d8be23d40e0c4f1ed0', 'DSH', 'TJCG', '2018-05-14 10:38:23', '2018-05-14 10:39:12', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('ff5f3ac9156e443286694ee36e27072e', '5ff3960f37e14dda94e25cdadd1a04a0', 'DSH', 'SCSSCL', '2018-05-16 11:39:37', '2018-05-16 11:40:13', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ajzt` VALUES ('ff8729b09f0843f9b5a1c6e289a4179d', 'a7f6f44ba0104f6a8237cf1032b1522e', 'DSH', 'BJWSLA', '2018-05-14 17:38:10', '2018-05-14 17:38:10', 'archibald_witwicky', 'archibald_witwicky');

-- ----------------------------
-- Table structure for sspt_bg
-- ----------------------------
DROP TABLE IF EXISTS `sspt_bg`;
CREATE TABLE `sspt_bg` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `ajid` varchar(32) DEFAULT NULL COMMENT '案件id',
  `dsrlx` varchar(20) DEFAULT NULL COMMENT '当事人类型',
  `bgxm` varchar(20) DEFAULT NULL COMMENT '被告姓名',
  `zjlx` varchar(20) DEFAULT NULL COMMENT '证件类型',
  `zjhm` varchar(20) DEFAULT NULL COMMENT '证件号码',
  `sjhm` varchar(11) DEFAULT NULL COMMENT '手机号码',
  `mz` varchar(20) DEFAULT NULL COMMENT '民族',
  `nl` int(11) DEFAULT NULL COMMENT '年龄',
  `csrq` datetime DEFAULT NULL COMMENT '出生日期',
  `xb` varchar(20) DEFAULT NULL COMMENT '性别',
  `gzdw` varchar(255) DEFAULT NULL COMMENT '工作单位',
  `zy` varchar(50) DEFAULT NULL COMMENT '职业',
  `dzlx` varchar(50) DEFAULT NULL COMMENT '地址类型',
  `dz` varchar(255) DEFAULT NULL COMMENT '地址类型对应地址',
  `gddh` varchar(20) DEFAULT NULL COMMENT '固定电话',
  `dwmc` varchar(255) DEFAULT NULL COMMENT '单位名称',
  `dwxz` varchar(50) DEFAULT NULL COMMENT '单位性质',
  `zzlx` varchar(50) DEFAULT NULL COMMENT '证照类型',
  `zzhm` varchar(50) DEFAULT NULL COMMENT '证照号码',
  `zsd` varchar(255) DEFAULT NULL COMMENT '住所地',
  `fddbrxm` varchar(20) DEFAULT NULL COMMENT '法定代表人姓名',
  `fddbrzw` varchar(50) DEFAULT NULL COMMENT '法定代表人职务',
  `fddbrzjlx` varchar(50) DEFAULT NULL COMMENT '法定代表人证件类型',
  `fddbrzjhm` varchar(50) DEFAULT NULL COMMENT '法定代表人证件号码',
  `fddbrsjhm` varchar(11) DEFAULT NULL COMMENT '法定代表人手机号码',
  `fddbrgddh` varchar(20) DEFAULT NULL COMMENT '法定代表人固定电话',
  `zyfzrxm` varchar(50) DEFAULT NULL COMMENT '主要负责人姓名',
  `zyfzrzw` varchar(50) DEFAULT NULL COMMENT '主要负责人职务',
  `zyfzrzjlx` varchar(50) DEFAULT NULL COMMENT '主要负责人证件类型',
  `zyfzrzjhm` varchar(50) DEFAULT NULL COMMENT '主要负责人证件号码',
  `zyfzrsjhm` varchar(11) DEFAULT NULL COMMENT '主要负责人手机号码',
  `zyfzrgddh` varchar(20) DEFAULT NULL COMMENT '主要负责人固定电话',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='被告';

-- ----------------------------
-- Records of sspt_bg
-- ----------------------------
INSERT INTO `sspt_bg` VALUES ('25c16797eede4227a91b6c84fc778281', '5d923fa8dd1c4383bb38c59a32105678', '自然人', 'fasdf', '军官证', '123', '17521211444', '身份证', '21', '2018-05-22 00:00:00', '1', '12dasd', '身份证', 'on', 'sdv', '17521211444', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-05-14 10:09:55', '2018-05-14 10:09:55', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_bg` VALUES ('5a092b42fd384d8aac6b07a2bd873097', 'e171496d723b460ba7dcbd627188c938', '自然人', '被告1', 'JGZ', '412725199407270019', '13033333333', 'HZ', '23', '2018-05-15 00:00:00', '2', '上海浦东华宇', 'GCJSRYHNLJSRY', 'on', '上海浦东', '13033333333', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-05-15 09:48:09', '2018-05-15 09:48:09', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_bg` VALUES ('f0fb025b29b14efd86cce7c378d141f5', 'e171496d723b460ba7dcbd627188c938', '自然人', '被告2', 'JGZ', '412725199407270019', '13033333333', 'HZ', '23', '2018-05-30 00:00:00', '男', '上海浦东华宇', 'KXYJRY', 'on', '上海浦东华宇', '13033333333', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-05-15 10:25:57', '2018-05-15 10:25:57', 'archibald_witwicky', 'archibald_witwicky');

-- ----------------------------
-- Table structure for sspt_djzjxx
-- ----------------------------
DROP TABLE IF EXISTS `sspt_djzjxx`;
CREATE TABLE `sspt_djzjxx` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `ajid` varchar(32) DEFAULT NULL COMMENT '案件id',
  `zjmc` varchar(255) DEFAULT NULL COMMENT '证据名称',
  `zjly` varchar(255) DEFAULT NULL COMMENT '证据来源',
  `zmwt` varchar(255) DEFAULT NULL COMMENT '证明问题',
  `ssr` varchar(255) DEFAULT NULL COMMENT '所属人(选择登记的原告人员之一)',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='登记证据信息';

-- ----------------------------
-- Records of sspt_djzjxx
-- ----------------------------
INSERT INTO `sspt_djzjxx` VALUES ('6ee722b5051342f98222ccec183fbd37', '5d923fa8dd1c4383bb38c59a32105678', '证据名称', '证据来源', 'rtgfds', '身份证', '2018-05-14 10:12:38', '2018-05-14 10:12:38', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_djzjxx` VALUES ('f3560daf13fc43c6b242daf169d754a8', '46826d1585094dc1a10fe15aef265d58', '证据名称1', '证据来源1', '证明问题1', '身份证', '2018-05-04 11:29:23', '2018-05-04 11:29:23', 'archibald_witwicky', 'archibald_witwicky');

-- ----------------------------
-- Table structure for sspt_dsr
-- ----------------------------
DROP TABLE IF EXISTS `sspt_dsr`;
CREATE TABLE `sspt_dsr` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `ajid` varchar(32) DEFAULT NULL COMMENT '案件id',
  `dsrlx` varchar(20) DEFAULT NULL COMMENT '当事人类型',
  `dsrxm` varchar(20) DEFAULT NULL COMMENT '第三人姓名',
  `zjlx` varchar(20) DEFAULT NULL COMMENT '证件类型',
  `zjhm` varchar(20) DEFAULT NULL COMMENT '证件号码',
  `sjhm` varchar(11) DEFAULT NULL COMMENT '手机号码',
  `mz` varchar(10) DEFAULT NULL COMMENT '民族',
  `nl` int(11) DEFAULT NULL COMMENT '年龄',
  `csrq` datetime DEFAULT NULL COMMENT '出生日期',
  `xb` varchar(10) DEFAULT NULL COMMENT '性别',
  `gzdw` varchar(50) DEFAULT NULL COMMENT '工作单位',
  `zy` varchar(50) DEFAULT NULL COMMENT '职业',
  `dzlx` varchar(50) DEFAULT NULL COMMENT '地址类型',
  `dz` varchar(255) DEFAULT NULL COMMENT '地址类型对应地址',
  `gddh` varchar(20) DEFAULT NULL COMMENT '固定电话',
  `dwmc` varchar(50) DEFAULT NULL COMMENT '单位名称',
  `dwxz` varchar(50) DEFAULT NULL COMMENT '单位性质',
  `zzlx` varchar(20) DEFAULT NULL COMMENT '证照类型',
  `zzhm` varchar(50) DEFAULT NULL COMMENT '证照号码',
  `zsd` varchar(255) DEFAULT NULL COMMENT '住所地',
  `fddbrxm` varchar(20) DEFAULT NULL COMMENT '法定代表人姓名',
  `fddbrzw` varchar(20) DEFAULT NULL COMMENT '法定代表人职务',
  `fddbrzjlx` varchar(20) DEFAULT NULL COMMENT '法定代表人证件类型',
  `fddbrzjhm` varchar(50) DEFAULT NULL COMMENT '法定代表人证件号码',
  `fddbrsjhm` varchar(11) DEFAULT NULL COMMENT '法定代表人手机号码',
  `fddbrgddh` varchar(20) DEFAULT NULL COMMENT '法定代表人固定电话',
  `zyfzrxm` varchar(20) DEFAULT NULL COMMENT '主要负责人姓名',
  `zyfzrzw` varchar(20) DEFAULT NULL COMMENT '主要负责人职务',
  `zyfzrzjlx` varchar(20) DEFAULT NULL COMMENT '主要负责人证件类型',
  `zyfzrzjhm` varchar(50) DEFAULT NULL COMMENT '主要负责人证件号码',
  `zyfzrsjhm` varchar(11) DEFAULT NULL COMMENT '主要负责人手机号码',
  `zyfzrgddh` varchar(20) DEFAULT NULL COMMENT '主要负责人固定电话',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='第三人';

-- ----------------------------
-- Records of sspt_dsr
-- ----------------------------
INSERT INTO `sspt_dsr` VALUES ('81f1dc840d3d471cba950575e9f85e9f', '46826d1585094dc1a10fe15aef265d58', '自然人', '第三人1', '身份证', '412725199407270019', '13033333333', '身份证', '23', '2018-05-23 00:00:00', '男', '上海浦东华宇', '身份证', 'on', '上海浦东华宇', '13033333333', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-05-04 11:29:09', '2018-05-04 11:29:09', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_dsr` VALUES ('007df9c53d15413ca999c9c1acf14d7b', '5d923fa8dd1c4383bb38c59a32105678', '自然人', 'ndf', '军官证', '123', '17521211444', '身份证', '12', '2018-04-10 00:00:00', '1', '12fsa', '身份证', 'on', '17521211444', '17521211444', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-05-14 10:12:08', '2018-05-14 10:12:08', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_dsr` VALUES ('2b4d02b16a4f45e2a8a22fe913cd820f', 'e171496d723b460ba7dcbd627188c938', '自然人', '第三人1', 'HZ', '412725199407270019', '13033333333', 'HUIZU', '12', '2018-05-16 00:00:00', '男', '上海浦东华宇', 'KXYJRY', 'on', '上海浦东华宇', '13033333333', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-05-15 10:30:09', '2018-05-15 10:30:09', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_dsr` VALUES ('1809a50cb7f04b789a695fbd09f1607f', 'e171496d723b460ba7dcbd627188c938', '自然人', '第三人1', 'JGZ', '412725199407270019', '13033333333', 'HZ', '23', '2018-05-22 00:00:00', '男', '上海浦东华宇', 'KXYJRY', 'on', '上海浦东', '13033333333', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-05-15 10:50:38', '2018-05-15 10:50:38', 'archibald_witwicky', 'archibald_witwicky');

-- ----------------------------
-- Table structure for sspt_dzsd
-- ----------------------------
DROP TABLE IF EXISTS `sspt_dzsd`;
CREATE TABLE `sspt_dzsd` (
  `id` varchar(32) NOT NULL COMMENT '电子送达 id',
  `yhid` varchar(32) DEFAULT NULL COMMENT '用户id',
  `ah` varchar(255) DEFAULT NULL COMMENT '案号',
  `wsmc` varchar(255) DEFAULT NULL COMMENT '文书名称',
  `sdfy` varchar(255) DEFAULT NULL COMMENT '送达法院',
  `gxsj` datetime DEFAULT NULL COMMENT '更新时间',
  `zt` int(11) DEFAULT NULL COMMENT '状态 1 未签收 2 已签收 3 已失败',
  `dzsd_gxsj` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(255) DEFAULT NULL COMMENT '创建人',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建人 时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '修改时间',
  `upd_user` varchar(255) DEFAULT NULL COMMENT '修改人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sspt_dzsd
-- ----------------------------
INSERT INTO `sspt_dzsd` VALUES ('wewqewqeqew', 'fdertd1585094dc1a10fe15aef265d58', '1', '1', '1', '2018-05-16 16:38:44', '1', '2018-05-16 16:38:50', '1', '2018-05-16 16:39:09', '2018-05-16 16:39:13', '1');

-- ----------------------------
-- Table structure for sspt_fwjg
-- ----------------------------
DROP TABLE IF EXISTS `sspt_fwjg`;
CREATE TABLE `sspt_fwjg` (
  `id` varchar(32) NOT NULL,
  `lxid` varchar(32) DEFAULT NULL,
  `fghf` varchar(255) DEFAULT NULL,
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sspt_fwjg
-- ----------------------------
INSERT INTO `sspt_fwjg` VALUES ('', '94f3dcac162b4116acb05319bce2877e', '广东警方表示,任何公民发现上述逃犯可立即向公安机关举报,公安机关将对举报人资料严格保密。凡在2015年12月30日前向公安机关举报或提供线索,配合公安机关抓获在逃人员的,将按照悬赏金额给予举报人壹万元人民币奖励,对隐瞒包庇在逃人员的,依法追究法律责任;对打击报复举报人的依法从严惩处。', null, null, null, null);

-- ----------------------------
-- Table structure for sspt_fy
-- ----------------------------
DROP TABLE IF EXISTS `sspt_fy`;
CREATE TABLE `sspt_fy` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `name` varchar(255) DEFAULT NULL COMMENT '法院名称',
  `address` varchar(255) DEFAULT NULL COMMENT '法院地址',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='法院';

-- ----------------------------
-- Records of sspt_fy
-- ----------------------------
INSERT INTO `sspt_fy` VALUES ('bvfbb136e5a74b168bddaf747eeacc34', '天津市和平区人民法院234234', '天津', '2018-05-05 14:03:53', '2018-05-05 14:03:53', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_fy` VALUES ('dfgbb136e5a74b168bddaf747eeacc34', '天津市第一中级人民法院', '天津', '2018-05-05 14:03:53', '2018-05-05 14:03:53', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_fy` VALUES ('rrrbb136e5a74b168bddaf747eeacc34', '天津市高级人民法院', '天津', '2018-05-05 14:03:53', '2018-05-05 14:03:53', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_fy` VALUES ('sdfbb136e5a74b168bddaf747eeacc34', '天津市南开区人民法院', '天津', '2018-05-05 14:03:53', '2018-05-05 14:03:53', 'archibald_witwicky', 'archibald_witwicky');

-- ----------------------------
-- Table structure for sspt_ktxx
-- ----------------------------
DROP TABLE IF EXISTS `sspt_ktxx`;
CREATE TABLE `sspt_ktxx` (
  `id` varchar(32) NOT NULL COMMENT '开庭信息ID',
  `ah` varchar(32) NOT NULL COMMENT '案号',
  `ktsj` varchar(32) DEFAULT NULL COMMENT '开庭时间',
  `ktlx` varchar(32) DEFAULT NULL COMMENT '开庭类型',
  `qy` varchar(32) DEFAULT NULL COMMENT '区域',
  `ft` varchar(32) DEFAULT NULL COMMENT '法庭',
  `ajms` varchar(32) DEFAULT NULL COMMENT '案件描述',
  `ptxw` varchar(32) DEFAULT NULL COMMENT '旁听席位',
  `syxw` varchar(32) DEFAULT NULL COMMENT '剩余席位',
  `zsfg` varchar(32) DEFAULT NULL COMMENT '主审法官',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='开庭信息';

-- ----------------------------
-- Records of sspt_ktxx
-- ----------------------------
INSERT INTO `sspt_ktxx` VALUES ('1', '(2018)京01民终4399号', '1527004000000', '开庭', '第一区域', '第一法庭', '法院', '10', '5', '1', '2018-05-08 16:47:59', '2018-05-08 16:49:16', null, null);
INSERT INTO `sspt_ktxx` VALUES ('10', '10', '1527004000000', '10', '10', '10', '10', '10', '10', '10', '2018-05-16 10:48:12', '2018-05-16 10:48:15', null, null);
INSERT INTO `sspt_ktxx` VALUES ('2', '(2018)京01民终4398号', '1527004000000', '2', '2', '第一法庭', '法院', '2', '2', '1', '2018-04-11 15:12:14', '2018-05-11 15:12:18', null, null);
INSERT INTO `sspt_ktxx` VALUES ('3', '(2018)京01民终3126号', '1527004000000', '3', '3', '第一法庭', '法院', '3', '3', '1', '2018-05-08 16:50:32', '2018-05-08 16:50:34', null, null);
INSERT INTO `sspt_ktxx` VALUES ('4', '(2018)京01民特78号', '1527004000000', '4', '4', '第一法庭', '法院', '4', '4', '1', '2018-05-08 16:50:49', '2018-05-08 16:50:51', null, null);
INSERT INTO `sspt_ktxx` VALUES ('5', '(2018)京01民终4126号', '1527004000000', '5', '5', '第一法庭', '法院', '5', '5', '1', '2018-05-08 16:51:09', '2018-05-08 16:51:12', null, null);
INSERT INTO `sspt_ktxx` VALUES ('6', '(2018)京01民终4398号', '1527004000000', '6', '6', '第一法庭', '法院', '6', '6', '1', '2018-05-08 16:51:35', '2018-05-08 16:51:37', null, null);
INSERT INTO `sspt_ktxx` VALUES ('7', '7', '1527004000000', '7', '7', '7', '7', '7', '7', '7', '2018-05-16 10:47:14', '2018-05-16 10:47:18', null, null);
INSERT INTO `sspt_ktxx` VALUES ('8', '8', '1527004000000', '8', '8', '8', '8', '8', '8', '8', '2018-05-16 10:47:35', '2018-05-16 10:47:37', null, null);
INSERT INTO `sspt_ktxx` VALUES ('9', '9', '1527004000000', '9', '9', '9', '9', '9', '9', '9', '2018-05-16 10:47:53', '2018-05-16 10:47:55', null, null);

-- ----------------------------
-- Table structure for sspt_lb
-- ----------------------------
DROP TABLE IF EXISTS `sspt_lb`;
CREATE TABLE `sspt_lb` (
  `lbbm` varchar(20) NOT NULL COMMENT '类别编码',
  `lbmc` varchar(50) NOT NULL COMMENT '类别名称',
  `px` int(11) NOT NULL COMMENT '排序',
  `crt_user` varchar(30) DEFAULT NULL COMMENT '创建用户',
  `upd_user` varchar(30) DEFAULT NULL COMMENT '更新用户',
  `crt_tm` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `upd_tm` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '更新时间',
  PRIMARY KEY (`lbbm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='类别';

-- ----------------------------
-- Records of sspt_lb
-- ----------------------------
INSERT INTO `sspt_lb` VALUES ('AJLB', '案件类型', '1', 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 13:48:39', '2018-05-05 14:02:59');
INSERT INTO `sspt_lb` VALUES ('AJLCZT', '案件流程状态', '1', 'archibald_witwicky', 'archibald_witwicky', '2018-05-05 16:43:22', '2018-05-05 16:41:35');
INSERT INTO `sspt_lb` VALUES ('AJZT', '案件状态', '1', 'archibald_witwicky', 'archibald_witwicky', '2018-05-05 11:35:50', '2018-05-05 11:34:03');
INSERT INTO `sspt_lb` VALUES ('DLRLX', '代理人类型', '1', 'archibald_witwicky', 'archibald_witwicky', '2018-05-05 14:09:57', '2018-05-05 14:08:10');
INSERT INTO `sspt_lb` VALUES ('DSRLX', '当事人类型', '1', 'archibald_witwicky', 'archibald_witwicky', '2018-05-05 14:11:24', '2018-05-05 14:09:43');
INSERT INTO `sspt_lb` VALUES ('DWXZ', '单位性质', '1', 'archibald_witwicky', 'archibald_witwicky', '2018-05-15 09:13:58', '2018-05-15 09:14:26');
INSERT INTO `sspt_lb` VALUES ('DZLX', '地址类型', '1', 'archibald_witwicky', 'archibald_witwicky', '2018-05-05 14:13:20', '2018-05-05 14:11:33');
INSERT INTO `sspt_lb` VALUES ('DZSDZT', '电子送达状态', '1', 'archibald_witwicky', 'archibald_witwicky', '2018-05-16 16:10:09', '2018-05-16 16:10:58');
INSERT INTO `sspt_lb` VALUES ('MZ', '民族', '1', 'archibald_witwicky', 'archibald_witwicky', '2018-05-05 14:12:07', '2018-05-05 14:10:19');
INSERT INTO `sspt_lb` VALUES ('SQLX', '申请类型', '1', 'archibald_witwicky', 'archibald_witwicky', '2018-05-05 14:05:06', '2018-05-05 14:03:26');
INSERT INTO `sspt_lb` VALUES ('SQRLX', '申请人类型', '1', 'archibald_witwicky', 'archibald_witwicky', '2018-05-05 14:05:40', '2018-05-05 14:04:02');
INSERT INTO `sspt_lb` VALUES ('ZJLX', '证件类型', '1', 'archibald_witwicky', 'archibald_witwicky', '2018-05-05 14:10:15', '2018-05-05 14:08:34');
INSERT INTO `sspt_lb` VALUES ('ZY', '职业', '1', 'archibald_witwicky', 'archibald_witwicky', '2018-05-05 14:12:47', '2018-05-05 14:10:59');
INSERT INTO `sspt_lb` VALUES ('ZZLX', '证照类型', '1', 'archibald_witwicky', 'archibald_witwicky', '2018-05-07 12:01:51', '2018-05-07 12:00:02');

-- ----------------------------
-- Table structure for sspt_lbbm
-- ----------------------------
DROP TABLE IF EXISTS `sspt_lbbm`;
CREATE TABLE `sspt_lbbm` (
  `lbbm` varchar(20) NOT NULL COMMENT '类别编码(ZD_LB)',
  `bm` varchar(20) NOT NULL COMMENT '编码',
  `mc` varchar(200) NOT NULL COMMENT '名称',
  `px` int(11) NOT NULL COMMENT '排序',
  `sjbm` varchar(6) DEFAULT NULL COMMENT '上级编码',
  `zt` varchar(1) DEFAULT '1' COMMENT '状态',
  `zgydm` varchar(6) DEFAULT NULL COMMENT '最高院代码',
  `crt_user` varchar(30) DEFAULT NULL COMMENT '创建用户',
  `upd_user` varchar(30) DEFAULT NULL COMMENT '更新用户',
  `crt_tm` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
  `upd_tm` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT '更新时间',
  PRIMARY KEY (`lbbm`,`bm`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='类别编码';

-- ----------------------------
-- Records of sspt_lbbm
-- ----------------------------
INSERT INTO `sspt_lbbm` VALUES ('AJLB', 'MS', '民事', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('AJLB', 'ZX', '执行', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('AJLCZT', 'BJWSLA', '编辑网上立案', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('AJLCZT', 'SCSSCL', '上传诉讼材料', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('AJLCZT', 'TJCG', '提交成功', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('AJLCZT', 'YLHTJ', '预览和提交', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('AJZT', 'DSH', '待审核', '1', null, '2', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('AJZT', 'DTJ', '待提交', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('AJZT', 'SHBTG', '审核不通过', '1', null, '3', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('AJZT', 'SHTG', '审核通过', '1', null, '4', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('AJZT', 'SLZ', '审理中', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('AJZT', 'SQSB', '申请失效', '1', null, '5', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('AJZT', 'YJA', '已结案', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('AJZT', 'YLA', '已立案', '1', null, '6', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('DLRLX', 'CDFLYZ', '承担法律援助的律师', '0', null, '0', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 18:24:38', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('DLRLX', 'FLGZZ', '法律工作者', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('DLRLX', 'FYXKDQ', '法院许可的其他公民', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('DLRLX', 'JHR', '监护人', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('DLRLX', 'LS', '律师', '0', null, '0', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 18:24:36', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('DLRLX', 'QY', '亲友', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('DLRLX', 'RMTTTJ', '人民团体推荐的人', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('DLRLX', 'SZDWTJ', '所在单位推荐的人', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('DSRLX', 'FFRZZ', '非法人组织', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('DSRLX', 'FR', '法人', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('DSRLX', 'ZRR', '自然人', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('DWXZ', 'SYDW', '事业单位', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-15 09:15:10', '2018-05-15 09:15:38');
INSERT INTO `sspt_lbbm` VALUES ('DWXZ', 'XZDW', '行政单位', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-15 09:14:37', '2018-05-15 09:15:06');
INSERT INTO `sspt_lbbm` VALUES ('DZLX', 'HJSZD', '户籍所在地', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('DZLX', 'JCJZD', '经常居住地', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('DZSDZT', 'SY', '所有', '0', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-16 16:28:18', '2018-05-16 16:11:30');
INSERT INTO `sspt_lbbm` VALUES ('DZSDZT', 'WQS', '未签收', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-16 16:00:46', '2018-05-16 16:01:36');
INSERT INTO `sspt_lbbm` VALUES ('DZSDZT', 'YQS', '已签收', '2', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-16 16:00:44', '2018-05-16 16:01:33');
INSERT INTO `sspt_lbbm` VALUES ('DZSDZT', 'YSB', '已失败', '3', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-16 16:00:40', '2018-05-16 16:01:27');
INSERT INTO `sspt_lbbm` VALUES ('MZ', 'HUIZU', '回族', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('MZ', 'HZ', '汉族', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('SQLX', 'QS', '起诉', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('SQLX', 'SQZX', '申请执行', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('SQRLX', 'WBRSQ', '为本人申请', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('SQRLX', 'WTRSQ', '为他人申请', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('STATUS', '2', '待提交', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-16 14:13:30', '2018-05-16 14:12:01');
INSERT INTO `sspt_lbbm` VALUES ('STATUS', '3', '待审查', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-16 14:13:35', '2018-05-16 14:12:12');
INSERT INTO `sspt_lbbm` VALUES ('STATUS', '4', '审查通过', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-16 14:13:36', '2018-05-16 14:12:15');
INSERT INTO `sspt_lbbm` VALUES ('STATUS', '5', '审查不通过', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-16 14:14:35', '2018-05-16 14:13:13');
INSERT INTO `sspt_lbbm` VALUES ('ZJLX', 'HZ', '护照', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('ZJLX', 'JGZ', '军官证', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('ZJLX', 'SFZ', '身份证', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('ZY', 'GCJSRYHNLJSRY', '工程技术人员和农林技术人员', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('ZY', 'KXYJRY', '科学研究人员', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('ZZLX', 'SHTYXYDM', '社会统一信用代码', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('ZZLX', 'WU', '无', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');
INSERT INTO `sspt_lbbm` VALUES ('ZZLX', 'ZZJGDM', '组织机构代码', '1', null, '1', null, 'archibald_witwicky', 'archibald_witwicky', '2018-05-14 14:23:55', '2018-05-14 14:23:55');

-- ----------------------------
-- Table structure for sspt_lxfg
-- ----------------------------
DROP TABLE IF EXISTS `sspt_lxfg`;
CREATE TABLE `sspt_lxfg` (
  `id` varchar(32) NOT NULL COMMENT '唯一标识',
  `xm` varchar(10) DEFAULT NULL COMMENT '姓名',
  `sfzhm` varchar(20) DEFAULT NULL COMMENT '身份证号码',
  `sjhm` varchar(20) DEFAULT NULL COMMENT '手机号码',
  `gddh` varchar(20) DEFAULT NULL COMMENT '固定电话',
  `tjfy` varchar(20) DEFAULT NULL COMMENT '提交法院',
  `ah` varchar(20) DEFAULT NULL COMMENT '案号',
  `nr` varchar(255) DEFAULT NULL COMMENT '内容',
  `cxmm` varchar(20) DEFAULT NULL COMMENT '查询密码',
  `qrmm` varchar(20) DEFAULT NULL COMMENT '确认密码',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sspt_lxfg
-- ----------------------------
INSERT INTO `sspt_lxfg` VALUES ('94f3dcac162b4116acb05319bce2877e', '张三', '441881199505017218 ', '17521211444', '17521211444', '天津市第一中级人民法院', '123', '广州杨志煌:男,汉族,1995年5月1日出生,身份证号码:441881199505017218 ,户籍地:广东省清远市英德市青塘镇榔社村委会上新组5号。2011年7月11月0时许,广州市白云区金信路某小区被入室盗窃,事主被盗窃财物价值约40万。经查,杨志煌有重大犯罪嫌疑。', '111111', '111111', '2018-05-08 14:19:40', '2018-05-08 14:19:41', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_lxfg` VALUES ('af315b51a57d43a8ad9ab8724fa99759', '1', '340322199505037815', '13665629056', '1', null, '11', '1', '111111', '111111', '2018-05-10 09:01:05', '2018-05-10 09:01:05', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_lxfg` VALUES ('b55dfe97c52847f4ac526b50e340ccc8', '1', '340322199505037815', '13665629056', '666', null, '55', '55', '222222', '222222', '2018-05-10 08:54:32', '2018-05-10 08:54:32', 'archibald_witwicky', 'archibald_witwicky');

-- ----------------------------
-- Table structure for sspt_phdy
-- ----------------------------
DROP TABLE IF EXISTS `sspt_phdy`;
CREATE TABLE `sspt_phdy` (
  `phdy_id` varchar(32) NOT NULL COMMENT '判后答疑id',
  `lfr` varchar(255) CHARACTER SET utf8 COLLATE utf8_unicode_ci DEFAULT NULL COMMENT '来访人',
  `sjhm` varchar(11) DEFAULT NULL COMMENT '手机号码',
  `dh` varchar(20) DEFAULT NULL COMMENT '电话',
  `zz` varchar(200) DEFAULT NULL COMMENT '住址',
  `sqr` varchar(10) DEFAULT NULL COMMENT '申请人',
  `ah` varchar(100) DEFAULT NULL COMMENT '案号',
  `sxrq` date DEFAULT NULL COMMENT '生效日期',
  `jtwt` text COMMENT '具体问题',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `crt_user` varchar(255) DEFAULT NULL COMMENT '创建人',
  `upd_tm` datetime DEFAULT NULL COMMENT '修改时间',
  `upd_user` varchar(255) DEFAULT NULL COMMENT '修改人',
  `zt` int(11) DEFAULT '1' COMMENT '状态 1 待审查 2 审查通过 3审查不通过',
  `sqsj` datetime DEFAULT NULL COMMENT '申请时间',
  `clsj` datetime DEFAULT NULL COMMENT '处理时间',
  `sqrid` varchar(255) DEFAULT NULL COMMENT '申请人id',
  `ndh` varchar(255) DEFAULT NULL COMMENT '年度号',
  `zh` varchar(255) DEFAULT NULL COMMENT '字号',
  `saxh` varchar(255) DEFAULT NULL COMMENT '收案序号',
  PRIMARY KEY (`phdy_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sspt_phdy
-- ----------------------------
INSERT INTO `sspt_phdy` VALUES ('24be206815bd464e8eefc3da30fa4d03', '23', '13033333333', '23', '232', 'hf', '3232沪民初字第323号', '2018-05-16', '具体问题', '2018-05-16 12:01:08', 'hf', '2018-05-17 10:54:40', '麻子', '1', '2018-05-17 10:54:40', null, 'fdertd1585094dc1a10fe15aef265d58', '3232', '沪民初', '323');
INSERT INTO `sspt_phdy` VALUES ('54d217fe11354901b32b09186291aca4', '来访人', '13033333333', '22', '22', 'hf', '222沪民初字第22号', '2018-05-16', '你好啊', '2018-05-16 20:23:24', 'hf', '2018-05-17 09:06:00', 'hf', '1', '2018-05-17 09:06:00', null, 'fdertd1585094dc1a10fe15aef265d58', '222', '沪民初', '22');
INSERT INTO `sspt_phdy` VALUES ('b83db9f8fced4c7ca2ca963607458735', '23', '13033333333', '23', '232', 'hf', '3232沪民初字第323号', '2018-05-16', '具体问题', '2018-05-16 12:01:09', 'hf', '2018-05-16 12:01:09', 'hf', '1', '2018-05-16 12:01:09', null, 'fdertd1585094dc1a10fe15aef265d58', '3232', '沪民初', '323');
INSERT INTO `sspt_phdy` VALUES ('b85c1661cd4b45a6b78904afa3191b68', '23', '13033333333', '23', '232', 'hf', '3232沪民初字第323号', '2018-05-16', '具体问题', '2018-05-16 12:01:09', 'hf', '2018-05-16 12:01:09', 'hf', '1', '2018-05-16 12:01:09', null, 'fdertd1585094dc1a10fe15aef265d58', '3232', '沪民初', '323');
INSERT INTO `sspt_phdy` VALUES ('c995b711a40946b0b1f3dd6264229c3a', '23', '13033333333', '23', '232', 'hf', '3232沪民初字第323号', '2018-05-16', '具体问题', '2018-05-16 12:01:05', 'hf', '2018-05-16 20:25:24', 'hf', '1', '2018-05-16 20:25:24', null, 'fdertd1585094dc1a10fe15aef265d58', '3232', '沪民初', '323');
INSERT INTO `sspt_phdy` VALUES ('d0c5429db8394439a62dd25e54d19eac', '23', '13033333333', '23', '232', 'hf', '3232沪民初字第323号', '2018-05-16', '具体问题', '2018-05-16 12:01:07', 'hf', '2018-05-16 12:01:07', 'hf', '1', '2018-05-16 12:01:07', null, 'fdertd1585094dc1a10fe15aef265d58', '3232', '沪民初', '323');
INSERT INTO `sspt_phdy` VALUES ('d377ec62d2424e53b3708110395ac7bb', '23', '13033333333', '23', '232', 'hf', '3232沪民初字第323号', '2018-05-16', '具体问题', '2018-05-16 12:01:02', 'hf', '2018-05-16 12:01:02', 'hf', '1', '2018-05-16 12:01:02', null, 'fdertd1585094dc1a10fe15aef265d58', '3232', '沪民初', '323');
INSERT INTO `sspt_phdy` VALUES ('d759965346024ac9af4a9113f6e2b747', '23', '13033333333', '23', '232', 'hf', '3232沪民初字第323号', '2018-05-16', '具体问题', '2018-05-16 12:01:08', 'hf', '2018-05-16 12:01:08', 'hf', '1', '2018-05-16 12:01:08', null, 'fdertd1585094dc1a10fe15aef265d58', '3232', '沪民初', '323');

-- ----------------------------
-- Table structure for sspt_phdy_zl
-- ----------------------------
DROP TABLE IF EXISTS `sspt_phdy_zl`;
CREATE TABLE `sspt_phdy_zl` (
  `phdy_zl_id` varchar(32) NOT NULL COMMENT '判后答疑资料id',
  `phdy_id` varchar(32) NOT NULL COMMENT '判后答疑id',
  `url` varchar(255) NOT NULL COMMENT '判后答疑资料路径',
  `crt_tm` datetime NOT NULL COMMENT '创建时间',
  `crt_user` varchar(255) NOT NULL COMMENT '创建人',
  `upd_tm` datetime NOT NULL COMMENT '修改时间',
  `upd_user` varchar(255) NOT NULL COMMENT '修改人',
  `zl_name` varchar(255) DEFAULT NULL COMMENT '资料名字',
  PRIMARY KEY (`phdy_zl_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sspt_phdy_zl
-- ----------------------------
INSERT INTO `sspt_phdy_zl` VALUES ('02ddedcf9b444e43a59580049a0a6cfd', '865ab1ff9c3c4694a1e7646738a3c2a3', '20180516/0bc16236d13c433ea7a6004e2eb5cbd1.jpg', '2018-05-16 12:01:11', 'hf', '2018-05-16 12:01:11', 'hf', 'jens-johnsson-346357-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('04f01108a9fc46bcb987718825e5f59e', 'c995b711a40946b0b1f3dd6264229c3a', '20180516/cc2243f0fc59477d9e587dd752376222.jpg', '2018-05-16 20:24:58', 'hf', '2018-05-16 20:24:58', 'hf', 'dan-aragon-387276-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('068b5100f8e9448588f191be25dee2ee', '24be206815bd464e8eefc3da30fa4d03', '20180516/93b77cab9f2449fea9d9b96f4e825553.jpg', '2018-05-16 12:01:08', 'hf', '2018-05-16 12:01:08', 'hf', 'matthew-brodeur-113968-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('06f5753259924279bf7304db343c7bd3', 'c995b711a40946b0b1f3dd6264229c3a', '20180516/61ddd557046343aebc8e543b06ec6f95.jpg', '2018-05-16 20:24:58', 'hf', '2018-05-16 20:24:58', 'hf', 'chuttersnap-135791-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('07a1bd13a19e44f9a9ce65ce2e797dd3', '24be206815bd464e8eefc3da30fa4d03', '20180516/67e555c41d0f4577b02ddabeab531641.jpg', '2018-05-16 12:08:53', 'hf', '2018-05-16 12:08:53', 'hf', 'card.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('07c4ab12b8954776b2f9be58abd4c4ef', '865ab1ff9c3c4694a1e7646738a3c2a3', '20180516/2d639f769e6648a2925686e8da5ffe71.jpg', '2018-05-16 12:01:11', 'hf', '2018-05-16 12:01:11', 'hf', 'koushik-chowdavarapu-108156-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('081994fd82e549a7ae7b08caabc9adb1', 'c995b711a40946b0b1f3dd6264229c3a', '20180516/b71060e46a9f46bca47a0ba25968f630.jpg', '2018-05-16 20:24:58', 'hf', '2018-05-16 20:24:58', 'hf', 'francisco-de-legarreta-403274-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('09cb5b38db4d4fecaa86de1bf2b1ad6c', '94c4217557ac4d0da86404891289c23b', '20180516/dfe23899956945e6a010faaf2b12833e.jpg', '2018-05-16 20:15:35', 'hf', '2018-05-16 20:15:35', 'hf', 'dan-aragon-387276-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('0a0318cffe6c4113b850335779862d9a', 'c995b711a40946b0b1f3dd6264229c3a', '20180516/93b77cab9f2449fea9d9b96f4e825553.jpg', '2018-05-16 12:01:05', 'hf', '2018-05-16 12:01:05', 'hf', 'matthew-brodeur-113968-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('0ac63d74f1bb4a5ab5b236b8005e2f23', 'c995b711a40946b0b1f3dd6264229c3a', '20180516/e5c5291940d046b39cbd4a94d8c4d0cc.jpg', '2018-05-16 20:25:24', 'hf', '2018-05-16 20:25:24', 'hf', 'photo-1419064642531-e575728395f2.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('0f27cb86f7f24dd0ab01e90ae34af947', '7a9efebf38f646d882b75cbf29202662', '20180516/05eb9f804b7641d393454299ace71404.jpg', '2018-05-16 20:23:13', 'hf', '2018-05-16 20:23:13', 'hf', 'hoach-le-dinh-111019-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('1081c65cc329483d9eb4884ea73ddd53', 'b83db9f8fced4c7ca2ca963607458735', '20180516/0bc16236d13c433ea7a6004e2eb5cbd1.jpg', '2018-05-16 12:01:09', 'hf', '2018-05-16 12:01:09', 'hf', 'jens-johnsson-346357-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('1614279154e444d19426a04be9a7ebc9', '7139b5fdcc644d159d5063d897af337c', '20180516/2d639f769e6648a2925686e8da5ffe71.jpg', '2018-05-16 12:01:10', 'hf', '2018-05-16 12:01:10', 'hf', 'koushik-chowdavarapu-108156-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('18c2b989cfa8415491703215fc58b044', 'd377ec62d2424e53b3708110395ac7bb', '20180516/93b77cab9f2449fea9d9b96f4e825553.jpg', '2018-05-16 12:01:02', 'hf', '2018-05-16 12:01:02', 'hf', 'matthew-brodeur-113968-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('19ddba8e7c734e46b96f0daaa4170528', '4704fccd886c4feb86cfc72f7a0c38c9', '20180516/2d639f769e6648a2925686e8da5ffe71.jpg', '2018-05-16 12:01:05', 'hf', '2018-05-16 12:01:05', 'hf', 'koushik-chowdavarapu-108156-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('1a7f86b1fff246788da26af6491fefd8', '94c4217557ac4d0da86404891289c23b', '20180516/9bea91372d174058859c01fea1bea857.jpg', '2018-05-16 20:15:35', 'hf', '2018-05-16 20:15:35', 'hf', 'jon-flobrant-618-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('1c864b5b46b54dde9ed105f63cc8c592', '94a89046e87546089f0ccf18618e721a', '20180516/0bc16236d13c433ea7a6004e2eb5cbd1.jpg', '2018-05-16 12:01:06', 'hf', '2018-05-16 12:01:06', 'hf', 'jens-johnsson-346357-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('2a469862fac34e1e98c1287b73167ade', 'd0c5429db8394439a62dd25e54d19eac', '20180516/0bc16236d13c433ea7a6004e2eb5cbd1.jpg', '2018-05-16 12:01:07', 'hf', '2018-05-16 12:01:07', 'hf', 'jens-johnsson-346357-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('2dc3a3d4a8bb4264bb27a3f32946b87a', 'c995b711a40946b0b1f3dd6264229c3a', '20180516/9d8cfa78300f46d9b8ea58451fa42234.jpg', '2018-05-16 20:25:24', 'hf', '2018-05-16 20:25:24', 'hf', 'photo-1422513391413-ddd4f2ce3340.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('2f692e1f4af94648bff6ea7c961c68fe', '94c4217557ac4d0da86404891289c23b', '20180516/f2c4bd0756ee446da0a702ab46863dab.jpg', '2018-05-16 20:15:35', 'hf', '2018-05-16 20:15:35', 'hf', 'hanna-schwichtenberg-35441-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('3a8d67600b214d23a5fb80a7e504569d', 'd759965346024ac9af4a9113f6e2b747', '20180516/93b77cab9f2449fea9d9b96f4e825553.jpg', '2018-05-16 12:01:08', 'hf', '2018-05-16 12:01:08', 'hf', 'matthew-brodeur-113968-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('3d7bbf498d7f423bae424d876ae44124', 'a6ac0348db994fb2801645a3acffa0ff', '20180515/776190904b894c5eba41c92b84cbcb97.jpg', '2018-05-15 11:10:07', '创建人', '2018-05-15 11:10:07', '修改人', 'photo-1469594292607-7bd90f8d3ba4.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('3f81f78032934cb7a5ea2debaaca1bc1', 'a69a805cd4a444659a57e67ff44d5d5a', '20180516/0bc16236d13c433ea7a6004e2eb5cbd1.jpg', '2018-05-16 12:01:06', 'hf', '2018-05-16 12:01:06', 'hf', 'jens-johnsson-346357-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('420d9489141a45f9863e04c0aec2cf02', '7a9efebf38f646d882b75cbf29202662', '20180516/f3c8885a8a0a4f339e99bdf546853d67.jpg', '2018-05-16 20:23:13', 'hf', '2018-05-16 20:23:13', 'hf', 'hanna-schwichtenberg-35441-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('42b4ea150aaf4b5bb2b6d725b431c5ed', 'c995b711a40946b0b1f3dd6264229c3a', '20180516/23c7a0873a6a4153b7033b5b7a7e6c75.jpg', '2018-05-16 20:25:25', 'hf', '2018-05-16 20:25:25', 'hf', 'photo-1439761414027-4f4ebeeda3a3.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('4bae78d3c26449cc8a53fbcd8ab1441c', 'd377ec62d2424e53b3708110395ac7bb', '20180516/2d639f769e6648a2925686e8da5ffe71.jpg', '2018-05-16 12:01:02', 'hf', '2018-05-16 12:01:02', 'hf', 'koushik-chowdavarapu-108156-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('4d2a5a34738a48b88c9b695c885564ee', 'c995b711a40946b0b1f3dd6264229c3a', '20180516/2d639f769e6648a2925686e8da5ffe71.jpg', '2018-05-16 12:01:05', 'hf', '2018-05-16 12:01:05', 'hf', 'koushik-chowdavarapu-108156-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('51ea6668c8d74189b226bc23578039b3', '87be0ea0daba4dc48a1dbfcfa830e205', '20180516/0bc16236d13c433ea7a6004e2eb5cbd1.jpg', '2018-05-16 12:01:08', 'hf', '2018-05-16 12:01:08', 'hf', 'jens-johnsson-346357-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('524877296b7945fead56d675b9d65fa8', 'a69a805cd4a444659a57e67ff44d5d5a', '20180516/2d639f769e6648a2925686e8da5ffe71.jpg', '2018-05-16 12:01:06', 'hf', '2018-05-16 12:01:06', 'hf', 'koushik-chowdavarapu-108156-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('5263a7ae478644f2b5a4c23e326ea8c5', '94c4217557ac4d0da86404891289c23b', '20180516/85ff6740d58a42ccaf440c8715b82215.jpg', '2018-05-16 20:15:35', 'hf', '2018-05-16 20:15:35', 'hf', 'francisco-de-legarreta-403274-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('53ee73355d1d44109718c894dadde646', '94c4217557ac4d0da86404891289c23b', '20180516/9fa31eef9be641f092e0a9e583e1c40b.jpg', '2018-05-16 20:15:35', 'hf', '2018-05-16 20:15:35', 'hf', 'jason-wong-351890-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('59b264ffad8946af8ab095e8a09df6a2', 'c995b711a40946b0b1f3dd6264229c3a', '20180516/0bc16236d13c433ea7a6004e2eb5cbd1.jpg', '2018-05-16 12:01:05', 'hf', '2018-05-16 12:01:05', 'hf', 'jens-johnsson-346357-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('59e1ebeb889b48dfbf2af66108496a51', '54d217fe11354901b32b09186291aca4', '20180516/f3c8885a8a0a4f339e99bdf546853d67.jpg', '2018-05-16 20:23:24', 'hf', '2018-05-16 20:23:24', 'hf', 'hanna-schwichtenberg-35441-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('5acf82e54302453f85b76a3323259244', 'd759965346024ac9af4a9113f6e2b747', '20180516/2d639f769e6648a2925686e8da5ffe71.jpg', '2018-05-16 12:01:08', 'hf', '2018-05-16 12:01:08', 'hf', 'koushik-chowdavarapu-108156-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('5c116675ae58464e88f32621c31e92e8', '94c4217557ac4d0da86404891289c23b', '20180516/22e5f4f846fd44698071d6c12c2e2398.jpg', '2018-05-16 20:15:35', 'hf', '2018-05-16 20:15:35', 'hf', 'koushik-chowdavarapu-108156-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('627f167dfff445f7a8308abd14b2ebbe', '94a89046e87546089f0ccf18618e721a', '20180516/93b77cab9f2449fea9d9b96f4e825553.jpg', '2018-05-16 12:01:07', 'hf', '2018-05-16 12:01:07', 'hf', 'matthew-brodeur-113968-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('6593c965d4ed49e8b62158ba52593a90', '94c4217557ac4d0da86404891289c23b', '20180516/abaf114c52d54b38aacf200b180c3065.jpg', '2018-05-16 20:15:35', 'hf', '2018-05-16 20:15:35', 'hf', 'hoach-le-dinh-111019-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('6a390b3887084fb1887fc303596a36bb', 'b85c1661cd4b45a6b78904afa3191b68', '20180516/2d639f769e6648a2925686e8da5ffe71.jpg', '2018-05-16 12:01:09', 'hf', '2018-05-16 12:01:09', 'hf', 'koushik-chowdavarapu-108156-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('6bb64b39ac2b4114b5af136bfcadece5', 'b83db9f8fced4c7ca2ca963607458735', '20180516/93b77cab9f2449fea9d9b96f4e825553.jpg', '2018-05-16 12:01:09', 'hf', '2018-05-16 12:01:09', 'hf', 'matthew-brodeur-113968-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('7afa79a7b09240539961aeb7f009fa9e', 'b83db9f8fced4c7ca2ca963607458735', '20180516/2d639f769e6648a2925686e8da5ffe71.jpg', '2018-05-16 12:01:09', 'hf', '2018-05-16 12:01:09', 'hf', 'koushik-chowdavarapu-108156-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('819b6150844840d1a0cb1d8b255b76cc', '4704fccd886c4feb86cfc72f7a0c38c9', '20180516/93b77cab9f2449fea9d9b96f4e825553.jpg', '2018-05-16 12:01:05', 'hf', '2018-05-16 12:01:05', 'hf', 'matthew-brodeur-113968-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('9115cc22bb204f4f9a6b1862ce16c3a3', '94a89046e87546089f0ccf18618e721a', '20180516/2d639f769e6648a2925686e8da5ffe71.jpg', '2018-05-16 12:01:06', 'hf', '2018-05-16 12:01:06', 'hf', 'koushik-chowdavarapu-108156-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('914972791f984a15bf81c54cb3bb6cee', '87be0ea0daba4dc48a1dbfcfa830e205', '20180516/93b77cab9f2449fea9d9b96f4e825553.jpg', '2018-05-16 12:01:08', 'hf', '2018-05-16 12:01:08', 'hf', 'matthew-brodeur-113968-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('9a6bbaa49ed747b7bb71a0a007ac5204', 'b85c1661cd4b45a6b78904afa3191b68', '20180516/0bc16236d13c433ea7a6004e2eb5cbd1.jpg', '2018-05-16 12:01:09', 'hf', '2018-05-16 12:01:09', 'hf', 'jens-johnsson-346357-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('a179347d9e514cd393df9a78feb14d20', '54d217fe11354901b32b09186291aca4', '20180517/65430974a86d4fc1b0c8fba6e804be5f.jpg', '2018-05-17 09:06:00', 'hf', '2018-05-17 09:06:00', 'hf', 'photo-1471443290059-92acdee54040.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('a37d086763924e6da7065fdaa8def782', '54d217fe11354901b32b09186291aca4', '20180516/d6e50e27db7a4fdcbda6890087137e24.jpg', '2018-05-16 20:23:24', 'hf', '2018-05-16 20:23:24', 'hf', 'ivan-vranic-118234-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('a3a67956359947f1baa8cced67c13b3f', '865ab1ff9c3c4694a1e7646738a3c2a3', '20180516/93b77cab9f2449fea9d9b96f4e825553.jpg', '2018-05-16 12:01:11', 'hf', '2018-05-16 12:01:11', 'hf', 'matthew-brodeur-113968-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('a6bad218b7234c5395b31e914acc355f', '87be0ea0daba4dc48a1dbfcfa830e205', '20180516/2d639f769e6648a2925686e8da5ffe71.jpg', '2018-05-16 12:01:08', 'hf', '2018-05-16 12:01:08', 'hf', 'koushik-chowdavarapu-108156-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('a99dd99140ad4651a720477a3ec8f3ef', '5c5c0b52a2364022ba60daea4fba5100', '20180515/1c0728f843e3455397093edd20301a0f.jpg', '2018-05-15 11:17:40', 'hf', '2018-05-15 11:17:40', 'hf', 'koushik-chowdavarapu-108156-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('aabce63c30ea48fc9f7c7fdb671929ad', 'd377ec62d2424e53b3708110395ac7bb', '20180516/0bc16236d13c433ea7a6004e2eb5cbd1.jpg', '2018-05-16 12:01:02', 'hf', '2018-05-16 12:01:02', 'hf', 'jens-johnsson-346357-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('b223ce11ea0a4ea9a904adf312cf72f8', '7139b5fdcc644d159d5063d897af337c', '20180516/93b77cab9f2449fea9d9b96f4e825553.jpg', '2018-05-16 12:01:10', 'hf', '2018-05-16 12:01:10', 'hf', 'matthew-brodeur-113968-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('b263ea8e8536456d8cb9a0758d1f3996', 'd759965346024ac9af4a9113f6e2b747', '20180516/0bc16236d13c433ea7a6004e2eb5cbd1.jpg', '2018-05-16 12:01:08', 'hf', '2018-05-16 12:01:08', 'hf', 'jens-johnsson-346357-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('b5c4a58f55ad4f4690ef7911c100534a', '4704fccd886c4feb86cfc72f7a0c38c9', '20180516/0618d3ee96644ca38d2a91e3c90171aa.jpg', '2018-05-16 12:02:26', 'hf', '2018-05-16 12:02:26', 'hf', 'thomas-pierre-26149-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('be14f1b17466446a83c878d47fa457e9', '752d852b29234a9d8a058fd3ac394994', '20180516/2d639f769e6648a2925686e8da5ffe71.jpg', '2018-05-16 12:01:10', 'hf', '2018-05-16 12:01:10', 'hf', 'koushik-chowdavarapu-108156-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('c2d322ba687e46fcad7d77252bd6286d', 'a69a805cd4a444659a57e67ff44d5d5a', '20180516/93b77cab9f2449fea9d9b96f4e825553.jpg', '2018-05-16 12:01:06', 'hf', '2018-05-16 12:01:06', 'hf', 'matthew-brodeur-113968-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('c46c0fbcbca843628d11fbb0d17a32cc', '54d217fe11354901b32b09186291aca4', '20180516/05eb9f804b7641d393454299ace71404.jpg', '2018-05-16 20:23:24', 'hf', '2018-05-16 20:23:24', 'hf', 'hoach-le-dinh-111019-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('c5e7137ba7b249dbb80412b508af2521', 'd0c5429db8394439a62dd25e54d19eac', '20180516/2d639f769e6648a2925686e8da5ffe71.jpg', '2018-05-16 12:01:07', 'hf', '2018-05-16 12:01:07', 'hf', 'koushik-chowdavarapu-108156-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('c8126c8795fe42b28920b86c4c98740d', '7139b5fdcc644d159d5063d897af337c', '20180516/0bc16236d13c433ea7a6004e2eb5cbd1.jpg', '2018-05-16 12:01:10', 'hf', '2018-05-16 12:01:10', 'hf', 'jens-johnsson-346357-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('d1b81b548a804cc9ba138e829f14f45b', '4704fccd886c4feb86cfc72f7a0c38c9', '20180516/0bc16236d13c433ea7a6004e2eb5cbd1.jpg', '2018-05-16 12:01:05', 'hf', '2018-05-16 12:01:05', 'hf', 'jens-johnsson-346357-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('d1c3cef330d14893a0b2b0201c7c9b49', '5c5c0b52a2364022ba60daea4fba5100', '20180515/772f597dec5d4f6ba7ea3e3909954ded.jpg', '2018-05-15 11:17:40', 'hf', '2018-05-15 11:17:40', 'hf', 'jens-johnsson-346357-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('d287c222721a4bdca59dc44a3757f8f0', 'd0c5429db8394439a62dd25e54d19eac', '20180516/93b77cab9f2449fea9d9b96f4e825553.jpg', '2018-05-16 12:01:07', 'hf', '2018-05-16 12:01:07', 'hf', 'matthew-brodeur-113968-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('d9a18dfdf4c045c8aa8d85bfeca39fb1', 'c995b711a40946b0b1f3dd6264229c3a', '20180516/358b5c56314d44a8987f203cfb018a46.jpg', '2018-05-16 20:24:58', 'hf', '2018-05-16 20:24:58', 'hf', 'hanna-schwichtenberg-35441-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('dd07b20940484652819f77fd39ee4940', '4704fccd886c4feb86cfc72f7a0c38c9', '20180516/73a8d7aec81d438ab91fcc4d9fdd1e34.jpg', '2018-05-16 12:02:26', 'hf', '2018-05-16 12:02:26', 'hf', 'thought-catalog-354861-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('ea83ba9954994ac1858e76d6581db041', '7a9efebf38f646d882b75cbf29202662', '20180516/d6e50e27db7a4fdcbda6890087137e24.jpg', '2018-05-16 20:23:13', 'hf', '2018-05-16 20:23:13', 'hf', 'ivan-vranic-118234-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('efb3cea9159e4920b8552c432ffbeb51', '54d217fe11354901b32b09186291aca4', '20180517/2236ca5c196a48b7bc7577512a5c8ebf.jpg', '2018-05-17 09:06:00', 'hf', '2018-05-17 09:06:00', 'hf', 'hoach-le-dinh-111019-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('f2f3bbb0f823431c98a3dabd3f96e6e8', '94c4217557ac4d0da86404891289c23b', '20180516/ab7f063ce54d4c8ebf2d6f3f7ea53d64.jpg', '2018-05-16 20:15:35', 'hf', '2018-05-16 20:15:35', 'hf', 'jens-johnsson-346357-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('f77f2b574f9e4112b7765e6d9e1850d5', '752d852b29234a9d8a058fd3ac394994', '20180516/0bc16236d13c433ea7a6004e2eb5cbd1.jpg', '2018-05-16 12:01:10', 'hf', '2018-05-16 12:01:10', 'hf', 'jens-johnsson-346357-unsplash.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('fd1c4d4db5b3471582477c4df58afc32', 'c995b711a40946b0b1f3dd6264229c3a', '20180516/729a858e19c644529dc106ee6792609a.jpg', '2018-05-16 20:25:25', 'hf', '2018-05-16 20:25:25', 'hf', 'photo-1433354359170-23a4ae7338c6.jpg');
INSERT INTO `sspt_phdy_zl` VALUES ('ff4442a3bf6343149e861f79adb14ae1', '752d852b29234a9d8a058fd3ac394994', '20180516/93b77cab9f2449fea9d9b96f4e825553.jpg', '2018-05-16 12:01:10', 'hf', '2018-05-16 12:01:10', 'hf', 'matthew-brodeur-113968-unsplash.jpg');

-- ----------------------------
-- Table structure for sspt_ptyy
-- ----------------------------
DROP TABLE IF EXISTS `sspt_ptyy`;
CREATE TABLE `sspt_ptyy` (
  `id` varchar(32) NOT NULL COMMENT '旁听预约ID',
  `yhid` varchar(32) NOT NULL COMMENT '用户id',
  `ajid` varchar(32) DEFAULT NULL COMMENT '案件id',
  `ah` varchar(32) NOT NULL COMMENT '案号',
  `sqrxm` varchar(32) DEFAULT NULL COMMENT '申请人姓名',
  `sqrzjh` varchar(32) DEFAULT NULL COMMENT '申请人证件号',
  `ktsj` varchar(32) DEFAULT NULL COMMENT '开庭时间',
  `ycagx` varchar(32) DEFAULT NULL COMMENT '与此案关系',
  `sjhm` varchar(32) DEFAULT NULL COMMENT '手机号码',
  `lybt` varchar(32) DEFAULT NULL COMMENT '留言标题',
  `nr` varchar(500) DEFAULT NULL COMMENT '内容',
  `yyzt` varchar(32) DEFAULT NULL COMMENT '预约状态:0处理中,1预约成功,2预约失败',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='旁听预约';

-- ----------------------------
-- Records of sspt_ptyy
-- ----------------------------
INSERT INTO `sspt_ptyy` VALUES ('08f7c6e8f07a4c76b12303ac6e609120', 'fdertd1585094dc1a10fe15aef265d58', null, '(2018)京01民终3126号', '1', '1', '2018-05-22 23:46:40', 'dsf', '1', '1', '1', '0', '2018-05-16 10:08:25', '2018-05-16 10:08:25', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ptyy` VALUES ('0a01d7d421124dd9bbda50a828eec7f6', 'fdertd1585094dc1a10fe15aef265d58', null, '(2018)京01民特78号', '2', '2', '2018-05-22 23:46:40', 'qs', '2', '2', '2', '0', '2018-05-16 10:44:50', '2018-05-16 10:44:50', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ptyy` VALUES ('1618c9e013b94309b10cba4425e93201', 'fdertd1585094dc1a10fe15aef265d58', null, '(2018)京01民特78号', '2', '2', '2018-05-22 23:46:40', 'qs', '2', '2', '2', '0', '2018-05-16 10:44:54', '2018-05-16 10:44:54', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ptyy` VALUES ('263d98ce57174360a1d1c02a79404835', 'fdertd1585094dc1a10fe15aef265d58', null, '1', '1', '1', '2018-05-15', 'dsf', '1', '1', '1', '0', '2018-05-15 20:18:27', '2018-05-15 20:18:27', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ptyy` VALUES ('400b0fd9ca0e4fbf8540c185bdbc4cfe', 'fdertd1585094dc1a10fe15aef265d58', null, '(2018)京01民终4398号', '1', '1', '2018-05-22 23:46:40', 'dsf', '1', '1', '1', '0', '2018-05-16 20:30:55', '2018-05-16 20:30:55', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ptyy` VALUES ('4cb714ce71744dea85485b41cd5f6ac2', 'fdertd1585094dc1a10fe15aef265d58', null, '(2018)京01民终3126号', '1', '1', '2018-05-22 23:46:40', 'dsf', '1', '1', '1', '0', '2018-05-16 10:08:32', '2018-05-16 10:08:32', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ptyy` VALUES ('646fbfa7d56b43e6b9ae0ec9633a5045', 'fdertd1585094dc1a10fe15aef265d58', null, '(2018)京01民终3126号', '1', '1', '2018-05-22 23:46:40', 'dsf', '1', '1', '1', '0', '2018-05-16 10:08:28', '2018-05-16 10:08:28', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ptyy` VALUES ('7c499a08b2394d71b5bc49372a914ed1', 'fdertd1585094dc1a10fe15aef265d58', null, '(2018)京01民终3126号', '1', '1', '2018-05-22 23:46:40', 'dsf', '1', '1', '1', '0', '2018-05-16 10:08:33', '2018-05-16 10:08:33', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ptyy` VALUES ('7dda3ac95a204e70b7cfc2cb58054f82', 'fdertd1585094dc1a10fe15aef265d58', null, '(2018)京01民特78号', '1', '1', '2018-05-22 23:46:40', 'dsf', '1', '1', '1', '0', '2018-05-16 20:32:29', '2018-05-16 20:32:29', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ptyy` VALUES ('83b745ceffec456c8a96a7f4877632b3', 'fdertd1585094dc1a10fe15aef265d58', null, '(2018)京01民终3126号', '1', '1', '2018-05-22 23:46:40', 'dsf', '1', '1', '1', '0', '2018-05-16 10:08:23', '2018-05-16 10:08:23', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ptyy` VALUES ('9bc7e8845de8493caab8539d7a95a080', 'fdertd1585094dc1a10fe15aef265d58', null, '(2018)京01民终3126号', '1', '1', '2018-05-22 23:46:40', 'dsf', '1', '1', '1', '0', '2018-05-16 10:08:30', '2018-05-16 10:08:30', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ptyy` VALUES ('b4ff5f111aee4b8d90219144482eaa50', 'fdertd1585094dc1a10fe15aef265d58', null, '(2018)京01民终4398号', '1', '1', '2018-05-22 23:46:40', 'dsf', '1', '1', '1', '0', '2018-05-16 20:31:02', '2018-05-16 20:31:02', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ptyy` VALUES ('f8c9809fd95f41dca0f77f24b091804e', 'fdertd1585094dc1a10fe15aef265d58', null, '(2018)京01民特78号', '2', '2', '2018-05-22 23:46:40', 'qs', '2', '2', '2', '0', '2018-05-16 10:44:51', '2018-05-16 10:44:51', 'archibald_witwicky', 'archibald_witwicky');

-- ----------------------------
-- Table structure for sspt_qsz
-- ----------------------------
DROP TABLE IF EXISTS `sspt_qsz`;
CREATE TABLE `sspt_qsz` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `ajid` varchar(32) DEFAULT NULL COMMENT '案件id',
  `clmc` varchar(255) DEFAULT NULL COMMENT '材料名称({原告}诉讼{被告}的起诉状)',
  `ssr` varchar(255) DEFAULT NULL COMMENT '所属人(所选择的原告)',
  `wjmc` varchar(255) DEFAULT NULL COMMENT '文件名称(md5/sha加密)',
  `wjlj` varchar(255) DEFAULT NULL COMMENT '文件路径',
  `ygbh` varchar(255) DEFAULT NULL COMMENT '原告编号(多个使用,分割)',
  `bgbh` varchar(255) DEFAULT NULL COMMENT '被告编号(多个使用,分割)',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='起诉状';

-- ----------------------------
-- Records of sspt_qsz
-- ----------------------------
INSERT INTO `sspt_qsz` VALUES ('11', '039f87680ef64762bd5e05cd62310b58', '{张三,李四}诉讼{王五}的起诉状', '张三,李四', '猫咪.jpg', '20180507/d37e57e45d9c48298001812fb5ef8e94.jpg', '张三,李四', '王五', '2018-05-07 11:30:28', null, null, null);
INSERT INTO `sspt_qsz` VALUES ('3ebd5b76dad14f4e9154338b3dab1d17', 'eeb2158afc904e9e818c1b1ca388466e', '{张三}诉讼{王五}的起诉状', '张三', 'benjamin-child-19747-unsplash.jpg', '20180507/50beb8d0bdef4e2faacf3930b3968e4d.jpg', '张三', '王五', '2018-05-07 13:44:27', '2018-05-07 13:44:27', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_qsz` VALUES ('5d21960354e34a82be4211e425709df7', '5d923fa8dd1c4383bb38c59a32105678', '{张三}诉讼{王五}的起诉状', '张三', 'Desert.jpg', '20180514/de10fdd48d2045ebbe460c0bbc17f08a.jpg', '张三', '王五', '2018-05-14 11:36:33', '2018-05-14 11:36:33', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_qsz` VALUES ('99e5e42d8dbd4c2ca2537b00343c46f3', 'd975d5cfa31a4ce4b28cf76e56917499', '{张三,李四}诉讼{王五}的起诉状', '张三,李四', 'jason-wong-351890-unsplash - 副本.jpg', '20180509/394b2849dd9844eda7712ed7f812cd46.jpg', '张三,李四', '王五', '2018-05-09 17:12:03', '2018-05-09 17:12:03', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_qsz` VALUES ('9d1b6d18f535488fb98540d3f9f18ac3', 'b322fc3b462747988cc85870681b822b', '{张三,李四}诉讼{王五}的起诉状', '张三,李四', '证件类材料关系映射.txt', '20180507/1fd5a81dfe614be79d9fa7b7bb43ed8a.txt', '张三,李四', '王五', '2018-05-07 11:01:01', '2018-05-07 11:01:01', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_qsz` VALUES ('eb14f747620e4560ae853d50e77a2917', 'b322fc3b462747988cc85870681b822b', '{张三,李四}诉讼{王五}的起诉状', '张三,李四', '猫咪.jpg', '20180507/d37e57e45d9c48298001812fb5ef8e94.jpg', '张三,李四', '王五', '2018-05-07 10:47:17', '2018-05-07 10:47:17', 'archibald_witwicky', 'archibald_witwicky');

-- ----------------------------
-- Table structure for sspt_qtcl
-- ----------------------------
DROP TABLE IF EXISTS `sspt_qtcl`;
CREATE TABLE `sspt_qtcl` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `ajid` varchar(32) DEFAULT NULL COMMENT '案件id',
  `clmc` varchar(255) DEFAULT NULL COMMENT '材料名称({原告}诉讼{被告}的起诉状)',
  `ssr` varchar(255) DEFAULT NULL COMMENT '所属人(所选择的原告)',
  `wjmc` varchar(255) DEFAULT NULL COMMENT '文件名称(md5/sha加密)',
  `wjlj` varchar(255) DEFAULT NULL COMMENT '文件路径',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='其他材料';

-- ----------------------------
-- Records of sspt_qtcl
-- ----------------------------
INSERT INTO `sspt_qtcl` VALUES ('11111', '039f87680ef64762bd5e05cd62310b58', '121', '2121', '21211', null, '2018-05-05 17:52:22', '2018-05-05 17:52:24', null, null);
INSERT INTO `sspt_qtcl` VALUES ('ab2b98510c6b4027b4357d9194ad535e', '46826d1585094dc1a10fe15aef265d58', '证件类', '哈哈', 'banner_buttom.jpg', '20180504/cd1e7dd7e77541c8b69f78ac7511e3c2.jpg', '2018-05-04 11:30:53', '2018-05-04 11:30:53', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_qtcl` VALUES ('c4c33dee0ace4e9dbfbafdcaa0292d82', '46826d1585094dc1a10fe15aef265d58', '证件类', '哈哈', 'banner_top.jpg', '20180504/a36863b3566144949f5a003d12419b5c.jpg', '2018-05-04 11:30:53', '2018-05-04 11:30:53', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_qtcl` VALUES ('cf49575738f9417594d58db78449e325', '46826d1585094dc1a10fe15aef265d58', '证件类', '哈哈', 'banner_top2.jpg', '20180504/3ab39c23a7b244b18078d14e1c65175a.jpg', '2018-05-04 11:30:53', '2018-05-04 11:30:53', 'archibald_witwicky', 'archibald_witwicky');

-- ----------------------------
-- Table structure for sspt_sddzqrs
-- ----------------------------
DROP TABLE IF EXISTS `sspt_sddzqrs`;
CREATE TABLE `sspt_sddzqrs` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `ajid` varchar(32) DEFAULT NULL COMMENT '案件id',
  `clmc` varchar(255) DEFAULT NULL COMMENT '材料名称(送达地址确认书{原告})',
  `sjr` varchar(255) DEFAULT NULL COMMENT '收件人',
  `wjmc` varchar(255) DEFAULT NULL COMMENT '文件名称(md5/sha加密)',
  `wjlj` varchar(255) DEFAULT NULL COMMENT '文件路径',
  `sddz` varchar(255) DEFAULT NULL COMMENT '送达地址',
  `sjryddh` varchar(20) DEFAULT NULL COMMENT '收件人移动电话',
  `yb` varchar(20) DEFAULT NULL COMMENT '邮编',
  `yx` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='送达地址确认书';

-- ----------------------------
-- Records of sspt_sddzqrs
-- ----------------------------
INSERT INTO `sspt_sddzqrs` VALUES ('1', '039f87680ef64762bd5e05cd62310b58', '2', '2', '2', '2', '2', '2', '2', '2', '2018-05-07 11:33:25', '2018-05-07 11:33:27', null, null);

-- ----------------------------
-- Table structure for sspt_sqr
-- ----------------------------
DROP TABLE IF EXISTS `sspt_sqr`;
CREATE TABLE `sspt_sqr` (
  `id` int(11) NOT NULL COMMENT 'id',
  `sqrxm` varchar(255) DEFAULT NULL COMMENT '申请人姓名',
  `sjhm` int(11) DEFAULT NULL COMMENT '手机号码',
  `zjlx` varchar(255) DEFAULT NULL COMMENT '证件类型',
  `smqk` varchar(255) DEFAULT NULL COMMENT '实名认证情况',
  `sqrlx` varchar(255) DEFAULT NULL COMMENT '申请人类型',
  `zjhm` varchar(255) DEFAULT NULL COMMENT '证件号码',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='申请人';

-- ----------------------------
-- Records of sspt_sqr
-- ----------------------------

-- ----------------------------
-- Table structure for sspt_wsyj
-- ----------------------------
DROP TABLE IF EXISTS `sspt_wsyj`;
CREATE TABLE `sspt_wsyj` (
  `id` varchar(32) NOT NULL COMMENT '主键ID',
  `userid` varchar(32) DEFAULT NULL,
  `yjfy` varchar(255) DEFAULT NULL COMMENT '阅卷法院',
  `ahType` varchar(255) DEFAULT NULL COMMENT '案号类型',
  `ah` varchar(255) DEFAULT NULL COMMENT '案号',
  `sqrxm` varchar(255) DEFAULT NULL COMMENT '申请人姓名',
  `sqrsf` varchar(255) DEFAULT NULL COMMENT '申请人身份',
  `sqrzjlx` varchar(255) DEFAULT NULL COMMENT '申请人证件类型',
  `sqrzjhm` varchar(255) DEFAULT NULL COMMENT '申请人证件号码',
  `sjhm` varchar(255) DEFAULT NULL COMMENT '手机号码',
  `sqyt` varchar(255) DEFAULT NULL COMMENT '申请用途',
  `qtytbz` varchar(255) DEFAULT NULL COMMENT '其他用途补充',
  `bcsm` varchar(255) DEFAULT NULL COMMENT '补充说明',
  `cllb` varchar(255) DEFAULT NULL COMMENT '材料类别',
  `wjm` varchar(255) DEFAULT NULL COMMENT '文件名',
  `scrq` datetime DEFAULT NULL COMMENT '上传日期',
  `status` varchar(5) DEFAULT NULL,
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of sspt_wsyj
-- ----------------------------
INSERT INTO `sspt_wsyj` VALUES ('1b33c846338543cfbd9e08d8eb578f01', 'fdertd1585094dc1a10fe15aef265d58', 'sdfbb136e5a74b168bddaf747eeacc34', '选择已有案号', '8008208820', '麻子', '律师', '1', '412725199407270019', '13033333333', '商业', '阿范德萨', '你是猪吗', null, null, null, '2', '2018-05-17 10:54:17', '2018-05-17 10:58:32', '麻子', '麻子');
INSERT INTO `sspt_wsyj` VALUES ('2fb4bcaea76e44fe8630fa677052d9a0', 'fdertd1585094dc1a10fe15aef265d58', 'dfgbb136e5a74b168bddaf747eeacc34', '选择已有案号', '8008208820', '赵六', '律师', '身份证', '4302221145121112', '17521211444', '商业', '阿范德萨', 'safas', null, null, null, '3', '2018-05-16 10:20:26', '2018-05-17 09:56:28', 'hf', 'hf');
INSERT INTO `sspt_wsyj` VALUES ('2fb4bcaea76e44fe8630fa677052d9a1', 'fdertd1585094dc1a10fe15aef265d58', 'dfgbb136e5a74b168bddaf747eeacc34', '选择已有案号', '8008208820', '张三', '律师', '身份证', '4302221145121112', '17521211444', '商业', '阿范德萨', 'safas', null, null, null, '3', '2018-05-16 10:20:26', '2018-05-16 10:20:26', 'hf', 'hf');
INSERT INTO `sspt_wsyj` VALUES ('2fb4bcaea76e44fe8630fa677052d9a2', 'fdertd1585094dc1a10fe15aef265d58', 'dfgbb136e5a74b168bddaf747eeacc34', '选择已有案号', '8008208820', '张三', '律师', '身份证', '4302221145121112', '17521211444', '商业', '阿范德萨', 'safas', null, null, null, '3', '2018-05-16 10:20:26', '2018-05-16 10:20:26', 'hf', 'hf');
INSERT INTO `sspt_wsyj` VALUES ('2fb4bcaea76e44fe8630fa677052d9a3', 'fdertd1585094dc1a10fe15aef265d58', 'dfgbb136e5a74b168bddaf747eeacc34', '选择已有案号', '8008208820', '张三', '律师', '身份证', '4302221145121112', '17521211444', '商业', '阿范德萨', 'safas', null, null, null, '3', '2018-05-16 10:20:26', '2018-05-16 10:20:26', 'hf', 'hf');
INSERT INTO `sspt_wsyj` VALUES ('2fb4bcaea76e44fe8630fa677052d9a4', 'fdertd1585094dc1a10fe15aef265d58', 'dfgbb136e5a74b168bddaf747eeacc34', '选择已有案号', '8008208820', '张三', '律师', '身份证', '4302221145121112', '17521211444', '商业', '阿范德萨', 'safas', null, null, null, '3', '2018-05-16 10:20:26', '2018-05-16 10:20:26', 'hf', 'hf');
INSERT INTO `sspt_wsyj` VALUES ('2fb4bcaea76e44fe8630fa677052d9a5', 'fdertd1585094dc1a10fe15aef265d58', 'dfgbb136e5a74b168bddaf747eeacc34', '选择已有案号', '8008208820', '张三', '律师', '身份证', '4302221145121112', '17521211444', '商业', '阿范德萨', 'safas', null, null, null, '3', '2018-05-16 10:20:26', '2018-05-16 10:20:26', 'hf', 'hf');
INSERT INTO `sspt_wsyj` VALUES ('2fb4bcaea76e44fe8630fa677052d9a6', 'fdertd1585094dc1a10fe15aef265d58', 'dfgbb136e5a74b168bddaf747eeacc34', '选择已有案号', '8008208820', '张三', '律师', '身份证', '4302221145121112', '17521211444', '商业', '阿范德萨', 'safas', null, null, null, '3', '2018-05-16 10:20:26', '2018-05-16 10:20:26', 'hf', 'hf');
INSERT INTO `sspt_wsyj` VALUES ('2fb4bcaea76e44fe8630fa677052d9a8', 'fdertd1585094dc1a10fe15aef265d58', 'dfgbb136e5a74b168bddaf747eeacc34', '选择已有案号', '8008208820', '张三', '律师', '身份证', '4302221145121112', '17521211444', '商业', '阿范德萨', 'safas', null, null, null, '3', '2018-05-16 10:20:26', '2018-05-16 10:20:26', 'hf', 'hf');
INSERT INTO `sspt_wsyj` VALUES ('328db0a2fd6d480595b1de62c27c8b4a', '151c3878f5d84f389d6bebfdb4db5236', 'dfgbb136e5a74b168bddaf747eeacc34', '手动输入案号', '852', '张三', '律师', '身份证', '4302221145121112', '17521211444', '商业', '阿范德萨', '双方的感受到', null, null, null, '2', '2018-05-15 11:43:08', '2018-05-15 11:43:08', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_wsyj` VALUES ('5e33e27101b94b62aee0e616daee4ddb', 'fdertd1585094dc1a10fe15aef265d58', 'bvfbb136e5a74b168bddaf747eeacc34', '选择已有案号', '8008208820', '麻子', '法人', '1', '412725199407270019', '13033333333', '商业', '阿范德萨', '还不出来吗', null, null, null, null, '2018-05-17 11:02:34', '2018-05-17 11:02:34', '麻子', '麻子');
INSERT INTO `sspt_wsyj` VALUES ('857b35dddd004a59bdf70c2ef7e8e9ed', 'fdertd1585094dc1a10fe15aef265d58', 'dfgbb136e5a74b168bddaf747eeacc34', '选择已有案号', '8008208820', '麻子', '律师', '1', '412725199407270019', '13033333333', '商业', '阿范德萨', '你真的是猪吗', null, null, null, null, '2018-05-17 10:59:55', '2018-05-17 10:59:55', '麻子', '麻子');
INSERT INTO `sspt_wsyj` VALUES ('c11eac6140fa425d9e1e61336dd78193', '151c3878f5d84f389d6bebfdb4db5236', 'dfgbb136e5a74b168bddaf747eeacc34', '手动输入案号', '1234', '张三', '律师', '身份证', '4302221145121112', '17521211444', '商业', '阿范德萨', '暗示法撒旦', null, null, null, '2', '2018-05-15 11:39:25', '2018-05-15 11:39:28', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_wsyj` VALUES ('e3e86451834e46ed8ae3b8732b720dcd', 'fdertd1585094dc1a10fe15aef265d58', 'dfgbb136e5a74b168bddaf747eeacc34', '选择已有案号', '8008208820', '张三', '律师', '身份证', '4302221145121112', '17521211444', '商业', '阿范德萨', 'bghsdgds', null, null, null, '3', '2018-05-16 10:04:35', '2018-05-16 10:04:35', 'archibald_witwicky', 'archibald_witwicky');

-- ----------------------------
-- Table structure for sspt_yg
-- ----------------------------
DROP TABLE IF EXISTS `sspt_yg`;
CREATE TABLE `sspt_yg` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `ajid` varchar(32) DEFAULT NULL COMMENT '案件id',
  `ssdlr` varchar(255) DEFAULT NULL COMMENT '诉讼代理人',
  `dsrlx` varchar(50) DEFAULT NULL COMMENT '当事人类型',
  `ygxm` varchar(50) DEFAULT NULL COMMENT '原告姓名',
  `zjlx` varchar(20) DEFAULT NULL COMMENT '证件类型',
  `zjhm` varchar(20) DEFAULT NULL COMMENT '证件号码',
  `sjhm` varchar(11) DEFAULT NULL COMMENT '手机号码',
  `mz` varchar(10) DEFAULT NULL COMMENT '民族',
  `nl` int(11) DEFAULT NULL COMMENT '年龄',
  `csrq` datetime DEFAULT NULL COMMENT '出生日期',
  `xb` varchar(10) DEFAULT NULL COMMENT '性别',
  `gzdw` varchar(50) DEFAULT NULL COMMENT '工作单位',
  `zy` varchar(50) DEFAULT NULL COMMENT '职业',
  `dzlx` varchar(50) DEFAULT NULL COMMENT '地址类型',
  `dz` varchar(255) DEFAULT NULL COMMENT '地址类型对应地址',
  `gddh` varchar(20) DEFAULT NULL COMMENT '固定电话',
  `dwmc` varchar(255) DEFAULT NULL COMMENT '单位名称',
  `dwxz` varchar(50) DEFAULT NULL COMMENT '单位性质',
  `zzlx` varchar(50) DEFAULT NULL COMMENT '证照类型',
  `zzhm` varchar(50) DEFAULT NULL COMMENT '证照号码',
  `zsd` varchar(255) DEFAULT NULL COMMENT '住所地',
  `fddbrxm` varchar(50) DEFAULT NULL COMMENT '法定代表人姓名',
  `fddbrzw` varchar(50) DEFAULT NULL COMMENT '法定代表人职务',
  `fddbrzjlx` varchar(50) DEFAULT NULL COMMENT '法定代表人证件类型',
  `fddbrzjhm` varchar(50) DEFAULT NULL COMMENT '法定代表人证件号码',
  `fddbrsjhm` varchar(11) DEFAULT NULL COMMENT '法定代表人手机号码',
  `fddbrgddh` varchar(20) DEFAULT NULL COMMENT '法定代表人固定电话',
  `zyfzrxm` varchar(50) DEFAULT NULL COMMENT '主要负责人姓名',
  `zyfzrzw` varchar(50) DEFAULT NULL COMMENT '主要负责人职务',
  `zyfzrzjlx` varchar(50) DEFAULT NULL COMMENT '主要负责人证件类型',
  `zyfzrzjhm` varchar(50) DEFAULT NULL COMMENT '主要负责人证件号码',
  `zyfzrsjhm` varchar(11) DEFAULT NULL COMMENT '主要负责人手机号码',
  `zyfzrgddh` varchar(50) DEFAULT NULL COMMENT '主要负责人固定电话',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人'
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='原告信息';

-- ----------------------------
-- Records of sspt_yg
-- ----------------------------
INSERT INTO `sspt_yg` VALUES ('95414fcc6d5b47bba24b821240bbdd55', 'adadb63341414108b3ac445145098ecf', null, '自然人', 'gfsd', '军官证', '430224199', '17521211444', '身份证', '12', '2018-05-22 00:00:00', '1', '12dasd', '身份证', 'on', '17521211444', '17521211444', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-05-11 11:02:04', '2018-05-11 11:02:04', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_yg` VALUES ('e26084d067b945c4acd63453c768b43b', 'adadb63341414108b3ac445145098ecf', null, 'on', 'asfas', '身份证', '12edsvw', '18422222222', '汉族', '12', '2018-05-22 00:00:00', '男', 'sas', '程序员', 'on', 'sdf', '18422222222', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-05-11 11:15:33', '2018-05-11 11:15:33', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_yg` VALUES ('c586b84d52454648b55efa739eff17a0', 'adadb63341414108b3ac445145098ecf', null, 'on', null, null, null, null, null, null, null, null, null, null, null, null, null, 'vsf', '汉族', 'on', 'sdvdf', 'dsvf', 'sdfgb', 'dsfg', '身份证', 'sdf', '18473384858', '18333333333', null, null, null, null, null, null, '2018-05-11 11:16:59', '2018-05-11 11:16:59', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_yg` VALUES ('34350a5269394fbbaca15d256a71a6bc', '711d06f34c0b44288a8041d612ed67b8', null, '法人', null, null, null, null, null, null, null, null, null, null, null, null, null, 'vsf', '汉族', 'on', 'sdvdf', 'dsvf', 'sdfgb', 'dsfg', '身份证', 'sdf', '18473384858', '18473377777', null, null, null, null, null, null, '2018-05-11 11:30:10', '2018-05-11 11:30:10', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_yg` VALUES ('0d79a10a657740c5bb288c64e1809850', '711d06f34c0b44288a8041d612ed67b8', null, '自然人', 'gfsd', '军官证', '12', '17521211444', '身份证', '21', '2018-05-29 00:00:00', '1', '12fsa', '军官证', 'on', '17521211444', '17521211444', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-05-14 10:11:25', '2018-05-14 10:11:25', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_yg` VALUES ('576d8aa719d6496fbe71536f93b4c7ee', 'e171496d723b460ba7dcbd627188c938', null, '自然人', '原告1', 'JGZ', '412725199407270019', '13033333333', 'HZ', '23', '2018-05-22 00:00:00', '1', '上海浦东华宇', 'KXYJRY', 'on', '上海浦东', '13033333333', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-05-15 09:18:30', '2018-05-15 09:18:30', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_yg` VALUES ('2c993ca5775c40ca91808ba1b38c963a', 'e171496d723b460ba7dcbd627188c938', 'bb28c372d7314cbabf8823e15f4a3ae4', '法人', null, null, null, null, null, null, null, null, null, null, null, null, null, '法人组织1', 'XZDW', '组织机构代码', '412725199707270019', '上海浦东', '法定代表人', '法定代表人职务', 'JGZ', '412725199707270018', '13033333333', '13033333333', null, null, null, null, null, null, '2018-05-15 09:23:01', '2018-05-15 09:23:01', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_yg` VALUES ('7bf75d86210d4075aeeeddfd593b1943', 'e171496d723b460ba7dcbd627188c938', '3387cc861b9a484cb69df07a445ce765,bb28c372d7314cbabf8823e15f4a3ae4', '自然人', '原告2', 'JGZ', '412725199407270019', '13033333333', 'HZ', '23', '2018-05-15 00:00:00', '1', '上海浦东华宇', 'KXYJRY', 'on', '上海浦东华宇', '13033333333', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-05-15 09:27:11', '2018-05-15 09:27:11', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_yg` VALUES ('de56a090a2fe46eea9bb0447dbf05c2f', 'e171496d723b460ba7dcbd627188c938', '3387cc861b9a484cb69df07a445ce765', '法人', null, null, null, null, null, null, null, null, null, null, null, null, null, '法人组织2', 'XZDW', '社会统一信用代码', '412725199707270019', '上海浦东', '法定代表人', '法定代表人职务', 'JGZ', '412725199707270018', '13033333333', '13033333333', null, null, null, null, null, null, '2018-05-15 09:30:59', '2018-05-15 09:30:59', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_yg` VALUES ('807dff43f2e644369ede877603c16dad', 'e7fe1d74f70b4bd7871fda9a575f3c26', null, '自然人', '原告1', 'HZ', '412725199407270019', '13033333333', 'HUIZU', '23', '2018-05-23 00:00:00', '1', '上海浦东华宇', 'KXYJRY', 'on', '上海浦东', '13033333333', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-05-16 09:56:40', '2018-05-16 09:56:40', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_yg` VALUES ('e49d71c451524e7b955c18d790e91024', 'e7fe1d74f70b4bd7871fda9a575f3c26', null, '自然人', '原告1', 'HZ', '412725199407270019', '13033333333', 'HUIZU', '12', '2018-05-30 00:00:00', '1', '上海浦东华宇', 'GCJSRYHNLJSRY', 'on', '上海浦东华宇', '13033333333', null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, null, '2018-05-16 09:58:12', '2018-05-16 09:58:12', 'archibald_witwicky', 'archibald_witwicky');

-- ----------------------------
-- Table structure for sspt_ygdlr
-- ----------------------------
DROP TABLE IF EXISTS `sspt_ygdlr`;
CREATE TABLE `sspt_ygdlr` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `ajid` varchar(32) DEFAULT NULL COMMENT '案件id',
  `dlrlx` varchar(255) DEFAULT NULL COMMENT '代理人类型',
  `dlrxm` varchar(255) DEFAULT NULL COMMENT '代理人姓名',
  `zjlx` varchar(255) DEFAULT NULL COMMENT '证件类型',
  `zyzh` varchar(255) DEFAULT NULL COMMENT '执业证号(律师、承担法律援助的律师填写)',
  `lsmc` varchar(255) DEFAULT NULL COMMENT '律所名称(律师事务所名称:律师、承担法律援助的律师i填写)',
  `zjhm` varchar(255) DEFAULT NULL COMMENT '证件号码',
  `sjhm` varchar(255) DEFAULT NULL COMMENT '手机号码',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='原告代理人';

-- ----------------------------
-- Records of sspt_ygdlr
-- ----------------------------
INSERT INTO `sspt_ygdlr` VALUES ('013dc974869a4b5197efb5edff18ea21', '43b567c4e64441b4adb77d2e1bea1079', 'LS', '原告代理人2', 'HZ', '123123123', '宏泰律师事务所', '412725199407270019', '13033333333', '2018-05-17 09:59:05', '2018-05-17 09:59:05', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ygdlr` VALUES ('1ac6ebc087de4b41bd4acc8ec33c8ad2', '3841770c008745209fd704fbc8570520', 'JHR', '原告代理人333', 'HZ', null, null, '412725199407270019', '13033333333', '2018-05-17 10:00:28', '2018-05-17 10:00:28', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ygdlr` VALUES ('aefe2c250336461f8b99a4350ac7de4d', '43b567c4e64441b4adb77d2e1bea1079', 'JHR', '原告代理人22', 'JGZ', null, null, '412725199407270019', '13033333333', '2018-05-17 09:59:13', '2018-05-17 09:59:13', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ygdlr` VALUES ('c321c82e301642b5b86db5f3a0955ff2', '3841770c008745209fd704fbc8570520', 'SZDWTJ', '原告代理人3333', 'HZ', null, null, '412725199407270019', '13033333333', '2018-05-17 10:00:10', '2018-05-17 10:00:10', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ygdlr` VALUES ('cf6787db6afa445fb7f97574ab13ac26', '59b5d7a0e90e4414960c24073eb0097a', 'RMTTTJ', '原告代理人1', 'SFZ', null, null, '412725199407270019', '13033333333', '2018-05-17 09:59:43', '2018-05-17 09:59:43', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_ygdlr` VALUES ('f964edfc9eee420186508f0682aff441', '3841770c008745209fd704fbc8570520', 'RMTTTJ', '原告代理人33333', 'JGZ', null, null, '412725199407270019', '13033333333', '2018-05-17 10:00:20', '2018-05-17 10:00:20', 'archibald_witwicky', 'archibald_witwicky');

-- ----------------------------
-- Table structure for sspt_yh
-- ----------------------------
DROP TABLE IF EXISTS `sspt_yh`;
CREATE TABLE `sspt_yh` (
  `yhid` varchar(32) NOT NULL DEFAULT '' COMMENT '用户id',
  `openid` varchar(50) DEFAULT NULL COMMENT '微信标示ID',
  `isbind` varchar(10) DEFAULT '0',
  `yhlx` varchar(1) NOT NULL DEFAULT '' COMMENT '用户类型',
  `yhm` varchar(100) NOT NULL DEFAULT '' COMMENT '用户名',
  `mm` varchar(100) NOT NULL DEFAULT '' COMMENT '密码',
  `xm` varchar(50) NOT NULL DEFAULT '' COMMENT '姓名',
  `zjlx` varchar(1) NOT NULL DEFAULT '' COMMENT '证件类型',
  `zjhm` varchar(18) NOT NULL DEFAULT '' COMMENT '证件号码',
  `sjhm` varchar(11) NOT NULL DEFAULT '' COMMENT '手机号码',
  `dwmc` varchar(100) DEFAULT NULL COMMENT '单位名称',
  `zzlx` varchar(1) DEFAULT NULL COMMENT '证照类型',
  `zzhm` varchar(20) DEFAULT NULL COMMENT '证照号码',
  `zsd` varchar(100) DEFAULT NULL COMMENT '住所地',
  `fddbrxm` varchar(50) DEFAULT NULL COMMENT '法定代表人姓名',
  `fddbrzw` varchar(100) DEFAULT NULL COMMENT '法定代表人职务',
  `zyfzrxm` varchar(50) DEFAULT NULL COMMENT '主要负责人姓名',
  `zyfzrzw` varchar(100) DEFAULT NULL COMMENT '主要负责人职务',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`yhid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户';

-- ----------------------------
-- Records of sspt_yh
-- ----------------------------
INSERT INTO `sspt_yh` VALUES ('fdertd1585094dc1a10fe15aef265d58', null, null, '1', 'admin', 'admin', '麻子', '1', '412725199407270019', '13033333333', '', '1', '', '', '', '', '', '', '2018-05-07 11:36:53', '2018-05-07 11:36:53', 'yy', 'yy');

-- ----------------------------
-- Table structure for sspt_yhaj
-- ----------------------------
DROP TABLE IF EXISTS `sspt_yhaj`;
CREATE TABLE `sspt_yhaj` (
  `id` varchar(32) NOT NULL COMMENT '用户案件中间表id',
  `yhid` varchar(32) NOT NULL COMMENT '用户id',
  `ajid` varchar(32) NOT NULL COMMENT '案件id',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户案件';

-- ----------------------------
-- Records of sspt_yhaj
-- ----------------------------
INSERT INTO `sspt_yhaj` VALUES ('0b16923b603e47f88fdfd26ae9dce648', 'fdertd1585094dc1a10fe15aef265d58', '2c0dd5395a8a4a50aa0d5bc330bfed2e', '2018-05-17 10:13:42', '2018-05-17 10:13:42', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_yhaj` VALUES ('5b89cd75a036458c8d74e0a172f6fd60', 'fdertd1585094dc1a10fe15aef265d58', '711d06f34c0b44288a8041d612ed67b8', '2018-05-17 10:13:14', '2018-05-17 10:13:14', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_yhaj` VALUES ('7664ea3e72274cd8acd63781737d751d', 'fdertd1585094dc1a10fe15aef265d58', 'adadb63341414108b3ac445145098ecf', '2018-05-17 10:14:20', '2018-05-17 10:14:20', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_yhaj` VALUES ('861ab8ae80ff4d9e9c5a4a66b919ca87', 'fdertd1585094dc1a10fe15aef265d58', 'a640dd7edf2442fdaa92e99072c4b4a7', '2018-05-17 10:44:33', '2018-05-17 10:44:33', 'archibald_witwicky', 'archibald_witwicky');

-- ----------------------------
-- Table structure for sspt_zjian
-- ----------------------------
DROP TABLE IF EXISTS `sspt_zjian`;
CREATE TABLE `sspt_zjian` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `ajid` varchar(32) DEFAULT NULL COMMENT '案件id',
  `clmc` varchar(255) DEFAULT NULL COMMENT '材料名称({原告}诉讼{被告}的起诉状)',
  `ssr` varchar(255) DEFAULT NULL COMMENT '所属人(所选择的原告)',
  `wjmc` varchar(255) DEFAULT NULL COMMENT '文件名称(md5/sha加密)',
  `wjlj` varchar(255) DEFAULT NULL COMMENT '文件路径',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='证件类材料';

-- ----------------------------
-- Records of sspt_zjian
-- ----------------------------
INSERT INTO `sspt_zjian` VALUES ('11', '039f87680ef64762bd5e05cd62310b58', '证件类', '火狐', 'banner_top2.jpg', '20180504/5efa55d42abe4fe6aad3de94026f71e3.jpg', '2018-05-07 11:32:28', '2018-05-07 11:32:31', null, null);
INSERT INTO `sspt_zjian` VALUES ('1e086c8b566643a2bda07c649c0fad8b', '46826d1585094dc1a10fe15aef265d58', '证件类', '哈哈', 'banner_buttom.jpg', '20180504/e9ff1f5a341f466885942ec5b8ef5bdd.jpg', '2018-05-04 11:30:11', '2018-05-04 11:30:11', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_zjian` VALUES ('22', '039f87680ef64762bd5e05cd62310b58', '组织', '啊', 'banner_top2.jpg', '20180504/5efa55d42abe4fe6aad3de94026f71e3.jpg', '2018-05-07 11:32:54', null, null, null);
INSERT INTO `sspt_zjian` VALUES ('4d5ce653b68e4f7586a491ec9e62f7f5', '46826d1585094dc1a10fe15aef265d58', '证件类', '哈哈', 'banner_top2.jpg', '20180504/5efa55d42abe4fe6aad3de94026f71e3.jpg', '2018-05-04 11:30:11', '2018-05-04 11:30:11', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_zjian` VALUES ('74821cd6487b41b7b5ce80896d7ff060', '49e06a6c59fc4ec2ab46d4c2d7703565', '证件类', '哈哈', 'Tulips.jpg', '20180515/3b4cabe28d5c4cf7b18dca97d5c0083d.jpg', '2018-05-15 20:19:11', '2018-05-15 20:19:11', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_zjian` VALUES ('accbd3be82984d23a485b8d838ca1ad2', '55f43d3218874015a579f32985202590', '证件类', '哈哈', '个人主页.jpg', '20180508/552879b2660c4d2a8e38ef8dea706122.jpg', '2018-05-08 13:20:07', '2018-05-08 13:20:07', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_zjian` VALUES ('d4368350bcc84cef9e9416cda530f9dc', '5d923fa8dd1c4383bb38c59a32105678', '证件类', '哈哈', 'Jellyfish.jpg', '20180514/8361633d903746e0a177762f96f83054.jpg', '2018-05-14 11:36:22', '2018-05-14 11:36:22', 'archibald_witwicky', 'archibald_witwicky');

-- ----------------------------
-- Table structure for sspt_zju
-- ----------------------------
DROP TABLE IF EXISTS `sspt_zju`;
CREATE TABLE `sspt_zju` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `ajid` varchar(32) DEFAULT NULL COMMENT '案件id',
  `wjmc` varchar(255) DEFAULT NULL COMMENT '文件名称(md5/sha加密)',
  `wjlj` varchar(255) DEFAULT NULL COMMENT '文件路径',
  `zjmc` varchar(255) DEFAULT NULL COMMENT '证据名称',
  `zjly` varchar(255) DEFAULT NULL COMMENT '证据来源',
  `ssr` varchar(255) DEFAULT NULL COMMENT '所属人(所选择的原告)',
  `zmwt` varchar(255) DEFAULT NULL COMMENT '证明问题',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='证据类材料';

-- ----------------------------
-- Records of sspt_zju
-- ----------------------------
INSERT INTO `sspt_zju` VALUES ('11', '039f87680ef64762bd5e05cd62310b58', '525e83def85e344ff0c8e54625f48418_hd.jpg', '20180504/2c56672fbfe0498faa3ec8e6c52f3aaf.jpg', '证据名称1', '证据来源1', '哈哈', '证明问题1', '2018-05-05 17:57:23', '2018-05-05 17:57:25', null, null);
INSERT INTO `sspt_zju` VALUES ('8bb95d727f95487e8293d48d31ed59b9', '46826d1585094dc1a10fe15aef265d58', 'f2deb48f8c5494eee3eebbab2df5e0fe98257eb7.jpg', '20180504/a2dcd62fcfa649349198fea1faa937ec.jpg', '证据名称1', '证据来源1', '哈哈', '证明问题1', '2018-05-04 11:30:35', '2018-05-04 11:30:35', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_zju` VALUES ('dfe06ea8a2ef4d0cb4b40bccb968d18d', '46826d1585094dc1a10fe15aef265d58', 'v2-525e83def85e344ff0c8e54625f48418_hd.jpg', '20180504/2c56672fbfe0498faa3ec8e6c52f3aaf.jpg', '证据名称1', '证据来源1', '哈哈', '证明问题1', '2018-05-04 11:30:35', '2018-05-04 11:30:35', 'archibald_witwicky', 'archibald_witwicky');

-- ----------------------------
-- Table structure for sspt_zr
-- ----------------------------
DROP TABLE IF EXISTS `sspt_zr`;
CREATE TABLE `sspt_zr` (
  `id` varchar(32) NOT NULL COMMENT '主键id',
  `ajid` varchar(32) DEFAULT NULL COMMENT '案件id',
  `zrxm` varchar(255) DEFAULT NULL COMMENT '证人姓名',
  `sjhm` varchar(11) DEFAULT NULL COMMENT '手机号码',
  `zjlx` varchar(255) DEFAULT NULL COMMENT '证件类型',
  `zjhm` varchar(255) DEFAULT NULL COMMENT '证件号码',
  `csrq` varchar(255) DEFAULT NULL COMMENT '出生日期',
  `zrnl` int(11) DEFAULT NULL COMMENT '证人年龄',
  `zrxb` varchar(255) DEFAULT NULL COMMENT '证人性别',
  `szdw` varchar(255) DEFAULT NULL COMMENT '所在单位',
  `zrzs` varchar(255) DEFAULT NULL COMMENT '证人住所',
  `ctzz` varchar(255) DEFAULT NULL COMMENT '出庭作证',
  `ylf` varchar(255) DEFAULT NULL COMMENT '有利方(原告中的一个或多个)',
  `crt_tm` datetime DEFAULT NULL COMMENT '创建时间',
  `upd_tm` datetime DEFAULT NULL COMMENT '更新时间',
  `crt_user` varchar(50) DEFAULT NULL COMMENT '创建人',
  `upd_user` varchar(50) DEFAULT NULL COMMENT '更新人',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='证人';

-- ----------------------------
-- Records of sspt_zr
-- ----------------------------
INSERT INTO `sspt_zr` VALUES ('018b850443cf4c16a211d9705ee8140b', '46826d1585094dc1a10fe15aef265d58', '啊的发送到', '13033333333', '身份证', '412725199407270019', '2018-05-23', '23', '女', '单位', '证人', '男', '李四', '2018-05-04 11:29:39', '2018-05-04 11:29:39', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_zr` VALUES ('212c09b843c4414c8add495511869950', '5d923fa8dd1c4383bb38c59a32105678', 'gvsd', '18473384858', '军官证', 'sd', '2018-05-29', '11', '1', 'afds', 'as', '1', '李四,张三', '2018-05-14 10:20:55', '2018-05-14 10:20:55', 'archibald_witwicky', 'archibald_witwicky');
INSERT INTO `sspt_zr` VALUES ('8fbf858eb04e445a9254ac332f7d14ed', '8747a70e6f5f40578f7868611f5ea3cf', '11', '13665629056', '身份证', '340322199505037815', '1995-05-03', '23', '1', '11', '1', '1', '李四', '2018-05-08 10:27:31', '2018-05-08 10:27:31', 'archibald_witwicky', 'archibald_witwicky');

 

复杂关联查询

-- -------------------------------
-- 案件、类别编码、法院
-- -------------------------------
-- SELECT
-- 	sa.ajid,
-- 	sa.ah,
-- 	sa.qrcode,
-- 	sa.cbr,
-- 	sa.ysfy,
-- 	sf.`name` AS jsfy,
-- 	sl_ajlb.mc AS ajlb,
-- 	sl_sqlx.mc AS sqlx,
-- 	sl_sqrlx.mc AS sqrlx,
-- 	sl_dlrlx.mc AS dlrlx,
-- 	sa.sqrid,
-- 	sa.ajms,
-- 	sa.crt_tm,
-- 	sa.upd_tm,
-- 	sa.crt_user,
-- 	sa.upd_user
-- FROM
-- 	sspt_aj AS sa
-- INNER JOIN sspt_fy AS sf ON sf.id = sa.jsfy
-- LEFT JOIN sspt_lbbm sl_ajlb ON sl_ajlb.bm = sa.ajlb
-- LEFT JOIN sspt_lbbm sl_sqlx ON sl_sqlx.bm = sa.sqlx
-- LEFT JOIN sspt_lbbm sl_sqrlx ON sl_sqrlx.bm = sa.sqrlx
-- LEFT JOIN sspt_lbbm sl_dlrlx ON sl_dlrlx.bm = sa.dlrlx
-- WHERE
-- 	sa.ajid IN (
-- 		SELECT
-- 			tmp_sya.ajid
-- 		FROM
-- 			sspt_yhaj AS tmp_sya
-- 		WHERE
-- 			tmp_sya.yhid = 'fdertd1585094dc1a10fe15aef265d58'
-- 	)
-- ORDER BY
-- 	crt_tm DESC
-- -------------------------------
-- 案件、案件状态、法院、类别编码
-- -------------------------------
SELECT
	sa.ajid,
	sl_ajzt.mc AS ajzt,
	sl_lalczt.mc AS lalczt,
	sa.ah,
	sa.qrcode,
	sa.cbr,
	sa.ysfy,
	sf.`name` AS jsfy,
	sl_ajlb.mc AS ajlb,
	sl_sqlx.mc AS sqlx,
	sl_sqrlx.mc AS sqrlx,
	sl_dlrlx.mc AS dlrlx,
	sa.sqrid,
	sa.ajms,
	sa.crt_tm,
	sa.upd_tm,
	sa.crt_user,
	sa.upd_user
FROM
	sspt_aj AS sa
INNER JOIN sspt_fy AS sf ON sf.id = sa.jsfy
INNER JOIN sspt_ajzt AS saz ON saz.ajid = sa.ajid
LEFT JOIN sspt_lbbm sl_ajzt ON sl_ajzt.bm = saz.ajzt
LEFT JOIN sspt_lbbm sl_lalczt ON sl_lalczt.bm = saz.lalczt
LEFT JOIN sspt_lbbm sl_ajlb ON sl_ajlb.bm = sa.ajlb
LEFT JOIN sspt_lbbm sl_sqlx ON sl_sqlx.bm = sa.sqlx
LEFT JOIN sspt_lbbm sl_sqrlx ON sl_sqrlx.bm = sa.sqrlx
LEFT JOIN sspt_lbbm sl_dlrlx ON sl_dlrlx.bm = sa.dlrlx
WHERE
	sa.ajid IN (
		SELECT
			tmp_sya.ajid
		FROM
			sspt_yhaj AS tmp_sya
		WHERE
			tmp_sya.yhid = 'fdertd1585094dc1a10fe15aef265d58'
	)
AND saz.ajzt = 'DSH'
ORDER BY
	sa.crt_tm DESC

 

展开阅读全文
打赏
0
0 收藏
分享
加载中
更多评论
打赏
0 评论
0 收藏
0
分享
返回顶部
顶部