供应商信息维护

## 银行信息子表

```

-- 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

  );

```