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 '许可证年审信息表';
  
  create table GK.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.GK_OPERATION_JSJY_LHBG
  is '理货变更';
comment on column GK.GK_OPERATION_JSJY_LHBG.id
  is '主健ID';
comment on column GK.GK_OPERATION_JSJY_LHBG.jyrid
  is '经营人ID';
comment on column GK.GK_OPERATION_JSJY_LHBG.jyrmc
  is '经营人名称';
comment on column GK.GK_OPERATION_JSJY_LHBG.xkzbh
  is '许可证号';
comment on column GK.GK_OPERATION_JSJY_LHBG.lxr
  is '联系人';
comment on column GK.GK_OPERATION_JSJY_LHBG.dh
  is '电话';
comment on column GK.GK_OPERATION_JSJY_LHBG.sqrq
  is '申请日期';
comment on column GK.GK_OPERATION_JSJY_LHBG.cz
  is '传真';
comment on column GK.GK_OPERATION_JSJY_LHBG.ybgdz
  is '原办公地址';
comment on column GK.GK_OPERATION_JSJY_LHBG.xbgdz
  is '现办公地址';
comment on column GK.GK_OPERATION_JSJY_LHBG.yfddbr
  is '原法定代表人';
comment on column GK.GK_OPERATION_JSJY_LHBG.xfddbr
  is '现法定代表人';
comment on column GK.GK_OPERATION_JSJY_LHBG.tyxyyy
  is '停业歇业原因';
comment on column GK.GK_OPERATION_JSJY_LHBG.gkjshyj
  is '港口局意见';
comment on column GK.GK_OPERATION_JSJY_LHBG.gkjshrq
  is '港口局审核时间';
comment on column GK.GK_OPERATION_JSJY_LHBG.jttshyj
  is '交通厅意见';
comment on column GK.GK_OPERATION_JSJY_LHBG.jttshrq
  is '交通厅审核时间';
comment on column GK.GK_OPERATION_JSJY_LHBG.szd
  is '所在地';
comment on column GK.GK_OPERATION_JSJY_LHBG.create_user
  is '创建人';
comment on column GK.GK_OPERATION_JSJY_LHBG.create_date_time
  is '创建时间';
comment on column GK.GK_OPERATION_JSJY_LHBG.update_user
  is '修改人';
comment on column GK.GK_OPERATION_JSJY_LHBG.update_date_time
  is '修改时间';
comment on column GK.GK_OPERATION_JSJY_LHBG.record_status
  is '状态';
comment on column GK.GK_OPERATION_JSJY_LHBG.szgk
  is '所在港口';
comment on column GK.GK_OPERATION_JSJY_LHBG.szgq
  is '所在港区';
comment on column GK.GK_OPERATION_JSJY_LHBG.tbzt
  is '同步状态';
comment on column GK.GK_OPERATION_JSJY_LHBG.sftb
  is '是否同步';


create table GK.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.GK_OPERATION_JSJY_LHBGFJ
  is '理货变更附件';


create table GK.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.GK_OPERATION_JSJY_LHSQ.id
  is '主键';
comment on column GK.GK_OPERATION_JSJY_LHSQ.sqr
  is '申请人';
comment on column GK.GK_OPERATION_JSJY_LHSQ.sqrlxfs
  is '申请人联系方式';
comment on column GK.GK_OPERATION_JSJY_LHSQ.sqrdz
  is '申请人地址';
comment on column GK.GK_OPERATION_JSJY_LHSQ.sqryzbm
  is '申请人邮政编码';
comment on column GK.GK_OPERATION_JSJY_LHSQ.wtdlrxm
  is '委托代理人姓名';
comment on column GK.GK_OPERATION_JSJY_LHSQ.wtdlrlxfs
  is '委托代理人联系方式';
comment on column GK.GK_OPERATION_JSJY_LHSQ.sqrq
  is '申请时间';
comment on column GK.GK_OPERATION_JSJY_LHSQ.sftb
  is '是否同步';
comment on column GK.GK_OPERATION_JSJY_LHSQ.tbzt
  is '同步状态';
comment on column GK.GK_OPERATION_JSJY_LHSQ.jyrid
  is '经营人id';
comment on column GK.GK_OPERATION_JSJY_LHSQ.jyrmc
  is '经营人名称';
comment on column GK.GK_OPERATION_JSJY_LHSQ.szd
  is '所在地';
comment on column GK.GK_OPERATION_JSJY_LHSQ.szgk
  is '所在港口';
comment on column GK.GK_OPERATION_JSJY_LHSQ.szgq
  is '所在港区';
comment on column GK.GK_OPERATION_JSJY_LHSQ.gsmc
  is '公司名称';
comment on column GK.GK_OPERATION_JSJY_LHSQ.zcdz
  is '注册地址';
comment on column GK.GK_OPERATION_JSJY_LHSQ.fddbr
  is '法定代表人';
comment on column GK.GK_OPERATION_JSJY_LHSQ.lxr
  is '联系人';
comment on column GK.GK_OPERATION_JSJY_LHSQ.lxdh
  is '联系人电话';
comment on column GK.GK_OPERATION_JSJY_LHSQ.gsyyzzbh
  is '工商营业执照编号';
comment on column GK.GK_OPERATION_JSJY_LHSQ.jydy
  is '经营地域';
comment on column GK.GK_OPERATION_JSJY_LHSQ.ygzs
  is '员工总数';
comment on column GK.GK_OPERATION_JSJY_LHSQ.lhys
  is '理货员数';
comment on column GK.GK_OPERATION_JSJY_LHSQ.zczb
  is '注册资本';
alter table GK.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
  );

prompt

prompt Creating table GK_OPERATION_JSJY_LHSQFJ
prompt =======================================
prompt

create table GK.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.GK_OPERATION_JSJY_LHSQFJ.id
  is '主键';
comment on column GK.GK_OPERATION_JSJY_LHSQFJ.sqid
  is '申请ID';
comment on column GK.GK_OPERATION_JSJY_LHSQFJ.fjid
  is '附件ID';
comment on column GK.GK_OPERATION_JSJY_LHSQFJ.fjmc
  is '附件名称';
comment on column GK.GK_OPERATION_JSJY_LHSQFJ.create_user
  is '创建人';
comment on column GK.GK_OPERATION_JSJY_LHSQFJ.update_user
  is '修改人';
comment on column GK.GK_OPERATION_JSJY_LHSQFJ.create_date_time
  is '创建时间';
comment on column GK.GK_OPERATION_JSJY_LHSQFJ.update_date_time
  is '修改时间';
comment on column GK.GK_OPERATION_JSJY_LHSQFJ.record_status
  is '状态';
comment on column GK.GK_OPERATION_JSJY_LHSQFJ.szd
  is '所在地';
comment on column GK.GK_OPERATION_JSJY_LHSQFJ.sftb
  is '是否同步';
comment on column GK.GK_OPERATION_JSJY_LHSQFJ.tbzt
  is '同步状态';
alter table GK.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.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.GK_OPERATION_JSJY_LHYX
  is '理货延续';


create table GK.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.GK_OPERATION_JSJY_LHYXFJ
  is '理货延续附件';

create table GK.GK_OPERATION_JSJY_JGBG
(
  id               VARCHAR2(40) not null,
  xmmc             VARCHAR2(200),
  xmfr             VARCHAR2(40),
  jsdd             NVARCHAR2(500),
  jsgm             NVARCHAR2(200),
  tzlx             VARCHAR2(20),
  ztz              NUMBER,
  xmhzjb           VARCHAR2(20),
  axspjb           VARCHAR2(20),
  axcd             NUMBER,
  bwdj             NUMBER,
  bwhz             VARCHAR2(40),
  tgnl             VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  create_date_time TIMESTAMP(0),
  update_date_time TIMESTAMP(0),
  record_status    NUMBER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NUMBER,
  xmlx             VARCHAR2(40),
  jyrid            VARCHAR2(40),
  sftb             CHAR(1) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null,
  bwyt             VARCHAR2(30),
  zyhbwfl          VARCHAR2(40),
  lcjd             VARCHAR2(40),
  sfqswj           VARCHAR2(20)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on column GK.GK_OPERATION_JSJY_JGBG.id
  is '唯一标识';
comment on column GK.GK_OPERATION_JSJY_JGBG.xmmc
  is '项目名称';
comment on column GK.GK_OPERATION_JSJY_JGBG.xmfr
  is '项目法人';
comment on column GK.GK_OPERATION_JSJY_JGBG.jsdd
  is '建设地点';
comment on column GK.GK_OPERATION_JSJY_JGBG.jsgm
  is '建设规模';
comment on column GK.GK_OPERATION_JSJY_JGBG.tzlx
  is '投资类型（政府投资/企业投资）';
comment on column GK.GK_OPERATION_JSJY_JGBG.ztz
  is '总投资（万元）';
comment on column GK.GK_OPERATION_JSJY_JGBG.xmhzjb
  is '项目核准级别(国/省/市)';
comment on column GK.GK_OPERATION_JSJY_JGBG.axspjb
  is '岸线审批级别（部/省/市/无）';
comment on column GK.GK_OPERATION_JSJY_JGBG.axcd
  is '岸线长度';
comment on column GK.GK_OPERATION_JSJY_JGBG.bwdj
  is '泊位吨级';
comment on column GK.GK_OPERATION_JSJY_JGBG.bwhz
  is '泊位货种';
comment on column GK.GK_OPERATION_JSJY_JGBG.tgnl
  is '通过能力';
comment on column GK.GK_OPERATION_JSJY_JGBG.szgk
  is '所在港口';
comment on column GK.GK_OPERATION_JSJY_JGBG.szgq
  is '所在港区';
comment on column GK.GK_OPERATION_JSJY_JGBG.szd
  is '所在地';
comment on column GK.GK_OPERATION_JSJY_JGBG.xmlx
  is '项目类型';
comment on column GK.GK_OPERATION_JSJY_JGBG.jyrid
  is '经营人id';
comment on column GK.GK_OPERATION_JSJY_JGBG.sftb
  is '是否同步';
comment on column GK.GK_OPERATION_JSJY_JGBG.tbzt
  is '同步状态';
comment on column GK.GK_OPERATION_JSJY_JGBG.bwyt
  is '泊位用途';
comment on column GK.GK_OPERATION_JSJY_JGBG.zyhbwfl
  is '专业化泊位分类';
comment on column GK.GK_OPERATION_JSJY_JGBG.lcjd
  is '流程节点';
comment on column GK.GK_OPERATION_JSJY_JGBG.sfqswj
  is '是否缺失文件';
alter table GK.GK_OPERATION_JSJY_JGBG
  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 GK.GK_OPERATION_JSJY_JGBGFJ
(
  id               VARCHAR2(40),
  ssid             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 16K
    next 8K
    minextents 1
    maxextents unlimited
  );


create table GK.GK_OPERATION_JSJY_JGSQ
(
  id               VARCHAR2(40) not null,
  xmmc             VARCHAR2(200),
  xmfr             VARCHAR2(40),
  jsdd             NVARCHAR2(500),
  jsgm             NVARCHAR2(200),
  tzlx             VARCHAR2(20),
  ztz              NUMBER,
  xmhzjb           VARCHAR2(20),
  axspjb           VARCHAR2(20),
  axcd             NUMBER,
  bwdj             NUMBER,
  bwhz             VARCHAR2(40),
  tgnl             VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  create_date_time TIMESTAMP(0),
  update_date_time TIMESTAMP(0),
  record_status    NUMBER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NUMBER,
  xmlx             VARCHAR2(40),
  jyrid            VARCHAR2(40),
  sftb             CHAR(1) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null,
  bwyt             VARCHAR2(30),
  zyhbwfl          VARCHAR2(40),
  lcjd             VARCHAR2(40),
  sfqswj           VARCHAR2(20)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on column GK.GK_OPERATION_JSJY_JGSQ.id
  is '唯一标识';
comment on column GK.GK_OPERATION_JSJY_JGSQ.xmmc
  is '项目名称';
comment on column GK.GK_OPERATION_JSJY_JGSQ.xmfr
  is '项目法人';
comment on column GK.GK_OPERATION_JSJY_JGSQ.jsdd
  is '建设地点';
comment on column GK.GK_OPERATION_JSJY_JGSQ.jsgm
  is '建设规模';
comment on column GK.GK_OPERATION_JSJY_JGSQ.tzlx
  is '投资类型（政府投资/企业投资）';
comment on column GK.GK_OPERATION_JSJY_JGSQ.ztz
  is '总投资（万元）';
comment on column GK.GK_OPERATION_JSJY_JGSQ.xmhzjb
  is '项目核准级别(国/省/市)';
comment on column GK.GK_OPERATION_JSJY_JGSQ.axspjb
  is '岸线审批级别（部/省/市/无）';
comment on column GK.GK_OPERATION_JSJY_JGSQ.axcd
  is '岸线长度';
comment on column GK.GK_OPERATION_JSJY_JGSQ.bwdj
  is '泊位吨级';
comment on column GK.GK_OPERATION_JSJY_JGSQ.bwhz
  is '泊位货种';
comment on column GK.GK_OPERATION_JSJY_JGSQ.tgnl
  is '通过能力';
comment on column GK.GK_OPERATION_JSJY_JGSQ.szgk
  is '所在港口';
comment on column GK.GK_OPERATION_JSJY_JGSQ.szgq
  is '所在港区';
comment on column GK.GK_OPERATION_JSJY_JGSQ.szd
  is '所在地';
comment on column GK.GK_OPERATION_JSJY_JGSQ.xmlx
  is '项目类型';
comment on column GK.GK_OPERATION_JSJY_JGSQ.jyrid
  is '经营人id';
comment on column GK.GK_OPERATION_JSJY_JGSQ.sftb
  is '是否同步';
comment on column GK.GK_OPERATION_JSJY_JGSQ.tbzt
  is '同步状态';
comment on column GK.GK_OPERATION_JSJY_JGSQ.bwyt
  is '泊位用途';
comment on column GK.GK_OPERATION_JSJY_JGSQ.zyhbwfl
  is '专业化泊位分类';
comment on column GK.GK_OPERATION_JSJY_JGSQ.lcjd
  is '流程节点';
comment on column GK.GK_OPERATION_JSJY_JGSQ.sfqswj
  is '是否缺失文件';
alter table GK.GK_OPERATION_JSJY_JGSQ
  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 GK.GK_OPERATION_JSJY_JGSQFJ
(
  id               VARCHAR2(40),
  ssid             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 16K
    next 8K
    minextents 1
    maxextents unlimited
  );


create table GK.GK_OPERATION_JSJY_JGZX
(
  id               VARCHAR2(40) not null,
  xmmc             VARCHAR2(200),
  xmfr             VARCHAR2(40),
  jsdd             NVARCHAR2(500),
  jsgm             NVARCHAR2(200),
  tzlx             VARCHAR2(20),
  ztz              NUMBER,
  xmhzjb           VARCHAR2(20),
  axspjb           VARCHAR2(20),
  axcd             NUMBER,
  bwdj             NUMBER,
  bwhz             VARCHAR2(40),
  tgnl             VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  create_date_time TIMESTAMP(0),
  update_date_time TIMESTAMP(0),
  record_status    NUMBER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NUMBER,
  xmlx             VARCHAR2(40),
  jyrid            VARCHAR2(40),
  sftb             CHAR(1) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null,
  bwyt             VARCHAR2(30),
  zyhbwfl          VARCHAR2(40),
  lcjd             VARCHAR2(40),
  sfqswj           VARCHAR2(20),
  flowstatus       CHAR(1)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on column GK.GK_OPERATION_JSJY_JGZX.id
  is '唯一标识';
comment on column GK.GK_OPERATION_JSJY_JGZX.xmmc
  is '项目名称';
comment on column GK.GK_OPERATION_JSJY_JGZX.xmfr
  is '项目法人';
comment on column GK.GK_OPERATION_JSJY_JGZX.jsdd
  is '建设地点';
comment on column GK.GK_OPERATION_JSJY_JGZX.jsgm
  is '建设规模';
comment on column GK.GK_OPERATION_JSJY_JGZX.tzlx
  is '投资类型（政府投资/企业投资）';
comment on column GK.GK_OPERATION_JSJY_JGZX.ztz
  is '总投资（万元）';
comment on column GK.GK_OPERATION_JSJY_JGZX.xmhzjb
  is '项目核准级别(国/省/市)';
comment on column GK.GK_OPERATION_JSJY_JGZX.axspjb
  is '岸线审批级别（部/省/市/无）';
comment on column GK.GK_OPERATION_JSJY_JGZX.axcd
  is '岸线长度';
comment on column GK.GK_OPERATION_JSJY_JGZX.bwdj
  is '泊位吨级';
comment on column GK.GK_OPERATION_JSJY_JGZX.bwhz
  is '泊位货种';
comment on column GK.GK_OPERATION_JSJY_JGZX.tgnl
  is '通过能力';
comment on column GK.GK_OPERATION_JSJY_JGZX.szgk
  is '所在港口';
comment on column GK.GK_OPERATION_JSJY_JGZX.szgq
  is '所在港区';
comment on column GK.GK_OPERATION_JSJY_JGZX.szd
  is '所在地';
comment on column GK.GK_OPERATION_JSJY_JGZX.xmlx
  is '项目类型';
comment on column GK.GK_OPERATION_JSJY_JGZX.jyrid
  is '经营人id';
comment on column GK.GK_OPERATION_JSJY_JGZX.sftb
  is '是否同步';
comment on column GK.GK_OPERATION_JSJY_JGZX.tbzt
  is '同步状态';
comment on column GK.GK_OPERATION_JSJY_JGZX.bwyt
  is '泊位用途';
comment on column GK.GK_OPERATION_JSJY_JGZX.zyhbwfl
  is '专业化泊位分类';
comment on column GK.GK_OPERATION_JSJY_JGZX.lcjd
  is '流程节点';
comment on column GK.GK_OPERATION_JSJY_JGZX.sfqswj
  is '是否缺失文件';
alter table GK.GK_OPERATION_JSJY_JGZX
  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 GK.GK_OPERATION_JSJY_JGZXFJ
(
  id               VARCHAR2(40),
  ssid             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 16K
    next 8K
    minextents 1
    maxextents unlimited
  );


create table GK.GK_OPERATION_JSJY_JSJDBG
(
  id               VARCHAR2(40) not null,
  xmmc             VARCHAR2(200),
  xmfr             VARCHAR2(40),
  jsdd             NVARCHAR2(500),
  jsgm             NVARCHAR2(200),
  tzlx             VARCHAR2(20),
  ztz              NUMBER,
  xmhzjb           VARCHAR2(20),
  axspjb           VARCHAR2(20),
  axcd             NUMBER,
  bwdj             NUMBER,
  bwhz             VARCHAR2(40),
  tgnl             VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  create_date_time TIMESTAMP(0),
  update_date_time TIMESTAMP(0),
  record_status    NUMBER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NUMBER,
  xmlx             VARCHAR2(40),
  jyrid            VARCHAR2(40),
  sftb             CHAR(1) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null,
  bwyt             VARCHAR2(30),
  zyhbwfl          VARCHAR2(40),
  lcjd             VARCHAR2(40),
  sfqswj           VARCHAR2(20)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on column GK.GK_OPERATION_JSJY_JSJDBG.id
  is '唯一标识';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.xmmc
  is '项目名称';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.xmfr
  is '项目法人';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.jsdd
  is '建设地点';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.jsgm
  is '建设规模';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.tzlx
  is '投资类型（政府投资/企业投资）';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.ztz
  is '总投资（万元）';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.xmhzjb
  is '项目核准级别(国/省/市)';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.axspjb
  is '岸线审批级别（部/省/市/无）';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.axcd
  is '岸线长度';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.bwdj
  is '泊位吨级';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.bwhz
  is '泊位货种';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.tgnl
  is '通过能力';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.szgk
  is '所在港口';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.szgq
  is '所在港区';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.szd
  is '所在地';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.xmlx
  is '项目类型';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.jyrid
  is '经营人id';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.sftb
  is '是否同步';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.tbzt
  is '同步状态';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.bwyt
  is '泊位用途';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.zyhbwfl
  is '专业化泊位分类';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.lcjd
  is '流程节点';
comment on column GK.GK_OPERATION_JSJY_JSJDBG.sfqswj
  is '是否缺失文件';
alter table GK.GK_OPERATION_JSJY_JSJDBG
  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 GK.GK_OPERATION_JSJY_JSJDBGFJ
(
  id               VARCHAR2(40),
  ssid             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 16K
    next 8K
    minextents 1
    maxextents unlimited
  );


create table GK.GK_OPERATION_JSJY_JSJDCBSJ
(
  id               VARCHAR2(40) not null,
  xmmc             VARCHAR2(200),
  xmfr             VARCHAR2(40),
  jsdd             NVARCHAR2(500),
  jsgm             NVARCHAR2(200),
  tzlx             VARCHAR2(20),
  ztz              NUMBER,
  xmhzjb           VARCHAR2(20),
  axspjb           VARCHAR2(20),
  axcd             NUMBER,
  bwdj             NUMBER,
  bwhz             VARCHAR2(40),
  tgnl             VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  create_date_time TIMESTAMP(0),
  update_date_time TIMESTAMP(0),
  record_status    NUMBER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NUMBER,
  xmlx             VARCHAR2(40),
  jyrid            VARCHAR2(40),
  sftb             CHAR(1) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null,
  bwyt             VARCHAR2(30),
  zyhbwfl          VARCHAR2(40),
  lcjd             VARCHAR2(40),
  sfqswj           VARCHAR2(20),
  flowstatus       CHAR(1)
)
tablespace GK_BASIC
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on table GK.GK_OPERATION_JSJY_JSJDCBSJ
  is '项目建设管理';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.id
  is '唯一标识';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.xmmc
  is '项目名称';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.xmfr
  is '项目法人';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.jsdd
  is '建设地点';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.jsgm
  is '建设规模';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.tzlx
  is '投资类型（政府投资/企业投资）';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.ztz
  is '总投资（万元）';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.xmhzjb
  is '项目核准级别(国/省/市)';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.axspjb
  is '岸线审批级别（部/省/市/无）';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.axcd
  is '岸线长度';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.bwdj
  is '泊位吨级';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.bwhz
  is '泊位货种';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.tgnl
  is '通过能力';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.szgk
  is '所在港口';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.szgq
  is '所在港区';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.szd
  is '所在地';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.xmlx
  is '项目类型';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.jyrid
  is '经营人id';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.sftb
  is '是否同步';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.tbzt
  is '同步状态';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.bwyt
  is '泊位用途';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.zyhbwfl
  is '专业化泊位分类';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.lcjd
  is '流程节点';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.sfqswj
  is '是否缺失文件';
comment on column GK.GK_OPERATION_JSJY_JSJDCBSJ.flowstatus
  is '状态0,正常1.退回地市2完成';
alter table GK.GK_OPERATION_JSJY_JSJDCBSJ
  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 GK.GK_OPERATION_JSJY_JSJDCBSJFJ
(
  id               VARCHAR2(40),
  ssid             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 1M
    minextents 1
    maxextents unlimited
  );


create table GK.GK_OPERATION_JSJY_JSJDZX
(
  id               VARCHAR2(40) not null,
  xmmc             VARCHAR2(200),
  xmfr             VARCHAR2(40),
  jsdd             NVARCHAR2(500),
  jsgm             NVARCHAR2(200),
  tzlx             VARCHAR2(20),
  ztz              NUMBER,
  xmhzjb           VARCHAR2(20),
  axspjb           VARCHAR2(20),
  axcd             NUMBER,
  bwdj             NUMBER,
  bwhz             VARCHAR2(40),
  tgnl             VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  create_date_time TIMESTAMP(0),
  update_date_time TIMESTAMP(0),
  record_status    NUMBER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NUMBER,
  xmlx             VARCHAR2(40),
  jyrid            VARCHAR2(40),
  sftb             CHAR(1) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null,
  bwyt             VARCHAR2(30),
  zyhbwfl          VARCHAR2(40),
  lcjd             VARCHAR2(40),
  sfqswj           VARCHAR2(20),
  flowstatus       CHAR(1)
)
tablespace GK_OPERATION
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 16K
    next 8K
    minextents 1
    maxextents unlimited
  );
comment on column GK.GK_OPERATION_JSJY_JSJDZX.id
  is '唯一标识';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.xmmc
  is '项目名称';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.xmfr
  is '项目法人';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.jsdd
  is '建设地点';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.jsgm
  is '建设规模';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.tzlx
  is '投资类型（政府投资/企业投资）';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.ztz
  is '总投资（万元）';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.xmhzjb
  is '项目核准级别(国/省/市)';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.axspjb
  is '岸线审批级别（部/省/市/无）';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.axcd
  is '岸线长度';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.bwdj
  is '泊位吨级';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.bwhz
  is '泊位货种';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.tgnl
  is '通过能力';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.szgk
  is '所在港口';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.szgq
  is '所在港区';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.szd
  is '所在地';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.xmlx
  is '项目类型';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.jyrid
  is '经营人id';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.sftb
  is '是否同步';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.tbzt
  is '同步状态';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.bwyt
  is '泊位用途';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.zyhbwfl
  is '专业化泊位分类';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.lcjd
  is '流程节点';
comment on column GK.GK_OPERATION_JSJY_JSJDZX.sfqswj
  is '是否缺失文件';
alter table GK.GK_OPERATION_JSJY_JSJDZX
  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 GK.GK_OPERATION_JSJY_JSJDZXFJ
(
  id               VARCHAR2(40),
  ssid             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 16K
    next 8K
    minextents 1
    maxextents unlimited
  );