sql

最新推荐文章于 2024-08-22 15:30:52 发布

iteye_18309

最新推荐文章于 2024-08-22 15:30:52 发布

阅读量114

点赞数

CC 4.0 BY-SA版权

分类专栏： Java

本文链接：https://blog.youkuaiyun.com/iteye_18309/article/details/82615638

Java 专栏收录该内容

11 篇文章

订阅专栏

-- ----------------------------
-- Table structure for T_ALLIN_PLC
-- ----------------------------
DROP TABLE "AEONLIFE"."T_ALLIN_PLC";
CREATE TABLE "AEONLIFE"."T_ALLIN_PLC" (
"ALLIN_ID" VARCHAR2(36 BYTE) NOT NULL ,
"TRANSR_NO" VARCHAR2(36 BYTE) NULL ,
"PROPOSAL_CONT_NO" VARCHAR2(60 BYTE) NULL ,
"POLICY_STATUS" VARCHAR2(500 BYTE) NULL ,
"POLICY_DATE" DATE NULL ,
"APPNT_NAME" VARCHAR2(25 BYTE) NULL ,
"CORE_ACCEPT_TIME" DATE NULL ,
"BANK_CODE" VARCHAR2(10 BYTE) NULL ,
"ACC_NO" VARCHAR2(32 BYTE) NULL ,
"TRANSFER_START_TIME" DATE NULL ,
"TRANSFER_SUCCESS_TIME" DATE NULL ,
"UPDATE_DATE" DATE NULL ,
"PAY_BANK_CODE" VARCHAR2(10 BYTE) NULL ,
"PAY_STATUS" VARCHAR2(1 BYTE) NULL ,
"REQ_SN" VARCHAR2(50 BYTE) NULL ,
"PREM" NUMBER NULL
)
LOGGING
NOCOMPRESS
NOCACHE

;
COMMENT ON COLUMN "AEONLIFE"."T_ALLIN_PLC"."ALLIN_ID" IS '主键ID';
COMMENT ON COLUMN "AEONLIFE"."T_ALLIN_PLC"."TRANSR_NO" IS '交易串号';
COMMENT ON COLUMN "AEONLIFE"."T_ALLIN_PLC"."PROPOSAL_CONT_NO" IS '投保确认书号';
COMMENT ON COLUMN "AEONLIFE"."T_ALLIN_PLC"."POLICY_STATUS" IS '保单状态';
COMMENT ON COLUMN "AEONLIFE"."T_ALLIN_PLC"."POLICY_DATE" IS '投保日期';
COMMENT ON COLUMN "AEONLIFE"."T_ALLIN_PLC"."APPNT_NAME" IS '投保人';
COMMENT ON COLUMN "AEONLIFE"."T_ALLIN_PLC"."CORE_ACCEPT_TIME" IS '核心接收时间';
COMMENT ON COLUMN "AEONLIFE"."T_ALLIN_PLC"."BANK_CODE" IS '银行代码';
COMMENT ON COLUMN "AEONLIFE"."T_ALLIN_PLC"."ACC_NO" IS '账号';
COMMENT ON COLUMN "AEONLIFE"."T_ALLIN_PLC"."TRANSFER_START_TIME" IS '转账时间';
COMMENT ON COLUMN "AEONLIFE"."T_ALLIN_PLC"."TRANSFER_SUCCESS_TIME" IS '转账成功时间';
COMMENT ON COLUMN "AEONLIFE"."T_ALLIN_PLC"."UPDATE_DATE" IS '数据更新时间';
COMMENT ON COLUMN "AEONLIFE"."T_ALLIN_PLC"."PAY_BANK_CODE" IS '支付用银行代码';
COMMENT ON COLUMN "AEONLIFE"."T_ALLIN_PLC"."PAY_STATUS" IS '支付状态';
COMMENT ON COLUMN "AEONLIFE"."T_ALLIN_PLC"."REQ_SN" IS '交易流水号';
COMMENT ON COLUMN "AEONLIFE"."T_ALLIN_PLC"."PREM" IS '保费';

-- ----------------------------
-- Records of T_ALLIN_PLC
-- ----------------------------
INSERT INTO "AEONLIFE"."T_ALLIN_PLC" VALUES ('1ec53ffe-7085-4b8b-a12d-50d5cbaec028', '0000000000002350', '1316000000000608', '支付成功', TO_DATE('2014-11-11 14:30:18', 'YYYY-MM-DD HH24:MI:SS'), '测试', TO_DATE('2014-11-11 14:30:18', 'YYYY-MM-DD HH24:MI:SS'), '02', '6013827014004211002', TO_DATE('2014-11-11 14:30:18', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2014-11-11 14:30:19', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2014-11-11 14:30:19', 'YYYY-MM-DD HH24:MI:SS'), '0103', '1', '13160000000006081430184809', '11617');
INSERT INTO "AEONLIFE"."T_ALLIN_PLC" VALUES ('ea7bbc65-d183-40a3-baa2-c841330837f6', '0000000000003178', '1316600000000210', '支付成功', TO_DATE('2014-11-26 14:43:58', 'YYYY-MM-DD HH24:MI:SS'), '测试', TO_DATE('2014-11-26 14:43:58', 'YYYY-MM-DD HH24:MI:SS'), '02', '6013827014004211002', TO_DATE('2014-11-26 14:43:58', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2014-11-26 14:44:01', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2014-11-26 14:44:01', 'YYYY-MM-DD HH24:MI:SS'), '0103', '1', '13166000000002101443584396', '154790');
INSERT INTO "AEONLIFE"."T_ALLIN_PLC" VALUES ('5b75051e-85fe-46d0-925c-07549e137c12', '0000000000002339', '1316600000000063', '支付成功', TO_DATE('2014-11-11 11:08:19', 'YYYY-MM-DD HH24:MI:SS'), '刚刚好', TO_DATE('2014-11-11 11:08:19', 'YYYY-MM-DD HH24:MI:SS'), '02', '6013827014004211002', TO_DATE('2014-11-11 11:08:19', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2014-11-11 11:08:22', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2014-11-11 11:08:22', 'YYYY-MM-DD HH24:MI:SS'), '0103', '1', '13166000000000631108191386', '120100');
INSERT INTO "AEONLIFE"."T_ALLIN_PLC" VALUES ('bcd58157-50e2-444f-bf34-d074d49d5e24', '0000000000002457', '1316600000000093', '支付成功', TO_DATE('2014-11-13 14:41:45', 'YYYY-MM-DD HH24:MI:SS'), '规划局', TO_DATE('2014-11-13 14:41:45', 'YYYY-MM-DD HH24:MI:SS'), '02', '6013827014004211002', TO_DATE('2014-11-13 14:41:45', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2014-11-13 14:41:48', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2014-11-13 14:41:48', 'YYYY-MM-DD HH24:MI:SS'), '0103', '1', '13166000000000931441451345', '102600');
INSERT INTO "AEONLIFE"."T_ALLIN_PLC" VALUES ('76186c1a-3e79-4d8c-a575-b96fdd5226da', '0000000000002704', '1316227733664499', '支付成功', TO_DATE('2014-11-18 09:21:25', 'YYYY-MM-DD HH24:MI:SS'), '百二', TO_DATE('2014-11-18 09:21:25', 'YYYY-MM-DD HH24:MI:SS'), '07', '6222023400015847519', TO_DATE('2014-11-18 09:21:25', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2014-11-18 09:21:29', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2014-11-18 09:21:29', 'YYYY-MM-DD HH24:MI:SS'), '0308', '1', '13162277336644990921252853', '4179');
INSERT INTO "AEONLIFE"."T_ALLIN_PLC" VALUES ('0d4c314e-42ee-4236-a6fe-76d5e39d39c4', '0000000000002311', '1316600000000040', '支付成功', TO_DATE('2014-11-10 16:51:12', 'YYYY-MM-DD HH24:MI:SS'), '环境', TO_DATE('2014-11-10 16:51:12', 'YYYY-MM-DD HH24:MI:SS'), '02', '6013827014004211002', TO_DATE('2014-11-10 16:51:12', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2014-11-10 16:51:15', 'YYYY-MM-DD HH24:MI:SS'), TO_DATE('2014-11-10 16:51:15', 'YYYY-MM-DD HH24:MI:SS'), '0103', '1', '13166000000000401651121923', '4930');