jsgkj/gkjsjy/trunk/WebContent/static/sql/oracle/table/2.5.OtherTableCreate.sql

--GK_OPERATION_JSJY_GGFWXX_HX
--GK_OPERATION_JSJY_GGFWXX_JDTX
--GK_BASIC_JSJY_JYR_ZXJX
--GK_OPERATION_JSJY_GGFWXX_TX
--GK_OPERATION_JSJY_GGXX
--GK_OPERATION_JSJY_GGXX_TX
--GK_SHARE_JSJY_HS_LIQUIDGOODS
--GK_SHARE_JSJY_HS_PACKCONTAINER
--GK_SHARE_JSJY_HS_PACKGOODS
--GK_SHARE_JSJY_HS_SHIPINFO
--GK_SHARE_JSJY_HS_SOLIDGOODS
--GK_SHARE_JSJY_HS_TPCONTAINER
--GK_SHARE_JSJY_HS_TRAFFICLIQUID
--GK_SHARE_JSJY_HS_TRAFFICPACK
--GK_SHARE_JSJY_HS_TRAFFICSOLID
--GK_SHARE_JSJY_XKZNSFJ
--GK_SHARE_JSJY_XKZNSFJ
--航线航班表
-- Create table
create table GK_OPERATION_JSJY_GGFWXX_HX
(
  id               VARCHAR2(40) not null,
  hxmc             VARCHAR2(40),
  hxlx             VARCHAR2(40),
  cgs              VARCHAR2(500),
  hc               NUMBER,
  qdg              VARCHAR2(200),
  zdg              VARCHAR2(200),
  cq               VARCHAR2(40),
  tkg              VARCHAR2(200),
  bz               VARCHAR2(500),
  bynmwcl          NUMBER,
  bywmwcl          NUMBER,
  rq               VARCHAR2(40),
  tbsj             TIMESTAMP(6),
  sftb             CHAR(1) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null,
  create_date_time TIMESTAMP(0),
  update_date_time TIMESTAMP(0),
  record_status    NUMBER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  sfth             VARCHAR2(40),
  yhmc             VARCHAR2(40),
  szd              VARCHAR2(40),
  jyrid            VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );
-- Add comments to the columns 
comment on column GK_OPERATION_JSJY_GGFWXX_HX.id
  is '航线ID';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.hxmc
  is '航线名称';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.hxlx
  is '航线类型';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.cgs
  is '船公司';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.hc
  is '航程';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.qdg
  is '起点港';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.zdg
  is '终点港';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.cq
  is '船期';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.tkg
  is '停靠港';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.bz
  is '备注';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.bynmwcl
  is '本月内贸完成量';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.bywmwcl
  is '本月外贸完成量';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.rq
  is '日期';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.tbsj
  is '填报时间';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.sftb
  is '是否同步';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.tbzt
  is '同步状态';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.sfth
  is '是否停航';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.yhmc
  is '用户名称';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.jyrid
  is '经营人名称';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.szgk
  is '所在港口';
comment on column GK_OPERATION_JSJY_GGFWXX_HX.szgq
  is '所在港区';

--监督提醒表
-- Create table
create table GK_OPERATION_JSJY_GGFWXX_JDTX
(
  id               VARCHAR2(40) not null,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    NUMBER,
  bt               VARCHAR2(100),
  nr               VARCHAR2(1000),
  txr              VARCHAR2(100),
  txsj             TIMESTAMP(6),
  szd              VARCHAR2(40),
  sftb             CHAR(1) default 'Y',
  tbzt             CHAR(1) default 'N'
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Add comments to the columns 
comment on column GK_OPERATION_JSJY_GGFWXX_JDTX.id
  is 'ID';
comment on column GK_OPERATION_JSJY_GGFWXX_JDTX.create_user
  is '创建人';
comment on column GK_OPERATION_JSJY_GGFWXX_JDTX.update_user
  is '修改人';
comment on column GK_OPERATION_JSJY_GGFWXX_JDTX.create_date_time
  is '创建时间';
comment on column GK_OPERATION_JSJY_GGFWXX_JDTX.update_date_time
  is '修改时间';
comment on column GK_OPERATION_JSJY_GGFWXX_JDTX.record_status
  is '数据状态';
comment on column GK_OPERATION_JSJY_GGFWXX_JDTX.bt
  is '标题';
comment on column GK_OPERATION_JSJY_GGFWXX_JDTX.nr
  is '内容';
comment on column GK_OPERATION_JSJY_GGFWXX_JDTX.txr
  is '填写人';
comment on column GK_OPERATION_JSJY_GGFWXX_JDTX.txsj
  is '提醒时间';
comment on column GK_OPERATION_JSJY_GGFWXX_JDTX.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_GGFWXX_JDTX.sftb
  is '是否同步';
comment on column GK_OPERATION_JSJY_GGFWXX_JDTX.tbzt
  is '同步状态';
-- Create/Recreate primary, unique and foreign key constraints 
alter table GK_OPERATION_JSJY_GGFWXX_JDTX
  add primary key (ID)
  using index 
  tablespace GK_OPERATION
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

  --装卸机械表
  -- Create table
create table GK_BASIC_JSJY_JYR_ZXJX
(
  id               VARCHAR2(40) not null,
  szd              VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  szzyq            VARCHAR2(40),
  ssjyr            VARCHAR2(40),
  jxlbmc           VARCHAR2(100),
  xhhgg            VARCHAR2(40),
  jxsl             NUMBER,
  jxfhnlsz         NUMBER,
  jxfhnldw         VARCHAR2(40),
  syqxsta          TIMESTAMP(6),
  syqxend          TIMESTAMP(6),
  syq              VARCHAR2(40),
  bz               VARCHAR2(1000),
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    NUMBER(38),
  aqid             VARCHAR2(40),
  sftb             VARCHAR2(40) default 'Y' not null,
  tbzt             VARCHAR2(40) default 'N' not null,
  yzxjxid          VARCHAR2(40),
  xkzid            VARCHAR2(40)
)
tablespace GK_BASIC
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Add comments to the table 
comment on table GK_BASIC_JSJY_JYR_ZXJX
  is '装卸机械';
-- Add comments to the columns 
comment on column GK_BASIC_JSJY_JYR_ZXJX.id
  is '唯一标识';
comment on column GK_BASIC_JSJY_JYR_ZXJX.szd
  is '所在地';
comment on column GK_BASIC_JSJY_JYR_ZXJX.szgk
  is '所在港口';
comment on column GK_BASIC_JSJY_JYR_ZXJX.szgq
  is '所在港区';
comment on column GK_BASIC_JSJY_JYR_ZXJX.szzyq
  is '所在作业区';
comment on column GK_BASIC_JSJY_JYR_ZXJX.ssjyr
  is '所属经营人';
comment on column GK_BASIC_JSJY_JYR_ZXJX.jxlbmc
  is '机械类别名称';
comment on column GK_BASIC_JSJY_JYR_ZXJX.jxsl
  is '机械数量';
comment on column GK_BASIC_JSJY_JYR_ZXJX.jxfhnlsz
  is '机械负荷能力数值';
comment on column GK_BASIC_JSJY_JYR_ZXJX.jxfhnldw
  is '机械负荷能力单位';
comment on column GK_BASIC_JSJY_JYR_ZXJX.syqxsta
  is '使用期限自';
comment on column GK_BASIC_JSJY_JYR_ZXJX.syqxend
  is '使用期限至';
comment on column GK_BASIC_JSJY_JYR_ZXJX.syq
  is '所有权';
comment on column GK_BASIC_JSJY_JYR_ZXJX.bz
  is '备注';
comment on column GK_BASIC_JSJY_JYR_ZXJX.create_user
  is '创建人';
comment on column GK_BASIC_JSJY_JYR_ZXJX.update_user
  is '修改人';
comment on column GK_BASIC_JSJY_JYR_ZXJX.create_date_time
  is '创建日期';
comment on column GK_BASIC_JSJY_JYR_ZXJX.update_date_time
  is '修改日期';
comment on column GK_BASIC_JSJY_JYR_ZXJX.record_status
  is '数据状态';
comment on column GK_BASIC_JSJY_JYR_ZXJX.aqid
  is '安全同步id';
comment on column GK_BASIC_JSJY_JYR_ZXJX.sftb
  is '是否同步';
comment on column GK_BASIC_JSJY_JYR_ZXJX.tbzt
  is '同步状态';
comment on column GK_BASIC_JSJY_JYR_ZXJX.yzxjxid
  is '原Id';
comment on column GK_BASIC_JSJY_JYR_ZXJX.xkzid
  is '许可证ID';
-- Create/Recreate primary, unique and foreign key constraints 
alter table GK_BASIC_JSJY_JYR_ZXJX
  add primary key (ID)
  using index 
  tablespace GK_BASIC
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

  
  -- Create table
create table GK_OPERATION_JSJY_GGFWXX_TX
(
  id               VARCHAR2(40) not null,
  jyr              VARCHAR2(1000),
  xzry             VARCHAR2(1000),
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    NUMBER,
  sftb             CHAR(1) default 'Y',
  tbzt             CHAR(1) default 'N',
  szd              VARCHAR2(40),
  tx               VARCHAR2(40)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    next 1
    minextents 1
    maxextents unlimited
  );
-- Add comments to the columns 
comment on column GK_OPERATION_JSJY_GGFWXX_TX.jyr
  is '提醒经营人';
comment on column GK_OPERATION_JSJY_GGFWXX_TX.xzry
  is '提醒行政人员';
comment on column GK_OPERATION_JSJY_GGFWXX_TX.create_user
  is '创建人';
comment on column GK_OPERATION_JSJY_GGFWXX_TX.update_user
  is '修改人';
comment on column GK_OPERATION_JSJY_GGFWXX_TX.create_date_time
  is '创建时间';
comment on column GK_OPERATION_JSJY_GGFWXX_TX.update_date_time
  is '修改时间';
comment on column GK_OPERATION_JSJY_GGFWXX_TX.record_status
  is '数据状态';
comment on column GK_OPERATION_JSJY_GGFWXX_TX.sftb
  is '是否同步';
comment on column GK_OPERATION_JSJY_GGFWXX_TX.tbzt
  is '同步状态';
comment on column GK_OPERATION_JSJY_GGFWXX_TX.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_GGFWXX_TX.tx
  is '提醒id';
-- Create/Recreate primary, unique and foreign key constraints 
alter table GK_OPERATION_JSJY_GGFWXX_TX
  add primary key (ID)
  using index 
  tablespace GK_OPERATION
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

  
  -- Create table
create table GK_OPERATION_JSJY_GGXX
(
  id               VARCHAR2(40),
  title            NVARCHAR2(400),
  gglx             VARCHAR2(40),
  fbdw             NVARCHAR2(100),
  zw               NVARCHAR2(2000),
  fjid             VARCHAR2(40),
  jsdx             NVARCHAR2(200),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40),
  sftb             CHAR(1),
  tbzt             CHAR(1),
  fbzt             CHAR(1),
  fbsj             TIMESTAMP(6)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16
    next 8
    minextents 1
    maxextents unlimited
  );
-- Add comments to the table 
comment on table GK_OPERATION_JSJY_GGXX
  is '公告信息（新）';
-- Add comments to the columns 
comment on column GK_OPERATION_JSJY_GGXX.id
  is '主键';
comment on column GK_OPERATION_JSJY_GGXX.title
  is '标题';
comment on column GK_OPERATION_JSJY_GGXX.gglx
  is '公告类型';
comment on column GK_OPERATION_JSJY_GGXX.fbdw
  is '发布单位';
comment on column GK_OPERATION_JSJY_GGXX.zw
  is '正文';
comment on column GK_OPERATION_JSJY_GGXX.fjid
  is '附件ID';
comment on column GK_OPERATION_JSJY_GGXX.jsdx
  is '接收对像';
comment on column GK_OPERATION_JSJY_GGXX.create_user
  is '创建人';
comment on column GK_OPERATION_JSJY_GGXX.create_date_time
  is '创建时间';
comment on column GK_OPERATION_JSJY_GGXX.update_user
  is '修改人';
comment on column GK_OPERATION_JSJY_GGXX.update_date_time
  is '修改时间';
comment on column GK_OPERATION_JSJY_GGXX.record_status
  is '状态';
comment on column GK_OPERATION_JSJY_GGXX.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_GGXX.fbzt
  is '发布状态';
comment on column GK_OPERATION_JSJY_GGXX.fbsj
  is '发布时间';

  
  -- Create table
create table GK_OPERATION_JSJY_GGXX_TX
(
  id               VARCHAR2(40),
  ggid             VARCHAR2(40),
  jyr              VARCHAR2(40),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  sftb             CHAR(1),
  tbzt             CHAR(1),
  szd              VARCHAR2(40),
  sfyd             CHAR(1),
  flag             CHAR(1),
  fbzt             CHAR(1)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16
    next 8
    minextents 1
    maxextents unlimited
  );
-- Add comments to the table 
comment on table GK_OPERATION_JSJY_GGXX_TX
  is '公告发布对象表';
-- Add comments to the columns 
comment on column GK_OPERATION_JSJY_GGXX_TX.ggid
  is '公告ID';
comment on column GK_OPERATION_JSJY_GGXX_TX.jyr
  is '经营人';
comment on column GK_OPERATION_JSJY_GGXX_TX.create_user
  is '创建人';
comment on column GK_OPERATION_JSJY_GGXX_TX.create_date_time
  is '创建时间';
comment on column GK_OPERATION_JSJY_GGXX_TX.update_user
  is '修改人';
comment on column GK_OPERATION_JSJY_GGXX_TX.update_date_time
  is '修改时间';
comment on column GK_OPERATION_JSJY_GGXX_TX.record_status
  is '状态';
comment on column GK_OPERATION_JSJY_GGXX_TX.sftb
  is '是否同步';
comment on column GK_OPERATION_JSJY_GGXX_TX.tbzt
  is '同步状态';
comment on column GK_OPERATION_JSJY_GGXX_TX.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_GGXX_TX.sfyd
  is '是否阅读';
comment on column GK_OPERATION_JSJY_GGXX_TX.flag
  is '指定对像类型';
comment on column GK_OPERATION_JSJY_GGXX_TX.fbzt
  is '发布时间';

  
  -- Create table
create table GK_SHARE_JSJY_HS_LIQUIDGOODS
(
  id               VARCHAR2(40) not null,
  create_date_time TIMESTAMP(6) default current_timestamp,
  update_date_time TIMESTAMP(6) default current_timestamp,
  record_status    NUMBER default 1,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NVARCHAR2(40),
  sbdbh            CHAR(18),
  xh               INTEGER,
  whsbdbh          CHAR(18),
  hwlx             CHAR(1),
  sfzz             CHAR(1),
  sfgj             CHAR(1),
  wgxh             CHAR(10),
  wgbh             CHAR(10),
  zqysmczw         VARCHAR2(160),
  zqysmcyw         VARCHAR2(255),
  hwzl             CHAR(1),
  wxlb             CHAR(10),
  wrlb             CHAR(10),
  ylxz             CHAR(1),
  szyhqxz          CHAR(1),
  sl               NUMBER(16,3),
  yhcbh            CHAR(20),
  yhcsfdh          CHAR(1),
  zxhwwd           NUMBER(4,1),
  zhgzwmc          VARCHAR2(40),
  zhgywmc          VARCHAR2(80),
  xhgzwmc          VARCHAR2(40),
  xhgywmc          VARCHAR2(80),
  qygmc            VARCHAR2(40),
  mdgmc            VARCHAR2(40),
  md               NUMBER(8,3),
  nd               NUMBER(8,3),
  nddw             VARCHAR2(20),
  bizh             NUMBER(6,1),
  sd               CHAR(1),
  zyfs             CHAR(1),
  tyr              VARCHAR2(60),
  hz               VARCHAR2(60),
  tshwbz           CHAR(1),
  bz               VARCHAR2(80),
  wxhwbz           CHAR(1),
  zdlbz            CHAR(1)
)
tablespace GK_SHARE
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    next 8
    minextents 1
    maxextents unlimited
  );

  
  -- Create table
create table GK_SHARE_JSJY_HS_PACKCONTAINER
(
  id               VARCHAR2(40) not null,
  create_date_time TIMESTAMP(6) default current_timestamp,
  update_date_time TIMESTAMP(6) default current_timestamp,
  record_status    NUMBER default 1,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NVARCHAR2(40),
  sbdbh            CHAR(18),
  hwxh             INTEGER,
  thdh             VARCHAR2(100),
  jzxbh            VARCHAR2(20),
  jzxgg            CHAR(4),
  bw_x             CHAR(3),
  bw_y             CHAR(3),
  bw_z             CHAR(3),
  jzxnjs           INTEGER,
  pxbz             CHAR(3),
  qfh              VARCHAR2(30)
)
tablespace GK_SHARE
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    next 1
    minextents 1
    maxextents unlimited
  );

  -- Create table
create table GK_SHARE_JSJY_HS_PACKGOODS
(
  id               VARCHAR2(40) not null,
  create_date_time TIMESTAMP(6) default current_timestamp,
  update_date_time TIMESTAMP(6) default current_timestamp,
  record_status    NUMBER default 1,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  sbdbh            CHAR(18),
  xh               INTEGER,
  whsbdbh          CHAR(18),
  thdh             VARCHAR2(100),
  hwlx             CHAR(1),
  sfzz             CHAR(1),
  sfgj             CHAR(1),
  sfgb             CHAR(1),
  sfgnzy           CHAR(1),
  yccshbh          VARCHAR2(20),
  wgxh             CHAR(10) not null,
  wgbh             CHAR(10),
  zqysmczw         VARCHAR2(160),
  zqysmcyw         VARCHAR2(255),
  zqysmcbcsm       VARCHAR2(255),
  wxlb             CHAR(10),
  fwxx             VARCHAR2(20),
  zyxs             VARCHAR2(20),
  js               INTEGER,
  xl               CHAR(1),
  bjzl             CHAR(20),
  bjcl             CHAR(1),
  bjjz             NUMBER(16,3),
  bjjzdw           CHAR(2),
  rqnzjz           NUMBER(16,3),
  rqnzjzdw         CHAR(2),
  bzl              CHAR(10),
  zzl              NUMBER(16,3),
  sfhfqw           CHAR(1),
  kddwqj           CHAR(1),
  zhgzwmc          VARCHAR2(40),
  zhgywmc          VARCHAR2(80),
  xhgzwmc          VARCHAR2(40),
  xhgywmc          VARCHAR2(80),
  qygmc            VARCHAR2(40),
  mdgmc            VARCHAR2(40),
  zzwz             VARCHAR2(255),
  bzxgg            VARCHAR2(255),
  jzx20            INTEGER,
  jzx30            INTEGER,
  jzx40            INTEGER,
  jzx45            INTEGER,
  bzxteu           NUMBER(8,2),
  fbzxgg           INTEGER,
  fbxxs            INTEGER,
  ggcc             VARCHAR2(30),
  ggsl             INTEGER,
  tyr              VARCHAR2(60),
  hz               VARCHAR2(60),
  tshwbz           CHAR(1),
  pxbz             CHAR(3),
  bz               VARCHAR2(80),
  wxhwbz           CHAR(1),
  zdlbz            CHAR(1),
  szd              NVARCHAR2(40)
)
tablespace GK_SHARE
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    next 1
    minextents 1
    maxextents unlimited
  );

  -- Create table
create table GK_SHARE_JSJY_HS_SHIPINFO
(
  id               VARCHAR2(40) not null,
  create_date_time TIMESTAMP(6) default current_timestamp,
  update_date_time TIMESTAMP(6) default current_timestamp,
  record_status    NUMBER default 1,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NVARCHAR2(40),
  cbbh             CHAR(20),
  cbfl             CHAR(1),
  cbdjh            CHAR(14),
  zwcm             VARCHAR2(20),
  ywcm             VARCHAR2(40),
  ccdjh            CHAR(14),
  cbhh             CHAR(6),
  imobh            CHAR(10),
  pbh              CHAR(20),
  gjdm             CHAR(3),
  cjg              VARCHAR2(40),
  hcnhcbz          CHAR(1),
  cbzldm           CHAR(4),
  jcrq             TIMESTAMP(6),
  cbcd             NUMBER(8,2),
  zd               INTEGER,
  cbsyr            VARCHAR2(60),
  lzbz             CHAR(1)
)
tablespace GK_SHARE
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    next 1
    minextents 1
    maxextents unlimited
  );

  -- Create table
create table GK_SHARE_JSJY_HS_SOLIDGOODS
(
  id               VARCHAR2(40) not null,
  create_date_time TIMESTAMP(6) default current_timestamp,
  update_date_time TIMESTAMP(6) default current_timestamp,
  record_status    NUMBER default 1,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NVARCHAR2(40),
  sbdbh            CHAR(18),
  xh               INTEGER,
  whsbdbh          CHAR(18),
  thdh             VARCHAR2(100),
  hwlx             CHAR(1),
  sfzz             CHAR(1),
  sfgj             CHAR(1),
  wgxh             CHAR(10),
  wgbh             CHAR(10),
  zqysmczw         VARCHAR2(160),
  zqysmcyw         VARCHAR2(255),
  zb               CHAR(2),
  wxlb             CHAR(10),
  zzl              NUMBER(16,3),
  zhgzwmc          VARCHAR2(40),
  zhgywmc          VARCHAR2(40),
  xhgzwmc          VARCHAR2(40),
  xhgywmc          VARCHAR2(80),
  qygmc            VARCHAR2(40),
  mdgmc            VARCHAR2(40),
  zzwz             VARCHAR2(255),
  bz               VARCHAR2(80),
  tshwbz           CHAR(1),
  wxhwbz           CHAR(1),
  zdlbz            CHAR(1)
)
tablespace GK_SHARE
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    next 1
    minextents 1
    maxextents unlimited
  );

  -- Create table
create table GK_SHARE_JSJY_HS_TPCONTAINER
(
  id               VARCHAR2(40) not null,
  create_date_time TIMESTAMP(6) default current_timestamp,
  update_date_time TIMESTAMP(6) default current_timestamp,
  record_status    NUMBER default 1,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NVARCHAR2(40),
  sbdbh            CHAR(18),
  jzxbh            VARCHAR2(20),
  jzxgg            CHAR(4),
  jzxnjs           INTEGER,
  zl               NUMBER(16,2),
  pxbz             CHAR(3),
  qfh              VARCHAR2(30)
)
tablespace GK_SHARE
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    next 1
    minextents 1
    maxextents unlimited
  );

  -- Create table
create table GK_SHARE_JSJY_HS_TRAFFICLIQUID
(
  id               VARCHAR2(40) not null,
  create_date_time TIMESTAMP(6) default current_timestamp,
  update_date_time TIMESTAMP(6) default current_timestamp,
  record_status    NUMBER default 1,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NVARCHAR2(40),
  sbdbh            CHAR(18),
  cbbh             CHAR(20),
  zwcm             VARCHAR2(20),
  ywcm             VARCHAR2(40),
  hc               VARCHAR2(20),
  jcgbz            CHAR(1),
  nwmbz            CHAR(1),
  fhrzw            VARCHAR2(80),
  fhryw            VARCHAR2(80),
  shrzw            VARCHAR2(80),
  shryw            VARCHAR2(80),
  cyrdlzw          VARCHAR2(80),
  cyrdlyw          VARCHAR2(80),
  bwdm             CHAR(7),
  zhgzwmc          VARCHAR2(40),
  zhgywmc          VARCHAR2(80),
  xhgzwmc          VARCHAR2(40),
  xhgywmc          VARCHAR2(80),
  kszysj           TIMESTAMP(6),
  jszysj           TIMESTAMP(6),
  thdh             VARCHAR2(100),
  hwzl             CHAR(1),
  wrlb             CHAR(10),
  ylxz             CHAR(1),
  szyhqxz          CHAR(1),
  wgxh             CHAR(10),
  wgbh             CHAR(10),
  zqysmczw         VARCHAR2(160),
  zqysmcyw         VARCHAR2(255),
  wxlb             CHAR(10),
  hwbj             VARCHAR2(10),
  sl               NUMBER(16,3),
  sd               CHAR(1),
  krsx             NUMBER(4,1),
  krxx             NUMBER(4,1),
  zrwd             NUMBER(4,1),
  fd               NUMBER(4,1),
  ytxdmd           NUMBER(8,3),
  zqmd             NUMBER(8,3),
  zqyl             NUMBER(8,3),
  szrjd            NUMBER(8,3),
  nd               NUMBER(8,3),
  nddw             VARCHAR2(20),
  suand            NUMBER(8,3),
  tlv              NUMBER(8,3),
  kf               NUMBER(4,1),
  pc               NUMBER(4,1),
  ddl              NUMBER(4,1),
  yhwdhyl          NUMBER(4,1),
  zywd             NUMBER(4,1),
  hwfyx            VARCHAR2(100),
  yjcs             VARCHAR2(64),
  ryfh             VARCHAR2(80),
  fszl             VARCHAR2(255),
  lxrxm            VARCHAR2(30),
  lxfs             VARCHAR2(80),
  sbybh            CHAR(18),
  sbyxm            VARCHAR2(60),
  sbyzsbh          VARCHAR2(30),
  sbdwbh           CHAR(20),
  sbdwmc           VARCHAR2(100),
  sbrq             TIMESTAMP(6),
  hz               VARCHAR2(60),
  tyr              VARCHAR2(60),
  tshwbz           CHAR(1),
  yhgbbz           CHAR(1),
  bz               VARCHAR2(150),
  sjly             CHAR(3),
  shdw             CHAR(6),
  slrdm            CHAR(11),
  slrq             TIMESTAMP(6),
  shrdm            CHAR(11),
  shrq             TIMESTAMP(6),
  shyj             VARCHAR2(255),
  zfzh             CHAR(20),
  lzbz             CHAR(1)
)
tablespace GK_SHARE
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    next 8
    minextents 1
    maxextents unlimited
  );

  -- Create table
create table GK_SHARE_JSJY_HS_TRAFFICPACK
(
  id               VARCHAR2(40) not null,
  create_date_time TIMESTAMP(6) default current_timestamp,
  update_date_time TIMESTAMP(6) default current_timestamp,
  record_status    NUMBER default 1,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NVARCHAR2(40),
  sbdbh            CHAR(18),
  cbbh             CHAR(20),
  zwcm             VARCHAR2(20),
  ywcm             VARCHAR2(40),
  hc               VARCHAR2(20),
  bzszbz           CHAR(1),
  jcgbz            CHAR(1),
  nwmbz            CHAR(1),
  fhrzw            VARCHAR2(80),
  fhryw            VARCHAR2(80),
  shrzw            VARCHAR2(80),
  shryw            VARCHAR2(80),
  cyrdlzw          VARCHAR2(80),
  cyrdlyw          VARCHAR2(80),
  bwdm             CHAR(7),
  zhgzwmc          VARCHAR2(40),
  zhgywmc          VARCHAR2(80),
  xhgzwmc          VARCHAR2(40),
  xhgywmc          VARCHAR2(80),
  thdh             VARCHAR2(100),
  wgxh             CHAR(10),
  wgbh             CHAR(10),
  zqysmczw         VARCHAR2(160),
  zqysmcyw         VARCHAR2(255),
  zqysmcbcsm       VARCHAR2(255),
  wxlb             CHAR(10),
  fwxx1            VARCHAR2(50),
  fwxx2            VARCHAR2(50),
  pzl              CHAR(1),
  bjzl             CHAR(20),
  bjcl             CHAR(1),
  unbzbsh          VARCHAR2(40),
  hwbj             VARCHAR2(80),
  sd               CHAR(10),
  bzl              VARCHAR2(10),
  bjsl             INTEGER,
  mbzl             NUMBER(16,3),
  sldw             CHAR(2),
  zzl              NUMBER(16,3),
  jzl              NUMBER(16,3),
  kzwd             NUMBER(4,1),
  yjwd             NUMBER(4,1),
  sfhywrw          CHAR(1),
  yjcs             VARCHAR2(64),
  yljj             VARCHAR2(50),
  hwzyxs           CHAR(1),
  zjlx             CHAR(1),
  sfkc             CHAR(1),
  jzx20            INTEGER,
  jzx30            INTEGER,
  jzx40            INTEGER,
  jzx45            INTEGER,
  bzxteu           NUMBER(8,2),
  fbzxgg           INTEGER,
  fbxxs            INTEGER,
  jzxggcc          VARCHAR2(30),
  jzxggsl          INTEGER,
  fszl             VARCHAR2(255),
  kszysj           TIMESTAMP(6),
  jszysj           TIMESTAMP(6),
  sbybh            CHAR(18),
  sbyxm            VARCHAR2(60),
  sbyzsbh          VARCHAR2(30),
  sbdwbh           CHAR(20),
  sbdwmc           VARCHAR2(100),
  sbrq             TIMESTAMP(6),
  lxrxm            VARCHAR2(30),
  lxfs             VARCHAR2(80),
  hz               VARCHAR2(60),
  tyr              VARCHAR2(60),
  tshwbz           CHAR(1),
  bz               VARCHAR2(200),
  sjly             CHAR(3),
  shdw             CHAR(6),
  slrdm            CHAR(11),
  slrq             TIMESTAMP(6),
  shrdm            CHAR(11),
  shrq             TIMESTAMP(6),
  shyj             VARCHAR2(255),
  zfzh             CHAR(20),
  lzbz             CHAR(1)
)
tablespace GK_SHARE
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    next 8
    minextents 1
    maxextents unlimited
  );

  -- Create table
create table GK_SHARE_JSJY_HS_TRAFFICSOLID
(
  id               VARCHAR2(40) not null,
  create_date_time TIMESTAMP(6) default current_timestamp,
  update_date_time TIMESTAMP(6) default current_timestamp,
  record_status    NUMBER default 1,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NVARCHAR2(40),
  sbdbh            CHAR(18),
  cbbh             CHAR(20),
  zwcm             VARCHAR2(20),
  ywcm             VARCHAR2(40),
  hc               VARCHAR2(20),
  bzszbz           CHAR(1),
  jcgbz            CHAR(1),
  nwmbz            CHAR(1),
  fhrzw            VARCHAR2(80),
  fhryw            VARCHAR2(80),
  shrzw            VARCHAR2(80),
  shryw            VARCHAR2(80),
  cyrdlzw          VARCHAR2(80),
  cyrdlyw          VARCHAR2(80),
  bwdm             CHAR(7),
  zhgzwmc          VARCHAR2(40),
  zhgywmc          VARCHAR2(80),
  xhgzwmc          VARCHAR2(40),
  xhgywmc          VARCHAR2(80),
  thdh             VARCHAR2(100),
  wgxh             CHAR(10),
  wgbh             CHAR(10),
  zqysmczw         VARCHAR2(160),
  zqysmcyw         VARCHAR2(255),
  wxlb             CHAR(10),
  zzl              NUMBER(16,3),
  ms               VARCHAR2(200),
  znhqtsx          VARCHAR2(200),
  jzj              VARCHAR2(20),
  jzys             VARCHAR2(50),
  zb               CHAR(2),
  sysfjx           VARCHAR2(30),
  hxtx             VARCHAR2(200),
  pccx             VARCHAR2(200),
  tssm             VARCHAR2(200),
  yssfhl           VARCHAR2(30),
  tsxz             VARCHAR2(200),
  fszl             VARCHAR2(255),
  kszysj           TIMESTAMP(6),
  jszysj           TIMESTAMP(6),
  sbybh            CHAR(18),
  sbyxm            VARCHAR2(60),
  sbyzsbh          VARCHAR2(30),
  sbdwbh           CHAR(9),
  sbdwmc           VARCHAR2(100),
  sbrq             TIMESTAMP(6),
  lxrxm            VARCHAR2(30),
  lxfs             VARCHAR2(80),
  hz               VARCHAR2(60),
  tyr              VARCHAR2(60),
  tshwbz           CHAR(1),
  bz               VARCHAR2(200),
  sjly             CHAR(3),
  shdw             CHAR(6),
  slrdm            CHAR(11),
  slrq             TIMESTAMP(6),
  shrdm            CHAR(11),
  shrq             TIMESTAMP(6),
  shyj             VARCHAR2(255),
  zfzh             CHAR(20),
  lzbz             CHAR(1)
)
tablespace GK_SHARE
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    next 1
    minextents 1
    maxextents unlimited
  );

  -- Create table
create table GK_SHARE_JSJY_XKZNSFJ
(
  id               VARCHAR2(40),
  xkznsid          VARCHAR2(40),
  fjid             VARCHAR2(40),
  fjmc             NVARCHAR2(100),
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40),
  sftb             CHAR(1) default 'Y',
  tbzt             CHAR(1) default 'N'
)
tablespace GK_SHARE
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
-- Add comments to the table 
comment on table GK_SHARE_JSJY_XKZNSFJ
  is '许可证年审附件表';

  -- Create table
create table GK_SHARE_JSJY_XKZNSXX
(
  id               VARCHAR2(40),
  nsnf             NVARCHAR2(10),
  xkzid            VARCHAR2(40),
  ssjyr            VARCHAR2(40),
  bz               NVARCHAR2(400),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  record_status    NUMBER default 1,
  sftb             CHAR(1) default 'Y',
  tbzt             CHAR(1) default 'N',
  szd              VARCHAR2(40),
  szgq             VARCHAR2(40),
  szgk             VARCHAR2(40),
  clshyj           NVARCHAR2(400),
  clshry           NVARCHAR2(40),
  clshsj           TIMESTAMP(6),
  pzyj             NVARCHAR2(400),
  pzry             NVARCHAR2(40),
  pzsj             TIMESTAMP(6)
)
tablespace GK_SHARE
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 8K
    minextents 1
    maxextents unlimited
  );
-- Add comments to the table 
comment on table GK_SHARE_JSJY_XKZNSXX
  is '许可证年审信息表';