-- Create table
create table CON_CONTRACT_IFRS9
(
  ifrs_id                   NUMBER,
  bp_code                   VARCHAR2(30),
  bp_name                   VARCHAR2(100),
  contract_number           VARCHAR2(2000),
  int_rate_display          NUMBER,
  lease_start_date          DATE,
  contract_amount           NUMBER,
  pre_pay_amount            NUMBER,
  contract_principal_amount NUMBER,
  overdue_amount            NUMBER,
  max_overdue_days          NUMBER,
  rest_amount               NUMBER,
  pay_date                  DATE,
  pay_amount                NUMBER,
  industry_belonged         VARCHAR2(1000),
  lease_item_location       VARCHAR2(1000),
  base_date                 DATE,
  created_by                NUMBER default -1,
  creation_date             DATE default SYSDATE,
  last_updated_by           NUMBER default -1,
  last_update_date          DATE default SYSDATE,
  period_day                VARCHAR2(200)
)
tablespace HL_CM_DEV
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Add comments to the columns
comment on column CON_CONTRACT_IFRS9.period_day
  is '期间';
alter table con_contract_ifrs9
  add constraint CON_CONTRACT_IFRS9_PK primary key (ifrs_id);
CREATE SEQUENCE CON_CONTRACT_IFRS9_S;