## 银行信息子表
```
-- Create table
create table BYD_PURA_SUPPLIER_BI
(
ID NUMBER not null,
FORM_ID VARCHAR2(200),
BANK_COUNTRY_BEFORE VARCHAR2(1000),
BANK_COUNTRY_AFTER VARCHAR2(1000),
COOPERATIVE_BANK_BEFORE VARCHAR2(1000),
COOPERATIVE_BANK_AFTER VARCHAR2(1000),
BANK_NAME_BEFORE VARCHAR2(1000),
BANK_NAME_AFTER VARCHAR2(1000),
BANK_ACCOUNT_NAME_BEFORE VARCHAR2(1000),
BANK_ACCOUNT_NAME_AFTER VARCHAR2(1000),
BANK_NUMBER_BEFORE VARCHAR2(1000),
BANK_NUMBER_AFTER VARCHAR2(1000),
BANK_ACCOUNT_NUMBER_BEFORE VARCHAR2(1000),
BANK_ACCOUNT_NUMBER_AFTER VARCHAR2(1000),
SWIFT_CODE_BEFORE VARCHAR2(1000),
SWIFT_CODE_AFTER VARCHAR2(1000),
OBJECT_VERSION_NUMBER NUMBER,
CREATED_BY VARCHAR2(100) not null,
CREATION_DATE DATE not null,
LAST_UPDATED_BY VARCHAR2(100) not null,
LAST_UPDATE_DATE DATE not null,
BANK_CITY_BEFORE VARCHAR2(1000),
BANK_CITY_AFTER VARCHAR2(1000),
BANK_CNAPS_BEFORE VARCHAR2(1000),
BANK_CNAPS_AFTER VARCHAR2(1000),
BANK_STATUS_BEFORE VARCHAR2(1000),
BANK_STATUS_AFTER VARCHAR2(1000)
)
tablespace BYD_BPMPLATFORM
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 16K
next 8K
minextents 1
maxextents unlimited
);
-- Add comments to the table
comment on table BYD_PURA_SUPPLIER_BI
is '供应商信息维护申请(银行信息)';
-- Add comments to the columns
comment on column BYD_PURA_SUPPLIER_BI.BANK_COUNTRY_BEFORE
is '银行国家地区变更前信息';
comment on column BYD_PURA_SUPPLIER_BI.BANK_COUNTRY_AFTER
is '银行国家地区变更后信息';
comment on column BYD_PURA_SUPPLIER_BI.COOPERATIVE_BANK_BEFORE
is '合作银行类型变更前信息';
comment on column BYD_PURA_SUPPLIER_BI.COOPERATIVE_BANK_AFTER
is '合作银行类型变更后信息';
comment on column BYD_PURA_SUPPLIER_BI.BANK_NAME_BEFORE
is '银行名称变更前信息';
comment on column BYD_PURA_SUPPLIER_BI.BANK_NAME_AFTER
is '银行名称变更后信息';
comment on column BYD_PURA_SUPPLIER_BI.BANK_ACCOUNT_NAME_BEFORE
is '银行账户名变更前信息';
comment on column BYD_PURA_SUPPLIER_BI.BANK_ACCOUNT_NAME_AFTER
is '银行账户名变更后信息';
comment on column BYD_PURA_SUPPLIER_BI.BANK_NUMBER_BEFORE
is '银行编号变更前信息';
comment on column BYD_PURA_SUPPLIER_BI.BANK_NUMBER_AFTER
is '银行编号变更后信息';
comment on column BYD_PURA_SUPPLIER_BI.BANK_ACCOUNT_NUMBER_BEFORE
is '银行账号变更前信息';
comment on column BYD_PURA_SUPPLIER_BI.BANK_ACCOUNT_NUMBER_AFTER
is '银行账号变更后信息';
comment on column BYD_PURA_SUPPLIER_BI.SWIFT_CODE_BEFORE
is 'SWIFT CODE变更前信息';
comment on column BYD_PURA_SUPPLIER_BI.SWIFT_CODE_AFTER
is 'SWIFT CODE变更后信息';
comment on column BYD_PURA_SUPPLIER_BI.BANK_CITY_BEFORE
is '银行城市变更前信息';
comment on column BYD_PURA_SUPPLIER_BI.BANK_CITY_AFTER
is '银行城市变更后信息';
comment on column BYD_PURA_SUPPLIER_BI.BANK_CNAPS_BEFORE
is '银行联行号变更前信息';
comment on column BYD_PURA_SUPPLIER_BI.BANK_CNAPS_AFTER
is '银行联行号变更后信息';
comment on column BYD_PURA_SUPPLIER_BI.BANK_STATUS_BEFORE
is '状态变更前信息';
comment on column BYD_PURA_SUPPLIER_BI.BANK_STATUS_AFTER
is '状态变更后信息';
-- Create/Recreate primary, unique and foreign key constraints
alter table BYD_PURA_SUPPLIER_BI
add primary key (ID)
using index
tablespace BYD_BPMPLATFORM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
-- Create/Recreate indexes
create index BYD_PURA_SUPPLIER_BI_IDX on BYD_PURA_SUPPLIER_BI (FORM_ID)
tablespace BYD_BPMPLATFORM
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
```
网友评论