-----------------------------------------------------
-- Export file for user EPORT                      --
-- Created by Administrator on 2017-8-18, 17:28:32 --
-----------------------------------------------------

set define off
spool ept_col_qualification.log

prompt
prompt Creating table EPT_COL_QUALIFICATION
prompt ====================================
prompt
create table EPORT.EPT_COL_QUALIFICATION
(
  id               NUMBER(11) not null,
  seq_no           VARCHAR2(36),
  plat_no2         VARCHAR2(36),
  customs          VARCHAR2(36),
  col_code         VARCHAR2(36),
  trade_code       VARCHAR2(20),
  trade_name       VARCHAR2(255),
  biz_type         VARCHAR2(10),
  control_flag     VARCHAR2(10),
  begin_date       DATE,
  end_date         DATE,
  col_area_code    VARCHAR2(10),
  col_customs_code VARCHAR2(10),
  app_person       VARCHAR2(50),
  app_date         DATE,
  remark           VARCHAR2(50),
  area_code        VARCHAR2(10),
  customs_code     VARCHAR2(255),
  trades_code      VARCHAR2(50),
  step_id          VARCHAR2(10),
  create_person    VARCHAR2(50),
  create_date      DATE,
  declare_person   VARCHAR2(50),
  declare_date     DATE,
  approve_person   VARCHAR2(50),
  approve_date     DATE,
  outer_comment    VARCHAR2(500),
  inner_comment    VARCHAR2(500),
  extend_field_1   VARCHAR2(50),
  extend_field_2   VARCHAR2(50),
  extend_field_3   VARCHAR2(50),
  extend_field_4   DATE,
  extend_field_5   NUMBER(18,5),
  update_date      DATE
)
tablespace EPORT
  pctfree 10
  initrans 1
  maxtrans 255;
comment on column EPORT.EPT_COL_QUALIFICATION.id
  is 'ID';
comment on column EPORT.EPT_COL_QUALIFICATION.seq_no
  is '外部企业编码';
comment on column EPORT.EPT_COL_QUALIFICATION.plat_no2
  is '外部企业编码';
comment on column EPORT.EPT_COL_QUALIFICATION.customs
  is '对接海关区域代码';
comment on column EPORT.EPT_COL_QUALIFICATION.col_code
  is '资格编号';
comment on column EPORT.EPT_COL_QUALIFICATION.trade_code
  is '经营企业代码';
comment on column EPORT.EPT_COL_QUALIFICATION.trade_name
  is '经营企业名称';
comment on column EPORT.EPT_COL_QUALIFICATION.biz_type
  is '业务类型';
comment on column EPORT.EPT_COL_QUALIFICATION.control_flag
  is '资格标识';
comment on column EPORT.EPT_COL_QUALIFICATION.begin_date
  is '设置开始时间';
comment on column EPORT.EPT_COL_QUALIFICATION.end_date
  is '设置结束时间';
comment on column EPORT.EPT_COL_QUALIFICATION.col_area_code
  is '关区代码';
comment on column EPORT.EPT_COL_QUALIFICATION.col_customs_code
  is '区域代码';
comment on column EPORT.EPT_COL_QUALIFICATION.app_person
  is '申请人';
comment on column EPORT.EPT_COL_QUALIFICATION.app_date
  is '申请时间';
comment on column EPORT.EPT_COL_QUALIFICATION.remark
  is '备注';
comment on column EPORT.EPT_COL_QUALIFICATION.area_code
  is '关区代码';
comment on column EPORT.EPT_COL_QUALIFICATION.customs_code
  is '区域代码';
comment on column EPORT.EPT_COL_QUALIFICATION.trades_code
  is '企业编码';
comment on column EPORT.EPT_COL_QUALIFICATION.step_id
  is '当前环节';
comment on column EPORT.EPT_COL_QUALIFICATION.create_person
  is '创建人';
comment on column EPORT.EPT_COL_QUALIFICATION.create_date
  is '创建时间';
comment on column EPORT.EPT_COL_QUALIFICATION.declare_person
  is '申报人';
comment on column EPORT.EPT_COL_QUALIFICATION.declare_date
  is '申报时间';
comment on column EPORT.EPT_COL_QUALIFICATION.approve_person
  is '审批人';
comment on column EPORT.EPT_COL_QUALIFICATION.approve_date
  is '审批时间';
comment on column EPORT.EPT_COL_QUALIFICATION.outer_comment
  is '外部审批意见';
comment on column EPORT.EPT_COL_QUALIFICATION.inner_comment
  is '内部审批意见';
comment on column EPORT.EPT_COL_QUALIFICATION.extend_field_1
  is '扩展字段1';
comment on column EPORT.EPT_COL_QUALIFICATION.extend_field_2
  is '扩展字段2';
comment on column EPORT.EPT_COL_QUALIFICATION.extend_field_3
  is '扩展字段3';
comment on column EPORT.EPT_COL_QUALIFICATION.extend_field_4
  is '扩展字段4';
comment on column EPORT.EPT_COL_QUALIFICATION.extend_field_5
  is '扩展字段5';
comment on column EPORT.EPT_COL_QUALIFICATION.update_date
  is '更新时间';
alter table EPORT.EPT_COL_QUALIFICATION
  add primary key (ID)
  using index 
  tablespace EPORT
  pctfree 10
  initrans 2
  maxtrans 255;


spool off