angelo
/
java-retail-app
3
0
Fork 1
Code Issues Pull Requests Packages Projects Releases Wiki Activity
java-retail-app/文档/sql/member.sql

1664 lines
46 KiB
MySQL
Raw Permalink Normal View History

## 初始化；
2025-03-23 09:44:16 +08:00
-- Create table 会员信息
create table CU_MEMBER
(
pk_id NUMBER(20) not null,
member_code VARCHAR2(20) not null,
member_name VARCHAR2(100) not null,
category NUMBER(2) default 0 not null
customer_type NUMBER(2) not null,
phone VARCHAR2(20),
id_card VARCHAR2(30),
sex NUMBER(1),
birth_date DATE,
pk_country NUMBER(4) not null,
pk_settle_country NUMBER(4) not null,
parent VARCHAR2(20) not null,
place_parent VARCHAR2(20),
place_dept number(1),
team_code VARCHAR2(20),
center_code VARCHAR2(20) not null,
source NUMBER(2) not null,
province NUMBER(6),
city NUMBER(6),
county NUMBER(6),
address VARCHAR2(200),
pk_register_grade NUMBER(4) not null,
pk_settle_grade NUMBER(4) not null,
pk_awards NUMBER(4) DEFAULT 0 not null ,
consume_achieve NUMBER(15,4) default 0 not null,
purchase_status NUMBER(2) default 0 not null,
share_status NUMBER(2) default 0 not null,
pay_time DATE,
pay_status number(2) default 0 not null
login_pwd VARCHAR2(100) not null,
pay_pwd VARCHAR2(100) not null,
login_password VARCHAR2(50) not null,
pay_password VARCHAR2(50) not null,
edit_number NUMBER(4) default 0 not null,
del_flag NUMBER(1) default 0 not null,
pkCreator VARCHAR2(50) not null,
creation_time DATE default sysdate not null,
pkModified VARCHAR2(50),
modified_time DATE,
register_authority NUMBER(6) default 0 not null,
vertex VARCHAR2(20),
account_status NUMBER(1) default 0 not null,
pay_status NUMBER(2) default 0 not null,
category NUMBER(2) default 0 not null,
email VARCHAR2(50)
)
tablespace CLOUD
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Add comments to the table
comment on table CU_MEMBER
is '会员信息';
-- Add comments to the columns
comment on column CU_MEMBER.pk_id
is '用户ID';
comment on column CU_MEMBER.member_code
is '会员编号';
comment on column CU_MEMBER.member_name
is '会员名称';
comment on column CU_MEMBER.customer_type
is '会员类型（0.正常 1.空单 2.死点 4.嗨粉 5.商城小程序游客）';
comment on column CU_MEMBER.customer_type
is '会员类型（0.正常 1.空单 2.死点 4.嗨粉 5.商城小程序游客）';
comment on column CU_MEMBER.phone
is '手机号码';
comment on column CU_MEMBER.id_card
is '证件号码';
comment on column CU_MEMBER.sex
is '性别（0=未知,1=男,2=女）';
comment on column CU_MEMBER.birth_date
is '出生日期（年月日）';
comment on column CU_MEMBER.pk_country
is '自然国';
comment on column CU_MEMBER.pk_settle_country
is '结算国';
comment on column CU_MEMBER.parent
is '推荐人编号';
comment on column CU_MEMBER.place_parent
is '安置人编号';
comment on column CU_MEMBER.place_dept
is '安置部门';
comment on column CU_MEMBER.team_code
is '所属团队编号';
comment on column CU_MEMBER.center_code
is '报单中心编号';
comment on column CU_MEMBER.source
is '数据来源（1=PC端,2=H5,5=报单公众号,6=商城小程序,7=报单APP,8=商城APP）';
comment on column CU_MEMBER.province
is '注册省';
comment on column CU_MEMBER.city
is '注册市';
comment on column CU_MEMBER.county
is '注册县';
comment on column CU_MEMBER.address
is '注册地址';
comment on column CU_MEMBER.pk_register_grade
is '注册等级';
comment on column CU_MEMBER.pk_settle_grade
is '结算等级';
comment on column CU_MEMBER.pk_awards
is '真实奖衔';
comment on column CU_MEMBER.consume_achieve
is '消费业绩';
comment on column CU_MEMBER.purchase_status
is '是否复购考核状态（0=是,1=否）';
comment on column CU_MEMBER.share_status
is '是否分红考核状态（0=是,1=否）';
comment on column CU_MEMBER.pay_time
is '支付时间';
comment on column CU_MEMBER.pay_status
is '支付状态 (0=未支付,1=已支付)';
comment on column CU_MEMBER.login_pwd
is '登录密码';
comment on column CU_MEMBER.pay_pwd
is '支付密码';
comment on column CU_MEMBER.login_password
is '登录密码明文';
comment on column CU_MEMBER.pay_password
is '支付密码明文';
comment on column CU_MEMBER.edit_number
is '修改次数';
comment on column CU_MEMBER.del_flag
is '逻辑删除 (0=未删除,1已删除)';
comment on column CU_MEMBER.pkCreator
is '创建人';
comment on column CU_MEMBER.creation_time
is '创建时间';
comment on column CU_MEMBER.pkModified
is '修改人';
comment on column CU_MEMBER.modified_time
is '修改时间';
comment on column CU_MEMBER.register_authority
is '注册权限（0=普通用户,1=报单中心,2=服务中心）';
comment on column CU_MEMBER.vertex
is '顶点编号';
comment on column CU_MEMBER.account_status
is '账户状态（0=正常,1=冻结,2=封停）';
comment on column CU_MEMBER.pay_status
is '支付状态 (0=未支付,1=已支付)';
comment on column CU_MEMBER.category
is '用户类型分类（0=正常（正常 空单 嗨粉） 1=死点（死点））';
comment on column CU_MEMBER.email
is '邮箱';
-- Create/Recreate indexes
create unique index MEMBER_MEMBER_CODE on CU_MEMBER (MEMBER_CODE)
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table CU_MEMBER
add constraint CU_MEMBER_PK primary key (PK_ID)
using index
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
create sequence CU_MEMBER_SEQ
minvalue 1
maxvalue 999999999999999999999999
start with 1
increment by 1
cache 20;
-- Create table 会员注册信息
create table CU_MEMBER_REGISTER
(
pk_id NUMBER(20) not null,
member_code VARCHAR2(30) not null,
member_name VARCHAR2(100) not null,
customer_type NUMBER(2) not null,
phone VARCHAR2(20),
id_card VARCHAR2(30),
sex NUMBER(1),
birth_date DATE,
pk_country NUMBER(4) not null,
pk_settle_country NUMBER(4) not null,
parent VARCHAR2(20) not null,
place_parent VARCHAR2(20),
place_dept number(2),
team_code VARCHAR2(20),
center_code VARCHAR2(20) not null,
source NUMBER(2) not null,
province NUMBER(6),
city NUMBER(6),
county NUMBER(6),
address VARCHAR2(200),
pk_register_grade NUMBER(4) not null,
consume_achieve NUMBER(15,4) default 0 not null,
pay_time DATE,
del_flag NUMBER(1) default 0 not null,
pkCreator VARCHAR2(50) not null,
creation_time DATE default sysdate not null,
pkModified VARCHAR2(50),
modified_time DATE,
vertex VARCHAR2(20)
)
tablespace CLOUD
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Add comments to the table
comment on table CU_MEMBER_REGISTER
is '会员信息-注册信息';
-- Add comments to the columns
comment on column CU_MEMBER_REGISTER.pk_id
is '用户ID';
comment on column CU_MEMBER_REGISTER.member_code
is '会员编号';
comment on column CU_MEMBER_REGISTER.member_name
is '会员名称';
comment on column CU_MEMBER_REGISTER.customer_type
is '会员类型（0.正常 1.空单 2.死点 4.嗨粉 5.商城小程序游客）';
comment on column CU_MEMBER_REGISTER.phone
is '手机号码';
comment on column CU_MEMBER_REGISTER.id_card
is '证件号码';
comment on column CU_MEMBER_REGISTER.sex
is '性别（0=未知,1=男,2=女）';
comment on column CU_MEMBER_REGISTER.birth_date
is '出生日期（年月日）';
comment on column CU_MEMBER_REGISTER.pk_country
is '自然国';
comment on column CU_MEMBER_REGISTER.pk_settle_country
is '结算国';
comment on column CU_MEMBER_REGISTER.parent
is '推荐人编号';
comment on column CU_MEMBER_REGISTER.place_parent
is '安置人编号';
comment on column CU_MEMBER_REGISTER.place_dept
is '安置部门';
comment on column CU_MEMBER_REGISTER.team_code
is '所属团队编号';
comment on column CU_MEMBER_REGISTER.center_code
is '报单中心编号';
comment on column CU_MEMBER_REGISTER.source
is '数据来源（1=PC端,2=H5,5=报单公众号,6=商城小程序,7=报单APP,8=商城APP）';
comment on column CU_MEMBER_REGISTER.province
is '注册省';
comment on column CU_MEMBER_REGISTER.city
is '注册市';
comment on column CU_MEMBER_REGISTER.county
is '注册县';
comment on column CU_MEMBER_REGISTER.address
is '注册地址';
comment on column CU_MEMBER_REGISTER.pk_register_grade
is '注册等级';
comment on column CU_MEMBER_REGISTER.consume_achieve
is '消费业绩';
comment on column CU_MEMBER_REGISTER.del_flag
is '逻辑删除 (0=未删除,1已删除)';
comment on column CU_MEMBER_REGISTER.pkCreator
is '创建人';
comment on column CU_MEMBER_REGISTER.creation_time
is '创建时间';
comment on column CU_MEMBER_REGISTER.pkModified
is '修改人';
comment on column CU_MEMBER_REGISTER.modified_time
is '修改时间';
comment on column CU_MEMBER_REGISTER.vertex
is '顶点编号';
-- Create/Recreate indexes
create unique index CU_MEMBER_REGISTER_MEMBER_CODE on CU_MEMBER_REGISTER (MEMBER_CODE)
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table CU_MEMBER_REGISTER
add constraint CU_MEMBER_REGISTER_PK primary key (PK_ID)
using index
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
create sequence CU_MEMBER_REGISTER_SEQ
minvalue 1
maxvalue 999999999999999999999999
start with 1
increment by 1
cache 20;
-- Create table 会员登录记录
create table CU_MEMBER_LOGIN
(
pk_id NUMBER(20) not null,
member_code VARCHAR2(20) not null,
login_id VARCHAR2(128) not null,
login_time DATE default sysdate not null,
login_device VARCHAR2(2),
status NUMBER(1) not null,
message VARCHAR2(50)
)
tablespace CLOUD
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 256K
next 256K
minextents 1
maxextents unlimited
pctincrease 0
);
-- Add comments to the table
comment on table CU_MEMBER_LOGIN
is '会员登录记录';
-- Add comments to the columns
comment on column CU_MEMBER_LOGIN.pk_id
is '主键ID';
comment on column CU_MEMBER_LOGIN.member_code
is '会员编号';
comment on column CU_MEMBER_LOGIN.login_id
is '登录IP';
comment on column CU_MEMBER_LOGIN.login_time
is '登录时间';
comment on column CU_MEMBER_LOGIN.login_device
is '登录设备';
comment on column CU_MEMBER_LOGIN.status
is '状态（0=成功,1=失败）';
comment on column CU_MEMBER_LOGIN.message
is '消息内容';
-- Create/Recreate indexes
create index MEMBER_LOGIN_MEMBER_CODE on CU_MEMBER_LOGIN (MEMBER_CODE)
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 256K
next 256K
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table CU_MEMBER_LOGIN
add constraint CU_MEMBER_LOGIN_PK primary key (PK_ID)
using index
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 256K
next 256K
minextents 1
maxextents unlimited
pctincrease 0
);
create sequence CU_MEMBER_LOGIN_SEQ
minvalue 1
maxvalue 999999999999999999999999
start with 1
increment by 1
cache 20;
-- Create table 会员密码修改记录
create table CU_MEMBER_PASSWORD
(
pk_id NUMBER(20) not null,
member_code VARCHAR2(20) not null,
edit_type NUMBER(2) not null,
old_value VARCHAR2(50) not null,
new_value VARCHAR2(50) not null,
del_flag NUMBER(1) default 0 not null,
pkCreator VARCHAR2(50) not null,
creation_time DATE default sysdate not null,
pkModified VARCHAR2(50),
modified_time DATE,
pk_country NUMBER(4) not null
)
tablespace CLOUD
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 256K
next 256K
minextents 1
maxextents unlimited
pctincrease 0
);
-- Add comments to the table
comment on table CU_MEMBER_PASSWORD
is '会员更名、密码修改表';
-- Add comments to the columns
comment on column CU_MEMBER_PASSWORD.pk_id
is '主键';
comment on column CU_MEMBER_PASSWORD.member_code
is '会员编号';
comment on column CU_MEMBER_PASSWORD.edit_type
is '修改类型（0=忘记密码,1=修改登录密码,2=修改支付密码,3=更改姓名,4=修改手机号）';
comment on column CU_MEMBER_PASSWORD.old_value
is '原值';
comment on column CU_MEMBER_PASSWORD.new_value
is '新值';
comment on column CU_MEMBER_PASSWORD.del_flag
is '逻辑删除 (0=未删除,1已删除)';
comment on column CU_MEMBER_PASSWORD.pkCreator
is '创建人';
comment on column CU_MEMBER_PASSWORD.creation_time
is '创建时间';
comment on column CU_MEMBER_PASSWORD.pkModified
is '修改人';
comment on column CU_MEMBER_PASSWORD.modified_time
is '修改时间';
comment on column CU_MEMBER_PASSWORD.pk_country
is '国家';
-- Create/Recreate indexes
create index MEMBER_PASSWORD_MEMBER_CODE on CU_MEMBER_PASSWORD (MEMBER_CODE)
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255;
-- Create/Recreate primary, unique and foreign key constraints
alter table CU_MEMBER_PASSWORD
add constraint CU_MEMBER_PASSWORD_PK primary key (PK_ID)
using index
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255;
create sequence CU_MEMBER_PASSWORD_SEQ
minvalue 1
maxvalue 999999999999999999999999
start with 1
increment by 1
cache 20;
-- Create table
create table CU_MEMBER_AGENT
(
pk_id NUMBER(20) not null,
member_code VARCHAR2(20) not null,
agent_type VARCHAR2(100) not null,
agent_province NUMBER(6) not null,
agent_city NUMBER(6),
agent_county NUMBER(6),
agent_grade NUMBER(6),
del_flag NUMBER(1) default 0 not null,
pkCreator VARCHAR2(50) not null,
creation_time DATE default sysdate not null,
pkModified VARCHAR2(50),
modified_time DATE,
pk_country NUMBER(4) not null
)
tablespace CLOUD
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Add comments to the table
comment on table CU_MEMBER_AGENT
is '会员信息-代理商信息';
-- Add comments to the columns
comment on column CU_MEMBER_AGENT.pk_id
is '主键';
comment on column CU_MEMBER_AGENT.member_code
is '会员编号';
comment on column CU_MEMBER_AGENT.agent_type
is '代理类型 (1=代理商,2=店铺)';
comment on column CU_MEMBER_AGENT.agent_province
is '省';
comment on column CU_MEMBER_AGENT.agent_city
is '市';
comment on column CU_MEMBER_AGENT.agent_county
is '县';
comment on column CU_MEMBER_AGENT.agent_grade
is '级别来源(1=代理商级别, 2=店铺级别)';
comment on column CU_MEMBER_AGENT.del_flag
is '逻辑删除 (0=未删除,1已删除)';
comment on column CU_MEMBER_AGENT.pkCreator
is '创建人';
comment on column CU_MEMBER_AGENT.creation_time
is '创建时间';
comment on column CU_MEMBER_AGENT.pkModified
is '修改人';
comment on column CU_MEMBER_AGENT.modified_time
is '修改时间';
comment on column CU_MEMBER_AGENT.pk_country
is '国家';
-- Create/Recreate indexes
create unique index CU_MEMBER_AGENT_MEMBER_CODE on CU_MEMBER_AGENT (MEMBER_CODE)
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table CU_MEMBER_AGENT
add constraint CU_MEMBER_AGENT_PK primary key (PK_ID)
using index
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
create sequence CU_MEMBER_AGENT_SEQ
minvalue 1
maxvalue 999999999999999999999999
start with 1
increment by 1
cache 20;
-- Create table 会员银行卡信息
create table CU_MEMBER_BANK
(
pk_id NUMBER(20) not null,
member_code VARCHAR2(20) not null,
deposit_bank NUMBER(4) not null,
account_name VARCHAR2(100) not null,
card_number VARCHAR2(50) not null,
id_card VARCHAR2(30) not null,
phone VARCHAR2(20) not null,
del_flag NUMBER(1) default 0 not null,
pkCreator VARCHAR2(50) not null,
creation_time DATE default sysdate not null,
pkModified VARCHAR2(50),
modified_time DATE,
pk_country NUMBER(4) not null
)
tablespace CLOUD
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Add comments to the table
comment on table CU_MEMBER_BANK
is '会员信息-银行卡信息';
-- Add comments to the columns
comment on column CU_MEMBER_BANK.pk_id
is '主键';
comment on column CU_MEMBER_BANK.member_code
is '会员编号';
comment on column CU_MEMBER_BANK.deposit_bank
is '开户银行';
comment on column CU_MEMBER_BANK.account_name
is '开户姓名';
comment on column CU_MEMBER_BANK.card_number
is '银行卡号';
comment on column CU_MEMBER_BANK.id_card
is '身份证号';
comment on column CU_MEMBER_BANK.phone
is '手机号';
comment on column CU_MEMBER_BANK.del_flag
is '逻辑删除 (0=未删除,1已删除)';
comment on column CU_MEMBER_BANK.pkCreator
is '创建人';
comment on column CU_MEMBER_BANK.creation_time
is '创建时间';
comment on column CU_MEMBER_BANK.pkModified
is '修改人';
comment on column CU_MEMBER_BANK.modified_time
is '修改时间';
comment on column CU_MEMBER_BANK.pk_country
is '国家';
-- Create/Recreate indexes
create index CU_MEMBER_BANK_MEMBER_CODE on CU_MEMBER_BANK (MEMBER_CODE)
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table CU_MEMBER_BANK
add constraint CU_MEMBER_BANK_PK primary key (PK_ID)
using index
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
create sequence CU_MEMBER_BANK_SEQ
minvalue 1
maxvalue 999999999999999999999999
start with 1
increment by 1
cache 20;
-- Create table 收货地址
create table CU_MEMBER_RECEIVING
(
pk_id NUMBER(20) not null,
member_code VARCHAR2(20) not null,
rec_address VARCHAR2(200) not null,
rec_name VARCHAR2(100) not null,
rec_phone VARCHAR2(20) not null,
rec_province NUMBER(20) not null,
rec_city NUMBER(20),
rec_county NUMBER(20),
is_default NUMBER(1) default 1 not null,
del_flag NUMBER(1) default 0 not null,
pkCreator VARCHAR2(50) not null,
creation_time DATE default sysdate not null,
pkModified VARCHAR2(50),
modified_time DATE,
pk_country NUMBER(4) not null
)
tablespace CLOUD
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 256K
next 256K
minextents 1
maxextents unlimited
pctincrease 0
);
-- Add comments to the table
comment on table CU_MEMBER_RECEIVING
is '会员收货信息';
-- Add comments to the columns
comment on column CU_MEMBER_RECEIVING.pk_id
is '主键';
comment on column CU_MEMBER_RECEIVING.member_code
is '会员编号';
comment on column CU_MEMBER_RECEIVING.rec_address
is '收货地址';
comment on column CU_MEMBER_RECEIVING.rec_name
is '收货人';
comment on column CU_MEMBER_RECEIVING.rec_phone
is '收货人手机';
comment on column CU_MEMBER_RECEIVING.rec_province
is '收货省';
comment on column CU_MEMBER_RECEIVING.rec_city
is '收货市';
comment on column CU_MEMBER_RECEIVING.rec_county
is '收货县';
comment on column CU_MEMBER_RECEIVING.is_default
is '是否默认（0=是,1=否）';
comment on column CU_MEMBER_RECEIVING.del_flag
is '逻辑删除 (0=未删除,1已删除)';
comment on column CU_MEMBER_RECEIVING.pkCreator
is '创建人';
comment on column CU_MEMBER_RECEIVING.creation_time
is '创建时间';
comment on column CU_MEMBER_RECEIVING.pkModified
is '修改人';
comment on column CU_MEMBER_RECEIVING.modified_time
is '修改时间';
comment on column CU_MEMBER_RECEIVING.pk_country
is '自然国';
-- Create/Recreate indexes
create index MEMBER_RECEIVING_MEMBER_CODE on CU_MEMBER_RECEIVING (MEMBER_CODE)
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255;
-- Create/Recreate primary, unique and foreign key constraints
alter table CU_MEMBER_RECEIVING
add constraint CU_MEMBER_RECEIVING_PK primary key (PK_ID)
using index
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255;
create sequence CU_MEMBER_RECEIVING_SEQ
minvalue 1
maxvalue 999999999999999999999999
start with 1
increment by 1
cache 20;
-- Create table 礼包收货地址
create table CU_MEMBER_GIFT
(
pk_id NUMBER(20) not null,
member_code VARCHAR2(20) not null,
gift_address VARCHAR2(200) not null,
gift_name VARCHAR2(100) not null,
gift_phone VARCHAR2(20) not null,
gift_province NUMBER(20) not null,
gift_city NUMBER(20),
gift_county NUMBER(20),
del_flag NUMBER(1) default 0 not null,
pkCreator VARCHAR2(50) not null,
creation_time DATE default sysdate not null,
pkModified VARCHAR2(50),
modified_time DATE,
pk_country NUMBER(4) not null
)
tablespace CLOUD
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 256K
next 256K
minextents 1
maxextents unlimited
pctincrease 0
);
-- Add comments to the table
comment on table CU_MEMBER_GIFT
is '会员礼包收货地址';
-- Add comments to the columns
comment on column CU_MEMBER_GIFT.pk_id
is '主键';
comment on column CU_MEMBER_GIFT.member_code
is '会员编号';
comment on column CU_MEMBER_GIFT.gift_address
is '收货地址';
comment on column CU_MEMBER_GIFT.gift_name
is '收货人';
comment on column CU_MEMBER_GIFT.gift_phone
is '收货人手机';
comment on column CU_MEMBER_GIFT.gift_province
is '收货省';
comment on column CU_MEMBER_GIFT.gift_city
is '收货市';
comment on column CU_MEMBER_GIFT.gift_county
is '收货县';
comment on column CU_MEMBER_GIFT.del_flag
is '逻辑删除 (0=未删除,1已删除)';
comment on column CU_MEMBER_GIFT.pkCreator
is '创建人';
comment on column CU_MEMBER_GIFT.creation_time
is '创建时间';
comment on column CU_MEMBER_GIFT.pkModified
is '修改人';
comment on column CU_MEMBER_GIFT.modified_time
is '修改时间';
comment on column CU_MEMBER_GIFT.pk_country
is '自然国';
-- Create/Recreate primary, unique and foreign key constraints
alter table CU_MEMBER_GIFT
add constraint CU_MEMBER_GIFT_PK primary key (PK_ID)
using index
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255;
create sequence CU_MEMBER_GIFT_SEQ
minvalue 1
maxvalue 999999999999999999999999
start with 1
increment by 1
cache 20;
-- Create table 会员账户信息
create table CU_MEMBER_ACCOUNT
(
pk_id NUMBER(20) not null,
member_code VARCHAR2(30) not null,
account1 NUMBER(17,6) default 0 not null,
lock_account1 NUMBER(17,6) default 0 not null,
account2 NUMBER(17,6) default 0 not null,
lock_account2 NUMBER(17,6) default 0 not null,
account3 NUMBER(17,6) default 0 not null,
lock_account3 NUMBER(17,6) default 0 not null,
account4 NUMBER(17,6) default 0 not null,
lock_account4 NUMBER(17,6) default 0 not null,
withdraw_account4 NUMBER(17,6) default 0 not null,
consume_account4 NUMBER(17,6) default 0 not null,
account5 NUMBER(17,6) default 0 not null,
lock_account5 NUMBER(17,6) default 0 not null,
account6 NUMBER(17,6) default 0 not null,
lock_account6 NUMBER(17,6) default 0 not null,
account7 NUMBER(17,6) default 0 not null,
lock_account7 NUMBER(17,6) default 0 not null,
account8 NUMBER(17,6) default 0 not null,
lock_account8 NUMBER(17,6) default 0 not null,
account9 NUMBER(17,6) default 0 not null,
lock_account9 NUMBER(17,6) default 0 not null,
account10 NUMBER(17,6) default 0 not null,
lock_account10 NUMBER(17,6) default 0 not null,
account11 NUMBER(17,6) default 0 not null,
account12 NUMBER(17,6) default 0 not null,
account13 NUMBER(17,6) default 0 not null,
account14 NUMBER(17,6) default 0 not null,
account15 NUMBER(17,6) default 0 not null,
account16 NUMBER(17,6) default 0 not null,
account17 NUMBER(17,6) default 0 not null,
account18 NUMBER(17,6) default 0 not null,
account19 NUMBER(17,6) default 0 not null,
account20 NUMBER(17,6) default 0 not null,
wallet_status NUMBER(1) default 0 not null,
del_flag NUMBER(1) default 0 not null,
pkCreator VARCHAR2(50) not null,
creation_time DATE default sysdate not null,
pkModified VARCHAR2(50),
modified_time DATE,
pk_country NUMBER(4) not null
)
tablespace CLOUD
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 256K
next 256K
minextents 1
maxextents unlimited
pctincrease 0
);
-- Add comments to the table
comment on table CU_MEMBER_ACCOUNT
is '会员账户信息';
-- Add comments to the columns
comment on column CU_MEMBER_ACCOUNT.pk_id
is '主键ID';
comment on column CU_MEMBER_ACCOUNT.member_code
is '会员编号';
comment on column CU_MEMBER_ACCOUNT.account1
is '消费账户';
comment on column CU_MEMBER_ACCOUNT.account2
is '现金账户';
comment on column CU_MEMBER_ACCOUNT.account3
is '政策账户';
comment on column CU_MEMBER_ACCOUNT.account4
is '奖金账户';
comment on column CU_MEMBER_ACCOUNT.lock_account4
is '奖金锁定账户';
comment on column CU_MEMBER_ACCOUNT.withdraw_account4
is '可提现账户';
comment on column CU_MEMBER_ACCOUNT.consume_account4
is '可消费账户';
comment on column CU_MEMBER_ACCOUNT.account5
is '重消账户';
comment on column CU_MEMBER_ACCOUNT.account6
is '积分账户';
comment on column CU_MEMBER_ACCOUNT.account7
is '鼓励账户';
comment on column CU_MEMBER_ACCOUNT.account8
is '复购券账户';
comment on column CU_MEMBER_ACCOUNT.account9
is '预置账户9';
comment on column CU_MEMBER_ACCOUNT.account10
is '预置账户10';
comment on column CU_MEMBER_ACCOUNT.account11
is '预置账户11';
comment on column CU_MEMBER_ACCOUNT.account12
is '预置账户12';
comment on column CU_MEMBER_ACCOUNT.account13
is '预置账户13';
comment on column CU_MEMBER_ACCOUNT.account14
is '预置账户14';
comment on column CU_MEMBER_ACCOUNT.account15
is '预置账户15';
comment on column CU_MEMBER_ACCOUNT.account16
is '预置账户16';
comment on column CU_MEMBER_ACCOUNT.account17
is '预置账户17';
comment on column CU_MEMBER_ACCOUNT.account18
is '预置账户18';
comment on column CU_MEMBER_ACCOUNT.account19
is '预置账户19';
comment on column CU_MEMBER_ACCOUNT.account20
is '预置账户20';
comment on column CU_MEMBER_ACCOUNT.wallet_status
is '钱包状态（0=正常,1=锁定）';
comment on column CU_MEMBER_ACCOUNT.del_flag
is '逻辑删除 (0=未删除,1已删除)';
comment on column CU_MEMBER_ACCOUNT.pkCreator
is '创建人';
comment on column CU_MEMBER_ACCOUNT.creation_time
is '创建时间';
comment on column CU_MEMBER_ACCOUNT.pkModified
is '修改人';
comment on column CU_MEMBER_ACCOUNT.modified_time
is '修改时间';
comment on column CU_MEMBER_ACCOUNT.pk_country
is '国家';
comment on column CU_MEMBER_ACCOUNT.lock_account1
is '消费锁定账户';
comment on column CU_MEMBER_ACCOUNT.lock_account2
is '现金锁定账户';
-- Create/Recreate indexes
create unique index MEMBER_ACCOUNT_MEMBER_CODE on CU_MEMBER_ACCOUNT (MEMBER_CODE)
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 256K
next 256K
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table CU_MEMBER_ACCOUNT
add constraint CU_MEMBER_ACCOUNT_PK primary key (PK_ID)
using index
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 256K
next 256K
minextents 1
maxextents unlimited
pctincrease 0
);
create sequence cu_member_account_SEQ
minvalue 1
maxvalue 999999999999999999999999
start with 1
increment by 1
cache 20;
-- Create table 升级记录
create table CU_MEMBER_AWARDS
(
pk_id NUMBER(20) not null,
member_code VARCHAR2(20) not null,
period NUMBER(6) not null,
up_type NUMBER(2) not null,
old_level NUMBER(6) not null,
new_level NUMBER(6) not null,
remark VARCHAR2(200),
del_flag NUMBER(1) default 0 not null,
pkCreator VARCHAR2(50) not null,
creation_time DATE default sysdate not null,
pkModified VARCHAR2(50),
modified_time DATE,
pk_country NUMBER(4) not null
)
tablespace CLOUD
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Add comments to the table
comment on table CU_MEMBER_AWARDS
is '会员信息-奖衔升级记录';
-- Add comments to the columns
comment on column CU_MEMBER_AWARDS.pk_id
is '主键';
comment on column CU_MEMBER_AWARDS.member_code
is '会员编号';
comment on column CU_MEMBER_AWARDS.period
is '结算期间';
comment on column CU_MEMBER_AWARDS.up_type
is '升级类型 (1=自动升级,2=手动升级,3=购买赠予)';
comment on column CU_MEMBER_AWARDS.old_level
is '原等级';
comment on column CU_MEMBER_AWARDS.new_level
is '新等级';
comment on column CU_MEMBER_AWARDS.remark
is '备注';
comment on column CU_MEMBER_AWARDS.del_flag
is '逻辑删除 (0=未删除,1已删除)';
comment on column CU_MEMBER_AWARDS.pkCreator
is '创建人';
comment on column CU_MEMBER_AWARDS.creation_time
is '创建时间';
comment on column CU_MEMBER_AWARDS.pkModified
is '修改人';
comment on column CU_MEMBER_AWARDS.modified_time
is '修改时间';
comment on column CU_MEMBER_AWARDS.pk_country
is '国家';
-- Create/Recreate indexes
create index CU_MEMBER_AWARDS_MEMBER_CODE on CU_MEMBER_AWARDS (MEMBER_CODE)
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table CU_MEMBER_AWARDS
add constraint CU_MEMBER_AWARDS_PK primary key (PK_ID)
using index
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
create sequence CU_MEMBER_AWARDS_SEQ
minvalue 1
maxvalue 999999999999999999999999
start with 1
increment by 1
cache 20;
-- Create table 会员考核记录
create table CU_MEMBER_ASSESS
(
pk_id NUMBER(20) not null,
member_code VARCHAR2(20) not null,
settle_month VARCHAR2(10) not null,
assess_type NUMBER(2) not null,
pk_awards NUMBER(6) not null,
assess_target NUMBER(17,6) default 0 not null,
assess_status NUMBER(2) not null,
month_balance NUMBER(17,6) default 0 not null,
month_add NUMBER(17,6) default 0 not null,
month_used NUMBER(17,6) default 0 not null,
month_surplus NUMBER(17,6) default 0 not null,
del_flag NUMBER(1) default 0 not null,
pkCreator VARCHAR2(50) not null,
creation_time DATE default sysdate not null,
pkModified VARCHAR2(50),
modified_time DATE,
pk_country NUMBER(4) not null
)
tablespace CLOUD
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Add comments to the table
comment on table CU_MEMBER_ASSESS
is '会员信息-会员考核记录';
-- Add comments to the columns
comment on column CU_MEMBER_ASSESS.pk_id
is '主键';
comment on column CU_MEMBER_ASSESS.member_code
is '会员编号';
comment on column CU_MEMBER_ASSESS.settle_month
is '结算月';
comment on column CU_MEMBER_ASSESS.assess_type
is '考核类型( 0=复购考核,1=分红考核)';
comment on column CU_MEMBER_ASSESS.pk_awards
is '考核奖衔';
comment on column CU_MEMBER_ASSESS.assess_target
is '考核指标';
comment on column CU_MEMBER_ASSESS.assess_status
is '考核状态 (0=考核通过,1=免考通过,2=考核不通过,3=不考核)';
comment on column CU_MEMBER_ASSESS.month_balance
is '上月结余业绩';
comment on column CU_MEMBER_ASSESS.month_add
is '当月新增业绩';
comment on column CU_MEMBER_ASSESS.month_used
is '当月使用业绩';
comment on column CU_MEMBER_ASSESS.month_surplus
is '当月剩余业绩';
comment on column CU_MEMBER_ASSESS.del_flag
is '逻辑删除 (0=未删除,1已删除)';
comment on column CU_MEMBER_ASSESS.pkCreator
is '创建人';
comment on column CU_MEMBER_ASSESS.creation_time
is '创建时间';
comment on column CU_MEMBER_ASSESS.pkModified
is '修改人';
comment on column CU_MEMBER_ASSESS.modified_time
is '修改时间';
comment on column CU_MEMBER_ASSESS.pk_country
is '国家';
-- Create/Recreate indexes
create index CU_ASSESSMENT_MEMBER_CODE on CU_MEMBER_ASSESS (MEMBER_CODE)
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table CU_MEMBER_ASSESS
add constraint CU_MEMBER_ASSESS_PK primary key (PK_ID)
using index
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
create sequence CU_MEMBER_ASSESS_SEQ
minvalue 1
maxvalue 999999999999999999999999
start with 1
increment by 1
cache 20;
-- Create table 会员提现记录
create table CU_MEMBER_WITHDRAW
(
pk_id NUMBER(20) not null,
member_code VARCHAR2(20) not null,
withdraw_code VARCHAR2(30) not null,
pk_account number(6) not null,
pk_bank_id NUMBER(6) not null,
pk_rate_id NUMBER(6) not null,
cash_amount NUMBER(17,6) not null,
service_charge NUMBER(17,6) not null,
income_tax NUMBER(17,6) not null,
issued_amount NUMBER(17,6) not null,
approve_state NUMBER(2) not null,
payment_time DATE,
payer NUMBER(6),
remarks VARCHAR2(200),
del_flag NUMBER(1),
pk_country NUMBER(4) not null,
pkCreator VARCHAR2(100) not null,
creation_time DATE default sysdate not null,
pkModified VARCHAR2(100),
modified_time DATE,
approver NUMBER(6),
approve_time DATE
)
tablespace CLOUD
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 256K
next 256K
minextents 1
maxextents unlimited
pctincrease 0
);
-- Add comments to the table
comment on table CU_MEMBER_WITHDRAW
is '会员提现表';
-- Add comments to the columns
comment on column CU_MEMBER_WITHDRAW.pk_id
is '主键';
comment on column CU_MEMBER_WITHDRAW.member_code
is '会员编号';
comment on column CU_MEMBER_WITHDRAW.withdraw_code
is '申请单号';
comment on column CU_MEMBER_WITHDRAW.pk_account
is '账号类型(来源参照：币种配置)';
comment on column CU_MEMBER_WITHDRAW.pk_bank_id
is '银行信息';
comment on column CU_MEMBER_WITHDRAW.pk_rate_id
is '汇率';
comment on column CU_MEMBER_WITHDRAW.cash_amount
is '提现金额';
comment on column CU_MEMBER_WITHDRAW.service_charge
is '手续费';
comment on column CU_MEMBER_WITHDRAW.income_tax
is '个人所得税';
comment on column CU_MEMBER_WITHDRAW.issued_amount
is '实发金额';
comment on column CU_MEMBER_WITHDRAW.approve_state
is '审核状态(1=待提交,2=已提交,3=审核中,4=已驳回,5=已完成,6=已归档)';
comment on column CU_MEMBER_WITHDRAW.payment_time
is '打款日期';
comment on column CU_MEMBER_WITHDRAW.payer
is '打款人';
comment on column CU_MEMBER_WITHDRAW.remarks
is '备注';
comment on column CU_MEMBER_WITHDRAW.del_flag
is '逻辑删除 (0=未删除,1已删除)';
comment on column CU_MEMBER_WITHDRAW.pk_country
is '所属国家';
comment on column CU_MEMBER_WITHDRAW.pkCreator
is '创建人';
comment on column CU_MEMBER_WITHDRAW.creation_time
is '创建时间';
comment on column CU_MEMBER_WITHDRAW.pkModified
is '修改人';
comment on column CU_MEMBER_WITHDRAW.modified_time
is '修改时间';
comment on column CU_MEMBER_WITHDRAW.approver
is '审核人';
comment on column CU_MEMBER_WITHDRAW.approve_time
is '审核时间';
-- Create/Recreate indexes
create index CU_WITHDRAW_MEMBER_CODE on CU_MEMBER_WITHDRAW (MEMBER_CODE)
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table CU_MEMBER_WITHDRAW
add constraint CU_MEMBER_WITHDRAW_PK primary key (PK_ID)
using index
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
create sequence CU_MEMBER_WITHDRAW_SEQ
minvalue 1
maxvalue 999999999999999999999999
start with 1
increment by 1
cache 20;
-- Create table 会员转账记录
create table CU_MEMBER_TRANSFER
(
pk_id NUMBER(20) not null,
member_code VARCHAR2(20) not null,
transfer_code VARCHAR2(30) not null,
pk_account NUMBER(6) not null,
to_member_code VARCHAR2(20) not null,
pk_to_account NUMBER(6) not null,
pk_rate NUMBER(6) not null,
transfer_money NUMBER(17,6),
remarks VARCHAR2(200),
approve_state NUMBER(2) default 1 not null,
approver NUMBER(6),
approve_time DATE,
del_flag NUMBER(1) default 0 not null,
pkCreator VARCHAR2(50) not null,
creation_time DATE default sysdate not null,
pkModified VARCHAR2(50),
modified_time DATE,
pk_country NUMBER(4) not null
)
tablespace CLOUD
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Add comments to the table
comment on table CU_MEMBER_TRANSFER
is '会员信息-奖衔升级记录';
-- Add comments to the columns
comment on column CU_MEMBER_TRANSFER.pk_id
is '主键';
comment on column CU_MEMBER_TRANSFER.member_code
is '转出编号';
comment on column CU_MEMBER_TRANSFER.transfer_code
is '申请单号';
comment on column CU_MEMBER_TRANSFER.pk_account
is '账户类型(来源于参照：币种配置)';
comment on column CU_MEMBER_TRANSFER.to_member_code
is '转入编号';
comment on column CU_MEMBER_TRANSFER.pk_to_account
is '转入账户类型(来源于参照：币种配置)';
comment on column CU_MEMBER_TRANSFER.pk_rate
is '汇率';
comment on column CU_MEMBER_TRANSFER.transfer_money
is '转账金额';
comment on column CU_MEMBER_TRANSFER.remarks
is '备注';
comment on column CU_MEMBER_TRANSFER.approve_state
is '审核状态';
comment on column CU_MEMBER_TRANSFER.approver
is '审核人';
comment on column CU_MEMBER_TRANSFER.approve_time
is '审核时间';
comment on column CU_MEMBER_TRANSFER.del_flag
is '逻辑删除 (0=未删除,1已删除)';
comment on column CU_MEMBER_TRANSFER.pkCreator
is '创建人';
comment on column CU_MEMBER_TRANSFER.creation_time
is '创建时间';
comment on column CU_MEMBER_TRANSFER.pkModified
is '修改人';
comment on column CU_MEMBER_TRANSFER.modified_time
is '修改时间';
comment on column CU_MEMBER_TRANSFER.pk_country
is '国家';
-- Create/Recreate indexes
create index CU_MEMBER_TRANSFER_MEMBER_CODE on CU_MEMBER_TRANSFER (MEMBER_CODE)
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table CU_MEMBER_TRANSFER
add constraint CU_MEMBER_TRANSFER_PK primary key (PK_ID)
using index
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
create sequence CU_MEMBER_TRANSFER_SEQ
minvalue 1
maxvalue 999999999999999999999999
start with 1
increment by 1
cache 20;
-- Create table
create table CU_MEMBER_TRADE
(
pk_id NUMBER(20) not null,
member_code VARCHAR2(20) not null,
trade_code VARCHAR2(30) not null,
pk_account NUMBER(6) not null,
trade_type NUMBER(2) not null,
trade_classify NUMBER(2) not null,
pk_rate_id NUMBER(6) not null,
trade_amount NUMBER(17,6) not null,
trade_balance NUMBER(17,6) not null,
source_code VARCHAR2(30) not null,
trade_statue NUMBER(2) not null,
remarks VARCHAR2(200),
del_flag NUMBER(1) default 0 not null,
pk_country NUMBER(4) default 1 not null,
pkCreator VARCHAR2(100) not null,
creation_time DATE default sysdate not null,
pkModified VARCHAR2(100),
modified_time DATE
)
tablespace CLOUD
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 256K
next 256K
minextents 1
maxextents unlimited
pctincrease 0
);
-- Add comments to the table
comment on table CU_MEMBER_TRADE
is '会员交易明细';
-- Add comments to the columns
comment on column CU_MEMBER_TRADE.pk_id
is '主键';
comment on column CU_MEMBER_TRADE.member_code
is '会员编号';
comment on column CU_MEMBER_TRADE.trade_code
is '交易编号';
comment on column CU_MEMBER_TRADE.pk_account
is '账户类型(来源于参照：币种配置)';
comment on column CU_MEMBER_TRADE.trade_type
is '交易类型:(10充值, 11转账, 12收益发放, 13转换, 14提现, 15提现撤回, 16提现拒绝, 17注册订单, 18升级订单, 19复购订单, 20圣宝云代注册, 21圣宝云代升级, 22圣宝云代复购, 23商城vip, 24返还补偿鼓励币, 25返还本金鼓励币, 26扣减抢拼现金币, 27撤单返钱, 28返还本金, 30抢拼专区, 31兑换专区, 40领取红包, 50发放复购券, 51复购券撤单, 52使用复购券, 54圣宝云代使用复购券)';
comment on column CU_MEMBER_TRADE.trade_classify
is '交易分:(1=消费 2=提现 3=转账 4=充值 5=收益)';
comment on column CU_MEMBER_TRADE.pk_rate_id
is '汇率';
comment on column CU_MEMBER_TRADE.trade_amount
is '交易金额';
comment on column CU_MEMBER_TRADE.trade_balance
is '交易余额';
comment on column CU_MEMBER_TRADE.source_code
is '来源单号';
comment on column CU_MEMBER_TRADE.trade_statue
is '交易状态:(1=可消费 2=生效)';
comment on column CU_MEMBER_TRADE.remarks
is '备注';
comment on column CU_MEMBER_TRADE.del_flag
is '逻辑删除 (0=未删除,1已删除)';
comment on column CU_MEMBER_TRADE.pk_country
is '所属国家';
comment on column CU_MEMBER_TRADE.pkCreator
is '创建人';
comment on column CU_MEMBER_TRADE.creation_time
is '创建时间';
comment on column CU_MEMBER_TRADE.pkModified
is '修改人';
comment on column CU_MEMBER_TRADE.modified_time
is '修改时间';
-- Create/Recreate indexes
create index CU_MEMBER_TRADE_MEMBER_CODE on CU_MEMBER_TRADE (MEMBER_CODE)
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table CU_MEMBER_TRADE
add constraint CU_MEMBER_TRADE_PK primary key (PK_ID)
using index
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
create sequence CU_MEMBER_TRADE_SEQ
minvalue 1
maxvalue 999999999999999999999999
start with 1
increment by 1
cache 20;
-- Create table
create table CU_MEMBER_TEAM
(
pk_id NUMBER(20) not null,
member_code VARCHAR2(20) not null,
team_name VARCHAR2(100) not null,
pk_transaction NUMBER(8),
del_flag NUMBER(1) default 0 not null,
pk_country NUMBER(4) default 1 not null,
pkCreator VARCHAR2(100) not null,
creation_time DATE default sysdate not null,
pkModified VARCHAR2(100),
modified_time DATE
)
tablespace CLOUD
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 256K
next 256K
minextents 1
maxextents unlimited
pctincrease 0
);
-- Add comments to the table
comment on table CU_MEMBER_TEAM
is '会员所属团队';
-- Add comments to the columns
comment on column CU_MEMBER_TEAM.pk_id
is '主键';
comment on column CU_MEMBER_TEAM.member_code
is '会员编号';
comment on column CU_MEMBER_TEAM.team_name
is '团队名称';
comment on column CU_MEMBER_TEAM.pk_transaction
is '统一翻译,来源于统一翻译';
comment on column CU_MEMBER_TEAM.del_flag
is '逻辑删除 (0=未删除,1已删除)';
comment on column CU_MEMBER_TEAM.pk_country
is '所属国家';
comment on column CU_MEMBER_TEAM.pkCreator
is '创建人';
comment on column CU_MEMBER_TEAM.creation_time
is '创建时间';
comment on column CU_MEMBER_TEAM.pkModified
is '修改人';
comment on column CU_MEMBER_TEAM.modified_time
is '修改时间';
-- Create/Recreate indexes
create index CU_MEMBER_TEAM_MEMBER_CODE on CU_MEMBER_TEAM (MEMBER_CODE)
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
-- Create/Recreate primary, unique and foreign key constraints
alter table CU_MEMBER_TEAM
add constraint CU_MEMBER_TEAM_PK primary key (PK_ID)
using index
tablespace CLOUD
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
pctincrease 0
);
create sequence cu_member_team_SEQ
minvalue 1
maxvalue 999999999999999999999999
start with 1
increment by 1
cache 20;