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