XieYingFa commented on issue #6448:
URL:
https://github.com/apache/incubator-seata/issues/6448#issuecomment-2041323794
@slievrly
表结构如下：
-- Create table
create table MALLCARD.QST_MALLCARD_INFO
(
id VARCHAR2(36) not null,
card_no VARCHAR2(30) not null,
active_date DATE,
create_date DATE default sysdate not null,
expire_date DATE,
status NUMBER not null,
mercard_id VARCHAR2(36),
mem_id VARCHAR2(36),
amount NUMBER(18,2),
ori_amount NUMBER(18,2),
mer_id VARCHAR2(36),
freeze_amount NUMBER(18,2),
card_discount NUMBER(4,2),
ori_cardid VARCHAR2(36),
card_type NUMBER(2),
card_kind NUMBER,
nonce_str VARCHAR2(19),
card_qr_inf VARCHAR2(100),
sequence_number VARCHAR2(9),
track_info VARCHAR2(200),
industry_no VARCHAR2(3),
first_charge NUMBER(1) default 0,
is_fee NUMBER default 1,
fee_date DATE,
legal_id_num VARCHAR2(30),
legal_card_positive VARCHAR2(200),
legal_card_negative VARCHAR2(200),
auth_flag NUMBER(1) default 0,
auth_date DATE,
real_name VARCHAR2(100),
virtual_fee NUMBER(8,2) default 0,
virtual_fee_version_no NUMBER default 0,
sale_card_status NUMBER default 0,
card_type_id VARCHAR2(20),
bind_date DATE,
get_hxq_rate NUMBER(22,6) default 0,
ele_account_no VARCHAR2(30),
bind_amount NUMBER(18,2),
policy_id VARCHAR2(36),
card_upgrade NUMBER(6,2),
cd_key VARCHAR2(200),
upgrade_status NUMBER default 0,
bind_card_disable VARCHAR2(30) default 1,
transfer_flag NUMBER default 2,
frozen_date DATE,
agent_no VARCHAR2(10),
limit_type NUMBER,
card_recycle NUMBER,
limit_value NUMBER(6,2),
buy_flag NUMBER,
price_type NUMBER default 1,
wx_flag NUMBER,
frozen_reason VARCHAR2(255),
unfrozen_date DATE,
unfrozen_reason VARCHAR2(255),
frozen_update_by VARCHAR2(50),
update_date DATE,
unfrozen_update_by VARCHAR2(50),
combine_pay_flag NUMBER,
total_limit_amount NUMBER(18,2),
limit_amount NUMBER(18,2),
bind_before_is_ava NUMBER default 0,
card_category NUMBER default 1,
user_type NUMBER,
operator VARCHAR2(36),
update_expire_date DATE,
exchange_num NUMBER,
original_card_no VARCHAR2(30),
movie_coupon_superpose NUMBER default 1,
is_card_group INTEGER default 0,
purchase_company VARCHAR2(500),
card_sell_order_no VARCHAR2(500),
risk_policy_id VARCHAR2(36),
remark VARCHAR2(1000)
)
tablespace MALLCARD
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Create/Recreate indexes
create index IDX_NALLCARD_CARD_NO on MALLCARD.QST_MALLCARD_INFO (CARD_NO);
create index IDX_NALLCARD_MEM_ID on MALLCARD.QST_MALLCARD_INFO (MEM_ID);
create index IDX_NALLCARD_MERCARD_ID on MALLCARD.QST_MALLCARD_INFO
(MERCARD_ID);
create index MALLCARD.idx_active_date on MALLCARD.QST_MALLCARD_INFO
(ACTIVE_DATE);
-- Create/Recreate primary, unique and foreign key constraints
alter table MALLCARD.QST_MALLCARD_INFO
add primary key (ID)
using index ;
-- Grant/Revoke object privileges
grant select, update on MALLCARD.QST_MALLCARD_INFO to YFCUSR;
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
