alter table t_customs add lv VARCHAR2(200);
alter table t_buried_point add source_code VARCHAR2(20) DEFAULT 1001;
alter table t_control_role modify node_id varchar2(2000);
alter table t_customs add tags VARCHAR2(2000);
create sequence seq_order_score_id
increment by 1
start with 1
nomaxvalue
nominvalue
nocache;
create sequence seq_welfare_id
increment by 1
start with 1
nomaxvalue
nominvalue
nocache;
create sequence seq_goods_type_id
increment by 1
start with 1
nomaxvalue
nominvalue
nocache;
create sequence seq_custom_class_id
increment by 1
start with 1
nomaxvalue
nominvalue
nocache;
create sequence seq_welfare_custom_id
increment by 1
start with 1
nomaxvalue
nominvalue
nocache;
create sequence seq_tags_id
increment by 1
start with 1
nomaxvalue
nominvalue
nocache;
create sequence seq_white_list_id
increment by 1
start with 1
nomaxvalue
nominvalue
nocache;
CREATE TABLE "TONGBAO"."T_ORDER_SCORE"
( "ID" VARCHAR2(20 BYTE) NOT NULL ENABLE,
"NUM" VARCHAR2(50 BYTE),
"TYPE" VARCHAR2(20 BYTE),
"PAYTYPE" VARCHAR2(20 BYTE),
"CUSTOMID" CHAR(8 BYTE),
"AMOUNT" NUMBER(12,2),
"ORDERNO" VARCHAR2(50 BYTE),
"DATETIME" VARCHAR2(20 BYTE),
"SOURCE_TYPE" VARCHAR2(20 BYTE),
"SOURCE_CODE" VARCHAR2(20 BYTE),
CONSTRAINT "TABLE1_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ENABLE
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ;
COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."NUM" IS '流水号';
COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."TYPE" IS '类型1:赠送 2 :退款';
COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."PAYTYPE" IS '渠道类型:默认404';
COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."CUSTOMID" IS '会员ID';
COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."AMOUNT" IS '金额';
COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."ORDERNO" IS '外部订单号';
COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."DATETIME" IS '时间';
COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."SOURCE_TYPE" IS '类型1.活动赠送 2.消费赠送';
COMMENT ON COLUMN "TONGBAO"."T_ORDER_SCORE"."SOURCE_CODE" IS '渠道号(app:1001 洛阳小程序:2001 物业霸王餐:9001)';
CREATE TABLE "TONGBAO"."T_GOODS_TYPE"
( "ID" NUMBER(12,0) NOT NULL ENABLE,
"NAME" VARCHAR2(2000 BYTE),
"DATETIME" VARCHAR2(20 BYTE),
CONSTRAINT "T_GOODS_TYPE_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ENABLE
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ;
COMMENT ON COLUMN "TONGBAO"."T_GOODS_TYPE"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_GOODS_TYPE"."NAME" IS '商品名称';
COMMENT ON COLUMN "TONGBAO"."T_GOODS_TYPE"."DATETIME" IS '创建时间';
CREATE TABLE "TONGBAO"."T_WELFARE"
( "ID" NUMBER(20,0) NOT NULL ENABLE,
"TYPE" VARCHAR2(20 BYTE),
"AMOUNT" NUMBER(12,2),
"GID" NUMBER(20,0),
"FREQUENCY" NUMBER(10,2),
"USERNAME" VARCHAR2(200 BYTE),
"USERID" CHAR(8 BYTE),
"STATUS" CHAR(8 BYTE),
"DATETIME" VARCHAR2(20 BYTE),
CONSTRAINT "T_WELFARE_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ENABLE
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ;
COMMENT ON COLUMN "TONGBAO"."T_WELFARE"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE"."TYPE" IS '类型1:折扣 2 :减免';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE"."AMOUNT" IS '(1.累计金额)(2.减免金额)';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE"."GID" IS '福利类型ID';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE"."STATUS" IS '1:启用2:禁用';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE"."FREQUENCY" IS '减免次数或者折扣力度';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE"."USERNAME" IS '创建者名称';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE"."USERID" IS '创建者ID';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE"."DATETIME" IS '添加时间';
CREATE TABLE "TONGBAO"."T_CUSTOM_CLASS"
( "ID" NUMBER(20,0) NOT NULL ENABLE,
"TITLE" VARCHAR2(500 BYTE),
"IMG" VARCHAR2(2000 BYTE),
"WID" VARCHAR2(2000 BYTE),
"COUTENT" VARCHAR2(2000 BYTE),
"USERNAME" VARCHAR2(2000 BYTE),
"USERID" VARCHAR2(20 BYTE),
"DATETIME" VARCHAR2(20 BYTE),
CONSTRAINT "T_CUSTOM_CLASS_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ENABLE
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ;
COMMENT ON COLUMN "TONGBAO"."T_CUSTOM_CLASS"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_CUSTOM_CLASS"."TITLE" IS '标题';
COMMENT ON COLUMN "TONGBAO"."T_CUSTOM_CLASS"."IMG" IS '图标地址';
COMMENT ON COLUMN "TONGBAO"."T_CUSTOM_CLASS"."WID" IS '会员福利编号';
COMMENT ON COLUMN "TONGBAO"."T_CUSTOM_CLASS"."COUTENT" IS '等级描述';
COMMENT ON COLUMN "TONGBAO"."T_CUSTOM_CLASS"."USERNAME" IS '创建者';
COMMENT ON COLUMN "TONGBAO"."T_CUSTOM_CLASS"."USERID" IS '创建ID';
COMMENT ON COLUMN "TONGBAO"."T_CUSTOM_CLASS"."DATETIME" IS '创建时间';
CREATE TABLE "TONGBAO"."T_WELFARE_CUSTOM"
( "ID" NUMBER(20,0),
"TYPE" VARCHAR2(2 BYTE),
"AMOUNT" NUMBER(20,2),
"END_AMOUNT" NUMBER(20,2),
"WID" VARCHAR2(2000 BYTE),
"CUSTOMID" CHAR(8 BYTE),
"LV" VARCHAR2(200 BYTE),
"GID" VARCHAR2(20 BYTE),
"FREQUENCY" VARCHAR2(20 BYTE),
"END_FREQUENCY" VARCHAR2(20 BYTE),
"ENABLE" VARCHAR2(20 BYTE),
"DATETIME" VARCHAR2(20 BYTE),
"ENDTIME" VARCHAR2(20 BYTE)
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ;
COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."TYPE" IS '类型1:折扣 2 :减免';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."AMOUNT" IS '(1.累计金额)(2.减免金额)';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."END_AMOUNT" IS '(剩余累计金额)';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."WID" IS '福利ID';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."CUSTOMID" IS '会员ID';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."LV" IS '会员等级 ';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."GID" IS '福利类型ID';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."FREQUENCY" IS '次数或者折扣力度';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."END_FREQUENCY" IS '剩余次数';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."ENABLE" IS '1.启用 2.关闭';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."DATETIME" IS '添加时间';
COMMENT ON COLUMN "TONGBAO"."T_WELFARE_CUSTOM"."ENDTIME" IS '关闭时间';
CREATE TABLE "TONGBAO"."T_TAGS"
( "ID" NUMBER(20,0),
"COUTENT" VARCHAR2(2000 BYTE),
"TITLE" VARCHAR2(2000 BYTE),
"NUMBERS" NUMBER(14,0),
"USERNAME" VARCHAR2(200 BYTE),
"USERID" NUMBER(20,0),
"DATETIME" VARCHAR2(20 BYTE)
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ;
COMMENT ON COLUMN "TONGBAO"."T_TAGS"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_TAGS"."COUTENT" IS '内容描述';
COMMENT ON COLUMN "TONGBAO"."T_TAGS"."TITLE" IS '标题';
COMMENT ON COLUMN "TONGBAO"."T_TAGS"."NUMBERS" IS '人数';
COMMENT ON COLUMN "TONGBAO"."T_TAGS"."USERNAME" IS '创建人';
COMMENT ON COLUMN "TONGBAO"."T_TAGS"."USERID" IS '创建人ID';
COMMENT ON COLUMN "TONGBAO"."T_TAGS"."DATETIME" IS '创建时间';
alter table t_tags add status VARCHAR2(20) DEFAULT 1;
CREATE TABLE "TONGBAO"."T_WHITE_LIST"
( "ID" NUMBER(20,0) NOT NULL ENABLE,
"CUSTOMID" CHAR(8 BYTE) NOT NULL ENABLE,
"LARGE_STATUS" VARCHAR2(20 BYTE),
"TEST_STATUS" VARCHAR2(20 BYTE),
"RANSOM_STATUS" VARCHAR2(20 BYTE),
"USERID" VARCHAR2(20 BYTE),
"USERNAME" VARCHAR2(20 BYTE),
"DATETIME" VARCHAR2(20 BYTE),
CONSTRAINT "T_WHITE_LIST_PK" PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ENABLE
) SEGMENT CREATION DEFERRED
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
TABLESPACE "TONGBAO" ;
COMMENT ON COLUMN "TONGBAO"."T_WHITE_LIST"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_WHITE_LIST"."CUSTOMID" IS '会员ID';
COMMENT ON COLUMN "TONGBAO"."T_WHITE_LIST"."LARGE_STATUS" IS '大额状态 1:启用2:禁用';
COMMENT ON COLUMN "TONGBAO"."T_WHITE_LIST"."TEST_STATUS" IS '测试状态 1:启用2:禁用';
COMMENT ON COLUMN "TONGBAO"."T_WHITE_LIST"."RANSOM_STATUS" IS '赎回状态 1:启用2:禁用';
COMMENT ON COLUMN "TONGBAO"."T_WHITE_LIST"."USERID" IS '创建人ID';
COMMENT ON COLUMN "TONGBAO"."T_WHITE_LIST"."USERNAME" IS '创建人姓名';
COMMENT ON COLUMN "TONGBAO"."T_WHITE_LIST"."DATETIME" IS '添加时间';
alter table t_custom_class add numbers NUMBER(12) DEFAULT 0;
CREATETABLE"TONGBAO"."T_FREE_ORDER"
(
"ID"CHAR(10 BYTE) NOTNULLENABLE,
"OUT_ORDER"VARCHAR2(100 BYTE) DEFAULT 0,
"FREE_NUM"VARCHAR2(50 BYTE) NOTNULLENABLE,
"AMOUNT"NUMBER(10,2) DEFAULT 0,
"TYPE"VARCHAR2(20 BYTE) NOTNULLENABLE,
"PANTERID"CHAR(8 BYTE) NOTNULLENABLE,
"CUSTOMID"CHAR(8 BYTE) NOTNULLENABLE,
"FREE_LV"VARCHAR2(100 BYTE),
"FREE_AMOUNT"NUMBER(10,2) DEFAULT 0,
"STATUS"VARCHAR2(20 BYTE) NOTNULLENABLE,
"ORDERTIME"VARCHAR2(20 BYTE) NOTNULLENABLE,
"DATETIME"VARCHAR2(20 BYTE) NOTNULLENABLE,
"UPDATETIME"VARCHAR2(20 BYTE) NOTNULLENABLE,
CONSTRAINT"T_FREE_ORDER_PK"PRIMARYKEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536NEXT1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "JYCARD"ENABLE
) SEGMENT CREATION IMMEDIATE
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536NEXT1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "TONGBAO" ;
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."OUT_ORDER" IS '消费订单号';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."FREE_NUM" IS '免单订单号';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."AMOUNT" IS '消费金额';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."TYPE" IS '免单的类型 1: 自有资金 2: 备付金（至尊卡）3 通宝 4 通宝+';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."PANTERID" IS '商户id';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."CUSTOMID" IS '会员id';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."FREE_LV" IS '免单等级';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."FREE_AMOUNT" IS '免单金额';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."ID" IS 'ID';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."STATUS" IS '类型 1 申请免单，2免单成功 3，免单失败 ';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."ORDERTIME" IS '消费订单的时间';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."DATETIME" IS '下单的时间';
COMMENT ON COLUMN "TONGBAO"."T_FREE_ORDER"."UPDATETIME" IS '更新的时间';
createsequence seq_free_order_id
increment by1
startwith1
NOMAXVALUE
NOMINVALUE
NOCACHE;
alter table T_CONSUME add SUBSIDY VARCHAR2(100 BYTE);
COMMENT ON COLUMN "TONGBAO"."T_CONSUME"."SUBSIDY" IS '补贴';
alter table T_CONSUME add ORIGINAL_PRICEVARCHAR2(100 BYTE);
COMMENT ON COLUMN "TONGBAO"."T_CONSUME"."ORIGINAL_PRICE" IS '折扣前订单金额';
alter table T_CONSUME_BACK add SUBSIDY VARCHAR2(100 BYTE);
COMMENT ON COLUMN "TONGBAO"."T_CONSUME_BACK"."SUBSIDY" IS '补贴';
- 通宝+后台
- 新数据字典
- 测试数据库配置
- 核心账户改造需求文档
- 物业霸王餐
- 物业霸王餐上线流程
- 4月27版本上线数据库变动情况
- 5月7日2.22版本上线数据库变动情况
- 5月7日2.22版本上线须知
- 5月26日2.23版本数据库变动情况
- 6月9日2.24版本数据库变动情况
- 7月22日2.25版本数据库变动情况
- 9月4日2.26版本数据库变动情况
- 11月11日添加汇款规则设置
- 20.11.23大额转账转用大额组件
- 20.11.25监控mns异常消息
- 20.12.04 通宝+入口限制
- 20.12.24 3.0通宝+阶梯利率
- 21.01.08 通宝+迁移景安方案
- 21.01.29 物业霸王餐2.0
- 21.02.02 结算添加88折补贴金额
- 21.03.22 大额汇款赠送活动增加限制条件
- 21.05.20 代他付
- 21.06.28 充值对账
- 21.07.03 添加折扣退款补贴
- 8月14版本,前端icon优化
- D0对账
- 账户注销
- 通宝+充值作废
- 通宝+商家商户信息
- 上线注意事项
- 上线执行sql语句
- 物业缴费
- 1.查询用户欠费绑定的信息
- 2.1手机号查询信息接口