--表如下： --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);