jsgkj/gkjsjy/trunk/WebContent/static/sql/oracle/table/2.1.GkjcTableCreate.sql

--表如下：
--GK_BASIC_JSJY_DWXX_XZGLBMXX
--GK_BASIC_JSJY_DWXX_XZGLRYXX
--GK_BASIC_JSJY_GK_GK
--GK_BASIC_JSJY_GK_GQ
--GK_BASIC_JSJY_GK_ZYQ
--GK_BASIC_JSJY_GK_MD
--GK_BASIC_JSJY_GK_AX
--GK_BASIC_JSJY_GK_FBD
--GK_BASIC_JSJY_GK_HDXX
--GK_SHARE_DTYW_CBJBXX
--共10张表

 --行政管理部门
create table GK_BASIC_JSJY_DWXX_XZGLBMXX
(
  id               VARCHAR2(40) not null,
  gkglbmqc         NVARCHAR2(100),
  bmlx             VARCHAR2(40),
  rybz             NUMBER,
  lxr              NVARCHAR2(20),
  lxdh             VARCHAR2(40),
  cz               NVARCHAR2(40),
  yb               VARCHAR2(20),
  bz               NVARCHAR2(200),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  record_status    NUMBER,
  update_date_time TIMESTAMP(6),
  szd              VARCHAR2(40),
  pid              VARCHAR2(40),
  sortno           NUMBER
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_DWXX_XZGLBMXX
  is '行政管理部门信息管理';
comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.id
  is '唯一标识';
comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.gkglbmqc
  is '港口管理部门全称';
comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.bmlx
  is '部门类型';
comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.rybz
  is '人员编制';
comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.lxr
  is '联系人';
comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.lxdh
  is '联系电话';
comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.cz
  is '传真';
comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.yb
  is '邮编';
comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.bz
  is '备注';
comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.create_user
  is '创建人';
comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.create_date_time
  is '创建日期';
comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.update_user
  is '修改人';
comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.record_status
  is '删除状态';
comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.update_date_time
  is '修改日期';
comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.szd
  is '所在地';
comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.pid
  is '上级部门';
  comment on column GK_BASIC_JSJY_DWXX_XZGLBMXX.sortno
  is '排序';
alter table GK_BASIC_JSJY_DWXX_XZGLBMXX
  add primary key (ID);

 --行政管理人员
create table GK_BASIC_JSJY_DWXX_XZGLRYXX
(
  id               VARCHAR2(40) not null,
  xm               NVARCHAR2(40),
  xb               VARCHAR2(40),
  ssbm             VARCHAR2(40),
  gw               NVARCHAR2(20),
  lxfs             NVARCHAR2(40),
  szd              VARCHAR2(40),
  create_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_user      VARCHAR2(40),
  record_status    NUMBER,
  update_date_time TIMESTAMP(6),
  sortno           NUMBER,
  zc               NVARCHAR2(40),
  txdz             NVARCHAR2(40),
  yzbm             NVARCHAR2(40),
  dzyx             NVARCHAR2(40),
  cz               NVARCHAR2(40)
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_DWXX_XZGLRYXX
  is '行政管理人员信息';
comment on column GK_BASIC_JSJY_DWXX_XZGLRYXX.id
  is '唯一标识';
comment on column GK_BASIC_JSJY_DWXX_XZGLRYXX.xm
  is '姓名';
comment on column GK_BASIC_JSJY_DWXX_XZGLRYXX.xb
  is '性别';
comment on column GK_BASIC_JSJY_DWXX_XZGLRYXX.ssbm
  is '所属部门';
comment on column GK_BASIC_JSJY_DWXX_XZGLRYXX.gw
  is '岗位（职务）';
comment on column GK_BASIC_JSJY_DWXX_XZGLRYXX.lxfs
  is '联系方式';
comment on column GK_BASIC_JSJY_DWXX_XZGLRYXX.szd
  is '所在地';
comment on column GK_BASIC_JSJY_DWXX_XZGLRYXX.create_user
  is '创建人';
comment on column GK_BASIC_JSJY_DWXX_XZGLRYXX.create_date_time
  is '创建日期';
comment on column GK_BASIC_JSJY_DWXX_XZGLRYXX.update_user
  is '修改人';
comment on column GK_BASIC_JSJY_DWXX_XZGLRYXX.record_status
  is '删除状态';
comment on column GK_BASIC_JSJY_DWXX_XZGLRYXX.update_date_time
  is '修改日期';
comment on column GK_BASIC_JSJY_DWXX_XZGLRYXX.sortno
  is '排序号';
comment on column GK_BASIC_JSJY_DWXX_XZGLRYXX.zc
  is '职称';
comment on column GK_BASIC_JSJY_DWXX_XZGLRYXX.txdz
  is '通信地址';
comment on column GK_BASIC_JSJY_DWXX_XZGLRYXX.yzbm
  is '邮政编码';
comment on column GK_BASIC_JSJY_DWXX_XZGLRYXX.dzyx
  is '电子邮箱';
comment on column GK_BASIC_JSJY_DWXX_XZGLRYXX.cz
  is '传真';
alter table GK_BASIC_JSJY_DWXX_XZGLRYXX
  add primary key (ID);
--港口表
create table GK_BASIC_JSJY_GK_GK
(
  id               VARCHAR2(40) not null,
  szd              VARCHAR2(40),
  aqgk             NVARCHAR2(1500),
  syhg             NVARCHAR2(1000),
  whcg             NVARCHAR2(1000),
  whpz             NVARCHAR2(1000),
  zdwxy            NVARCHAR2(1000),
  pthwcg           NVARCHAR2(1000),
  pthwpz           NVARCHAR2(1000),
  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),
  gkmc             NVARCHAR2(100),
  gkdm             NVARCHAR2(40),
  ssgkglbm         VARCHAR2(40),
  gkszhq           NVARCHAR2(40),
  gkszgw           NVARCHAR2(40),
  hlmc             NVARCHAR2(40),
  hgmc             NVARCHAR2(40),
  gkmhwz           NVARCHAR2(400),
  ghsfpf           VARCHAR2(40),
  ghpfwh           NVARCHAR2(400),
  sfhb             VARCHAR2(40),
  bhbgkmc          NVARCHAR2(400),
  bz               NVARCHAR2(400),
  dtsj             NVARCHAR2(400),
  zyid             VARCHAR2(40),
  aqid             VARCHAR2(40),
  zraxcd           NUMBER(10,2)
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_GK_GK
  is '港口';
comment on column GK_BASIC_JSJY_GK_GK.id
  is '唯一标识';
comment on column GK_BASIC_JSJY_GK_GK.szd
  is '所在地';
comment on column GK_BASIC_JSJY_GK_GK.aqgk
  is '港口安全概况描述';
comment on column GK_BASIC_JSJY_GK_GK.syhg
  is '石油化工码头企业描述';
comment on column GK_BASIC_JSJY_GK_GK.whcg
  is '危险货物储罐描述';
comment on column GK_BASIC_JSJY_GK_GK.whpz
  is '危险货物品种描述';
comment on column GK_BASIC_JSJY_GK_GK.zdwxy
  is '重大危险源描述';
comment on column GK_BASIC_JSJY_GK_GK.pthwcg
  is '普通货物储罐描述';
comment on column GK_BASIC_JSJY_GK_GK.pthwpz
  is '普通货物品种描述';
comment on column GK_BASIC_JSJY_GK_GK.record_status
  is '记录状态-有效1  记录状态-删除9';
comment on column GK_BASIC_JSJY_GK_GK.gkmc
  is '港口名称';
comment on column GK_BASIC_JSJY_GK_GK.gkdm
  is '港口代码';
comment on column GK_BASIC_JSJY_GK_GK.ssgkglbm
  is '所属港口管理部门';
comment on column GK_BASIC_JSJY_GK_GK.gkszhq
  is '港口所在地海区';
comment on column GK_BASIC_JSJY_GK_GK.gkszgw
  is '所在海湾';
comment on column GK_BASIC_JSJY_GK_GK.hlmc
  is '河流名称';
comment on column GK_BASIC_JSJY_GK_GK.hgmc
  is '海关名称';
comment on column GK_BASIC_JSJY_GK_GK.gkmhwz
  is '港口门户网站';
comment on column GK_BASIC_JSJY_GK_GK.ghsfpf
  is '总体规划是否批复1为是2为否';
comment on column GK_BASIC_JSJY_GK_GK.ghpfwh
  is '总体规划批复问号';
comment on column GK_BASIC_JSJY_GK_GK.sfhb
  is '1996年后港口是否经过合并，1为是2为否';
comment on column GK_BASIC_JSJY_GK_GK.bhbgkmc
  is '被合并港口原名称';
comment on column GK_BASIC_JSJY_GK_GK.bz
  is '备注';
comment on column GK_BASIC_JSJY_GK_GK.dtsj
  is '地图相关';
comment on column GK_BASIC_JSJY_GK_GK.zyid
  is '资源系统对应主键';
comment on column GK_BASIC_JSJY_GK_GK.aqid
  is '安全主键';
comment on column GK_BASIC_JSJY_GK_GK.zraxcd
  is '自然岸线长度';
alter table GK_BASIC_JSJY_GK_GK
  add primary key (ID);
  
--港区表  
create table GK_BASIC_JSJY_GK_GQ
(
  id               VARCHAR2(40) not null,
  gqmc             NVARCHAR2(400),
  gqszsylx         VARCHAR2(40),
  gqmj             NUMBER,
  lymj             NUMBER,
  syfw             NUMBER,
  symj             NUMBER,
  gqghmj           NUMBER,
  ghlymj           NUMBER,
  fgyscydghmj      NUMBER,
  ghsymj           NUMBER,
  gqzraxcd         NUMBER,
  gymtaxcd         NUMBER,
  gqgkaxcd         NUMBER,
  gkssysyaxcd      NUMBER,
  gqdmbdzdz        NUMBER,
  bz               NVARCHAR2(400),
  create_date_time TIMESTAMP(8) default current_timestamp,
  update_date_time TIMESTAMP(8) default current_timestamp,
  record_status    NUMBER default 1 not null,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              VARCHAR2(40),
  szgk             VARCHAR2(40),
  ssgkglbm         VARCHAR2(40),
  gqdm             NVARCHAR2(40),
  gqnhhddm         NVARCHAR2(40),
  dlwzwd           NVARCHAR2(40),
  dlwzjd           NVARCHAR2(40),
  dtsj             NVARCHAR2(40),
  yjptid           VARCHAR2(20),
  gqms             NVARCHAR2(500),
  zyid             VARCHAR2(40),
  aqid             VARCHAR2(40)
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_GK_GQ
  is '港区';
comment on column GK_BASIC_JSJY_GK_GQ.id
  is '唯一标识';
comment on column GK_BASIC_JSJY_GK_GQ.gqmc
  is '港区名称';
comment on column GK_BASIC_JSJY_GK_GQ.gqszsylx
  is '港区所在水域类型';
comment on column GK_BASIC_JSJY_GK_GQ.gqmj
  is '港区面积(万平方米)';
comment on column GK_BASIC_JSJY_GK_GQ.lymj
  is '陆域面积(万平方米)';
comment on column GK_BASIC_JSJY_GK_GQ.syfw
  is '水域范围万平方米';
comment on column GK_BASIC_JSJY_GK_GQ.symj
  is '水域面积(万平方米)';
comment on column GK_BASIC_JSJY_GK_GQ.gqghmj
  is '港区规划面积(万平方米)';
comment on column GK_BASIC_JSJY_GK_GQ.ghlymj
  is '规划陆域面积(万平方米)';
comment on column GK_BASIC_JSJY_GK_GQ.fgyscydghmj
  is '非工业生产用地规划面积(万平方米)';
comment on column GK_BASIC_JSJY_GK_GQ.ghsymj
  is '规划水域面积(万平方米)';
comment on column GK_BASIC_JSJY_GK_GQ.gqzraxcd
  is '港区自然岸线长度(米)';
comment on column GK_BASIC_JSJY_GK_GQ.gymtaxcd
  is '公用码头岸线长度(米)';
comment on column GK_BASIC_JSJY_GK_GQ.gqgkaxcd
  is '港区港口岸线长度(米)';
comment on column GK_BASIC_JSJY_GK_GQ.gkssysyaxcd
  is '港口设施已使用岸线长度(米)';
comment on column GK_BASIC_JSJY_GK_GQ.gqdmbdzdz
  is '港区地面坡度最大值';
comment on column GK_BASIC_JSJY_GK_GQ.bz
  is '备注';
comment on column GK_BASIC_JSJY_GK_GQ.record_status
  is '记录状态-有效1  记录状态-删除9';
comment on column GK_BASIC_JSJY_GK_GQ.szd
  is '所在地';
comment on column GK_BASIC_JSJY_GK_GQ.szgk
  is '所在港口';
comment on column GK_BASIC_JSJY_GK_GQ.ssgkglbm
  is '所在港口管理部门';
comment on column GK_BASIC_JSJY_GK_GQ.gqdm
  is '港区代码';
comment on column GK_BASIC_JSJY_GK_GQ.gqnhhddm
  is '港区所在内河道编码';
comment on column GK_BASIC_JSJY_GK_GQ.dlwzwd
  is '港区地理位置纬度';
comment on column GK_BASIC_JSJY_GK_GQ.dlwzjd
  is '港区地理位置经度';
comment on column GK_BASIC_JSJY_GK_GQ.dtsj
  is 'gis';
comment on column GK_BASIC_JSJY_GK_GQ.gqms
  is '港区描述';
comment on column GK_BASIC_JSJY_GK_GQ.zyid
  is '资源主键';
comment on column GK_BASIC_JSJY_GK_GQ.aqid
  is '安全主键';
alter table GK_BASIC_JSJY_GK_GQ
  add primary key (ID);
--作业区表
  create table GK_BASIC_JSJY_GK_ZYQ
(
  id               VARCHAR2(40) not null,
  szgk             VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  update_user      VARCHAR2(40),
  create_user      VARCHAR2(40),
  szd              VARCHAR2(40),
  ssgkglbm         VARCHAR2(40),
  szgq             VARCHAR2(500),
  zyqmc            NVARCHAR2(40),
  zyqyt            NVARCHAR2(200),
  bz               NVARCHAR2(200),
  zyid             VARCHAR2(40)
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_GK_ZYQ
  is '作业区表';
comment on column GK_BASIC_JSJY_GK_ZYQ.szgk
  is '所在港口';
comment on column GK_BASIC_JSJY_GK_ZYQ.szd
  is '所在地';
comment on column GK_BASIC_JSJY_GK_ZYQ.ssgkglbm
  is '所属管理部门';
comment on column GK_BASIC_JSJY_GK_ZYQ.szgq
  is '所在港区';
comment on column GK_BASIC_JSJY_GK_ZYQ.zyqmc
  is '作业区名称';
comment on column GK_BASIC_JSJY_GK_ZYQ.zyqyt
  is '作业区用途';
comment on column GK_BASIC_JSJY_GK_ZYQ.bz
  is '备注';
comment on column GK_BASIC_JSJY_GK_ZYQ.zyid
  is '资源ID';
alter table GK_BASIC_JSJY_GK_ZYQ
  add primary key (ID);
--锚地表
create table GK_BASIC_JSJY_GK_MD
(
  id               VARCHAR2(40) not null,
  mdmc             NVARCHAR2(40),
  szgk             VARCHAR2(40),
  mdcd             NUMBER(8,2),
  mdkd             NUMBER(8,2),
  mdss             VARCHAR2(30),
  mdmj             NUMBER(8,2),
  mdwz             NVARCHAR2(200),
  xbnl             NVARCHAR2(200),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    INTEGER,
  update_user      VARCHAR2(40),
  create_user      VARCHAR2(40),
  szd              VARCHAR2(40),
  ssgkglbm         VARCHAR2(40),
  szgq             NVARCHAR2(500),
  mddz             NVARCHAR2(40),
  mwbj             NVARCHAR2(40),
  ftgs             NVARCHAR2(40),
  mbss             NVARCHAR2(40),
  bz               NVARCHAR2(500),
  zyid             VARCHAR2(40),
  zyyt             NVARCHAR2(100)
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_GK_MD
  is '锚地表';
comment on column GK_BASIC_JSJY_GK_MD.id
  is '唯一标识';
comment on column GK_BASIC_JSJY_GK_MD.mdmc
  is '锚地名称';
comment on column GK_BASIC_JSJY_GK_MD.szgk
  is '所在港口';
comment on column GK_BASIC_JSJY_GK_MD.mdcd
  is '锚地长度（米）';
comment on column GK_BASIC_JSJY_GK_MD.mdkd
  is '锚地宽度（米）';
comment on column GK_BASIC_JSJY_GK_MD.mdss
  is '锚地水深（米）';
comment on column GK_BASIC_JSJY_GK_MD.mdmj
  is '锚地面积（平方米）';
comment on column GK_BASIC_JSJY_GK_MD.mdwz
  is '锚地位置';
comment on column GK_BASIC_JSJY_GK_MD.xbnl
  is '系泊能力（吨级）';
comment on column GK_BASIC_JSJY_GK_MD.create_date_time
  is '创建时间';
comment on column GK_BASIC_JSJY_GK_MD.update_date_time
  is '修改时间';
comment on column GK_BASIC_JSJY_GK_MD.record_status
  is '数据状态';
comment on column GK_BASIC_JSJY_GK_MD.update_user
  is '创建人';
comment on column GK_BASIC_JSJY_GK_MD.create_user
  is '修改人';
comment on column GK_BASIC_JSJY_GK_MD.szd
  is '所在地';
comment on column GK_BASIC_JSJY_GK_MD.ssgkglbm
  is '所属港口管理部门';
comment on column GK_BASIC_JSJY_GK_MD.szgq
  is '所服务的港区，多个逗号隔开';
comment on column GK_BASIC_JSJY_GK_MD.mddz
  is '锚地底质';
comment on column GK_BASIC_JSJY_GK_MD.mwbj
  is '锚位半径（米）';
comment on column GK_BASIC_JSJY_GK_MD.ftgs
  is '浮筒个数（个）';
comment on column GK_BASIC_JSJY_GK_MD.mbss
  is '锚泊艘数(艘)';
comment on column GK_BASIC_JSJY_GK_MD.bz
  is '备注';
comment on column GK_BASIC_JSJY_GK_MD.zyid
  is '资源主键';
comment on column GK_BASIC_JSJY_GK_MD.zyyt
  is '主要用途';
alter table GK_BASIC_JSJY_GK_MD
  add primary key (ID);  
--岸线表
create table GK_BASIC_JSJY_GK_AX
(
  id               VARCHAR2(40) not null,
  axmc             NVARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  ssjyr            VARCHAR2(40),
  axlx             VARCHAR2(40),
  axgn             VARCHAR2(40),
  lyzt             VARCHAR2(40),
  jzrq             TIMESTAMP(6),
  nba              NVARCHAR2(100),
  axcd             NUMBER(8,2),
  qdzb             VARCHAR2(50),
  zdzb             VARCHAR2(50),
  axpb             NVARCHAR2(100),
  bz               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),
  ssgkglbm         VARCHAR2(40),
  waterarea        NUMBER,
  landarea         NUMBER,
  zyid             VARCHAR2(40),
  linelength       NUMBER
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_GK_AX
  is '岸线表';
comment on column GK_BASIC_JSJY_GK_AX.id
  is '唯一标识';
comment on column GK_BASIC_JSJY_GK_AX.axmc
  is '岸线名称';
comment on column GK_BASIC_JSJY_GK_AX.szgk
  is '所在港口';
comment on column GK_BASIC_JSJY_GK_AX.szgq
  is '所在港区';
comment on column GK_BASIC_JSJY_GK_AX.ssjyr
  is '所属经营人';
comment on column GK_BASIC_JSJY_GK_AX.axlx
  is '岸线类型';
comment on column GK_BASIC_JSJY_GK_AX.axgn
  is '岸线功能';
comment on column GK_BASIC_JSJY_GK_AX.lyzt
  is '利用状态';
comment on column GK_BASIC_JSJY_GK_AX.jzrq
  is '截止日期';
comment on column GK_BASIC_JSJY_GK_AX.nba
  is '南北岸';
comment on column GK_BASIC_JSJY_GK_AX.axcd
  is '岸线长度';
comment on column GK_BASIC_JSJY_GK_AX.qdzb
  is '起点坐标';
comment on column GK_BASIC_JSJY_GK_AX.zdzb
  is '终点坐标';
comment on column GK_BASIC_JSJY_GK_AX.axpb
  is '岸线批备';
comment on column GK_BASIC_JSJY_GK_AX.bz
  is '备注';
comment on column GK_BASIC_JSJY_GK_AX.create_user
  is '创建人';
comment on column GK_BASIC_JSJY_GK_AX.update_user
  is '修改人';
comment on column GK_BASIC_JSJY_GK_AX.create_date_time
  is '创建日期';
comment on column GK_BASIC_JSJY_GK_AX.update_date_time
  is '修改日期';
comment on column GK_BASIC_JSJY_GK_AX.record_status
  is '数据状态';
comment on column GK_BASIC_JSJY_GK_AX.szd
  is '所在地';
comment on column GK_BASIC_JSJY_GK_AX.ssgkglbm
  is '所属港口管理部门';
comment on column GK_BASIC_JSJY_GK_AX.waterarea
  is '使用陆域土地面积（平方米）';
comment on column GK_BASIC_JSJY_GK_AX.landarea
  is '使用水域面积（平方米）';
comment on column GK_BASIC_JSJY_GK_AX.zyid
  is '资源主键';
comment on column GK_BASIC_JSJY_GK_AX.linelength
  is '使用自然岸线长度（米）';
alter table GK_BASIC_JSJY_GK_AX
  add primary key (ID);  
--防波堤
create table GK_BASIC_JSJY_GK_FBD
(
  id               VARCHAR2(40) not null,
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  fbdlx            NVARCHAR2(40),
  ssjyr            VARCHAR2(40),
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    NUMBER,
  fbdmc            NVARCHAR2(100),
  szd              VARCHAR2(40),
  ssgkglbm         VARCHAR2(40)
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_GK_FBD
  is '防波堤表';
comment on column GK_BASIC_JSJY_GK_FBD.id
  is '唯一标识';
comment on column GK_BASIC_JSJY_GK_FBD.szgk
  is '所在港口';
comment on column GK_BASIC_JSJY_GK_FBD.szgq
  is '所在港区';
comment on column GK_BASIC_JSJY_GK_FBD.fbdlx
  is '防波堤类型';
comment on column GK_BASIC_JSJY_GK_FBD.ssjyr
  is '所属经营人';
comment on column GK_BASIC_JSJY_GK_FBD.create_user
  is '创建人';
comment on column GK_BASIC_JSJY_GK_FBD.update_user
  is '修改人';
comment on column GK_BASIC_JSJY_GK_FBD.create_date_time
  is '创建时间';
comment on column GK_BASIC_JSJY_GK_FBD.update_date_time
  is '修改时间';
comment on column GK_BASIC_JSJY_GK_FBD.record_status
  is '数据状态';
comment on column GK_BASIC_JSJY_GK_FBD.fbdmc
  is '防波堤名称';
comment on column GK_BASIC_JSJY_GK_FBD.szd
  is '所在地';
comment on column GK_BASIC_JSJY_GK_FBD.ssgkglbm
  is '所在管理部门';
alter table GK_BASIC_JSJY_GK_FBD
  add primary key (ID);  
--进港航道
create table GK_BASIC_JSJY_GK_HDXX
(
  id               VARCHAR2(40) not null,
  hdmc             NVARCHAR2(100),
  szgq             VARCHAR2(400),
  hdss             NUMBER,
  hdcd             NUMBER,
  create_user      NVARCHAR2(40),
  update_user      NVARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    NUMBER,
  szd              VARCHAR2(40),
  ssgkglbm         VARCHAR2(40),
  hdtgnl           NUMBER,
  hddm             NVARCHAR2(40),
  hdqdmc           NVARCHAR2(40),
  hdqdmm           NVARCHAR2(40),
  hdzdss           NUMBER,
  hdkd             NUMBER,
  hdyxkd           NUMBER,
  bz               NVARCHAR2(100),
  szgk             VARCHAR2(40)
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_GK_HDXX
  is '航道信息表';
comment on column GK_BASIC_JSJY_GK_HDXX.id
  is '唯一标识';
comment on column GK_BASIC_JSJY_GK_HDXX.hdmc
  is '航道名称';
comment on column GK_BASIC_JSJY_GK_HDXX.szgq
  is '服务港区，多个逗号隔开';
comment on column GK_BASIC_JSJY_GK_HDXX.hdss
  is '航道水深米';
comment on column GK_BASIC_JSJY_GK_HDXX.hdcd
  is '航道长度米';
comment on column GK_BASIC_JSJY_GK_HDXX.create_user
  is '创建人';
comment on column GK_BASIC_JSJY_GK_HDXX.update_user
  is '修改人';
comment on column GK_BASIC_JSJY_GK_HDXX.create_date_time
  is '创建时间';
comment on column GK_BASIC_JSJY_GK_HDXX.update_date_time
  is '修改时间';
comment on column GK_BASIC_JSJY_GK_HDXX.record_status
  is '数据状态';
comment on column GK_BASIC_JSJY_GK_HDXX.szd
  is '所在地';
comment on column GK_BASIC_JSJY_GK_HDXX.ssgkglbm
  is '所属管理部门';
comment on column GK_BASIC_JSJY_GK_HDXX.hdtgnl
  is '航道通过能力(万吨/年)';
comment on column GK_BASIC_JSJY_GK_HDXX.hddm
  is '航道代码';
comment on column GK_BASIC_JSJY_GK_HDXX.hdqdmc
  is '航道起点名称';
comment on column GK_BASIC_JSJY_GK_HDXX.hdqdmm
  is '航道讫点名称';
comment on column GK_BASIC_JSJY_GK_HDXX.hdzdss
  is '航道最大水深(米)';
comment on column GK_BASIC_JSJY_GK_HDXX.hdkd
  is '航道宽度(米)';
comment on column GK_BASIC_JSJY_GK_HDXX.hdyxkd
  is '航道有效宽度(米)';
comment on column GK_BASIC_JSJY_GK_HDXX.bz
  is '备注';
comment on column GK_BASIC_JSJY_GK_HDXX.szgk
  is '所在港口';
alter table GK_BASIC_JSJY_GK_HDXX
  add primary key (ID);
--船舶表
create table GK_SHARE_DTYW_CBJBXX
(
  cbbh             CHAR(20) not null,
  cbfl             CHAR(1),
  cbdjh            CHAR(14),
  zwcm             NVARCHAR2(20),
  ywcm             NVARCHAR2(40),
  ccdjh            CHAR(14),
  cjdjh            CHAR(12),
  cbhh             CHAR(10),
  imobh            CHAR(10),
  pbh              CHAR(20),
  gjdm             CHAR(3),
  hcnhcbz          CHAR(1),
  hx               CHAR(1),
  hqdm             CHAR(2),
  cjgdm            CHAR(6),
  cjg              NVARCHAR2(40),
  cbzldm           CHAR(4),
  ctcldm           CHAR(2),
  jcrq             DATE,
  zcc              NVARCHAR2(100),
  cbcd             NUMBER(8,2),
  cbxk             NUMBER(8,2),
  cbxs             NUMBER(8,2),
  zd               NUMBER,
  jd               NUMBER,
  zzzd             NUMBER,
  zjzldm           CHAR(2),
  zjsl             NUMBER,
  zjgl             NUMBER(16,2),
  tjqzldm          CHAR(2),
  tjqsl            NUMBER,
  xjmzcs           NUMBER(8,2),
  hdkfdj           CHAR(2),
  zxgx             NUMBER(8,3),
  xw               NUMBER,
  cw               NUMBER,
  kw               NUMBER,
  hs               NUMBER(5,2),
  cbsyr            NVARCHAR2(60),
  cbjyr            NVARCHAR2(60),
  sssjhsjg         CHAR(6),
  cjsdm            CHAR(6),
  zdaqpyrs         NUMBER,
  jssbzdrs         NUMBER,
  ickh             NVARCHAR2(12),
  txm              NVARCHAR2(12),
  cbbsh            CHAR(16),
  bz               NVARCHAR2(255),
  fkbz             CHAR(1),
  djbz             CHAR(1),
  lzbz             CHAR(5),
  jgdm             CHAR(6),
  czsj             DATE,
  czydm            CHAR(11),
  gxbz             CHAR(1),
  mrut             DATE,
  xxly             CHAR(7),
  mtime            TIMESTAMP(6),
  create_date_time TIMESTAMP(0) default current_timestamp,
  update_date_time TIMESTAMP(0) default current_timestamp,
  record_status    NUMBER default 1,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  id               VARCHAR2(40) default sys_guid() not null,
  szd              VARCHAR2(40),
  hs_mmsi          NVARCHAR2(20),
  hs_name          NVARCHAR2(100)
)TABLESPACE "GK_BASIC";
comment on table GK_SHARE_DTYW_CBJBXX
  is '船舶基本信息';
comment on column GK_SHARE_DTYW_CBJBXX.cbbh
  is '船舶编号';
comment on column GK_SHARE_DTYW_CBJBXX.cbfl
  is '船舶分类';
comment on column GK_SHARE_DTYW_CBJBXX.cbdjh
  is '船舶登记号';
comment on column GK_SHARE_DTYW_CBJBXX.zwcm
  is '中文船名';
comment on column GK_SHARE_DTYW_CBJBXX.ywcm
  is '英文船名';
comment on column GK_SHARE_DTYW_CBJBXX.ccdjh
  is '初次登记号';
comment on column GK_SHARE_DTYW_CBJBXX.cjdjh
  is '船检登记号';
comment on column GK_SHARE_DTYW_CBJBXX.cbhh
  is '船舶呼号';
comment on column GK_SHARE_DTYW_CBJBXX.imobh
  is 'IMO编号';
comment on column GK_SHARE_DTYW_CBJBXX.pbh
  is '牌簿号';
comment on column GK_SHARE_DTYW_CBJBXX.gjdm
  is '国籍代码';
comment on column GK_SHARE_DTYW_CBJBXX.hcnhcbz
  is '海船内河船标志';
comment on column GK_SHARE_DTYW_CBJBXX.hx
  is '航线';
comment on column GK_SHARE_DTYW_CBJBXX.hqdm
  is '航区代码';
comment on column GK_SHARE_DTYW_CBJBXX.cjg
  is '船籍港';
comment on column GK_SHARE_DTYW_CBJBXX.cbzldm
  is '船舶种类代码';
comment on column GK_SHARE_DTYW_CBJBXX.jcrq
  is '建成日期';
comment on column GK_SHARE_DTYW_CBJBXX.zcc
  is '造船厂';
comment on column GK_SHARE_DTYW_CBJBXX.cbcd
  is '船舶长度（米）';
comment on column GK_SHARE_DTYW_CBJBXX.cbxk
  is '船舶型宽（米）';
comment on column GK_SHARE_DTYW_CBJBXX.cbxs
  is '船舶型深（米）';
comment on column GK_SHARE_DTYW_CBJBXX.zd
  is '总吨';
comment on column GK_SHARE_DTYW_CBJBXX.jd
  is '净吨';
comment on column GK_SHARE_DTYW_CBJBXX.zzzd
  is '总载重吨';
comment on column GK_SHARE_DTYW_CBJBXX.zjsl
  is '主机数量(个)';
comment on column GK_SHARE_DTYW_CBJBXX.zjgl
  is '主机功率（kw）';
comment on column GK_SHARE_DTYW_CBJBXX.tjqsl
  is '推进器数量（个）';
comment on column GK_SHARE_DTYW_CBJBXX.xjmzcs
  is '夏季满载吃水';
comment on column GK_SHARE_DTYW_CBJBXX.hdkfdj
  is '核定抗风等级';
comment on column GK_SHARE_DTYW_CBJBXX.zxgx
  is '最小干舷';
comment on column GK_SHARE_DTYW_CBJBXX.xw
  is '箱位	';
comment on column GK_SHARE_DTYW_CBJBXX.cw
  is '车位';
comment on column GK_SHARE_DTYW_CBJBXX.kw
  is '客位';
comment on column GK_SHARE_DTYW_CBJBXX.hs
  is '航速(节)';
comment on column GK_SHARE_DTYW_CBJBXX.cbsyr
  is '船舶所有人';
comment on column GK_SHARE_DTYW_CBJBXX.cbjyr
  is '船舶经营人';
comment on column GK_SHARE_DTYW_CBJBXX.sssjhsjg
  is '所属省级海事机构';
comment on column GK_SHARE_DTYW_CBJBXX.zdaqpyrs
  is '最低安全配员人数';
comment on column GK_SHARE_DTYW_CBJBXX.jssbzdrs
  is '救生设备最大人数';
comment on column GK_SHARE_DTYW_CBJBXX.ickh
  is 'IC卡号	';
comment on column GK_SHARE_DTYW_CBJBXX.txm
  is '条形码';
comment on column GK_SHARE_DTYW_CBJBXX.cbbsh
  is '船舶标识号';
comment on column GK_SHARE_DTYW_CBJBXX.bz
  is '备注';
comment on column GK_SHARE_DTYW_CBJBXX.fkbz
  is '发卡标志';
comment on column GK_SHARE_DTYW_CBJBXX.djbz
  is '登记标志';
comment on column GK_SHARE_DTYW_CBJBXX.lzbz
  is '流转标志';
comment on column GK_SHARE_DTYW_CBJBXX.jgdm
  is '机构代码';
comment on column GK_SHARE_DTYW_CBJBXX.czsj
  is '操作时间';
comment on column GK_SHARE_DTYW_CBJBXX.czydm
  is '操作员代码';
comment on column GK_SHARE_DTYW_CBJBXX.gxbz
  is '更新标志';
comment on column GK_SHARE_DTYW_CBJBXX.mrut
  is '更新时间';
comment on column GK_SHARE_DTYW_CBJBXX.xxly
  is '信息来源';
comment on column GK_SHARE_DTYW_CBJBXX.record_status
  is '记录状态-有效1  记录状态-删除9';
comment on column GK_SHARE_DTYW_CBJBXX.id
  is '唯一标识';
comment on column GK_SHARE_DTYW_CBJBXX.szd
  is '所在地';
comment on column GK_SHARE_DTYW_CBJBXX.hs_mmsi
  is '海事AIS MMSI号';
comment on column GK_SHARE_DTYW_CBJBXX.hs_name
  is '海事英文船名';
alter table GK_SHARE_DTYW_CBJBXX
  add primary key (ID);