表：t_category

  1 /*
  2 Navicat Oracle Data Transfer
  3 Oracle Client Version : 10.2.0.5.0
  4 
  5 Source Server         : 3.42 Oracle11g
  6 Source Server Version : 110200
  7 Source Host           : 192.168.3.42:1521
  8 Source Schema         : DBUSER
  9 
 10 Target Server Type    : ORACLE
 11 Target Server Version : 110200
 12 File Encoding         : 65001
 13 
 14 Date: 2013-10-22 08:13:07
 15 */
 16 
 17 
 18 -- ----------------------------
 19 -- Table structure for "DBUSER"."t_category"
 20 -- ----------------------------
 21 DROP TABLE "DBUSER"."t_category";
 22 CREATE TABLE "DBUSER"."t_category" (
 23 "id" NUMBER(11) NOT NULL ,
 24 "groupCode" NVARCHAR2(50) NULL ,
 25 "parentId" NUMBER(11) NULL ,
 26 "number" NVARCHAR2(50) DEFAULT to_char( SYSTIMESTAMP, 'yyyy-MM-dd HH24:mi:ss.ff6' )  NULL ,
 27 "name" NVARCHAR2(2000) NULL ,
 28 "description" VARCHAR2(2000 BYTE) NULL ,
 29 "value" NVARCHAR2(2000) NULL ,
 30 "jsonContent" NVARCHAR2(2000) NULL ,
 31 "status" NVARCHAR2(50) NULL ,
 32 "insertedDatetime" DATE DEFAULT sysdate  NULL ,
 33 "insertUserId" NUMBER(11) NULL ,
 34 "checkedDatetime" DATE NULL ,
 35 "checkerId" NUMBER(11) NULL ,
 36 "comment" NVARCHAR2(2000) NULL ,
 37 "valueA" VARCHAR2(2000 BYTE) NULL ,
 38 "valueB" VARCHAR2(2000 BYTE) NULL ,
 39 "valueC" VARCHAR2(2000 BYTE) NULL 
 40 )
 41 LOGGING
 42 NOCOMPRESS
 43 NOCACHE
 44 
 45 ;
 46 COMMENT ON TABLE "DBUSER"."t_category" IS '类别表
 47 
 48 
 49 
 50 可以存储 用户、职员、部门、卡口';
 51 COMMENT ON COLUMN "DBUSER"."t_category"."parentId" IS '父ID';
 52 COMMENT ON COLUMN "DBUSER"."t_category"."jsonContent" IS '{''tel'':''024-25733345'',''address'':''南京街砂阳路''}';
 53 COMMENT ON COLUMN "DBUSER"."t_category"."status" IS '状态： 0 - Normal（正常）
 54 
 55 1 - 。。。。';
 56 COMMENT ON COLUMN "DBUSER"."t_category"."comment" IS '备注';
 57 
 58 -- ----------------------------
 59 -- Records of t_category
 60 -- ----------------------------
 61 INSERT INTO "DBUSER"."t_category" VALUES ('287', 'surveilDevice', '227', '1', '1', null, null, null, null, TO_DATE('2013-09-22 11:50:10', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, null, null, null);
 62 INSERT INTO "DBUSER"."t_category" VALUES ('209', 'checkPoint', '128', '3', '南京南街 - 砂阳路 路口东1.2公里', null, null, null, null, TO_DATE('2013-09-04 15:39:43', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, 'a', null, null);
 63 INSERT INTO "DBUSER"."t_category" VALUES ('227', 'checkPoint', '128', '4', '和平大街 - 南八马路 路口', null, null, null, null, TO_DATE('2013-09-09 08:39:36', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, 'a', null, null);
 64 INSERT INTO "DBUSER"."t_category" VALUES ('348', 'checkPoint', null, '2013-10-12 08:49:53.328000', null, null, null, null, null, TO_DATE('2013-10-12 08:49:53', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, '1111', null, null);
 65 INSERT INTO "DBUSER"."t_category" VALUES ('350', 'checkPoint', null, '2013-10-12 08:50:58.421000', null, null, null, null, null, TO_DATE('2013-10-12 08:50:58', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, null, null, null);
 66 INSERT INTO "DBUSER"."t_category" VALUES ('353', 'surveilDevice', '187', '12', '2223', null, null, null, null, TO_DATE('2013-10-12 08:59:23', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, null, null, null);
 67 INSERT INTO "DBUSER"."t_category" VALUES ('360', 'violation', null, '2013-10-12 09:11:16.921000', null, null, null, null, null, TO_DATE('2013-10-12 09:11:16', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, null, null, null);
 68 INSERT INTO "DBUSER"."t_category" VALUES ('357', 'surveilDevice', null, '2013-10-12 09:05:08.703000', null, null, null, null, null, TO_DATE('2013-10-12 09:05:08', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, null, null, null);
 69 INSERT INTO "DBUSER"."t_category" VALUES ('362', 'violation', null, '2013-10-12 09:16:11.968000', null, null, null, null, null, TO_DATE('2013-10-12 09:16:11', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, null, null, null);
 70 INSERT INTO "DBUSER"."t_category" VALUES ('187', 'checkPoint', '174', '1', '保工南街 - 沈辽路 路口', null, null, null, null, TO_DATE('2013-09-03 15:25:54', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, 'a', null, null);
 71 INSERT INTO "DBUSER"."t_category" VALUES ('-1', 'maxDatetimeInTheCollectedData', null, '1', null, null, '2013-10-11 18:31:46.001', null, null, TO_DATE('2013-09-06 09:22:12', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, '当前已经处理的数据的时间字段值，number - 数据源编号', null, null, null);
 72 INSERT INTO "DBUSER"."t_category" VALUES ('116', null, null, '5', null, null, null, null, null, TO_DATE('2013-09-02 10:54:49', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, null, null, null, null);
 73 INSERT INTO "DBUSER"."t_category" VALUES ('117', null, null, '6', null, null, null, null, null, TO_DATE('2013-09-02 10:55:35', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, null, null, null, null);
 74 INSERT INTO "DBUSER"."t_category" VALUES ('383', 'user', '1', 'admin', '1', null, '1234', null, '1', TO_DATE('2013-10-14 14:55:00', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, 'ROLE_ADMIN', null, null);
 75 INSERT INTO "DBUSER"."t_category" VALUES ('-2', 'userStatus', null, '1', '正常', null, null, null, null, TO_DATE('2013-09-06 14:19:51', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, null, null, null, null);
 76 INSERT INTO "DBUSER"."t_category" VALUES ('-3', 'userStatus', null, '2', '禁用', null, null, null, null, TO_DATE('2013-09-06 14:20:29', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, null, null, null, null);
 77 INSERT INTO "DBUSER"."t_category" VALUES ('385', 'user', '3', '333', '3', null, '3', null, '3', TO_DATE('2013-10-14 14:55:41', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, '3', null, null);
 78 INSERT INTO "DBUSER"."t_category" VALUES ('380', 'department', null, '12', '12', null, null, null, null, TO_DATE('2013-10-14 14:53:01', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, null, null, null);
 79 INSERT INTO "DBUSER"."t_category" VALUES ('394', 'user', '321', '321321', '321', null, '321', null, '321', TO_DATE('2013-10-14 14:59:24', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, '321', null, null);
 80 INSERT INTO "DBUSER"."t_category" VALUES ('395', 'user', '379', 'admin1', '1234', null, '1234', null, '1', TO_DATE('2013-10-14 15:51:58', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, 'ROLE_ADMIN', null, null);
 81 INSERT INTO "DBUSER"."t_category" VALUES ('250', 'violation', null, '1001', '闯红灯', null, null, null, '1', TO_DATE('2013-09-17 11:52:02', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, null, null, null);
 82 INSERT INTO "DBUSER"."t_category" VALUES ('382', 'department', null, '1234', '1234', null, null, null, null, TO_DATE('2013-10-14 14:53:12', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, null, null, null);
 83 INSERT INTO "DBUSER"."t_category" VALUES ('398', 'violation', null, '1321', '1', null, null, null, '1', TO_DATE('2013-10-14 16:18:21', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, null, null, null);
 84 INSERT INTO "DBUSER"."t_category" VALUES ('208', 'checkPoint', '174', '0', '南京南街 - 砂阳路 路口', null, null, null, null, TO_DATE('2013-09-04 15:39:24', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, 'admin', null, null);
 85 INSERT INTO "DBUSER"."t_category" VALUES ('301', 'userRole', null, '2013-09-05 10:20:10', '180', null, '302', null, null, TO_DATE('2013-09-05 09:53:15', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, '用户-角色关系', null, null, null);
 86 INSERT INTO "DBUSER"."t_category" VALUES ('302', 'role', null, 'ROLE_ADMIN', null, null, null, null, null, TO_DATE('2013-09-05 09:57:21', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, '角色', null, null, null);
 87 INSERT INTO "DBUSER"."t_category" VALUES ('303', 'test', null, '05-SEP-13 10.20.40.663000 AM +08:00', null, null, null, null, null, TO_DATE('2013-09-05 10:20:40', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, null, null, null, null);
 88 INSERT INTO "DBUSER"."t_category" VALUES ('305', 'test', null, '2013-09-05 10:32:14.851000', null, null, null, null, null, TO_DATE('2013-09-05 10:32:14', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, null, null, null, null);
 89 INSERT INTO "DBUSER"."t_category" VALUES ('306', 'userRole', '0', '2013-09-05 13:35:26.492000', '207', null, '307', null, null, TO_DATE('2013-09-05 13:35:26', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, '用户-角色关系', null, null, null);
 90 INSERT INTO "DBUSER"."t_category" VALUES ('307', 'role', '0', 'ROLE_USER', null, null, null, null, null, TO_DATE('2013-09-05 13:36:01', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, '角色', null, null, null);
 91 INSERT INTO "DBUSER"."t_category" VALUES ('228', 'checkPoint', null, '5', '5.测试用', null, null, null, null, TO_DATE('2013-09-09 12:05:37', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, 'Livon', null, null);
 92 INSERT INTO "DBUSER"."t_category" VALUES ('-5', 'nameList', null, '( 车牌号码 )', null, null, 'B1', null, '1', TO_DATE('2013-09-12 10:18:22', 'YYYY-MM-DD HH24:MI:SS'), null, null, null, '名单,B=Black;R=Red,status:1=活跃；0=禁用，valueA=开始时间；valueB=结束时间', '2013-09-01 00：00：00', '2013-09-30 00：00：00', null);
 93 INSERT INTO "DBUSER"."t_category" VALUES ('384', 'user', '2', '2222', '2', null, '2', null, '2', TO_DATE('2013-10-14 14:55:32', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, '2', null, null);
 94 INSERT INTO "DBUSER"."t_category" VALUES ('251', 'violation', null, '10022', '100223355667788', null, null, null, '2', TO_DATE('2013-09-17 12:23:51', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, null, null, null);
 95 INSERT INTO "DBUSER"."t_category" VALUES ('349', 'checkPoint', null, '2013-10-12 08:50:53.671000', null, null, null, null, null, TO_DATE('2013-10-12 08:50:53', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, null, null, null);
 96 INSERT INTO "DBUSER"."t_category" VALUES ('354', 'surveilDevice', '208', '13', '111', null, null, null, null, TO_DATE('2013-10-12 08:59:38', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, null, null, null);
 97 INSERT INTO "DBUSER"."t_category" VALUES ('356', 'surveilDevice', null, '2013-10-12 09:05:04.296000', null, null, null, null, null, TO_DATE('2013-10-12 09:05:04', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, null, null, null);
 98 INSERT INTO "DBUSER"."t_category" VALUES ('358', 'surveilDevice', null, '2013-10-12 09:05:11.640000', null, null, null, null, null, TO_DATE('2013-10-12 09:05:11', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, null, null, null);
 99 INSERT INTO "DBUSER"."t_category" VALUES ('359', 'violation', null, '2013-10-12 09:11:11.968000', null, null, null, null, null, TO_DATE('2013-10-12 09:11:11', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, null, null, null);
100 INSERT INTO "DBUSER"."t_category" VALUES ('379', 'department', null, '1', '1', null, null, null, null, TO_DATE('2013-10-14 14:52:54', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, null, null, null);
101 INSERT INTO "DBUSER"."t_category" VALUES ('381', 'department', null, '123', '123', null, null, null, null, TO_DATE('2013-10-14 14:53:06', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, null, null, null);
102 INSERT INTO "DBUSER"."t_category" VALUES ('396', 'checkPoint', null, '32', '沈阳了桔钓沙', null, null, null, null, TO_DATE('2013-10-14 16:14:43', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, '321321', null, null);
103 INSERT INTO "DBUSER"."t_category" VALUES ('397', 'surveilDevice', '321', '321', '321', null, null, null, null, TO_DATE('2013-10-14 16:17:35', 'YYYY-MM-DD HH24:MI:SS'), '0', null, null, null, null, null, null);
104 
105 -- ----------------------------
106 -- Indexes structure for table t_category
107 -- ----------------------------
108 
109 -- ----------------------------
110 -- Uniques structure for table "DBUSER"."t_category"
111 -- ----------------------------
112 ALTER TABLE "DBUSER"."t_category" ADD UNIQUE ("groupCode", "number");
113 
114 -- ----------------------------
115 -- Checks structure for table "DBUSER"."t_category"
116 -- ----------------------------
117 ALTER TABLE "DBUSER"."t_category" ADD CHECK ("id" IS NOT NULL);
118 
119 -- ----------------------------
120 -- Primary Key structure for table "DBUSER"."t_category"
121 -- ----------------------------
122 ALTER TABLE "DBUSER"."t_category" ADD PRIMARY KEY ("id");