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_XKZNSXX
--GK_OPERATION_JSJY_LHBG
--GK_OPERATION_JSJY_LHBGFJ
--GK_OPERATION_JSJY_LHSQ
--GK_OPERATION_JSJY_LHSQFJ
--GK_OPERATION_JSJY_LHYX
--GK_OPERATION_JSJY_LHYXFJ
--GK_OPERATION_JSJY_JDTX
--GK_OPERATION_JSJY_JDTXFJ
--GK_OPERATION_JSJY_JDTXXX
--GK_OPERATION_JSJY_HXHBTJ
--航线航班表
-- 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 '许可证年审信息表';
  
  create table GK_OPERATION_JSJY_LHBG
(
  id               VARCHAR2(40),
  jyrid            VARCHAR2(40),
  jyrmc            NVARCHAR2(100),
  xkzbh            NVARCHAR2(100),
  lxr              NVARCHAR2(40),
  dh               NVARCHAR2(40),
  sqrq             TIMESTAMP(6),
  cz               NVARCHAR2(40),
  ybgdz            NVARCHAR2(40),
  xbgdz            NVARCHAR2(40),
  yfddbr           NVARCHAR2(40),
  xfddbr           NVARCHAR2(40),
  tyxyyy           NVARCHAR2(200),
  gkjshyj          NVARCHAR2(200),
  gkjshrq          TIMESTAMP(6),
  jttshyj          NVARCHAR2(200),
  jttshrq          TIMESTAMP(6),
  szd              VARCHAR2(40),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  tbzt             CHAR(1),
  sftb             CHAR(1)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table GK_OPERATION_JSJY_LHBG
  is '理货变更';
comment on column GK_OPERATION_JSJY_LHBG.id
  is '主健ID';
comment on column GK_OPERATION_JSJY_LHBG.jyrid
  is '经营人ID';
comment on column GK_OPERATION_JSJY_LHBG.jyrmc
  is '经营人名称';
comment on column GK_OPERATION_JSJY_LHBG.xkzbh
  is '许可证号';
comment on column GK_OPERATION_JSJY_LHBG.lxr
  is '联系人';
comment on column GK_OPERATION_JSJY_LHBG.dh
  is '电话';
comment on column GK_OPERATION_JSJY_LHBG.sqrq
  is '申请日期';
comment on column GK_OPERATION_JSJY_LHBG.cz
  is '传真';
comment on column GK_OPERATION_JSJY_LHBG.ybgdz
  is '原办公地址';
comment on column GK_OPERATION_JSJY_LHBG.xbgdz
  is '现办公地址';
comment on column GK_OPERATION_JSJY_LHBG.yfddbr
  is '原法定代表人';
comment on column GK_OPERATION_JSJY_LHBG.xfddbr
  is '现法定代表人';
comment on column GK_OPERATION_JSJY_LHBG.tyxyyy
  is '停业歇业原因';
comment on column GK_OPERATION_JSJY_LHBG.gkjshyj
  is '港口局意见';
comment on column GK_OPERATION_JSJY_LHBG.gkjshrq
  is '港口局审核时间';
comment on column GK_OPERATION_JSJY_LHBG.jttshyj
  is '交通厅意见';
comment on column GK_OPERATION_JSJY_LHBG.jttshrq
  is '交通厅审核时间';
comment on column GK_OPERATION_JSJY_LHBG.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_LHBG.create_user
  is '创建人';
comment on column GK_OPERATION_JSJY_LHBG.create_date_time
  is '创建时间';
comment on column GK_OPERATION_JSJY_LHBG.update_user
  is '修改人';
comment on column GK_OPERATION_JSJY_LHBG.update_date_time
  is '修改时间';
comment on column GK_OPERATION_JSJY_LHBG.record_status
  is '状态';
comment on column GK_OPERATION_JSJY_LHBG.szgk
  is '所在港口';
comment on column GK_OPERATION_JSJY_LHBG.szgq
  is '所在港区';
comment on column GK_OPERATION_JSJY_LHBG.tbzt
  is '同步状态';
comment on column GK_OPERATION_JSJY_LHBG.sftb
  is '是否同步';


create table GK_OPERATION_JSJY_LHBGFJ
(
  id               VARCHAR2(40),
  bgid             VARCHAR2(40),
  fjmc             NVARCHAR2(100),
  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),
  fjid             VARCHAR2(40)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table GK_OPERATION_JSJY_LHBGFJ
  is '理货变更附件';


create table GK_OPERATION_JSJY_LHSQ
(
  id               VARCHAR2(40) not null,
  sqr              NVARCHAR2(100),
  sqrlxfs          NVARCHAR2(20),
  sqrdz            NVARCHAR2(200),
  sqryzbm          NVARCHAR2(20),
  wtdlrxm          NVARCHAR2(20),
  wtdlrlxfs        NVARCHAR2(20),
  sqrq             TIMESTAMP(6),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  sftb             CHAR(1) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null,
  jyrid            VARCHAR2(40),
  jyrmc            VARCHAR2(40),
  szd              VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  gsmc             VARCHAR2(40),
  zcdz             NVARCHAR2(200),
  fddbr            VARCHAR2(40),
  lxr              VARCHAR2(40),
  lxdh             VARCHAR2(40),
  gsyyzzbh         VARCHAR2(40),
  jydy             VARCHAR2(40),
  ygzs             VARCHAR2(40),
  lhys             VARCHAR2(40),
  zczb             VARCHAR2(40),
  sqnr             NVARCHAR2(200),
  yysr             NVARCHAR2(20),
  yysrr            NVARCHAR2(20),
  lhl              NVARCHAR2(20),
  lhll             NVARCHAR2(20),
  lxl              NVARCHAR2(20),
  lxll             NVARCHAR2(20),
  oneyear          NVARCHAR2(20),
  twoyear          NVARCHAR2(20),
  gdmc             NVARCHAR2(2000),
  zcd              NVARCHAR2(2000),
  tzgb             NVARCHAR2(2000),
  sqrqz            NVARCHAR2(20)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on column GK_OPERATION_JSJY_LHSQ.id
  is '主键';
comment on column GK_OPERATION_JSJY_LHSQ.sqr
  is '申请人';
comment on column GK_OPERATION_JSJY_LHSQ.sqrlxfs
  is '申请人联系方式';
comment on column GK_OPERATION_JSJY_LHSQ.sqrdz
  is '申请人地址';
comment on column GK_OPERATION_JSJY_LHSQ.sqryzbm
  is '申请人邮政编码';
comment on column GK_OPERATION_JSJY_LHSQ.wtdlrxm
  is '委托代理人姓名';
comment on column GK_OPERATION_JSJY_LHSQ.wtdlrlxfs
  is '委托代理人联系方式';
comment on column GK_OPERATION_JSJY_LHSQ.sqrq
  is '申请时间';
comment on column GK_OPERATION_JSJY_LHSQ.sftb
  is '是否同步';
comment on column GK_OPERATION_JSJY_LHSQ.tbzt
  is '同步状态';
comment on column GK_OPERATION_JSJY_LHSQ.jyrid
  is '经营人id';
comment on column GK_OPERATION_JSJY_LHSQ.jyrmc
  is '经营人名称';
comment on column GK_OPERATION_JSJY_LHSQ.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_LHSQ.szgk
  is '所在港口';
comment on column GK_OPERATION_JSJY_LHSQ.szgq
  is '所在港区';
comment on column GK_OPERATION_JSJY_LHSQ.gsmc
  is '公司名称';
comment on column GK_OPERATION_JSJY_LHSQ.zcdz
  is '注册地址';
comment on column GK_OPERATION_JSJY_LHSQ.fddbr
  is '法定代表人';
comment on column GK_OPERATION_JSJY_LHSQ.lxr
  is '联系人';
comment on column GK_OPERATION_JSJY_LHSQ.lxdh
  is '联系人电话';
comment on column GK_OPERATION_JSJY_LHSQ.gsyyzzbh
  is '工商营业执照编号';
comment on column GK_OPERATION_JSJY_LHSQ.jydy
  is '经营地域';
comment on column GK_OPERATION_JSJY_LHSQ.ygzs
  is '员工总数';
comment on column GK_OPERATION_JSJY_LHSQ.lhys
  is '理货员数';
comment on column GK_OPERATION_JSJY_LHSQ.zczb
  is '注册资本';
alter table GK_OPERATION_JSJY_LHSQ
  add primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

create table GK_OPERATION_JSJY_LHSQFJ
(
  id               VARCHAR2(40) not null,
  sqid             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' not null,
  tbzt             CHAR(1) default 'N' not null
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on column GK_OPERATION_JSJY_LHSQFJ.id
  is '主键';
comment on column GK_OPERATION_JSJY_LHSQFJ.sqid
  is '申请ID';
comment on column GK_OPERATION_JSJY_LHSQFJ.fjid
  is '附件ID';
comment on column GK_OPERATION_JSJY_LHSQFJ.fjmc
  is '附件名称';
comment on column GK_OPERATION_JSJY_LHSQFJ.create_user
  is '创建人';
comment on column GK_OPERATION_JSJY_LHSQFJ.update_user
  is '修改人';
comment on column GK_OPERATION_JSJY_LHSQFJ.create_date_time
  is '创建时间';
comment on column GK_OPERATION_JSJY_LHSQFJ.update_date_time
  is '修改时间';
comment on column GK_OPERATION_JSJY_LHSQFJ.record_status
  is '状态';
comment on column GK_OPERATION_JSJY_LHSQFJ.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_LHSQFJ.sftb
  is '是否同步';
comment on column GK_OPERATION_JSJY_LHSQFJ.tbzt
  is '同步状态';
alter table GK_OPERATION_JSJY_LHSQFJ
  add primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );


create table GK_OPERATION_JSJY_LHYX
(
  id               VARCHAR2(40),
  jyrid            VARCHAR2(40),
  jyrmc            NVARCHAR2(40),
  zcdz             NVARCHAR2(100),
  fddbr            NVARCHAR2(40),
  gsyyzzbh         NVARCHAR2(50),
  lxr              NVARCHAR2(20),
  zczb             NVARCHAR2(40),
  lxdh             NVARCHAR2(20),
  jydy             NVARCHAR2(500),
  xkzbh            NVARCHAR2(40),
  yxrq             TIMESTAMP(6),
  ygzs             NVARCHAR2(10),
  lhys             NVARCHAR2(10),
  yysr             NVARCHAR2(10),
  lhl              NVARCHAR2(10),
  lxl              NVARCHAR2(10),
  yysrr            NVARCHAR2(10),
  lhll             NVARCHAR2(10),
  lxll             NVARCHAR2(10),
  szd              VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  record_status    INTEGER,
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  tbzt             CHAR(1),
  sftb             CHAR(1),
  oneyear          NVARCHAR2(10),
  twoyear          NVARCHAR2(10)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table GK_OPERATION_JSJY_LHYX
  is '理货延续';


create table GK_OPERATION_JSJY_LHYXFJ
(
  id               VARCHAR2(40),
  yxid             VARCHAR2(40),
  fjmc             NVARCHAR2(100),
  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),
  fjid             VARCHAR2(40)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );
comment on table GK_OPERATION_JSJY_LHYXFJ
  is '理货延续附件';

create table GK_OPERATION_JSJY_JDTX
(
  id               VARCHAR2(40) not null,
  szd              VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  dcdw             NVARCHAR2(100),
  sqrq             TIMESTAMP(6),
  gkjyr            VARCHAR2(40),
  cjdcry           NVARCHAR2(100),
  bdcdwfzr         NVARCHAR2(100),
  bdcdwcjry        NVARCHAR2(100),
  zgqx             TIMESTAMP(6),
  yhmc             NVARCHAR2(1000),
  zgcsyq           NVARCHAR2(1000),
  zgsm             NVARCHAR2(1000),
  zgfj             NVARCHAR2(100),
  bz               NVARCHAR2(1000),
  zghfj            NVARCHAR2(100),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  tbzt             CHAR(1),
  sftb             CHAR(1),
  flowflag         CHAR(1),
  btnflag          CHAR(1),
  isflag           CHAR(1) default 0
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 8K
    minextents 1
    maxextents unlimited
  );
-- Add comments to the table 
comment on table GK_OPERATION_JSJY_JDTX
  is '监督提醒表';
-- Add comments to the columns 
comment on column GK_OPERATION_JSJY_JDTX.id
  is '主键';
comment on column GK_OPERATION_JSJY_JDTX.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_JDTX.szgk
  is '所在所在港口';
comment on column GK_OPERATION_JSJY_JDTX.szgq
  is '所在港区';
comment on column GK_OPERATION_JSJY_JDTX.dcdw
  is '监查单位';
comment on column GK_OPERATION_JSJY_JDTX.sqrq
  is '申请日期';
comment on column GK_OPERATION_JSJY_JDTX.gkjyr
  is '被监查单位';
comment on column GK_OPERATION_JSJY_JDTX.cjdcry
  is '参加监查人员';
comment on column GK_OPERATION_JSJY_JDTX.bdcdwfzr
  is '被督查单位负责人';
comment on column GK_OPERATION_JSJY_JDTX.bdcdwcjry
  is '被督查单位参加人员';
comment on column GK_OPERATION_JSJY_JDTX.zgqx
  is '整改期限';
comment on column GK_OPERATION_JSJY_JDTX.yhmc
  is '隐患名称';
comment on column GK_OPERATION_JSJY_JDTX.zgcsyq
  is '整改措施要求';
comment on column GK_OPERATION_JSJY_JDTX.zgsm
  is '整改说明';
comment on column GK_OPERATION_JSJY_JDTX.zgfj
  is '整改附件';
comment on column GK_OPERATION_JSJY_JDTX.bz
  is '备注';
comment on column GK_OPERATION_JSJY_JDTX.zghfj
  is '整改后附件';
comment on column GK_OPERATION_JSJY_JDTX.create_user
  is '创建人';
comment on column GK_OPERATION_JSJY_JDTX.create_date_time
  is '创建日期';
comment on column GK_OPERATION_JSJY_JDTX.update_user
  is '修改人';
comment on column GK_OPERATION_JSJY_JDTX.update_date_time
  is '修改日期';
comment on column GK_OPERATION_JSJY_JDTX.flowflag
  is '1下发，2，流程中3完成0保存';
comment on column GK_OPERATION_JSJY_JDTX.isflag
  is '文件是否已同步0.否 1.是';

alter table GK_OPERATION_JSJY_JDTX
  add constraint GK_OPERATION_JSJY_JDTX_PL primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

-- Create table
create table GK_OPERATION_JSJY_JDTXFJ
(
  id               VARCHAR2(40) not null,
  jdtxid           VARCHAR2(40),
  fjid             VARCHAR2(40),
  fjmc             NVARCHAR2(100),
  type             CHAR(1),
  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),
  tbzt             CHAR(1)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 8K
    minextents 1
    maxextents unlimited
  );
alter table GK_OPERATION_JSJY_JDTXFJ
  add constraint GK_OPERATION_JSJY_JDTXFJ_PK primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

create table GK_OPERATION_JSJY_JDTXXX
(
  id               VARCHAR2(40) not null,
  szd              VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  dcdw             NVARCHAR2(100),
  sqrq             TIMESTAMP(6),
  gkjyr            VARCHAR2(40),
  cjdcry           NVARCHAR2(100),
  bdcdwfzr         NVARCHAR2(100),
  bdcdwcjry        NVARCHAR2(100),
  yhdl             VARCHAR2(40),
  yhzl             VARCHAR2(40),
  jcfl             VARCHAR2(40),
  jcyj             VARCHAR2(40),
  yhfl             VARCHAR2(40),
  yhqy             VARCHAR2(40),
  yhjb             VARCHAR2(40),
  zgqx             TIMESTAMP(6),
  yhmc             NVARCHAR2(1000),
  zgcsyq           NVARCHAR2(1000),
  zgsm             NVARCHAR2(1000),
  zgfj             NVARCHAR2(100),
  bz               NVARCHAR2(1000),
  dqzt             VARCHAR2(10),
  zghtzje          NVARCHAR2(20),
  zghfj            NVARCHAR2(100),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  tbzt             CHAR(1),
  sftb             CHAR(1),
  ffcs             NVARCHAR2(1000),
  flowstatus       CHAR(1)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on column GK_OPERATION_JSJY_JDTXXX.id
  is '主键';
comment on column GK_OPERATION_JSJY_JDTXXX.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_JDTXXX.szgk
  is '所在港口';
comment on column GK_OPERATION_JSJY_JDTXXX.szgq
  is '所在港区';
comment on column GK_OPERATION_JSJY_JDTXXX.dcdw
  is '监查单位';
comment on column GK_OPERATION_JSJY_JDTXXX.sqrq
  is '申请日期';
comment on column GK_OPERATION_JSJY_JDTXXX.gkjyr
  is '被监查单位';
comment on column GK_OPERATION_JSJY_JDTXXX.cjdcry
  is '参加监查人员';
comment on column GK_OPERATION_JSJY_JDTXXX.bdcdwfzr
  is '被督查单位负责人';
comment on column GK_OPERATION_JSJY_JDTXXX.bdcdwcjry
  is '被督查单位参加人员';
comment on column GK_OPERATION_JSJY_JDTXXX.yhdl
  is '隐患大类';
comment on column GK_OPERATION_JSJY_JDTXXX.yhzl
  is '隐患中类';
comment on column GK_OPERATION_JSJY_JDTXXX.jcfl
  is '检查类型';
comment on column GK_OPERATION_JSJY_JDTXXX.jcyj
  is '检查依据';
comment on column GK_OPERATION_JSJY_JDTXXX.yhfl
  is '隐患分类';
comment on column GK_OPERATION_JSJY_JDTXXX.yhqy
  is '隐患区域';
comment on column GK_OPERATION_JSJY_JDTXXX.yhjb
  is '隐患级别';
comment on column GK_OPERATION_JSJY_JDTXXX.zgqx
  is '整改期限';
comment on column GK_OPERATION_JSJY_JDTXXX.yhmc
  is '隐患名称';
comment on column GK_OPERATION_JSJY_JDTXXX.zgcsyq
  is '整改措施要求';
comment on column GK_OPERATION_JSJY_JDTXXX.zgsm
  is '整改说明';
comment on column GK_OPERATION_JSJY_JDTXXX.zgfj
  is '整改附件';
comment on column GK_OPERATION_JSJY_JDTXXX.bz
  is '备注';
comment on column GK_OPERATION_JSJY_JDTXXX.dqzt
  is '当前状态';
comment on column GK_OPERATION_JSJY_JDTXXX.zghtzje
  is '整改后投资金额';
comment on column GK_OPERATION_JSJY_JDTXXX.zghfj
  is '整改后附件';
comment on column GK_OPERATION_JSJY_JDTXXX.create_user
  is '创建人';
comment on column GK_OPERATION_JSJY_JDTXXX.create_date_time
  is '创建日期';
comment on column GK_OPERATION_JSJY_JDTXXX.update_user
  is '修改人';
comment on column GK_OPERATION_JSJY_JDTXXX.update_date_time
  is '修改日期';
comment on column GK_OPERATION_JSJY_JDTXXX.ffcs
  is '防范措施（预案）';
alter table GK_OPERATION_JSJY_JDTXXX
  add constraint GK_OPERATION_JSJY_JDTXXX_PK primary key (ID)
  using index 
  tablespace USERS
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );

-- Create table
create table GK_OPERATION_JSJY_HXHBTJ
(
  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,
  nmjzxttl         NUMBER,
  wmjzxttl         NUMBER,
  yyhxts           NUMBER,
  yyhxhbs          NUMBER,
  yyhxbz           NVARCHAR2(200),
  jyhxts           NUMBER,
  jyhxhbs          NUMBER,
  jyhxbz           NVARCHAR2(200),
  nzxts            NUMBER,
  nzxhbs           NUMBER,
  nzxbz            NVARCHAR2(200),
  nmhxts           NUMBER,
  nmhxhbs          NUMBER,
  nmhxbz           NVARCHAR2(200),
  szgk             VARCHAR2(40),
  nnmjzxttl        NUMBER,
  nwmjzxttl        NUMBER,
  bywcl            NUMBER,
  bnljl            NUMBER,
  tbzzs            NUMBER,
  nmtbzzs          NUMBER,
  wmtbzzs          NUMBER,
  yyxkphxs         NUMBER,
  yytkhxs          NUMBER,
  jyxkphxs         NUMBER,
  jytkhxs          NUMBER,
  nzxxkphxs        NUMBER,
  nzxtkhxs         NUMBER,
  nmxkphxs         NUMBER,
  nmtkhxs          NUMBER,
  szd              VARCHAR2(40),
  sftb             CHAR(1) default 'Y',
  tbzt             CHAR(1) default 'N',
  rq               VARCHAR2(20)
)
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_HXHBTJ.id
  is 'ID';
comment on column GK_OPERATION_JSJY_HXHBTJ.create_user
  is '创建人';
comment on column GK_OPERATION_JSJY_HXHBTJ.update_user
  is '修改人';
comment on column GK_OPERATION_JSJY_HXHBTJ.create_date_time
  is '创建时间';
comment on column GK_OPERATION_JSJY_HXHBTJ.update_date_time
  is '修改时间';
comment on column GK_OPERATION_JSJY_HXHBTJ.record_status
  is '数据状态';
comment on column GK_OPERATION_JSJY_HXHBTJ.nmjzxttl
  is '月内贸集装箱吞吐量  TEU';
comment on column GK_OPERATION_JSJY_HXHBTJ.wmjzxttl
  is '月外贸集装箱吞吐量  TEU';
comment on column GK_OPERATION_JSJY_HXHBTJ.yyhxts
  is '远洋航线条数';
comment on column GK_OPERATION_JSJY_HXHBTJ.yyhxhbs
  is '远洋航线航班数';
comment on column GK_OPERATION_JSJY_HXHBTJ.yyhxbz
  is '远洋航线备注';
comment on column GK_OPERATION_JSJY_HXHBTJ.jyhxts
  is '近洋航线条数';
comment on column GK_OPERATION_JSJY_HXHBTJ.jyhxhbs
  is '近洋航线航班数';
comment on column GK_OPERATION_JSJY_HXHBTJ.jyhxbz
  is '近洋航线备注';
comment on column GK_OPERATION_JSJY_HXHBTJ.nzxts
  is '内支线条数';
comment on column GK_OPERATION_JSJY_HXHBTJ.nzxhbs
  is '内支线航班数';
comment on column GK_OPERATION_JSJY_HXHBTJ.nzxbz
  is '内支线备注';
comment on column GK_OPERATION_JSJY_HXHBTJ.nmhxts
  is '内贸航线条数';
comment on column GK_OPERATION_JSJY_HXHBTJ.nmhxhbs
  is '内贸航线航班数';
comment on column GK_OPERATION_JSJY_HXHBTJ.nmhxbz
  is '内贸航线备注';
comment on column GK_OPERATION_JSJY_HXHBTJ.szgk
  is '所在港口';
comment on column GK_OPERATION_JSJY_HXHBTJ.nnmjzxttl
  is '年内贸集装箱吞吐量  TEU';
comment on column GK_OPERATION_JSJY_HXHBTJ.nwmjzxttl
  is '年外贸集装箱吞吐量  TEU';
comment on column GK_OPERATION_JSJY_HXHBTJ.bywcl
  is '本月完成量';
comment on column GK_OPERATION_JSJY_HXHBTJ.bnljl
  is '本年累积量';
comment on column GK_OPERATION_JSJY_HXHBTJ.tbzzs
  is '同比增长数';
comment on column GK_OPERATION_JSJY_HXHBTJ.nmtbzzs
  is '内贸同比增长数';
comment on column GK_OPERATION_JSJY_HXHBTJ.wmtbzzs
  is '外贸同比增长数';
comment on column GK_OPERATION_JSJY_HXHBTJ.yyxkphxs
  is '远洋新开辟航线数';
comment on column GK_OPERATION_JSJY_HXHBTJ.yytkhxs
  is '远洋停开航线数';
comment on column GK_OPERATION_JSJY_HXHBTJ.jyxkphxs
  is '近洋新开辟航线数';
comment on column GK_OPERATION_JSJY_HXHBTJ.jytkhxs
  is '近洋停开航线数';
comment on column GK_OPERATION_JSJY_HXHBTJ.nzxxkphxs
  is '内支线新开辟航线数';
comment on column GK_OPERATION_JSJY_HXHBTJ.nzxtkhxs
  is '内支线停开航线数';
comment on column GK_OPERATION_JSJY_HXHBTJ.nmxkphxs
  is '内贸新开辟航线数';
comment on column GK_OPERATION_JSJY_HXHBTJ.nmtkhxs
  is '内贸停开航线数';
comment on column GK_OPERATION_JSJY_HXHBTJ.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_HXHBTJ.sftb
  is '是否同步';
comment on column GK_OPERATION_JSJY_HXHBTJ.tbzt
  is '同步状态';
comment on column GK_OPERATION_JSJY_HXHBTJ.rq
  is '日期';
-- Create/Recreate primary, unique and foreign key constraints 
alter table GK_OPERATION_JSJY_HXHBTJ
  add constraint GK_OPERATION_JSJY_HXHBTJ primary key (ID)
  using index 
  tablespace GK_BASIC
  pctfree 10
  initrans 2
  maxtrans 255
  storage
  (
    initial 64K
    next 1M
    minextents 1
    maxextents unlimited
  );