jsgkj/gkjsjy/trunk/WebContent/static/sql/oracle/table/2.3.GkjyTableCreate.sql

--表如下：
--GK_BASIC_JSJY_JYR
--GK_BASIC_JSJY_JYR_BW
--GK_BASIC_JSJY_JYR_DC
--GK_BASIC_JSJY_JYR_CG
--GK_BASIC_JSJY_JYR_CK
--GK_BASIC_JSJY_JYR_MT
--GK_BASIC_JSJY_JYR_SSSB
--GK_BASIC_JSJY_JYR_RY
--GK_BASIC_JSJY_JYR_RY_ZS
--GK_BASIC_JSJY_JYR_QYTZ
--GK_SHARE_JSJY_WHZYFZ
--GK_SHARE_JSJY_JYXKZ
--GK_OPERATION_JSJY_DCSB
--GK_OPERATION_JSJY_XKZJYFWXX
--GK_OPERATION_JSJY_XKZSQFJ
--GK_OPERATION_JSJY_XKZSQGLB
--GK_OPERATION_JSJY_XKZSQJDS
--GK_OPERATION_JSJY_XKZSQXX
--GK_OPERATION_JSJY_XKZSQZSCS
--GK_OPERATION_JSJY_XKZYWZLXX
--GK_OPERATION_JSJY_XKZYXXX
--GK_OPERATION_JSJY_XKZYXFJ
--GK_OPERATION_JSJY_XKZZXXX
--GK_OPERATION_JSJY_XKZZXFJ
--GK_OPERATION_JSJY_XKZZXJDS
--GK_OPERATION_JSJY_XKZYXJDS
--GK_SHARE_JSJY_HS_SHIP_CARRIAGE
--共28张表


--经营人
create table GK_BASIC_JSJY_JYR
(
  id               VARCHAR2(40) not null,
  szd              VARCHAR2(40), 
  szgq             VARCHAR2(40),  
  gkjyr            VARCHAR2(200), 
  qyxz             VARCHAR2(20), 
  yzbm             VARCHAR2(400), 
  bgdz             VARCHAR2(1000), 
  gkjyxkzh         VARCHAR2(400),
  fzrq             TIMESTAMP(6),
  fzjg             VARCHAR2(400),
  jyfw             VARCHAR2(4000),
  jyqy             VARCHAR2(2000),
  zyhz             VARCHAR2(200),
  fddbr            VARCHAR2(400),
  lxdh             VARCHAR2(400),
  cz               VARCHAR2(400),
  aqbmfzr          VARCHAR2(400),
  aqfzrlxdh        VARCHAR2(400),
  aqfzrsj          VARCHAR2(400),
  gsyyzzbh         VARCHAR2(400),
  tzze             NUMBER,
  zczb             NUMBER,
  gkwxhwzyfzbh     VARCHAR2(400),
  gkssbafhzsbh     VARCHAR2(400),
  bafzjg           VARCHAR2(400),
  bafzrq           TIMESTAMP(6),
  bayxq            TIMESTAMP(6),
  zywxhwpm         VARCHAR2(2000),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    NUMBER,
  sfwhqy           VARCHAR2(40),
  qylx             VARCHAR2(40),
  fzyxq            TIMESTAMP(6),
  qyzzjgdm         VARCHAR2(50),
  sshydl           VARCHAR2(40),
  sshyz            VARCHAR2(40),
  qyaqdj           CHAR(1),
  rs               NUMBER,
  aqzgbm           VARCHAR2(50),
  aqgljg           VARCHAR2(50),
  zzagrysl         NUMBER,
  zcze             VARCHAR2(20),
  xsje             VARCHAR2(20),
  aqfzrzbdh        VARCHAR2(20),
  gjjgdm           VARCHAR2(20),
  sfzdsp           VARCHAR2(40),
  parent_jyr_id    VARCHAR2(40),
  xzqh             VARCHAR2(40),
  szgk             VARCHAR2(100) not null,
  dtsj             NVARCHAR2(40),
  ssgkglbm         VARCHAR2(40),
  cyrysl           NVARCHAR2(100),
  xcglrysl         NVARCHAR2(100),
  xcglpxrysl       NVARCHAR2(100),
  zyjsrysl         NVARCHAR2(100),
  zyjspxrysl       NVARCHAR2(100),
  xczyrysl         NVARCHAR2(100),
  xczyrypxsl       NVARCHAR2(100),
  fjsszmj          NVARCHAR2(100),
  ywcqzm           NVARCHAR2(100),
  bgyfmj           NVARCHAR2(100),
  axcd             NVARCHAR2(100),
  mtqyhdgc         NVARCHAR2(100),
  mtbwzs           NVARCHAR2(100),
  scxbw            NVARCHAR2(100),
  fscxbw           NVARCHAR2(100),
  zdkbnl           NVARCHAR2(100),
  wdjysbwsl        NVARCHAR2(100),
  mtjgxs           NVARCHAR2(100),
  bwzcd            NVARCHAR2(100),
  ywjgys           NVARCHAR2(100),
  sjntgnl          NVARCHAR2(100),
  jzx              NVARCHAR2(100),
  sndzttl          NVARCHAR2(100),
  sndzjzx          NVARCHAR2(100),
  sndwmttl         NVARCHAR2(100),
  sndwmjzx         NVARCHAR2(100),
  lymj             NVARCHAR2(100),
  ckzmj            NVARCHAR2(100),
  tczmj            NVARCHAR2(100),
  zxsbgs           NVARCHAR2(100),
  mzdjgs           NVARCHAR2(100),
  ltqzjgs          NVARCHAR2(100),
  gddjgs           NVARCHAR2(100),
  qcqzjgs          NVARCHAR2(100),
  sssbgs           NVARCHAR2(100),
  qtjxgs           NVARCHAR2(100),
  gzcbgs           NVARCHAR2(100),
  cbzzzl           NVARCHAR2(100),
  gygxcd           NVARCHAR2(100),
  tlzyxcd          NVARCHAR2(100),
  cgsl             NVARCHAR2(100),
  cgzrl            NVARCHAR2(100),
  zyq              VARCHAR2(40),
  zyid             VARCHAR2(40),
  aqid             VARCHAR2(40)
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_JYR
  is '经营人基础信息';
comment on column GK_BASIC_JSJY_JYR.id
  is 'ID';
comment on column GK_BASIC_JSJY_JYR.szd
  is '所在地';
comment on column GK_BASIC_JSJY_JYR.szgq
  is '所在港区';
comment on column GK_BASIC_JSJY_JYR.gkjyr
  is '港口经营人名称';
comment on column GK_BASIC_JSJY_JYR.qyxz
  is '企业性质';
comment on column GK_BASIC_JSJY_JYR.yzbm
  is '邮政编码';
comment on column GK_BASIC_JSJY_JYR.bgdz
  is '办公地址';
comment on column GK_BASIC_JSJY_JYR.gkjyxkzh
  is '港口经营许可证编号';
comment on column GK_BASIC_JSJY_JYR.fzrq
  is '发证日期';
comment on column GK_BASIC_JSJY_JYR.fzjg
  is '发证机关';
comment on column GK_BASIC_JSJY_JYR.jyfw
  is '经营范围';
comment on column GK_BASIC_JSJY_JYR.jyqy
  is '经营区域';
comment on column GK_BASIC_JSJY_JYR.zyhz
  is '主营货种';
comment on column GK_BASIC_JSJY_JYR.fddbr
  is '法定代表人';
comment on column GK_BASIC_JSJY_JYR.lxdh
  is '联系电话';
comment on column GK_BASIC_JSJY_JYR.cz
  is '传真';
comment on column GK_BASIC_JSJY_JYR.aqbmfzr
  is '安全部门负责人';
comment on column GK_BASIC_JSJY_JYR.aqfzrlxdh
  is '安全部门负责人联系电话';
comment on column GK_BASIC_JSJY_JYR.aqfzrsj
  is '安全部门负责人手机';
comment on column GK_BASIC_JSJY_JYR.gsyyzzbh
  is '工商营业执照编号';
comment on column GK_BASIC_JSJY_JYR.tzze
  is '投资总额';
comment on column GK_BASIC_JSJY_JYR.zczb
  is '注册资本';
comment on column GK_BASIC_JSJY_JYR.gkwxhwzyfzbh
  is '港口危险货物作业附证编号';
comment on column GK_BASIC_JSJY_JYR.gkssbafhzsbh
  is '港口设施保安符合证书编号   港口设施保安符合证书编号';
comment on column GK_BASIC_JSJY_JYR.bafzjg
  is '保安符合证书发证机关';
comment on column GK_BASIC_JSJY_JYR.bafzrq
  is '保安符合证书发证日期';
comment on column GK_BASIC_JSJY_JYR.bayxq
  is '保安符合证书有效期至';
comment on column GK_BASIC_JSJY_JYR.zywxhwpm
  is '作业危险货物品名';
comment on column GK_BASIC_JSJY_JYR.create_user
  is '创建人';
comment on column GK_BASIC_JSJY_JYR.create_date_time
  is '创建日期';
comment on column GK_BASIC_JSJY_JYR.update_user
  is '修改人';
comment on column GK_BASIC_JSJY_JYR.update_date_time
  is '修改日期';
comment on column GK_BASIC_JSJY_JYR.record_status
  is '删除状态';
comment on column GK_BASIC_JSJY_JYR.sfwhqy
  is '是否危货企业';
comment on column GK_BASIC_JSJY_JYR.qylx
  is '企业类型';
comment on column GK_BASIC_JSJY_JYR.fzyxq
  is '附证有效期';
comment on column GK_BASIC_JSJY_JYR.qyzzjgdm
  is '企业组织机构代码';
comment on column GK_BASIC_JSJY_JYR.sshydl
  is '所属行业大类';
comment on column GK_BASIC_JSJY_JYR.sshyz
  is '所属行业中类';
comment on column GK_BASIC_JSJY_JYR.qyaqdj
  is '企业安全等级';
comment on column GK_BASIC_JSJY_JYR.rs
  is '人数';
comment on column GK_BASIC_JSJY_JYR.aqzgbm
  is '安全主管部门';
comment on column GK_BASIC_JSJY_JYR.aqgljg
  is '安全管理机构';
comment on column GK_BASIC_JSJY_JYR.zzagrysl
  is '专职安管人员数量';
comment on column GK_BASIC_JSJY_JYR.zcze
  is '资产总额';
comment on column GK_BASIC_JSJY_JYR.xsje
  is '销售金额';
comment on column GK_BASIC_JSJY_JYR.aqfzrzbdh
  is '安全负责人值班电话';
comment on column GK_BASIC_JSJY_JYR.gjjgdm
  is '国际机构代码';
comment on column GK_BASIC_JSJY_JYR.sfzdsp
  is '是否自动审批';
comment on column GK_BASIC_JSJY_JYR.parent_jyr_id
  is '上级港口经营人';
comment on column GK_BASIC_JSJY_JYR.xzqh
  is '行政区划';
comment on column GK_BASIC_JSJY_JYR.szgk
  is '所在港口';
comment on column GK_BASIC_JSJY_JYR.dtsj
  is 'gis';
comment on column GK_BASIC_JSJY_JYR.ssgkglbm
  is '所属港口管理部门';
comment on column GK_BASIC_JSJY_JYR.cyrysl
  is '人业人员数量';
comment on column GK_BASIC_JSJY_JYR.xcglrysl
  is '现场管理人员数量';
comment on column GK_BASIC_JSJY_JYR.xcglpxrysl
  is '现场管理培训人员数量';
comment on column GK_BASIC_JSJY_JYR.zyjsrysl
  is '专业技术人员数量';
comment on column GK_BASIC_JSJY_JYR.zyjspxrysl
  is '专业技术培训人员数量';
comment on column GK_BASIC_JSJY_JYR.xczyrysl
  is '现场作业人员数量';
comment on column GK_BASIC_JSJY_JYR.xczyrypxsl
  is '现场作业培训人员数量';
comment on column GK_BASIC_JSJY_JYR.fjsszmj
  is '房建设施总面积（平米）';
comment on column GK_BASIC_JSJY_JYR.ywcqzm
  is '有无产权证明';
comment on column GK_BASIC_JSJY_JYR.bgyfmj
  is '办公用房面积（平米）';
comment on column GK_BASIC_JSJY_JYR.axcd
  is '岸线长度（米）';
comment on column GK_BASIC_JSJY_JYR.mtqyhdgc
  is '码头前沿河底高程（米）';
comment on column GK_BASIC_JSJY_JYR.mtbwzs
  is '码头泊位总数（平米）';
comment on column GK_BASIC_JSJY_JYR.scxbw
  is '生产性泊位（个）';
comment on column GK_BASIC_JSJY_JYR.fscxbw
  is '非生产性泊位（个）';
comment on column GK_BASIC_JSJY_JYR.zdkbnl
  is '最大靠泊能力（万吨）';
comment on column GK_BASIC_JSJY_JYR.wdjysbwsl
  is '万吨级以上泊位数量';
comment on column GK_BASIC_JSJY_JYR.mtjgxs
  is '码头结构型式';
comment on column GK_BASIC_JSJY_JYR.bwzcd
  is '泊位总长度（米）';
comment on column GK_BASIC_JSJY_JYR.ywjgys
  is '有无竣工验收（证明）';
comment on column GK_BASIC_JSJY_JYR.sjntgnl
  is '设计年通过能力（万吨）';
comment on column GK_BASIC_JSJY_JYR.jzx
  is '集装箱（万TEU）';
comment on column GK_BASIC_JSJY_JYR.sndzttl
  is '上年度总吞吐量（万吨）';
comment on column GK_BASIC_JSJY_JYR.sndzjzx
  is '上年度总集装箱（万TEU）';
comment on column GK_BASIC_JSJY_JYR.sndwmttl
  is '上年度外贸吞吐量（万吨）';
comment on column GK_BASIC_JSJY_JYR.sndwmjzx
  is '上年度外贸集装箱（万TEU）';
comment on column GK_BASIC_JSJY_JYR.lymj
  is '陆域面积（平米）';
comment on column GK_BASIC_JSJY_JYR.ckzmj
  is '仓库总面积（平米）';
comment on column GK_BASIC_JSJY_JYR.tczmj
  is '堆场总面积（平米）';
comment on column GK_BASIC_JSJY_JYR.zxsbgs
  is '装卸设备个数（台）';
comment on column GK_BASIC_JSJY_JYR.mzdjgs
  is '门座吊机个数（台）';
comment on column GK_BASIC_JSJY_JYR.ltqzjgs
  is '轮胎起重机个数（台）';
comment on column GK_BASIC_JSJY_JYR.gddjgs
  is '固定吊机个数（台）';
comment on column GK_BASIC_JSJY_JYR.qcqzjgs
  is '汽车起重机个数（台）';
comment on column GK_BASIC_JSJY_JYR.sssbgs
  is '输送设备个数（台）';
comment on column GK_BASIC_JSJY_JYR.qtjxgs
  is '其他机械个数（台）';
comment on column GK_BASIC_JSJY_JYR.gzcbgs
  is '港作船舶个数（艘）';
comment on column GK_BASIC_JSJY_JYR.cbzzzl
  is '船舶总载重量（万吨）';
comment on column GK_BASIC_JSJY_JYR.gygxcd
  is '工艺管线长度（米）';
comment on column GK_BASIC_JSJY_JYR.tlzyxcd
  is '铁路专用线长度（米)';
comment on column GK_BASIC_JSJY_JYR.cgsl
  is '储罐数量（个）';
comment on column GK_BASIC_JSJY_JYR.cgzrl
  is '储罐总容量（立方米）';
comment on column GK_BASIC_JSJY_JYR.zyq
  is '所在作业区';
comment on column GK_BASIC_JSJY_JYR.zyid
  is '资源系统主键';
comment on column GK_BASIC_JSJY_JYR.aqid
  is '安全主键';
alter table GK_BASIC_JSJY_JYR
  add  primary key (ID);
 
  
--泊位表
create table GK_BASIC_JSJY_JYR_BW
(
  id               VARCHAR2(40) not null,
  szd              VARCHAR2(40),
  szgq             VARCHAR2(40),
  ssmt             VARCHAR2(40),
  bwmc             VARCHAR2(100),
  bwsx             VARCHAR2(40),
  bwszsx           VARCHAR2(40),
  fwlx             VARCHAR2(40),
  tcnf             NUMBER,
  jgxs             VARCHAR2(40),
  sclx             VARCHAR2(40),
  jgysnf           NUMBER,
  qysjsh           NUMBER,
  qysjss           NUMBER,
  bwcd             NUMBER,
  wxpbw            VARCHAR2(40),
  sjtgnl           NUMBER,
  sjkpnl           NUMBER,
  nhwtgnl          VARCHAR2(100),
  nwxhwttl         VARCHAR2(100),
  zyhbwfl          VARCHAR2(40),
  jd               VARCHAR2(30),
  wd               VARCHAR2(30),
  sffz             VARCHAR2(40),
  bwyt             VARCHAR2(30),
  zyrkfw           VARCHAR2(400),
  jtjgisdyidh      VARCHAR2(30),
  hckpnl           VARCHAR2(100),
  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),
  ssgkglbm         VARCHAR2(40),
  ssjyr            VARCHAR2(40),
  szgk             VARCHAR2(40),
  dtsj             NVARCHAR2(40),
  bwdm             VARCHAR2(40),
  sfdwkf           VARCHAR2(40),
  njzxtgnl         VARCHAR2(10),
  zyid             VARCHAR2(40),
  sszyq            VARCHAR2(40),
  hsid             VARCHAR2(40),
  aqid             VARCHAR2(40)
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_JYR_BW
  is '经营人泊位';
comment on column GK_BASIC_JSJY_JYR_BW.id
  is '唯一标识';
comment on column GK_BASIC_JSJY_JYR_BW.szd
  is '所在地';
comment on column GK_BASIC_JSJY_JYR_BW.szgq
  is '所在港区';
comment on column GK_BASIC_JSJY_JYR_BW.ssmt
  is '码头名称';
comment on column GK_BASIC_JSJY_JYR_BW.bwmc
  is '泊位名称';
comment on column GK_BASIC_JSJY_JYR_BW.bwsx
  is '泊位属性';
comment on column GK_BASIC_JSJY_JYR_BW.bwszsx
  is '泊位所在水系';
comment on column GK_BASIC_JSJY_JYR_BW.fwlx
  is '服务类型';
comment on column GK_BASIC_JSJY_JYR_BW.tcnf
  is '投产年份';
comment on column GK_BASIC_JSJY_JYR_BW.jgxs
  is '结构型式';
comment on column GK_BASIC_JSJY_JYR_BW.sclx
  is '生产类型';
comment on column GK_BASIC_JSJY_JYR_BW.jgysnf
  is '竣工验收年份';
comment on column GK_BASIC_JSJY_JYR_BW.qysjsh
  is '前沿设计水深';
comment on column GK_BASIC_JSJY_JYR_BW.qysjss
  is '前沿实际水深';
comment on column GK_BASIC_JSJY_JYR_BW.bwcd
  is '泊位长度';
comment on column GK_BASIC_JSJY_JYR_BW.wxpbw
  is '是否危险品泊位';
comment on column GK_BASIC_JSJY_JYR_BW.sjtgnl
  is '设计通过能力';
comment on column GK_BASIC_JSJY_JYR_BW.sjkpnl
  is '设计靠泊能力（吨级）';
comment on column GK_BASIC_JSJY_JYR_BW.nhwtgnl
  is '年货物通过能力';
comment on column GK_BASIC_JSJY_JYR_BW.nwxhwttl
  is '年危险货物吞吐量';
comment on column GK_BASIC_JSJY_JYR_BW.zyhbwfl
  is '专业化泊位分类';
comment on column GK_BASIC_JSJY_JYR_BW.jd
  is '经度';
comment on column GK_BASIC_JSJY_JYR_BW.wd
  is '纬度';
comment on column GK_BASIC_JSJY_JYR_BW.sffz
  is '是否发证';
comment on column GK_BASIC_JSJY_JYR_BW.bwyt
  is '泊位用途';
comment on column GK_BASIC_JSJY_JYR_BW.zyrkfw
  is '作业认可范围';
comment on column GK_BASIC_JSJY_JYR_BW.jtjgisdyidh
  is '交通GIS对应ID号';
comment on column GK_BASIC_JSJY_JYR_BW.hckpnl
  is '核查靠泊能力';
comment on column GK_BASIC_JSJY_JYR_BW.record_status
  is '记录状态-有效1  记录状态-删除9';
comment on column GK_BASIC_JSJY_JYR_BW.ssgkglbm
  is '所属管理部门';
comment on column GK_BASIC_JSJY_JYR_BW.ssjyr
  is '所属经营人';
comment on column GK_BASIC_JSJY_JYR_BW.szgk
  is '所在港口';
comment on column GK_BASIC_JSJY_JYR_BW.dtsj
  is 'gis';
comment on column GK_BASIC_JSJY_JYR_BW.bwdm
  is '泊位代码，对应海事泊位主键';
comment on column GK_BASIC_JSJY_JYR_BW.sfdwkf
  is '是否对外开放';
comment on column GK_BASIC_JSJY_JYR_BW.njzxtgnl
  is '年集装箱通过能力';
comment on column GK_BASIC_JSJY_JYR_BW.zyid
  is '资源主键';
comment on column GK_BASIC_JSJY_JYR_BW.sszyq
  is '所在作业区';
comment on column GK_BASIC_JSJY_JYR_BW.hsid
  is '海事泊位编号';
comment on column GK_BASIC_JSJY_JYR_BW.aqid
  is '安全主键';
alter table GK_BASIC_JSJY_JYR_BW
  add primary key (ID);  
--储罐
create table GK_BASIC_JSJY_JYR_CG
(
  id               NVARCHAR2(40) not null,
  ssjyr            NVARCHAR2(40),
  whzyfzbh         NVARCHAR2(2000),
  qyccbh           NVARCHAR2(2000),
  scjyhdlx         NVARCHAR2(10),
  cchxppzsl        NVARCHAR2(40),
  zxgyjzysb        NVARCHAR2(100),
  cccscq           NVARCHAR2(10),
  gkzdwxybh        NVARCHAR2(40),
  gkzdwxybabh      NVARCHAR2(40),
  cgqmc            NVARCHAR2(40),
  jtwz             NVARCHAR2(40),
  cgzb             NVARCHAR2(40),
  cgqmj            NUMBER,
  cggs             NUMBER,
  cgmc             NVARCHAR2(40),
  cgxh             NVARCHAR2(40),
  ywfhd            NVARCHAR2(40),
  gjzxjl           NUMBER,
  cgcz             NVARCHAR2(40),
  cgrj             NUMBER,
  cgxs             NVARCHAR2(10),
  cgazxs           NVARCHAR2(10),
  wzzt             NVARCHAR2(10),
  cgwx             NVARCHAR2(10),
  sjyl             NUMBER,
  sjgzyl           NUMBER,
  sjwd             NVARCHAR2(50),
  sjgzwd           NVARCHAR2(50),
  tcsj             TIMESTAMP(6),
  sjsynx           NUMBER,
  jlfs             NVARCHAR2(10),
  clfs             NVARCHAR2(10),
  fjdsssfnjjzs     NVARCHAR2(10),
  zsbh             NVARCHAR2(40),
  tbr              NVARCHAR2(40),
  lxdh             NVARCHAR2(20),
  tbsj             TIMESTAMP(6),
  hysl             NUMBER,
  hysm             NVARCHAR2(100),
  bdzzsl           NUMBER,
  bdzzsm           NVARCHAR2(100),
  qtsl             NUMBER,
  qtsm             NVARCHAR2(100),
  mapid            NUMBER,
  hxpmc            NVARCHAR2(2000),
  hxppz            NVARCHAR2(40),
  hxpsl            NUMBER,
  update_user      NVARCHAR2(40),
  record_status    NUMBER default 1,
  szd              NVARCHAR2(40),
  szgq             NVARCHAR2(40),
  zdwxycggs        NUMBER,
  zdwxycgrl        NUMBER,
  aqgd             NUMBER,
  zj               NUMBER,
  wxydj            NVARCHAR2(10),
  create_date_time TIMESTAMP(6) default current_timestamp,
  update_date_time TIMESTAMP(6) default current_timestamp,
  create_user      NVARCHAR2(40),
  szgk             VARCHAR2(40),
  ssgkglbm         VARCHAR2(40),
  aqid             VARCHAR2(40)
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_JYR_CG
  is '经营人储罐表';
comment on column GK_BASIC_JSJY_JYR_CG.id
  is '唯一标识';
comment on column GK_BASIC_JSJY_JYR_CG.ssjyr
  is '所属经营人';
comment on column GK_BASIC_JSJY_JYR_CG.whzyfzbh
  is '危货作业附证编号';
comment on column GK_BASIC_JSJY_JYR_CG.qyccbh
  is '企业存储编号';
comment on column GK_BASIC_JSJY_JYR_CG.scjyhdlx
  is '生产经营活动类型';
comment on column GK_BASIC_JSJY_JYR_CG.cchxppzsl
  is '储存化学品品种数量';
comment on column GK_BASIC_JSJY_JYR_CG.zxgyjzysb
  is '装卸工艺及主要设备';
comment on column GK_BASIC_JSJY_JYR_CG.cccscq
  is '储存场所产权';
comment on column GK_BASIC_JSJY_JYR_CG.gkzdwxybh
  is '港口重大危险源编号';
comment on column GK_BASIC_JSJY_JYR_CG.gkzdwxybabh
  is '港口重大危险源备案编号';
comment on column GK_BASIC_JSJY_JYR_CG.cgqmc
  is '储罐区名称';
comment on column GK_BASIC_JSJY_JYR_CG.jtwz
  is '具体位置';
comment on column GK_BASIC_JSJY_JYR_CG.cgzb
  is '储罐坐标';
comment on column GK_BASIC_JSJY_JYR_CG.cgqmj
  is '储罐区面积';
comment on column GK_BASIC_JSJY_JYR_CG.cggs
  is '储罐个数';
comment on column GK_BASIC_JSJY_JYR_CG.cgmc
  is '储罐名称';
comment on column GK_BASIC_JSJY_JYR_CG.cgxh
  is '储罐序号';
comment on column GK_BASIC_JSJY_JYR_CG.ywfhd
  is '有无防护堤';
comment on column GK_BASIC_JSJY_JYR_CG.gjzxjl
  is '罐间最小距离';
comment on column GK_BASIC_JSJY_JYR_CG.cgcz
  is '储罐材质';
comment on column GK_BASIC_JSJY_JYR_CG.cgrj
  is '储罐容积';
comment on column GK_BASIC_JSJY_JYR_CG.cgxs
  is '储罐形式';
comment on column GK_BASIC_JSJY_JYR_CG.cgazxs
  is '储罐安装形式';
comment on column GK_BASIC_JSJY_JYR_CG.wzzt
  is '物质状态';
comment on column GK_BASIC_JSJY_JYR_CG.cgwx
  is '储罐外形';
comment on column GK_BASIC_JSJY_JYR_CG.sjyl
  is '设计压力';
comment on column GK_BASIC_JSJY_JYR_CG.sjgzyl
  is '实际工作压力';
comment on column GK_BASIC_JSJY_JYR_CG.sjwd
  is '设计温度';
comment on column GK_BASIC_JSJY_JYR_CG.sjgzwd
  is '实际工作温度';
comment on column GK_BASIC_JSJY_JYR_CG.tcsj
  is '投产时间';
comment on column GK_BASIC_JSJY_JYR_CG.sjsynx
  is '设计使用年限';
comment on column GK_BASIC_JSJY_JYR_CG.jlfs
  is '进料方式';
comment on column GK_BASIC_JSJY_JYR_CG.clfs
  is '出料方式';
comment on column GK_BASIC_JSJY_JYR_CG.fjdsssfnjjzs
  is '防静电设施是否年检及证书';
comment on column GK_BASIC_JSJY_JYR_CG.zsbh
  is '证书编号';
comment on column GK_BASIC_JSJY_JYR_CG.tbr
  is '填表人';
comment on column GK_BASIC_JSJY_JYR_CG.lxdh
  is '联系电话';
comment on column GK_BASIC_JSJY_JYR_CG.tbsj
  is '填表时间';
comment on column GK_BASIC_JSJY_JYR_CG.hysl
  is '火源数量';
comment on column GK_BASIC_JSJY_JYR_CG.hysm
  is '火源说明';
comment on column GK_BASIC_JSJY_JYR_CG.bdzzsl
  is '变电装置数量';
comment on column GK_BASIC_JSJY_JYR_CG.bdzzsm
  is '变电装置说明';
comment on column GK_BASIC_JSJY_JYR_CG.qtsl
  is '其他数量';
comment on column GK_BASIC_JSJY_JYR_CG.qtsm
  is '其他说明';
comment on column GK_BASIC_JSJY_JYR_CG.mapid
  is '地图ID';
comment on column GK_BASIC_JSJY_JYR_CG.hxpmc
  is '化学品名称';
comment on column GK_BASIC_JSJY_JYR_CG.hxppz
  is '化学品品种';
comment on column GK_BASIC_JSJY_JYR_CG.hxpsl
  is '化学品数量';
comment on column GK_BASIC_JSJY_JYR_CG.record_status
  is '记录状态-有效1  记录状态-删除9';
comment on column GK_BASIC_JSJY_JYR_CG.szd
  is '所在地';
comment on column GK_BASIC_JSJY_JYR_CG.szgq
  is '所在港区';
comment on column GK_BASIC_JSJY_JYR_CG.zdwxycggs
  is '重大危险源储罐个数';
comment on column GK_BASIC_JSJY_JYR_CG.zdwxycgrl
  is '重大危险源储罐容量';
comment on column GK_BASIC_JSJY_JYR_CG.aqgd
  is '安全高度（米）';
comment on column GK_BASIC_JSJY_JYR_CG.zj
  is '直径';
comment on column GK_BASIC_JSJY_JYR_CG.wxydj
  is '危险源等级';
comment on column GK_BASIC_JSJY_JYR_CG.szgk
  is '所在港口';
comment on column GK_BASIC_JSJY_JYR_CG.ssgkglbm
  is '所属管理部门';
comment on column GK_BASIC_JSJY_JYR_CG.aqid
  is '安全主键';
alter table GK_BASIC_JSJY_JYR_CG
  add primary key (ID);
--仓库
  create table GK_BASIC_JSJY_JYR_CK
(
  id               NVARCHAR2(40) not null,
  szd              NVARCHAR2(40),
  szgq             NVARCHAR2(40),
  ssmt             NVARCHAR2(40),
  ssjyr            NVARCHAR2(40),
  ckmc             NVARCHAR2(200),
  wxpck            NVARCHAR2(40),
  ckyt             NVARCHAR2(200),
  ckytmc           NVARCHAR2(200),
  ckgs             NUMBER,
  ythgcgrj         NUMBER,
  scyckmj          NUMBER,
  wxpckmj          NUMBER,
  scyckrj          NUMBER,
  ykrj             NUMBER,
  cpyrj            NUMBER,
  jtjid            NUMBER,
  jd               NVARCHAR2(20),
  wd               NVARCHAR2(20),
  create_user      NVARCHAR2(40),
  update_user      NVARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szgk             NVARCHAR2(40),
  ssgkglbm         NVARCHAR2(40),
  aqid             VARCHAR2(40)
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_JYR_CK
  is '仓库表';
comment on column GK_BASIC_JSJY_JYR_CK.id
  is '唯一标识';
comment on column GK_BASIC_JSJY_JYR_CK.szd
  is '所在地';
comment on column GK_BASIC_JSJY_JYR_CK.szgq
  is '所地港区';
comment on column GK_BASIC_JSJY_JYR_CK.ssmt
  is '所属码头';
comment on column GK_BASIC_JSJY_JYR_CK.ssjyr
  is '所属经营人';
comment on column GK_BASIC_JSJY_JYR_CK.ckmc
  is '仓库名称';
comment on column GK_BASIC_JSJY_JYR_CK.wxpck
  is '是否危险品仓库';
comment on column GK_BASIC_JSJY_JYR_CK.ckyt
  is '仓库用途，存id，多个逗号隔开';
comment on column GK_BASIC_JSJY_JYR_CK.ckytmc
  is '仓库用途名称存中文，多个逗号隔开';
comment on column GK_BASIC_JSJY_JYR_CK.ckgs
  is '仓库个数';
comment on column GK_BASIC_JSJY_JYR_CK.ythgcgrj
  is '液体化工储罐容积';
comment on column GK_BASIC_JSJY_JYR_CK.scyckmj
  is '生产用仓库面积';
comment on column GK_BASIC_JSJY_JYR_CK.wxpckmj
  is '危险品仓库面积';
comment on column GK_BASIC_JSJY_JYR_CK.scyckrj
  is '生产用仓库容积';
comment on column GK_BASIC_JSJY_JYR_CK.ykrj
  is '油库容积';
comment on column GK_BASIC_JSJY_JYR_CK.cpyrj
  is '成品油容积';
comment on column GK_BASIC_JSJY_JYR_CK.jtjid
  is '交通局GIS对应ID号';
comment on column GK_BASIC_JSJY_JYR_CK.jd
  is '经度';
comment on column GK_BASIC_JSJY_JYR_CK.wd
  is '纬度';
comment on column GK_BASIC_JSJY_JYR_CK.create_user
  is '创建人';
comment on column GK_BASIC_JSJY_JYR_CK.update_user
  is '修改人';
comment on column GK_BASIC_JSJY_JYR_CK.create_date_time
  is '创建时间';
comment on column GK_BASIC_JSJY_JYR_CK.update_date_time
  is '修改时间';
comment on column GK_BASIC_JSJY_JYR_CK.record_status
  is '数据状态';
comment on column GK_BASIC_JSJY_JYR_CK.szgk
  is '所在港口';
comment on column GK_BASIC_JSJY_JYR_CK.ssgkglbm
  is '所属管理部门';
comment on column GK_BASIC_JSJY_JYR_CK.aqid
  is '安全主键';
alter table GK_BASIC_JSJY_JYR_CK
  add primary key (ID);
  --堆场
  create table GK_BASIC_JSJY_JYR_DC
(
  id               NVARCHAR2(40) not null,
  szd              NVARCHAR2(40),
  szgq             NVARCHAR2(40),
  ssjyr            NVARCHAR2(40),
  ssmt             NVARCHAR2(40),
  dcmc             NVARCHAR2(100),
  scydcyt          NVARCHAR2(100),
  dczmj            NUMBER,
  dczrl            NUMBER,
  jzxmj            NUMBER,
  jzxdcdcnl        NUMBER,
  wxpxdcmj         NUMBER,
  wxpxdcdcnl       NUMBER,
  jd               NVARCHAR2(30),
  wd               NVARCHAR2(30),
  jtjgisdyidh      NVARCHAR2(100),
  wxpdc            NVARCHAR2(40),
  zwdcyt           NVARCHAR2(200),
  create_date_time TIMESTAMP(0) default current_timestamp,
  update_date_time TIMESTAMP(0) default current_timestamp,
  record_status    NUMBER default 1,
  create_user      NVARCHAR2(40),
  update_user      NVARCHAR2(40),
  szgk             NVARCHAR2(40),
  ssgkglbm         NVARCHAR2(40),
  aqid             NVARCHAR2(40)
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_JYR_DC
  is '港口经营人堆场';
comment on column GK_BASIC_JSJY_JYR_DC.id
  is '唯一标识';
comment on column GK_BASIC_JSJY_JYR_DC.szd
  is '所在地';
comment on column GK_BASIC_JSJY_JYR_DC.szgq
  is '所在港区';
comment on column GK_BASIC_JSJY_JYR_DC.ssjyr
  is '所属经营人';
comment on column GK_BASIC_JSJY_JYR_DC.ssmt
  is '所属码头';
comment on column GK_BASIC_JSJY_JYR_DC.dcmc
  is '堆场名称';
comment on column GK_BASIC_JSJY_JYR_DC.scydcyt
  is '堆场用途多个逗号隔开';
comment on column GK_BASIC_JSJY_JYR_DC.dczmj
  is '堆场总面积（平方米）';
comment on column GK_BASIC_JSJY_JYR_DC.dczrl
  is '堆场总容量（吨）';
comment on column GK_BASIC_JSJY_JYR_DC.jzxmj
  is '集装箱堆场面积（平方米）';
comment on column GK_BASIC_JSJY_JYR_DC.jzxdcdcnl
  is '集装箱堆场堆存面积（平方米）';
comment on column GK_BASIC_JSJY_JYR_DC.wxpxdcmj
  is '危险品堆场面积（平方米）';
comment on column GK_BASIC_JSJY_JYR_DC.wxpxdcdcnl
  is '危险品堆场堆存能力（TEU）';
comment on column GK_BASIC_JSJY_JYR_DC.jd
  is '经度';
comment on column GK_BASIC_JSJY_JYR_DC.wd
  is '纬度';
comment on column GK_BASIC_JSJY_JYR_DC.jtjgisdyidh
  is '交通局GIS对应ID号';
comment on column GK_BASIC_JSJY_JYR_DC.wxpdc
  is '是否危险品堆场1是2否';
comment on column GK_BASIC_JSJY_JYR_DC.zwdcyt
  is '堆场用途名称,多个逗号隔开';
comment on column GK_BASIC_JSJY_JYR_DC.record_status
  is '记录状态-有效1  记录状态-删除9';
comment on column GK_BASIC_JSJY_JYR_DC.szgk
  is '所在港口';
comment on column GK_BASIC_JSJY_JYR_DC.ssgkglbm
  is '所属管理部门';
comment on column GK_BASIC_JSJY_JYR_DC.aqid
  is '安全同步id';
  alter table GK_BASIC_JSJY_JYR_DC
  add  primary key (ID);
  --码头
  create table GK_BASIC_JSJY_JYR_MT
(
  id               VARCHAR2(40) not null,
  szd              VARCHAR2(40),
  mtmc             NVARCHAR2(50),
  nhwtgnl          NUMBER,
  sjhwttl          NUMBER,
  sjlkttl          NUMBER,
  nlktgnl          NUMBER,
  njzxtgnl         NUMBER,
  mtsjqyss         NUMBER,
  gisid            NUMBER,
  mtyt             NVARCHAR2(200),
  ssjyr            VARCHAR2(40),
  szgq             VARCHAR2(40),
  create_date_time TIMESTAMP(6) default current_timestamp,
  update_date_time TIMESTAMP(6) default current_timestamp,
  record_status    NUMBER default 1 not null,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  mtcd             NUMBER,
  fwlx             VARCHAR2(40),
  sfdwkf           VARCHAR2(40),
  sfwhp            VARCHAR2(40),
  mtqysjclss       NUMBER,
  mtdm             VARCHAR2(40),
  mtxsdm           VARCHAR2(40),
  bwgs             NUMBER,
  mtqydbg          NUMBER,
  mtsfwars         VARCHAR2(40),
  szgk             VARCHAR2(40),
  ssgkglbm         VARCHAR2(40),
  szzyq            VARCHAR2(40),
  szax             VARCHAR2(40),
  jcrq             TIMESTAMP(6),
  zyid             VARCHAR2(40),
  aqid             VARCHAR2(40),
  dtsj             NVARCHAR2(400)
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_JYR_MT
  is '码头';
comment on column GK_BASIC_JSJY_JYR_MT.id
  is '唯一标识';
comment on column GK_BASIC_JSJY_JYR_MT.szd
  is '所在地';
comment on column GK_BASIC_JSJY_JYR_MT.mtmc
  is '码头名称';
comment on column GK_BASIC_JSJY_JYR_MT.nhwtgnl
  is '年货物通过能力 万吨';
comment on column GK_BASIC_JSJY_JYR_MT.sjhwttl
  is '设计货物吞吐量  万吨';
comment on column GK_BASIC_JSJY_JYR_MT.sjlkttl
  is '设计旅客吞吐量  万人';
comment on column GK_BASIC_JSJY_JYR_MT.nlktgnl
  is '年旅客通过能力 万人';
comment on column GK_BASIC_JSJY_JYR_MT.njzxtgnl
  is '年集装箱通过能力 万TEU';
comment on column GK_BASIC_JSJY_JYR_MT.mtsjqyss
  is '码头设计前沿水深';
comment on column GK_BASIC_JSJY_JYR_MT.gisid
  is 'GISID';
comment on column GK_BASIC_JSJY_JYR_MT.mtyt
  is '码头用途';
comment on column GK_BASIC_JSJY_JYR_MT.ssjyr
  is '经营人';
comment on column GK_BASIC_JSJY_JYR_MT.szgq
  is '所在港区';
comment on column GK_BASIC_JSJY_JYR_MT.record_status
  is '记录状态-有效1  记录状态-删除9';
comment on column GK_BASIC_JSJY_JYR_MT.mtcd
  is '码头长度（米）';
comment on column GK_BASIC_JSJY_JYR_MT.fwlx
  is '服务类型';
comment on column GK_BASIC_JSJY_JYR_MT.sfdwkf
  is '是否对外开放';
comment on column GK_BASIC_JSJY_JYR_MT.sfwhp
  is '是否危化品';
comment on column GK_BASIC_JSJY_JYR_MT.mtqysjclss
  is '码头前沿实际测量水深（米）';
comment on column GK_BASIC_JSJY_JYR_MT.mtdm
  is '码头代码';
comment on column GK_BASIC_JSJY_JYR_MT.mtxsdm
  is '码头形式代码';
comment on column GK_BASIC_JSJY_JYR_MT.bwgs
  is '泊位个数';
comment on column GK_BASIC_JSJY_JYR_MT.mtqydbg
  is '码头前沿底标高（米）';
comment on column GK_BASIC_JSJY_JYR_MT.mtsfwars
  is '码头是否凹入式码头1是2否';
comment on column GK_BASIC_JSJY_JYR_MT.szgk
  is '所在港口';
comment on column GK_BASIC_JSJY_JYR_MT.ssgkglbm
  is '所属港口管理部门';
comment on column GK_BASIC_JSJY_JYR_MT.szzyq
  is '所在作业区';
comment on column GK_BASIC_JSJY_JYR_MT.szax
  is '所在岸线';
comment on column GK_BASIC_JSJY_JYR_MT.jcrq
  is '建成日期';
comment on column GK_BASIC_JSJY_JYR_MT.zyid
  is '资源主键';
comment on column GK_BASIC_JSJY_JYR_MT.aqid
  is '安全主键';
    alter table GK_BASIC_JSJY_JYR_MT
  add primary key (ID);
  
  
  --企业投资
  create table GK_BASIC_JSJY_JYR_QYTZ
(
  id               VARCHAR2(40) not null,
  jjlx             VARCHAR2(40),
  tzzje            NUMBER,
  tzrmc            VARCHAR2(40),
  tzje             VARCHAR2(40),
  sfws             VARCHAR2(40),
  szb              VARCHAR2(40),
  zczb             NUMBER,
  zcdz             VARCHAR2(40),
  szd              VARCHAR2(40),
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    CHAR(1),
  ssjyr            VARCHAR2(40),
  szgk           VARCHAR2(40),
  szgq           VARCHAR2(40),
  ssgkglbm         VARCHAR2(40)
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_JYR_QYTZ
  is '企业投资';
comment on column GK_BASIC_JSJY_JYR_QYTZ.id
  is 'ID';
comment on column GK_BASIC_JSJY_JYR_QYTZ.jjlx
  is '资产类型';
comment on column GK_BASIC_JSJY_JYR_QYTZ.tzzje
  is '投资总金额';
comment on column GK_BASIC_JSJY_JYR_QYTZ.tzrmc
  is '投资人名称';
comment on column GK_BASIC_JSJY_JYR_QYTZ.tzje
  is '投资金额单位';
comment on column GK_BASIC_JSJY_JYR_QYTZ.sfws
  is '是否外商';
comment on column GK_BASIC_JSJY_JYR_QYTZ.szb
  is '所占比';
comment on column GK_BASIC_JSJY_JYR_QYTZ.zczb
  is '注册资本';
comment on column GK_BASIC_JSJY_JYR_QYTZ.zcdz
  is '注册地址';
comment on column GK_BASIC_JSJY_JYR_QYTZ.szd
  is '所在地';
comment on column GK_BASIC_JSJY_JYR_QYTZ.create_user
  is '创建人';
comment on column GK_BASIC_JSJY_JYR_QYTZ.update_user
  is '修改人';
comment on column GK_BASIC_JSJY_JYR_QYTZ.create_date_time
  is '创建时间';
comment on column GK_BASIC_JSJY_JYR_QYTZ.update_date_time
  is '修改时间';
comment on column GK_BASIC_JSJY_JYR_QYTZ.record_status
  is '数据状态';
comment on column GK_BASIC_JSJY_JYR_QYTZ.ssjyr
  is '经营人';
alter table GK_BASIC_JSJY_JYR_QYTZ
  add  primary key (ID);
  
  
  --人员
  create table GK_BASIC_JSJY_JYR_RY
(
  id               NVARCHAR2(40) not null,
  xm               NVARCHAR2(400),
  xb               NVARCHAR2(40),
  zwhzc            NVARCHAR2(400),
  lxdh             NVARCHAR2(400),
  sjhm             NVARCHAR2(400),
  ssjyr            NVARCHAR2(40),
  csrq             TIMESTAMP(6),
  create_user      NVARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      NVARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    NUMBER,
  sfzh             NVARCHAR2(30),
  szd              NVARCHAR2(40),
  szgq             NVARCHAR2(40),
  rylx             NVARCHAR2(40),
  bz               NVARCHAR2(2000),
  szgk             NVARCHAR2(40),
  ssgkglbm         NVARCHAR2(40),
  aqid             VARCHAR2(20),
  zjlx            VARCHAR2(40)
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_JYR_RY
  is '经营人的人员及持证信息';
comment on column GK_BASIC_JSJY_JYR_RY.id
  is 'ID';
comment on column GK_BASIC_JSJY_JYR_RY.xm
  is '姓名';
comment on column GK_BASIC_JSJY_JYR_RY.xb
  is '性别';
comment on column GK_BASIC_JSJY_JYR_RY.zwhzc
  is '职务或职称';
comment on column GK_BASIC_JSJY_JYR_RY.lxdh
  is '联系电话';
comment on column GK_BASIC_JSJY_JYR_RY.sjhm
  is '手机号码';
comment on column GK_BASIC_JSJY_JYR_RY.ssjyr
  is '所属经营人';
comment on column GK_BASIC_JSJY_JYR_RY.csrq
  is '出生日期';
comment on column GK_BASIC_JSJY_JYR_RY.create_user
  is '创建人';
comment on column GK_BASIC_JSJY_JYR_RY.create_date_time
  is '创建时间';
comment on column GK_BASIC_JSJY_JYR_RY.update_user
  is '修改人';
comment on column GK_BASIC_JSJY_JYR_RY.update_date_time
  is '修改时间';
comment on column GK_BASIC_JSJY_JYR_RY.record_status
  is '删除状态';
comment on column GK_BASIC_JSJY_JYR_RY.sfzh
  is '证件编号';
  comment on column GK_BASIC_JSJY_JYR_RY.sfzh
  is '证件编号';
comment on column GK_BASIC_JSJY_JYR_RY.zjlx
  is '证件类型';
comment on column GK_BASIC_JSJY_JYR_RY.szgq
  is '所在港区';
comment on column GK_BASIC_JSJY_JYR_RY.rylx
  is '人员类型';
comment on column GK_BASIC_JSJY_JYR_RY.bz
  is '备注';
comment on column GK_BASIC_JSJY_JYR_RY.szgk
  is '所在港口';
comment on column GK_BASIC_JSJY_JYR_RY.ssgkglbm
  is '所属港口管理部门';
alter table GK_BASIC_JSJY_JYR_RY
  add  primary key (ID);

  --人员证书
create table GK_BASIC_JSJY_JYR_RY_ZS
(
  id               NVARCHAR2(40) not null,
  create_user      NVARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      NVARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    NUMBER,
  zsmc             NVARCHAR2(100),
  zsbh             NVARCHAR2(100),
  fzbm             NVARCHAR2(100),
  yxq              TIMESTAMP(6),
  szd              NVARCHAR2(40),
  ryid             NVARCHAR2(40),
  aqid             VARCHAR2(20),
  sfzh             VARCHAR2(40)
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_JYR_RY_ZS
  is '港口人员信息证书子表';
comment on column GK_BASIC_JSJY_JYR_RY_ZS.zsmc
  is '证书名称';
comment on column GK_BASIC_JSJY_JYR_RY_ZS.zsbh
  is '证书编号';
comment on column GK_BASIC_JSJY_JYR_RY_ZS.fzbm
  is '发证部门';
comment on column GK_BASIC_JSJY_JYR_RY_ZS.yxq
  is '有效期';
comment on column GK_BASIC_JSJY_JYR_RY_ZS.szd
  is '所在地';
comment on column GK_BASIC_JSJY_JYR_RY_ZS.ryid
  is '关联的人员的id';
alter table GK_BASIC_JSJY_JYR_RY_ZS
  add  primary key (ID);

  --设施设备
create table GK_BASIC_JSJY_JYR_SSSB
(
  id               VARCHAR2(40) not null,
  ssmc             NVARCHAR2(100),
  ssjyr            VARCHAR2(3000),
  tbr              VARCHAR2(40),
  lxdh             VARCHAR2(40),
  szd              VARCHAR2(40),
  szgq             VARCHAR2(40),
  yjfl             VARCHAR2(40),
  ejfl             VARCHAR2(40),
  ggxh             VARCHAR2(100),
  sldw             VARCHAR2(10),
  sl               NUMBER,
  yxq              TIMESTAMP(6),
  cfcs             NVARCHAR2(200),
  bz               NVARCHAR2(1000),
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  ssgkglbm         VARCHAR2(40),
  szgk             VARCHAR2(40),
  aqid             VARCHAR2(40)
) TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_JYR_SSSB
  is '设施设备表';
comment on column GK_BASIC_JSJY_JYR_SSSB.id
  is '唯一标识';
comment on column GK_BASIC_JSJY_JYR_SSSB.ssmc
  is '设施名称';
comment on column GK_BASIC_JSJY_JYR_SSSB.ssjyr
  is '港口经营人名称';
comment on column GK_BASIC_JSJY_JYR_SSSB.tbr
  is '填表人';
comment on column GK_BASIC_JSJY_JYR_SSSB.lxdh
  is '联系电话';
comment on column GK_BASIC_JSJY_JYR_SSSB.szd
  is '所在地';
comment on column GK_BASIC_JSJY_JYR_SSSB.szgq
  is '所在港区';
comment on column GK_BASIC_JSJY_JYR_SSSB.yjfl
  is '一级分类';
comment on column GK_BASIC_JSJY_JYR_SSSB.ejfl
  is '二级分类';
comment on column GK_BASIC_JSJY_JYR_SSSB.ggxh
  is '规格型号';
comment on column GK_BASIC_JSJY_JYR_SSSB.sldw
  is '数量单位';
comment on column GK_BASIC_JSJY_JYR_SSSB.sl
  is '数量';
comment on column GK_BASIC_JSJY_JYR_SSSB.yxq
  is '有效期';
comment on column GK_BASIC_JSJY_JYR_SSSB.cfcs
  is '存放场所';
comment on column GK_BASIC_JSJY_JYR_SSSB.bz
  is '备注';
comment on column GK_BASIC_JSJY_JYR_SSSB.create_user
  is '创建人';
comment on column GK_BASIC_JSJY_JYR_SSSB.update_user
  is '修改人';
comment on column GK_BASIC_JSJY_JYR_SSSB.create_date_time
  is '创建日期';
comment on column GK_BASIC_JSJY_JYR_SSSB.update_date_time
  is '修改日期';
comment on column GK_BASIC_JSJY_JYR_SSSB.record_status
  is '数据状态';
comment on column GK_BASIC_JSJY_JYR_SSSB.ssgkglbm
  is '所属港口管理部门';
comment on column GK_BASIC_JSJY_JYR_SSSB.szgk
  is '所在港口';
comment on column GK_BASIC_JSJY_JYR_SSSB.aqid
  is '安全同步id';
alter table GK_BASIC_JSJY_JYR_SSSB
  add  primary key (ID);
  
  --许可证
  create table GK_SHARE_JSJY_JYXKZ
(
  id               VARCHAR2(40) not null,
  gkjyr            VARCHAR2(40),
  ssgq             VARCHAR2(40),
  dz               NVARCHAR2(200),
  fddbr            NVARCHAR2(80),
  lxdh             NVARCHAR2(80),
  zyqyfw           NVARCHAR2(200),
  cq               NVARCHAR2(200),
  zyfs             NVARCHAR2(200),
  zyhwpm           NVARCHAR2(200),
  spr              VARCHAR2(80),
  fzjg             VARCHAR2(80),
  fzrq             DATE,
  yxqz             DATE,
  qynbbh           VARCHAR2(80),
  gkjyxkzh         VARCHAR2(80),
  gkjyxkzsmj       VARCHAR2(80),
  create_date_time TIMESTAMP(6) default current_timestamp,
  update_date_time TIMESTAMP(6) default current_timestamp,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              VARCHAR2(20),
  record_status    NUMBER(38) default 1
)TABLESPACE "GK_SHARE"
;
comment on table GK_SHARE_JSJY_JYXKZ
  is '经营许可证表';
comment on column GK_SHARE_JSJY_JYXKZ.id
  is '唯一标识';
comment on column GK_SHARE_JSJY_JYXKZ.gkjyr
  is '港口经营人';
comment on column GK_SHARE_JSJY_JYXKZ.ssgq
  is '所属港区';
comment on column GK_SHARE_JSJY_JYXKZ.dz
  is '地址';
comment on column GK_SHARE_JSJY_JYXKZ.fddbr
  is '法定代表人';
comment on column GK_SHARE_JSJY_JYXKZ.lxdh
  is '联系电话';
comment on column GK_SHARE_JSJY_JYXKZ.zyqyfw
  is '作业区域范围';
comment on column GK_SHARE_JSJY_JYXKZ.cq
  is '经营范围';
comment on column GK_SHARE_JSJY_JYXKZ.zyfs
  is '作业方式';
comment on column GK_SHARE_JSJY_JYXKZ.zyhwpm
  is '作业货物品名';
comment on column GK_SHARE_JSJY_JYXKZ.spr
  is '审批人';
comment on column GK_SHARE_JSJY_JYXKZ.fzjg
  is '发证机关';
comment on column GK_SHARE_JSJY_JYXKZ.fzrq
  is '发证日期';
comment on column GK_SHARE_JSJY_JYXKZ.yxqz
  is '有效期至';
comment on column GK_SHARE_JSJY_JYXKZ.qynbbh
  is '企业内部编号';
comment on column GK_SHARE_JSJY_JYXKZ.gkjyxkzh
  is '许可证号';
comment on column GK_SHARE_JSJY_JYXKZ.gkjyxkzsmj
  is '扫描件';
comment on column GK_SHARE_JSJY_JYXKZ.create_date_time
  is '创建时间';
comment on column GK_SHARE_JSJY_JYXKZ.update_date_time
  is '更新时间';
comment on column GK_SHARE_JSJY_JYXKZ.create_user
  is '创建人';
comment on column GK_SHARE_JSJY_JYXKZ.update_user
  is '更新人';
comment on column GK_SHARE_JSJY_JYXKZ.szd
  is '所在地';
comment on column GK_SHARE_JSJY_JYXKZ.record_status
  is '记录状态';
  alter table GK_SHARE_JSJY_JYXKZ
  add  primary key (ID);
  --附证
  create table GK_SHARE_JSJY_WHZYFZ
(
  id               VARCHAR2(40) not null,
  create_date_time TIMESTAMP(6) default current_timestamp,
  create_user      NVARCHAR2(40),
  update_date_time TIMESTAMP(6) default current_timestamp,
  update_user      NVARCHAR2(40),
  szd              NVARCHAR2(40),
  record_status    NUMBER default 1,
  ssjyr            NVARCHAR2(40),
  szgk             NVARCHAR2(40),
  szgq             NVARCHAR2(40),
  dz               NVARCHAR2(2000),
  fddbr            NVARCHAR2(200),
  aqgljg           NVARCHAR2(200),
  aqfz             NVARCHAR2(200),
  gqgljgfzrxm      NVARCHAR2(200),
  gqgljgfzrzc      NVARCHAR2(200),
  gqgljgfzrlxdh    NVARCHAR2(20),
  gqgljgfzrdzyx    NVARCHAR2(200),
  zycs             NVARCHAR2(40),
  cq               NVARCHAR2(40),
  zyfs             NVARCHAR2(200),
  whdj             NVARCHAR2(40),
  wxhwpm           NVARCHAR2(2000),
  bh               NVARCHAR2(1000),
  sqtbrq           TIMESTAMP(6),
  fzsj             TIMESTAMP(6),
  fzsqh            NVARCHAR2(80),
  fzcsbh           NVARCHAR2(50),
  fzjg             NVARCHAR2(100),
  yxqkssj          TIMESTAMP(6),
  yxqjssj          TIMESTAMP(6),
  qynbbh           NVARCHAR2(50),
  gkjyxkz          NVARCHAR2(400),
  qynbmc           NVARCHAR2(200),
  aqid             VARCHAR2(40)
)TABLESPACE "GK_SHARE"
;
comment on table GK_SHARE_JSJY_WHZYFZ
  is '危险货物作业附证';
comment on column GK_SHARE_JSJY_WHZYFZ.ssjyr
  is '所属经营人';
comment on column GK_SHARE_JSJY_WHZYFZ.szgk
  is '所在港口';
comment on column GK_SHARE_JSJY_WHZYFZ.szgq
  is '港区';
comment on column GK_SHARE_JSJY_WHZYFZ.dz
  is '地址';
comment on column GK_SHARE_JSJY_WHZYFZ.fddbr
  is '法定代表人';
comment on column GK_SHARE_JSJY_WHZYFZ.aqgljg
  is '安全管理机构';
comment on column GK_SHARE_JSJY_WHZYFZ.aqfz
  is '安全副总';
comment on column GK_SHARE_JSJY_WHZYFZ.gqgljgfzrxm
  is '安全管理机构负责人信息  姓名';
comment on column GK_SHARE_JSJY_WHZYFZ.gqgljgfzrzc
  is '安全管理机构负责人信息  职称';
comment on column GK_SHARE_JSJY_WHZYFZ.gqgljgfzrlxdh
  is '安全管理机构负责人信息  联系电话';
comment on column GK_SHARE_JSJY_WHZYFZ.gqgljgfzrdzyx
  is '安全管理机构负责人信息  电子邮箱';
comment on column GK_SHARE_JSJY_WHZYFZ.zycs
  is '作业场所';
comment on column GK_SHARE_JSJY_WHZYFZ.cq
  is '产权';
comment on column GK_SHARE_JSJY_WHZYFZ.zyfs
  is '作业方式';
comment on column GK_SHARE_JSJY_WHZYFZ.whdj
  is '危货等级';
comment on column GK_SHARE_JSJY_WHZYFZ.wxhwpm
  is '作业危险货物品名';
comment on column GK_SHARE_JSJY_WHZYFZ.bh
  is '编号';
comment on column GK_SHARE_JSJY_WHZYFZ.sqtbrq
  is '填报日期';
comment on column GK_SHARE_JSJY_WHZYFZ.fzsj
  is '附证时间';
comment on column GK_SHARE_JSJY_WHZYFZ.fzsqh
  is '附证编号';
comment on column GK_SHARE_JSJY_WHZYFZ.fzcsbh
  is '附证场所编号';
comment on column GK_SHARE_JSJY_WHZYFZ.fzjg
  is '发证机关';
comment on column GK_SHARE_JSJY_WHZYFZ.yxqkssj
  is '有效期开始时间';
comment on column GK_SHARE_JSJY_WHZYFZ.yxqjssj
  is '有效期结束时间';
comment on column GK_SHARE_JSJY_WHZYFZ.qynbbh
  is '企业内部编号';
comment on column GK_SHARE_JSJY_WHZYFZ.gkjyxkz
  is '港口经营许可证号';
comment on column GK_SHARE_JSJY_WHZYFZ.qynbmc
  is '企业内部名称';
comment on column GK_SHARE_JSJY_WHZYFZ.aqid
  is '安全主键';
alter table GK_SHARE_JSJY_WHZYFZ
  add  primary key (ID);
  
  --单船申报
  
  create table GK_OPERATION_JSJY_DCSB
(
  id               VARCHAR2(40) not null,
  bh               VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  sfcd             CHAR(1),
  cs               INTEGER,
  cm               NVARCHAR2(20),
  zywtr            NVARCHAR2(30),
  hc               NVARCHAR2(30),
  zypmc            NVARCHAR2(100),
  zysl             INTEGER,
  jcg              NVARCHAR2(30),
  bgsj             TIMESTAMP(6),
  xg               NVARCHAR2(30),
  sg               NVARCHAR2(30),
  zyfs             NVARCHAR2(30),
  nwm              VARCHAR2(40),
  mt               VARCHAR2(40),
  bw               VARCHAR2(40),
  mtlb             NVARCHAR2(40),
  jzxsl            INTEGER,
  hwzl             VARCHAR2(40),
  huxs             VARCHAR2(40),
  huxs20           VARCHAR2(40),
  huxssl20         INTEGER,
  huxs40           VARCHAR2(40),
  huxssl40         INTEGER,
  huxs45           VARCHAR2(40),
  huxssl45         INTEGER,
  huxstzx          VARCHAR2(40),
  huxssltzx        INTEGER,
  zysjq            TIMESTAMP(6),
  zysjz            TIMESTAMP(6),
  bgr              VARCHAR2(40),
  lxfs             NVARCHAR2(40),
  shyj             NVARCHAR2(100),
  shsj             TIMESTAMP(6),
  shr              VARCHAR2(40),
  shzt             VARCHAR2(40),
  create_date_time TIMESTAMP(0) default current_timestamp,
  update_date_time TIMESTAMP(0) default current_timestamp,
  record_status    INTEGER default 1,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              VARCHAR2(40),
  ssjyr            VARCHAR2(40),
  zydd             NVARCHAR2(40),
  gk20             VARCHAR2(40),
  gksl20           INTEGER,
  gk40             VARCHAR2(40),
  gksl40           INTEGER
)TABLESPACE "GK_OPERATION"
;
comment on table GK_OPERATION_JSJY_DCSB
  is '单船申报表';
comment on column GK_OPERATION_JSJY_DCSB.id
  is '主键';
comment on column GK_OPERATION_JSJY_DCSB.bh
  is '编号';
comment on column GK_OPERATION_JSJY_DCSB.szgk
  is '所在港口';
comment on column GK_OPERATION_JSJY_DCSB.szgq
  is '所在港区';
comment on column GK_OPERATION_JSJY_DCSB.sfcd
  is '是否船队';
comment on column GK_OPERATION_JSJY_DCSB.cs
  is '船数';
comment on column GK_OPERATION_JSJY_DCSB.cm
  is '船名';
comment on column GK_OPERATION_JSJY_DCSB.zywtr
  is '作业委托人';
comment on column GK_OPERATION_JSJY_DCSB.hc
  is '航次';
comment on column GK_OPERATION_JSJY_DCSB.zypmc
  is '作业品名称';
comment on column GK_OPERATION_JSJY_DCSB.zysl
  is '作业数量';
comment on column GK_OPERATION_JSJY_DCSB.jcg
  is '进出港';
comment on column GK_OPERATION_JSJY_DCSB.bgsj
  is '报告时间';
comment on column GK_OPERATION_JSJY_DCSB.xg
  is '下港';
comment on column GK_OPERATION_JSJY_DCSB.sg
  is '上港';
comment on column GK_OPERATION_JSJY_DCSB.zyfs
  is '作业方式';
comment on column GK_OPERATION_JSJY_DCSB.nwm
  is '内外贸';
comment on column GK_OPERATION_JSJY_DCSB.mt
  is '码头';
comment on column GK_OPERATION_JSJY_DCSB.bw
  is '泊位';
comment on column GK_OPERATION_JSJY_DCSB.mtlb
  is '码头类别';
comment on column GK_OPERATION_JSJY_DCSB.jzxsl
  is '集装箱数量';
comment on column GK_OPERATION_JSJY_DCSB.hwzl
  is '货物种类';
comment on column GK_OPERATION_JSJY_DCSB.huxs
  is '货物形式';
comment on column GK_OPERATION_JSJY_DCSB.huxs20
  is '货物形式—集装箱20''';
comment on column GK_OPERATION_JSJY_DCSB.huxssl20
  is '货物形式—集装箱20''数量';
comment on column GK_OPERATION_JSJY_DCSB.huxs40
  is '货物形式—集装箱40''';
comment on column GK_OPERATION_JSJY_DCSB.huxssl40
  is '货物形式—集装箱40''数量';
comment on column GK_OPERATION_JSJY_DCSB.huxs45
  is '货物形式—集装箱45''';
comment on column GK_OPERATION_JSJY_DCSB.huxssl45
  is '货物形式—集装箱45''数量';
comment on column GK_OPERATION_JSJY_DCSB.huxstzx
  is '货物形式—特种箱';
comment on column GK_OPERATION_JSJY_DCSB.huxssltzx
  is '货物形式—特种箱 数量';
comment on column GK_OPERATION_JSJY_DCSB.zysjq
  is '作业时间起';
comment on column GK_OPERATION_JSJY_DCSB.zysjz
  is '作业时间止';
comment on column GK_OPERATION_JSJY_DCSB.bgr
  is '报告人';
comment on column GK_OPERATION_JSJY_DCSB.lxfs
  is '联系方式';
comment on column GK_OPERATION_JSJY_DCSB.shyj
  is '审核意见';
comment on column GK_OPERATION_JSJY_DCSB.shsj
  is '审核时间';
comment on column GK_OPERATION_JSJY_DCSB.shr
  is '审核人';
comment on column GK_OPERATION_JSJY_DCSB.shzt
  is '审核状态';
comment on column GK_OPERATION_JSJY_DCSB.create_date_time
  is '创建时间';
comment on column GK_OPERATION_JSJY_DCSB.update_date_time
  is '修改时间';
comment on column GK_OPERATION_JSJY_DCSB.record_status
  is '数据状态';
comment on column GK_OPERATION_JSJY_DCSB.create_user
  is '创建人';
comment on column GK_OPERATION_JSJY_DCSB.update_user
  is '修改人';
comment on column GK_OPERATION_JSJY_DCSB.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_DCSB.ssjyr
  is '所属于经营人';
comment on column GK_OPERATION_JSJY_DCSB.zydd
  is '作业地点';
comment on column GK_OPERATION_JSJY_DCSB.gk20
  is '罐柜20';
comment on column GK_OPERATION_JSJY_DCSB.gksl20
  is '罐柜数量20';
comment on column GK_OPERATION_JSJY_DCSB.gk40
  is '罐柜40';
comment on column GK_OPERATION_JSJY_DCSB.gksl40
  is '罐柜数量40';
alter table GK_OPERATION_JSJY_DCSB
  add  primary key (ID);
  
  
   --许可证经营范围信息
create table GK_OPERATION_JSJY_XKZJYFWXX
(
  id               VARCHAR2(40),
  fjdid            VARCHAR2(40),
  fjdmc            NVARCHAR2(40),
  jyfwid           VARCHAR2(40),
  jyfwmc           NVARCHAR2(40),
  jyrid            VARCHAR2(40),
  gkid             VARCHAR2(40),
  gqid             VARCHAR2(40),
  zyqid            VARCHAR2(40),
  mtid             VARCHAR2(40),
  bwid             VARCHAR2(40),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40)
)TABLESPACE "GK_OPERATION"
;
comment on table GK_OPERATION_JSJY_XKZJYFWXX
  is '许可证经营范围信息';
  alter table GK_OPERATION_JSJY_XKZJYFWXX
  add primary key (ID);
  --许可证申请附件表
create table GK_OPERATION_JSJY_XKZSQFJ
(
  id               VARCHAR2(40) not null,
  sqid             VARCHAR2(40),
  fjid             VARCHAR2(40),
  fjmc             NVARCHAR2(100),
  sfbx             INTEGER,
  sortno           INTEGER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40)
)TABLESPACE "GK_OPERATION"
;
comment on table GK_OPERATION_JSJY_XKZSQFJ
  is '许可证申请附件表';
comment on column GK_OPERATION_JSJY_XKZSQFJ.id
  is '主键';
comment on column GK_OPERATION_JSJY_XKZSQFJ.sqid
  is '申请ID';
comment on column GK_OPERATION_JSJY_XKZSQFJ.fjid
  is '附件ID';
comment on column GK_OPERATION_JSJY_XKZSQFJ.fjmc
  is '附件名称';
comment on column GK_OPERATION_JSJY_XKZSQFJ.sfbx
  is '是否必须';
comment on column GK_OPERATION_JSJY_XKZSQFJ.sortno
  is '排序号';
comment on column GK_OPERATION_JSJY_XKZSQFJ.create_user
  is '创建人';
comment on column GK_OPERATION_JSJY_XKZSQFJ.update_user
  is '修改人';
comment on column GK_OPERATION_JSJY_XKZSQFJ.create_date_time
  is '创建时间';
comment on column GK_OPERATION_JSJY_XKZSQFJ.update_date_time
  is '修改时间';
comment on column GK_OPERATION_JSJY_XKZSQFJ.record_status
  is '状态';
comment on column GK_OPERATION_JSJY_XKZSQFJ.szd
  is '所在地';
  alter table GK_OPERATION_JSJY_XKZSQFJ
  add primary key (ID);

  --许可证申请证书参数表
create table GK_OPERATION_JSJY_XKZSQZSCS
(
  id               VARCHAR2(40) not null,
  sortno           NVARCHAR2(10),
  sqclmc           NVARCHAR2(200),
  sfbx             CHAR(1),
  szd              VARCHAR2(40),
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  create_date_time TIMESTAMP(6),
  record_status    INTEGER
)TABLESPACE "GK_OPERATION"
;
comment on table GK_OPERATION_JSJY_XKZSQZSCS
  is '许可证申请证书参数表';
comment on column GK_OPERATION_JSJY_XKZSQZSCS.id
  is '唯一标识';
comment on column GK_OPERATION_JSJY_XKZSQZSCS.sortno
  is '排序号';
comment on column GK_OPERATION_JSJY_XKZSQZSCS.sqclmc
  is '申请材料名称';
comment on column GK_OPERATION_JSJY_XKZSQZSCS.sfbx
  is '是否必须';
alter table GK_OPERATION_JSJY_XKZSQZSCS
  add primary key (ID);

  --许可证申请关联表
create table GK_OPERATION_JSJY_XKZSQGLB
(
  id               VARCHAR2(40),
  delid            VARCHAR2(40),
  fileid           VARCHAR2(40),
  sortno           INTEGER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40)
)TABLESPACE "GK_OPERATION"
;
comment on table GK_OPERATION_JSJY_XKZSQGLB
  is '许可证申请关联表';
comment on column GK_OPERATION_JSJY_XKZSQGLB.delid
  is '第二类ID';
comment on column GK_OPERATION_JSJY_XKZSQGLB.fileid
  is '附件id（关联证书参数表id）';
  alter table GK_OPERATION_JSJY_XKZSQGLB
  add primary key (ID);
--许可证申请决定书
create table GK_OPERATION_JSJY_XKZSQJDS
(
  id               VARCHAR2(40),
  sqid             VARCHAR2(40),
  jyrid            VARCHAR2(40),
  jyrmc            NVARCHAR2(40),
  ah               NVARCHAR2(40),
  jyrfwmc          NVARCHAR2(100),
  gjrn             NVARCHAR2(300),
  xkzrn            NVARCHAR2(1000),
  dw               NVARCHAR2(20),
  rq               NVARCHAR2(20),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40)
)TABLESPACE "GK_OPERATION"
;
comment on table GK_OPERATION_JSJY_XKZSQJDS
  is '许可证申请决定书';
comment on column GK_OPERATION_JSJY_XKZSQJDS.id
  is '主键';
comment on column GK_OPERATION_JSJY_XKZSQJDS.sqid
  is '申请ID';
comment on column GK_OPERATION_JSJY_XKZSQJDS.jyrid
  is '经营人ID';
comment on column GK_OPERATION_JSJY_XKZSQJDS.jyrmc
  is '经营人名称';
comment on column GK_OPERATION_JSJY_XKZSQJDS.ah
  is '案号';
comment on column GK_OPERATION_JSJY_XKZSQJDS.jyrfwmc
  is '经营范围';
comment on column GK_OPERATION_JSJY_XKZSQJDS.gjrn
  is '根据内容';
comment on column GK_OPERATION_JSJY_XKZSQJDS.xkzrn
  is '许可证内容';
comment on column GK_OPERATION_JSJY_XKZSQJDS.dw
  is '单位';
comment on column GK_OPERATION_JSJY_XKZSQJDS.rq
  is '日期';
comment on column GK_OPERATION_JSJY_XKZSQJDS.create_user
  is '创建人';
comment on column GK_OPERATION_JSJY_XKZSQJDS.create_date_time
  is '创建时间';
comment on column GK_OPERATION_JSJY_XKZSQJDS.update_user
  is '修改人';
comment on column GK_OPERATION_JSJY_XKZSQJDS.update_date_time
  is '修改时间';
comment on column GK_OPERATION_JSJY_XKZSQJDS.record_status
  is '状态';
comment on column GK_OPERATION_JSJY_XKZSQJDS.szd
  is '所在地';
  
    alter table GK_OPERATION_JSJY_XKZSQJDS
  add primary key (ID);
--许可证申请信息
create table GK_OPERATION_JSJY_XKZSQXX
(
  id               VARCHAR2(40),
  jyrid            VARCHAR2(40),
  jyrmc            NVARCHAR2(40),
  bgdd             NVARCHAR2(100),
  fddbr            NVARCHAR2(20),
  lxr              NVARCHAR2(20),
  lxdh             NVARCHAR2(20),
  jydy             NVARCHAR2(200),
  sqr              VARCHAR2(40),
  sqyj             NVARCHAR2(200),
  sqrq             TIMESTAMP(6),
  clscjbr          VARCHAR2(40),
  clscyj           NVARCHAR2(200),
  fhyj             NVARCHAR2(200),
  fhjbr            VARCHAR2(40),
  fhrq             TIMESTAMP(6),
  jydyids          NVARCHAR2(2000),
  cz               NVARCHAR2(20),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40),
  clscrq           TIMESTAMP(6),
  xchcrq           TIMESTAMP(6),
  xchcyj           NVARCHAR2(200),
  xchcjbr          VARCHAR2(40),
  xchcry           NVARCHAR2(200),
  sqlx             VARCHAR2(20),
  spyj             NVARCHAR2(200),
  spry             VARCHAR2(20),
  sprq             TIMESTAMP(6),
 szgk           VARCHAR2(40),
  szgq           VARCHAR2(40),
  ssgkglbm         VARCHAR2(40)
)TABLESPACE "GK_OPERATION"
;
comment on table GK_OPERATION_JSJY_XKZSQXX
  is '许可证申请信息';
comment on column GK_OPERATION_JSJY_XKZSQXX.id
  is '主键';
comment on column GK_OPERATION_JSJY_XKZSQXX.jyrid
  is '经营人ID';
comment on column GK_OPERATION_JSJY_XKZSQXX.jyrmc
  is '经营人名称';
comment on column GK_OPERATION_JSJY_XKZSQXX.bgdd
  is '办公地点';
comment on column GK_OPERATION_JSJY_XKZSQXX.fddbr
  is '法定代表人';
comment on column GK_OPERATION_JSJY_XKZSQXX.lxr
  is '联系人';
comment on column GK_OPERATION_JSJY_XKZSQXX.lxdh
  is '联系电话';
comment on column GK_OPERATION_JSJY_XKZSQXX.jydy
  is '经营地域';
comment on column GK_OPERATION_JSJY_XKZSQXX.sqr
  is '申请人';
comment on column GK_OPERATION_JSJY_XKZSQXX.sqyj
  is '申请意见';
comment on column GK_OPERATION_JSJY_XKZSQXX.sqrq
  is '申请时间';
comment on column GK_OPERATION_JSJY_XKZSQXX.clscjbr
  is '材料审核经办人';
comment on column GK_OPERATION_JSJY_XKZSQXX.clscyj
  is '材料审核意见';
comment on column GK_OPERATION_JSJY_XKZSQXX.fhyj
  is '复核意见';
comment on column GK_OPERATION_JSJY_XKZSQXX.fhjbr
  is '复核经办人';
comment on column GK_OPERATION_JSJY_XKZSQXX.fhrq
  is '复核日期';
comment on column GK_OPERATION_JSJY_XKZSQXX.cz
  is '传真';
comment on column GK_OPERATION_JSJY_XKZSQXX.clscrq
  is '材料审核日期';
comment on column GK_OPERATION_JSJY_XKZSQXX.xchcrq
  is '现场核查时间';
comment on column GK_OPERATION_JSJY_XKZSQXX.xchcyj
  is '现场核查意见';
comment on column GK_OPERATION_JSJY_XKZSQXX.xchcjbr
  is '现场核查经办人';
comment on column GK_OPERATION_JSJY_XKZSQXX.xchcry
  is '现场经办人员';
comment on column GK_OPERATION_JSJY_XKZSQXX.sqlx
  is '申请类型';
      alter table GK_OPERATION_JSJY_XKZSQXX
  add primary key (ID);
  
--经营许可证经营业务种类信息表
create table GK_OPERATION_JSJY_XKZYWZLXX
(
  id               VARCHAR2(40) not null,
  xkzsqid          VARCHAR2(40),
  jyfwid           VARCHAR2(40),
  fjdmc            NVARCHAR2(100),
  jyfwmc           NVARCHAR2(200),
  gkid             VARCHAR2(40),
  gkmc             NVARCHAR2(100),
  gqid             VARCHAR2(40),
  gqmc             NVARCHAR2(100),
  zyqid            VARCHAR2(40),
  zyqmc            NVARCHAR2(100),
  mtid             VARCHAR2(40),
  mtmc             NVARCHAR2(100),
  bwid             VARCHAR2(40),
  bwmc             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),
  fjdid            VARCHAR2(40),
  flag             CHAR(1)
)TABLESPACE "GK_OPERATION"
;
comment on table GK_OPERATION_JSJY_XKZYWZLXX
  is '经营许可证经营业务种类信息表';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.id
  is '唯一ID';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.xkzsqid
  is '许可证申请ＩＤ';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.jyfwid
  is '经营人范围ID';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.fjdmc
  is '父节点名称';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.jyfwmc
  is '经营人范围名称';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.gkid
  is '港口ID';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.gkmc
  is '港口名称';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.gqid
  is '港区ID';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.gqmc
  is '港区名称';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.zyqid
  is '作业区id';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.zyqmc
  is '作业区名称';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.mtid
  is '码头ID';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.mtmc
  is '码头名称';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.bwid
  is '泊位ID';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.bwmc
  is '泊位名称';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.create_user
  is '创建人';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.create_date_time
  is '创建时间';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.update_user
  is '修改人';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.update_date_time
  is '修改时间';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.record_status
  is '数据状态';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.fjdid
  is '父节点ID';
comment on column GK_OPERATION_JSJY_XKZYWZLXX.flag
  is '标志位';
alter table GK_OPERATION_JSJY_XKZYWZLXX
  add primary key (ID);
--许可证申请附件表
create table GK_OPERATION_JSJY_XKZYXFJ
(
  id               VARCHAR2(40) not null,
  sqid             VARCHAR2(40),
  fjid             VARCHAR2(40),
  fjmc             NVARCHAR2(100),
  sfbx             INTEGER,
  sortno           INTEGER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40)
)TABLESPACE "GK_OPERATION"
;
comment on table GK_OPERATION_JSJY_XKZYXFJ
  is '许可证申请附件表';
comment on column GK_OPERATION_JSJY_XKZYXFJ.id
  is '主键';
comment on column GK_OPERATION_JSJY_XKZYXFJ.sqid
  is '申请ID';
comment on column GK_OPERATION_JSJY_XKZYXFJ.fjid
  is '附件ID';
comment on column GK_OPERATION_JSJY_XKZYXFJ.fjmc
  is '附件名称';
comment on column GK_OPERATION_JSJY_XKZYXFJ.sfbx
  is '是否必须';
comment on column GK_OPERATION_JSJY_XKZYXFJ.sortno
  is '排序号';
comment on column GK_OPERATION_JSJY_XKZYXFJ.create_user
  is '创建人';
comment on column GK_OPERATION_JSJY_XKZYXFJ.update_user
  is '修改人';
comment on column GK_OPERATION_JSJY_XKZYXFJ.create_date_time
  is '创建时间';
comment on column GK_OPERATION_JSJY_XKZYXFJ.update_date_time
  is '修改时间';
comment on column GK_OPERATION_JSJY_XKZYXFJ.record_status
  is '状态';
comment on column GK_OPERATION_JSJY_XKZYXFJ.szd
  is '所在地';
  
        alter table GK_OPERATION_JSJY_XKZYXFJ
  add primary key (ID);
--许可证延续
create table GK_OPERATION_JSJY_XKZYXXX
(
  id               VARCHAR2(40),
  jyrid            VARCHAR2(40),
  jyrmc            NVARCHAR2(40),
  xkzbh            NVARCHAR2(40),
  bgdd             NVARCHAR2(40),
  fddbr            NVARCHAR2(20),
  lxr              NVARCHAR2(20),
  lxdh             NVARCHAR2(20),
  jyfw             NVARCHAR2(200),
  jydy             NVARCHAR2(200),
  yxlx             VARCHAR2(10),
  bz               NVARCHAR2(200),
  sqr              VARCHAR2(40),
  sqyj             NVARCHAR2(200),
  sqrq             TIMESTAMP(6),
  clscjbr          VARCHAR2(40),
  clscrq           TIMESTAMP(6),
  clscyj           NVARCHAR2(200),
  hcjbr            VARCHAR2(40),
  hcjbrq           TIMESTAMP(6),
  hcyj             NVARCHAR2(200),
  fhjbr            VARCHAR2(40),
  fhyj             NVARCHAR2(200),
  fhrq             TIMESTAMP(6),
  spyj             NVARCHAR2(200),
  spjbr            VARCHAR2(40),
  sprq             TIMESTAMP(6),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40),
  yxrq             VARCHAR2(10),
  szgk           VARCHAR2(40),
  szgq           VARCHAR2(40),
  ssgkglbm         VARCHAR2(40)
)TABLESPACE "GK_OPERATION"
;
comment on table GK_OPERATION_JSJY_XKZYXXX
  is '许可证延续';
comment on column GK_OPERATION_JSJY_XKZYXXX.id
  is '主键';
comment on column GK_OPERATION_JSJY_XKZYXXX.jyrid
  is '经营人';
comment on column GK_OPERATION_JSJY_XKZYXXX.jyrmc
  is '经营名称';
comment on column GK_OPERATION_JSJY_XKZYXXX.xkzbh
  is '许可证编号';
comment on column GK_OPERATION_JSJY_XKZYXXX.bgdd
  is '办公地点';
comment on column GK_OPERATION_JSJY_XKZYXXX.fddbr
  is '法定代表人';
comment on column GK_OPERATION_JSJY_XKZYXXX.lxr
  is '联系人';
comment on column GK_OPERATION_JSJY_XKZYXXX.lxdh
  is '联系电话';
comment on column GK_OPERATION_JSJY_XKZYXXX.jyfw
  is '经营范围';
comment on column GK_OPERATION_JSJY_XKZYXXX.jydy
  is '经营地域';
comment on column GK_OPERATION_JSJY_XKZYXXX.yxlx
  is '延续类型';
comment on column GK_OPERATION_JSJY_XKZYXXX.bz
  is '备注';
comment on column GK_OPERATION_JSJY_XKZYXXX.sqr
  is '申请人';
comment on column GK_OPERATION_JSJY_XKZYXXX.sqyj
  is '申请意见';
comment on column GK_OPERATION_JSJY_XKZYXXX.sqrq
  is '申请日期';
comment on column GK_OPERATION_JSJY_XKZYXXX.clscjbr
  is '材料审核经办人';
comment on column GK_OPERATION_JSJY_XKZYXXX.clscrq
  is '材料审核经办日期';
comment on column GK_OPERATION_JSJY_XKZYXXX.clscyj
  is '材料审批意见';
comment on column GK_OPERATION_JSJY_XKZYXXX.hcjbr
  is '核查经办人';
comment on column GK_OPERATION_JSJY_XKZYXXX.hcjbrq
  is '核查经办日期';
comment on column GK_OPERATION_JSJY_XKZYXXX.hcyj
  is '核查意见';
comment on column GK_OPERATION_JSJY_XKZYXXX.fhjbr
  is '复核经办人';
comment on column GK_OPERATION_JSJY_XKZYXXX.fhyj
  is '复核意见';
comment on column GK_OPERATION_JSJY_XKZYXXX.fhrq
  is '复核日期';
comment on column GK_OPERATION_JSJY_XKZYXXX.spyj
  is '审批意见';
comment on column GK_OPERATION_JSJY_XKZYXXX.spjbr
  is '审批经办人';
comment on column GK_OPERATION_JSJY_XKZYXXX.sprq
  is '审批日期';
comment on column GK_OPERATION_JSJY_XKZYXXX.yxrq
  is '有效日期';
  
        alter table GK_OPERATION_JSJY_XKZYXXX
  add primary key (ID);
--许可证注销附件表
create table GK_OPERATION_JSJY_XKZZXFJ
(
  id               VARCHAR2(40) not null,
  sqid             VARCHAR2(40),
  fjid             VARCHAR2(40),
  fjmc             NVARCHAR2(100),
  sfbx             INTEGER,
  sortno           INTEGER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40)
)TABLESPACE "GK_OPERATION"
;
comment on table GK_OPERATION_JSJY_XKZZXFJ
  is '许可证注销附件表';
comment on column GK_OPERATION_JSJY_XKZZXFJ.id
  is '主键';
comment on column GK_OPERATION_JSJY_XKZZXFJ.sqid
  is '申请ID';
comment on column GK_OPERATION_JSJY_XKZZXFJ.fjid
  is '附件ID';
comment on column GK_OPERATION_JSJY_XKZZXFJ.fjmc
  is '附件名称';
comment on column GK_OPERATION_JSJY_XKZZXFJ.sfbx
  is '是否必须';
comment on column GK_OPERATION_JSJY_XKZZXFJ.sortno
  is '排序号';
comment on column GK_OPERATION_JSJY_XKZZXFJ.create_user
  is '创建人';
comment on column GK_OPERATION_JSJY_XKZZXFJ.update_user
  is '修改人';
comment on column GK_OPERATION_JSJY_XKZZXFJ.create_date_time
  is '创建时间';
comment on column GK_OPERATION_JSJY_XKZZXFJ.update_date_time
  is '修改时间';
comment on column GK_OPERATION_JSJY_XKZZXFJ.szd
  is '所在地';
          alter table GK_OPERATION_JSJY_XKZZXFJ
  add primary key (ID);
--许可证注销
create table GK_OPERATION_JSJY_XKZZXXX
(
  id               VARCHAR2(40),
  jyrid            VARCHAR2(40),
  jyrmc            NVARCHAR2(40),
  xkzbh            NVARCHAR2(40),
  bgdd             NVARCHAR2(40),
  fddbr            NVARCHAR2(40),
  lxr              NVARCHAR2(40),
  lxdh             NVARCHAR2(40),
  jyfw             NVARCHAR2(100),
  jydy             NVARCHAR2(100),
  zxlx             NVARCHAR2(10),
  zxyy             NVARCHAR2(200),
  sqr              VARCHAR2(40),
  sqyj             NVARCHAR2(200),
  sqrq             TIMESTAMP(6),
  clscjbr          VARCHAR2(40),
  clscrq           TIMESTAMP(6),
  clscyj           NVARCHAR2(200),
  hcjbr            VARCHAR2(40),
  hcjbrq           TIMESTAMP(6),
  hcyj             NVARCHAR2(200),
  spyj             NVARCHAR2(200),
  spjbr            VARCHAR2(40),
  sprq             TIMESTAMP(6),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40),
  fzrq             NVARCHAR2(10),
  yxrq             NVARCHAR2(10),
  fhyj             NVARCHAR2(200),
  fhrq             TIMESTAMP(6),
  fhjbr            VARCHAR2(40),
  szgk           VARCHAR2(40),
  szgq           VARCHAR2(40),
  ssgkglbm         VARCHAR2(40)
)TABLESPACE "GK_OPERATION"
;
comment on table GK_OPERATION_JSJY_XKZZXXX
  is '许可证注销';
comment on column GK_OPERATION_JSJY_XKZZXXX.id
  is '主键';
comment on column GK_OPERATION_JSJY_XKZZXXX.jyrid
  is '经营人ID';
comment on column GK_OPERATION_JSJY_XKZZXXX.jyrmc
  is '经营人名称';
comment on column GK_OPERATION_JSJY_XKZZXXX.xkzbh
  is '许可证编号';
comment on column GK_OPERATION_JSJY_XKZZXXX.bgdd
  is '办公地址';
comment on column GK_OPERATION_JSJY_XKZZXXX.fddbr
  is '法定代表人';
comment on column GK_OPERATION_JSJY_XKZZXXX.lxr
  is '联系人';
comment on column GK_OPERATION_JSJY_XKZZXXX.lxdh
  is '联系电话';
comment on column GK_OPERATION_JSJY_XKZZXXX.jyfw
  is '经营范围';
comment on column GK_OPERATION_JSJY_XKZZXXX.jydy
  is '经营地域';
comment on column GK_OPERATION_JSJY_XKZZXXX.zxlx
  is '注销类型';
comment on column GK_OPERATION_JSJY_XKZZXXX.zxyy
  is '注销原因';
comment on column GK_OPERATION_JSJY_XKZZXXX.sqr
  is '申请人';
comment on column GK_OPERATION_JSJY_XKZZXXX.sqyj
  is '申请意见';
comment on column GK_OPERATION_JSJY_XKZZXXX.sqrq
  is '申请日期';
comment on column GK_OPERATION_JSJY_XKZZXXX.clscjbr
  is '材料审核经办人';
comment on column GK_OPERATION_JSJY_XKZZXXX.clscrq
  is '材料审核经办日期';
comment on column GK_OPERATION_JSJY_XKZZXXX.clscyj
  is '材料审核意见';
comment on column GK_OPERATION_JSJY_XKZZXXX.hcjbr
  is '核查经办人';
comment on column GK_OPERATION_JSJY_XKZZXXX.hcjbrq
  is '核查经办日期';
comment on column GK_OPERATION_JSJY_XKZZXXX.hcyj
  is '核查意见';
comment on column GK_OPERATION_JSJY_XKZZXXX.spyj
  is '审批意见';
comment on column GK_OPERATION_JSJY_XKZZXXX.spjbr
  is '审批经办人';
comment on column GK_OPERATION_JSJY_XKZZXXX.sprq
  is '审批日期';
comment on column GK_OPERATION_JSJY_XKZZXXX.fzrq
  is '发证日期';
comment on column GK_OPERATION_JSJY_XKZZXXX.yxrq
  is '有效日期';
            alter table GK_OPERATION_JSJY_XKZZXXX
  add primary key (ID);
 --许可证延续决定书 
  create table GK_OPERATION_JSJY_XKZYXJDS
(
  id               VARCHAR2(40),
  yxid             VARCHAR2(40),
  jyrid            VARCHAR2(40),
  jyrmc            NVARCHAR2(40),
  ah               NVARCHAR2(20),
  xkzbh            NVARCHAR2(40),
  sqrq             NVARCHAR2(20),
  yxrq             NVARCHAR2(20),
  rq               NVARCHAR2(20),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40)
)TABLESPACE "GK_OPERATION"
;
comment on table GK_OPERATION_JSJY_XKZYXJDS
  is '许可证延续决定书';
comment on column GK_OPERATION_JSJY_XKZYXJDS.id
  is '主键';
comment on column GK_OPERATION_JSJY_XKZYXJDS.yxid
  is '延续ID';
comment on column GK_OPERATION_JSJY_XKZYXJDS.jyrid
  is '经营人ID';
comment on column GK_OPERATION_JSJY_XKZYXJDS.jyrmc
  is '经营人名称';
comment on column GK_OPERATION_JSJY_XKZYXJDS.ah
  is '案号';
comment on column GK_OPERATION_JSJY_XKZYXJDS.xkzbh
  is '许可证编号';
comment on column GK_OPERATION_JSJY_XKZYXJDS.sqrq
  is '申请日期';
comment on column GK_OPERATION_JSJY_XKZYXJDS.yxrq
  is '延续日期';
comment on column GK_OPERATION_JSJY_XKZYXJDS.rq
  is '日期';
  alter table GK_OPERATION_JSJY_XKZYXJDS
  add primary key (ID);
  --许可证注销决定书
create table GK_OPERATION_JSJY_XKZZXJDS
(
  id               VARCHAR2(40),
  zxid             VARCHAR2(40),
  jyrid            VARCHAR2(40),
  jyrmc            NVARCHAR2(40),
  ah               NVARCHAR2(20),
  xkzbh            NVARCHAR2(40),
  sqrq             NVARCHAR2(20),
  rq               nvarchar2(20),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  szd              VARCHAR2(40)
)TABLESPACE "GK_OPERATION"
;
comment on table GK_OPERATION_JSJY_XKZZXJDS
  is '许可证延续决定书';
comment on column GK_OPERATION_JSJY_XKZZXJDS.id
  is '主键';
comment on column GK_OPERATION_JSJY_XKZZXJDS.zxid
  is '注销ID';
comment on column GK_OPERATION_JSJY_XKZZXJDS.jyrid
  is '经营人ID';
comment on column GK_OPERATION_JSJY_XKZZXJDS.jyrmc
  is '经营人名称';
comment on column GK_OPERATION_JSJY_XKZZXJDS.ah
  is '案号';
comment on column GK_OPERATION_JSJY_XKZZXJDS.xkzbh
  is '许可证编号';
comment on column GK_OPERATION_JSJY_XKZZXJDS.sqrq
  is '申请日期';
comment on column GK_OPERATION_JSJY_XKZZXJDS.rq
  is '日期';
    alter table GK_OPERATION_JSJY_XKZZXJDS
  add primary key (ID);
  --海事进出港作业信息
  create table GK_SHARE_JSJY_HS_SHIP_CARRIAGE
(
  id               VARCHAR2(40),
  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            VARCHAR2(20),
  sbdlb            CHAR(2),
  cbbh             CHAR(20),
  zwcm             NVARCHAR2(40),
  ywcm             VARCHAR2(40),
  gjdm             CHAR(3),
  cjg              VARCHAR2(40),
  hcnhcbz          CHAR(1),
  cbzldm           CHAR(4),
  jcrq             TIMESTAMP(6),
  zd               NUMBER,
  jd               NUMBER,
  zzzd             NUMBER,
  xw               NUMBER,
  cbcd             NUMBER,
  zjgl             NUMBER,
  cbsyr            NVARCHAR2(60),
  cbjyr            NVARCHAR2(60),
  hc               VARCHAR2(20),
  nwmbz            CHAR(1),
  jcgbz            CHAR(1),
  gkzwmc           NVARCHAR2(40),
  gkywmc           VARCHAR2(80),
  zygkmc           NVARCHAR2(40),
  bwdm             CHAR(7),
  dgsj             TIMESTAMP(6),
  kszysj           TIMESTAMP(6),
  jszysj           TIMESTAMP(6),
  lxrxm            NVARCHAR2(30),
  lxfs             NVARCHAR2(80),
  bz               NVARCHAR2(200),
  dqsbbz           CHAR(1),
  yxq              TIMESTAMP(6),
  hxcs             NUMBER,
  eccbz            CHAR(1),
  tshwbz           CHAR(1),
  szd              NVARCHAR2(40)
)TABLESPACE "GK_SHARE"
;
comment on table GK_SHARE_JSJY_HS_SHIP_CARRIAGE
  is '船舶载运危险货物申报单信息表';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.id
  is '唯一标识';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.record_status
  is '记录状态-有效1  记录状态-删除9';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.sbdbh
  is '申报单号';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.sbdlb
  is '申报单类别';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.cbbh
  is '船舶编号';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.zwcm
  is '中文船名';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.ywcm
  is '英文船名';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.gjdm
  is '国籍代码';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.cjg
  is '船籍港';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.hcnhcbz
  is '海船内河船标志';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.cbzldm
  is '船舶种类代码';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.jcrq
  is '建成日期';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.zd
  is '总吨';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.jd
  is '净吨';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.zzzd
  is '总载重吨';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.xw
  is '箱位';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.cbcd
  is '船舶长度（米）';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.zjgl
  is '主机功率（kw）';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.cbsyr
  is '船舶所有人';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.cbjyr
  is '船舶经营人';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.hc
  is '航次';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.nwmbz
  is '内外贸标志';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.jcgbz
  is '进出港标志';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.gkzwmc
  is '港口中文名称';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.gkywmc
  is '港口英文名称';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.zygkmc
  is '作业港口名称';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.bwdm
  is '泊位代码';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.dgsj
  is '抵/离港时间';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.kszysj
  is '开始作业时间';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.jszysj
  is '结束作业时间';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.lxrxm
  is '紧急联系人姓名';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.lxfs
  is '联系方式';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.bz
  is '备注';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.dqsbbz
  is '定期申报标志';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.yxq
  is '有效期';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.hxcs
  is '航行次数';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.eccbz
  is '二程船标志';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.tshwbz
  is '特殊货物标志';
comment on column GK_SHARE_JSJY_HS_SHIP_CARRIAGE.szd
  is '所在地';
      alter table GK_SHARE_JSJY_HS_SHIP_CARRIAGE
  add primary key (ID);
  
  
  --船舶AIS
  create table GK_OPERATION_JSJY_HS_INFO
(
  mmsi    VARCHAR2(20) not null,
  time    VARCHAR2(20) not null,
  name    NVARCHAR2(100),
  bw_name NVARCHAR2(100),
  status  VARCHAR2(40),
  gq_name VARCHAR2(40),
  id      VARCHAR2(40) not null
)TABLESPACE "GK_OPERATION"
;
comment on table GK_OPERATION_JSJY_HS_INFO
  is '船舶AIS实时信息表';
comment on column GK_OPERATION_JSJY_HS_INFO.mmsi
  is '船舶MMSI';
comment on column GK_OPERATION_JSJY_HS_INFO.time
  is '信号时间';
comment on column GK_OPERATION_JSJY_HS_INFO.name
  is '英文船名';
comment on column GK_OPERATION_JSJY_HS_INFO.bw_name
  is '泊位名称';
comment on column GK_OPERATION_JSJY_HS_INFO.status
  is '靠泊状态';
comment on column GK_OPERATION_JSJY_HS_INFO.gq_name
  is '港区名称';
comment on column GK_OPERATION_JSJY_HS_INFO.id
  is '主键';
  
  --海事进出港
  create table GK_BASIC_GKHS_CBZYWXHWSBD
(
  sbdbh            VARCHAR2(18) not null,
  sbdlb            VARCHAR2(2),
  cbbh             NVARCHAR2(20),
  zwcm             NVARCHAR2(20),
  ywcm             NVARCHAR2(40),
  hcnhcbz          VARCHAR2(1),
  hc               NVARCHAR2(20),
  zygkmc           NVARCHAR2(40),
  bwdm             NVARCHAR2(7),
  kszysj           TIMESTAMP(0),
  jszysj           TIMESTAMP(0),
  nwmbz            VARCHAR2(1),
  sbbz             NVARCHAR2(8),
  sbdwbh           NVARCHAR2(15),
  sbdwmc           NVARCHAR2(100),
  lzbz             VARCHAR2(1),
  add_date         TIMESTAMP(0),
  sync_date        TIMESTAMP(0),
  sync_sign        VARCHAR2(1),
  sync_desc        NUMBER,
  byzd1            VARCHAR2(100),
  byzd2            VARCHAR2(100),
  byzd3            VARCHAR2(100),
  byzd4            VARCHAR2(100),
  sbrq             TIMESTAMP(0),
  shrq             TIMESTAMP(0),
  id               NVARCHAR2(40),
  szd              NVARCHAR2(40),
  create_user      NVARCHAR2(40),
  update_user      NVARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_GKHS_CBZYWXHWSBD
  is '船舶载运申报单';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.sbdbh
  is '申报单编号， 主键';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.sbdlb
  is '申报单类别 ，CB：包装货物  CS：固体散装  CY：散装液体';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.cbbh
  is '船舶编号，国轮：A+初次登记号外轮：B+IMO编号 ，港澳：C+牌簿号';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.zwcm
  is '中文船名';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.ywcm
  is '英文船名';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.hcnhcbz
  is '海船内河船标志 0：内河船1：海船';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.hc
  is '航次';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.zygkmc
  is '作业港口名称';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.bwdm
  is '泊位代码';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.kszysj
  is '开始作业时间';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.jszysj
  is '结束作业时间';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.nwmbz
  is '内外贸标志 0：内贸1：外贸';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.sbbz
  is '申报标志 0：委托申报1：船长申报船长申报时：轮船长、船长证书编号必录 委托申报时：申报单位编号、申报员编号、申报员证书编号必录';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.sbdwbh
  is '申报单位编号';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.sbdwmc
  is '申报单位名称';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.lzbz
  is '受理审核结果';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.add_date
  is '添加日期';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.sync_date
  is '同步日期';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.sync_sign
  is '同步状态';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.sync_desc
  is '同步地市';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.byzd1
  is '备用字段1';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.byzd2
  is '备用字段2';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.byzd3
  is '备用字段3';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.byzd4
  is '备用字段4';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.sbrq
  is '申报时期';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.shrq
  is '审核时期';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.id
  is '唯一标识';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.szd
  is '所在地';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.create_user
  is '创建人';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.update_user
  is '修改人';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.create_date_time
  is '创建时间';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.update_date_time
  is '修改时间';
comment on column GK_BASIC_GKHS_CBZYWXHWSBD.record_status
  is '数据状态';
  --许可证变更
  create table GK_OPERATION_JSJY_XKZBGFJ
(
  id               VARCHAR2(40) not null,
  bgid             VARCHAR2(40),
  fjid             VARCHAR2(40),
  fjmc             NVARCHAR2(100),
  sfbx             INTEGER,
  sortno           INTEGER,
  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
)
;
comment on table GK_OPERATION_JSJY_XKZBGFJ
  is '许可证变更附件表';
comment on column GK_OPERATION_JSJY_XKZBGFJ.id
  is '主键';
comment on column GK_OPERATION_JSJY_XKZBGFJ.fjid
  is '附件ID';
comment on column GK_OPERATION_JSJY_XKZBGFJ.fjmc
  is '附件名称';
comment on column GK_OPERATION_JSJY_XKZBGFJ.sfbx
  is '是否必须';
comment on column GK_OPERATION_JSJY_XKZBGFJ.sortno
  is '排序号';
comment on column GK_OPERATION_JSJY_XKZBGFJ.create_user
  is '创建人';
comment on column GK_OPERATION_JSJY_XKZBGFJ.update_user
  is '修改人';
comment on column GK_OPERATION_JSJY_XKZBGFJ.create_date_time
  is '创建时间';
comment on column GK_OPERATION_JSJY_XKZBGFJ.update_date_time
  is '修改时间';
comment on column GK_OPERATION_JSJY_XKZBGFJ.record_status
  is '状态';
comment on column GK_OPERATION_JSJY_XKZBGFJ.szd
  is '所在地';
comment on column GK_OPERATION_JSJY_XKZBGFJ.sftb
  is '是否同步';
comment on column GK_OPERATION_JSJY_XKZBGFJ.tbzt
  is '同步状态';
alter table GK_OPERATION_JSJY_XKZBGFJ
  add primary key (ID);
  --许可证变更决定书
  create table GK_OPERATION_JSJY_XKZBGJDS
(
  id               VARCHAR2(40) not null,
  bgid             VARCHAR2(40),
  jyrid            VARCHAR2(40),
  jyrmc            NVARCHAR2(40),
  ah               NVARCHAR2(40),
  xkzrn            NVARCHAR2(1000),
  dw               NVARCHAR2(20),
  rq               NVARCHAR2(20),
  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) default 'Y' not null,
  tbzt             CHAR(1) default 'N' not null
)
;
comment on table GK_OPERATION_JSJY_XKZBGJDS
  is '许可证变更决定书';
comment on column GK_OPERATION_JSJY_XKZBGJDS.id
  is '主键';
comment on column GK_OPERATION_JSJY_XKZBGJDS.bgid
  is '变更ID';
comment on column GK_OPERATION_JSJY_XKZBGJDS.jyrid
  is '经营人id';
comment on column GK_OPERATION_JSJY_XKZBGJDS.jyrmc
  is '经营人名称';
comment on column GK_OPERATION_JSJY_XKZBGJDS.ah
  is '案号';
comment on column GK_OPERATION_JSJY_XKZBGJDS.xkzrn
  is '许可内容';
comment on column GK_OPERATION_JSJY_XKZBGJDS.dw
  is '单位';
comment on column GK_OPERATION_JSJY_XKZBGJDS.rq
  is '日期';
alter table GK_OPERATION_JSJY_XKZBGJDS
  add primary key (ID);
  --许可证变更信息
  create table GK_OPERATION_JSJY_XKZBGXX
(
  id               VARCHAR2(40),
  jyrid            VARCHAR2(40),
  jyrmc            NVARCHAR2(40),
  xkzbh            NVARCHAR2(40),
  lxr              NVARCHAR2(40),
  dh               NVARCHAR2(40),
  cz               NVARCHAR2(40),
  yqymc            NVARCHAR2(100),
  xqymc            NVARCHAR2(100),
  ybgdz            NVARCHAR2(100),
  xbgdz            NVARCHAR2(100),
  yfddbr           NVARCHAR2(100),
  xfddbr           NVARCHAR2(100),
  yjydy            NVARCHAR2(1000),
  xjydy            NVARCHAR2(1000),
  ysjjyfw          NVARCHAR2(1000),
  xsjjyfw          NVARCHAR2(1000),
  yqt              NVARCHAR2(1000),
  xqt              NVARCHAR2(1000),
  fj               NVARCHAR2(100),
  sqr              VARCHAR2(40),
  sqrq             TIMESTAMP(6),
  clscyj           NVARCHAR2(200),
  clscjbr          VARCHAR2(40),
  clscrq           TIMESTAMP(6),
  hcyj             NVARCHAR2(200),
  hcjbr            VARCHAR2(40),
  hcrq             TIMESTAMP(6),
  fhyj             NVARCHAR2(200),
  fhjbr            VARCHAR2(40),
  fhrq             TIMESTAMP(6),
  spyj             NVARCHAR2(200),
  spry             VARCHAR2(40),
  sprq             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),
  ssgkglbm         VARCHAR2(40),
  sqyj             NVARCHAR2(200),
  tbzt             VARCHAR2(40),
  sftb             VARCHAR2(40)
)
;
comment on table GK_OPERATION_JSJY_XKZBGXX
  is '许可证变更信息';
comment on column GK_OPERATION_JSJY_XKZBGXX.id
  is '主键';
comment on column GK_OPERATION_JSJY_XKZBGXX.jyrid
  is '经营人ID';
comment on column GK_OPERATION_JSJY_XKZBGXX.jyrmc
  is '经营人';
comment on column GK_OPERATION_JSJY_XKZBGXX.xkzbh
  is '许可证编号';
comment on column GK_OPERATION_JSJY_XKZBGXX.lxr
  is '联系人';
comment on column GK_OPERATION_JSJY_XKZBGXX.dh
  is '电话';
comment on column GK_OPERATION_JSJY_XKZBGXX.cz
  is '传真';
comment on column GK_OPERATION_JSJY_XKZBGXX.yqymc
  is '原企业名称';
comment on column GK_OPERATION_JSJY_XKZBGXX.xqymc
  is '现企业名称';
comment on column GK_OPERATION_JSJY_XKZBGXX.ybgdz
  is '原办公地址';
comment on column GK_OPERATION_JSJY_XKZBGXX.xbgdz
  is '现办公地址';
comment on column GK_OPERATION_JSJY_XKZBGXX.yfddbr
  is '原法定代表人';
comment on column GK_OPERATION_JSJY_XKZBGXX.xfddbr
  is '现法定代表人';
comment on column GK_OPERATION_JSJY_XKZBGXX.yjydy
  is '原经营地域';
comment on column GK_OPERATION_JSJY_XKZBGXX.xjydy
  is '现经营地域';
comment on column GK_OPERATION_JSJY_XKZBGXX.ysjjyfw
  is '原缩减经营范围';
comment on column GK_OPERATION_JSJY_XKZBGXX.xsjjyfw
  is '现缩减经营范围';
comment on column GK_OPERATION_JSJY_XKZBGXX.yqt
  is '原其他';
comment on column GK_OPERATION_JSJY_XKZBGXX.xqt
  is '现其他';
comment on column GK_OPERATION_JSJY_XKZBGXX.fj
  is '附件';
  --许可证关联表
  create table GK_OPERATION_JSJY_XKZGLB
(
  id               VARCHAR2(40),
  xkzid            VARCHAR2(40),
  xkzbh            NVARCHAR2(40),
  jyrid            VARCHAR2(40),
  type             CHAR(1),
  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) default 'Y',
  tbzt             CHAR(1) default 'N',
  ywid             VARCHAR2(40),
  czid             VARCHAR2(40)
)
;
comment on table GK_OPERATION_JSJY_XKZGLB
  is '许可证关联表';
comment on column GK_OPERATION_JSJY_XKZGLB.id
  is '主键';
comment on column GK_OPERATION_JSJY_XKZGLB.xkzid
  is '许可证ID';
comment on column GK_OPERATION_JSJY_XKZGLB.xkzbh
  is '许可证编号';
comment on column GK_OPERATION_JSJY_XKZGLB.jyrid
  is '经营人ID';
comment on column GK_OPERATION_JSJY_XKZGLB.type
  is '类型';
comment on column GK_OPERATION_JSJY_XKZGLB.ywid
  is '业务ID';
comment on column GK_OPERATION_JSJY_XKZGLB.czid
  is '操作id';