jsgkj/gkaq/yjpt-java/trunk/resources/sql/init/10.gkhs-table.sql

-----------------------------------------------------
-- Export file  --
-- Created by Administrator on 2015/4/23, 10:51 --
-----------------------------------------------------

CREATE TABLE T_GKHS_CBZYWXHWSBD 
 (  
  SBDBH VARCHAR2(18) NOT NULL , 
  SBDLB VARCHAR2(2), 
  CBBH VARCHAR2(20), 
  ZWCM VARCHAR2(20), 
  YWCM VARCHAR2(40), 
  HCNHCBZ VARCHAR2(1), 
  HC VARCHAR2(20), 
  ZYGKMC VARCHAR2(40), 
  BWDM VARCHAR2(7), 
  KSZYSJ TIMESTAMP (0) , 
  JSZYSJ TIMESTAMP (0), 
  NWMBZ VARCHAR2(1),
  SBBZ VARCHAR2(8), 
  SBDWBH VARCHAR2(15), 
  SBDWMC VARCHAR2(100), 
  SBRQ TIMESTAMP (0) ,
  SHRQ TIMESTAMP (0) ,
  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) 
  ) ;
  ALTER TABLE T_GKHS_CBZYWXHWSBD ADD CONSTRAINT T_GKHS_CBZYWXHWSBD_PK PRIMARY KEY(SBDBH);
   COMMENT ON TABLE T_GKHS_CBZYWXHWSBD 
   IS '船舶载运申报单';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.SBDBH
   IS '申报单编号， 主键';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.SBDLB
   IS '申报单类别 ，CB：包装货物  CS：固体散装  CY：散装液体';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.CBBH
   IS '船舶编号，国轮：A+初次登记号外轮：B+IMO编号 ，港澳：C+牌簿号';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.ZWCM 
   IS '中文船名';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.YWCM 
   IS '英文船名';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.HCNHCBZ 
   IS '海船内河船标志 0：内河船1：海船';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.HC 
   IS '航次';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.ZYGKMC 
   IS '作业港口名称';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.BWDM
   IS '泊位代码';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.KSZYSJ 
   IS '开始作业时间';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.JSZYSJ
   IS '结束作业时间';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.NWMBZ 
   IS '内外贸标志 0：内贸1：外贸';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.SBBZ 
   IS '申报标志 0：委托申报1：船长申报船长申报时：轮船长、船长证书编号必录 委托申报时：申报单位编号、申报员编号、申报员证书编号必录';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.SBDWBH 
   IS '申报单位编号';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.SBDWMC 
   IS '申报单位名称';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.LZBZ 
   IS '受理审核结果';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.SBRQ 
   IS '申报日期';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.SHRQ 
   IS '审核日期';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.ADD_DATE 
   IS '添加日期';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.SYNC_DATE 
   IS '同步日期'; 
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.SYNC_SIGN 
   IS '同步状态';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.SYNC_DESC
   IS '同步地市';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.BYZD1 
   IS '备用字段1';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.BYZD2 
   IS '备用字段2';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.BYZD3 
   IS '备用字段3';
   COMMENT ON COLUMN T_GKHS_CBZYWXHWSBD.BYZD4 
   IS '备用字段4';
   
   
   
 CREATE TABLE T_GKHS_BZHWXX 
 (  
  ID VARCHAR2(40) NOT NULL,
  SBDBH VARCHAR2(18) NOT NULL , 
  XH INTEGER,
  WHSBDBH VARCHAR2(18),
  WGBH VARCHAR2(10),
  ZZL NUMBER(16,3),
  WXHWBZ VARCHAR2(1),
  ZQYSMCZW VARCHAR2(160),
  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) 
   ) ;
   ALTER TABLE T_GKHS_BZHWXX ADD CONSTRAINT T_GKHS_BZHWXX_PK PRIMARY KEY(ID);
   COMMENT ON TABLE T_GKHS_BZHWXX 
   IS '包装货物信息';
   COMMENT ON COLUMN T_GKHS_BZHWXX.ID
   IS '主键';
   COMMENT ON COLUMN T_GKHS_BZHWXX.SBDBH
   IS '申报单编号';
   COMMENT ON COLUMN T_GKHS_BZHWXX.XH
   IS '序号，流水号';
   COMMENT ON COLUMN T_GKHS_BZHWXX.WHSBDBH
   IS '危规申报单编号，海事人员对适运单的审批编号（出港船舶时需要，因为只有出港时有货报）';
   COMMENT ON COLUMN T_GKHS_BZHWXX.WGBH
   IS '危规编号';
   COMMENT ON COLUMN T_GKHS_BZHWXX.ZZL
   IS '总重量（千克）';
   COMMENT ON COLUMN T_GKHS_BZHWXX.WXHWBZ
   IS '危险货物标志，0：否 1：是';
   COMMENT ON COLUMN T_GKHS_BZHWXX.ZQYSMCZW
   IS '危险货物品名';
    COMMENT ON COLUMN T_GKHS_BZHWXX.ADD_DATE 
   IS '添加日期';
   COMMENT ON COLUMN T_GKHS_BZHWXX.SYNC_DATE 
   IS '同步日期'; 
   COMMENT ON COLUMN T_GKHS_BZHWXX.SYNC_SIGN 
   IS '同步状态';
   COMMENT ON COLUMN T_GKHS_BZHWXX.SYNC_DESC
   IS '同步地市';
   COMMENT ON COLUMN T_GKHS_BZHWXX.BYZD1 
   IS '备用字段1';
   COMMENT ON COLUMN T_GKHS_BZHWXX.BYZD2 
   IS '备用字段2';
   COMMENT ON COLUMN T_GKHS_BZHWXX.BYZD3 
   IS '备用字段3';
   COMMENT ON COLUMN T_GKHS_BZHWXX.BYZD4 
   IS '备用字段4';
   
   
   
CREATE TABLE T_GKHS_BZHWZJXX 
 (
  ID VARCHAR2(40) NOT NULL,
  SBDBH VARCHAR2(18) NOT NULL , 
  HWXH INTEGER,
  JZXBH VARCHAR2(100),
  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) 
   ) ;
   ALTER TABLE T_GKHS_BZHWZJXX ADD CONSTRAINT T_GKHS_BZHWZJXX_PK PRIMARY KEY(ID);
   COMMENT ON TABLE T_GKHS_BZHWZJXX 
   IS '包装货物组件信息';
    COMMENT ON COLUMN T_GKHS_BZHWZJXX.ID
   IS '主键';
   COMMENT ON COLUMN T_GKHS_BZHWZJXX.SBDBH
   IS '申报单编号';
   COMMENT ON COLUMN T_GKHS_BZHWZJXX.HWXH
   IS '货物序号，与包装货物信息中序号字段对应';
   COMMENT ON COLUMN T_GKHS_BZHWZJXX.JZXBH
   IS '成组件编号';
     COMMENT ON COLUMN T_GKHS_BZHWZJXX.ADD_DATE 
   IS '添加日期';
   COMMENT ON COLUMN T_GKHS_BZHWZJXX.SYNC_DATE 
   IS '同步日期'; 
   COMMENT ON COLUMN T_GKHS_BZHWZJXX.SYNC_SIGN 
   IS '同步状态';
   COMMENT ON COLUMN T_GKHS_BZHWZJXX.SYNC_DESC
   IS '同步地市';
   COMMENT ON COLUMN T_GKHS_BZHWZJXX.BYZD1 
   IS '备用字段1';
   COMMENT ON COLUMN T_GKHS_BZHWZJXX.BYZD2 
   IS '备用字段2';
   COMMENT ON COLUMN T_GKHS_BZHWZJXX.BYZD3 
   IS '备用字段3';
   COMMENT ON COLUMN T_GKHS_BZHWZJXX.BYZD4 
   IS '备用字段4';
   
   
   CREATE TABLE T_GKHS_SZGTHWXX 
 (  
  ID VARCHAR2(40) NOT NULL,
  SBDBH VARCHAR2(18) NOT NULL , 
  XH INTEGER,
  WHSBDBH VARCHAR2(100),
  WGBH VARCHAR2(10),
  ZZL NUMBER(16,3),
  WXHWBZ VARCHAR2(1),
  ZQYSMCZW VARCHAR2(160),
  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) 
   ) ;
   ALTER TABLE T_GKHS_SZGTHWXX ADD CONSTRAINT T_GKHS_SZGTHWXX_PK PRIMARY KEY(ID);
   COMMENT ON TABLE T_GKHS_SZGTHWXX 
   IS '散装固体货物信息';
   COMMENT ON COLUMN T_GKHS_SZGTHWXX.ID
   IS '主键';
   COMMENT ON COLUMN T_GKHS_SZGTHWXX.SBDBH
   IS '申报单编号';
   COMMENT ON COLUMN T_GKHS_SZGTHWXX.XH
   IS '序号，流水号';
   COMMENT ON COLUMN T_GKHS_SZGTHWXX.WHSBDBH
   IS '危货申报单编号，海事人员对适运单的审批编号（出港船舶时需要，因为只有出港时有货报）';
   COMMENT ON COLUMN T_GKHS_SZGTHWXX.WGBH
   IS '危规编号';
   COMMENT ON COLUMN T_GKHS_SZGTHWXX.ZZL
   IS '总重量（吨）';
   COMMENT ON COLUMN T_GKHS_SZGTHWXX.WXHWBZ
   IS '危险货物标志，0：否  1：是';
   COMMENT ON COLUMN T_GKHS_SZGTHWXX.ZQYSMCZW
   IS '危险货物品名';
    COMMENT ON COLUMN T_GKHS_SZGTHWXX.ADD_DATE 
   IS '添加日期';
   COMMENT ON COLUMN T_GKHS_SZGTHWXX.SYNC_DATE 
   IS '同步日期'; 
   COMMENT ON COLUMN T_GKHS_SZGTHWXX.SYNC_SIGN 
   IS '同步状态';
   COMMENT ON COLUMN T_GKHS_SZGTHWXX.SYNC_DESC
   IS '同步地市';
   COMMENT ON COLUMN T_GKHS_SZGTHWXX.BYZD1 
   IS '备用字段1';
   COMMENT ON COLUMN T_GKHS_SZGTHWXX.BYZD2 
   IS '备用字段2';
   COMMENT ON COLUMN T_GKHS_SZGTHWXX.BYZD3 
   IS '备用字段3';
   COMMENT ON COLUMN T_GKHS_SZGTHWXX.BYZD4 
   IS '备用字段4';
   
   CREATE TABLE T_GKHS_SZYTHWXX 
 (  
  ID VARCHAR2(40) NOT NULL,
  SBDBH VARCHAR2(18) NOT NULL , 
  XH INTEGER,
  WHSBDBH VARCHAR2(100),
  WGBH VARCHAR2(10),
  ZZL NUMBER(16,3),
  WXHWBZ VARCHAR2(1),
  ZQYSMCZW VARCHAR2(160),
  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) 
   ) ;
   ALTER TABLE T_GKHS_SZYTHWXX ADD CONSTRAINT T_GKHS_SZYTHWXX_PK PRIMARY KEY(ID);
   COMMENT ON TABLE T_GKHS_SZYTHWXX 
   IS '散装液体货物信息';
   COMMENT ON COLUMN T_GKHS_SZYTHWXX.ID
   IS '主键';
   COMMENT ON COLUMN T_GKHS_SZYTHWXX.SBDBH
   IS '申报单编号';
   COMMENT ON COLUMN T_GKHS_SZYTHWXX.XH
   IS '序号，流水号';
   COMMENT ON COLUMN T_GKHS_SZYTHWXX.WHSBDBH
   IS '危货申报单编号，海事人员对适运单的审批编号（出港船舶时需要，因为只有出港时有货报）';
   COMMENT ON COLUMN T_GKHS_SZYTHWXX.WGBH
   IS '危规编号';
   COMMENT ON COLUMN T_GKHS_SZYTHWXX.ZZL
   IS '数量（吨）';
   COMMENT ON COLUMN T_GKHS_SZGTHWXX.WXHWBZ
   IS '危险货物标志，0：否  1：是';
   COMMENT ON COLUMN T_GKHS_SZGTHWXX.ZQYSMCZW
   IS '危险货物品名';
    COMMENT ON COLUMN T_GKHS_SZYTHWXX.ADD_DATE 
   IS '添加日期';
   COMMENT ON COLUMN T_GKHS_SZYTHWXX.SYNC_DATE 
   IS '同步日期'; 
   COMMENT ON COLUMN T_GKHS_SZYTHWXX.SYNC_SIGN 
   IS '同步状态';
   COMMENT ON COLUMN T_GKHS_SZYTHWXX.SYNC_DESC
   IS '同步地市';
   COMMENT ON COLUMN T_GKHS_SZYTHWXX.BYZD1 
   IS '备用字段1';
   COMMENT ON COLUMN T_GKHS_SZYTHWXX.BYZD2 
   IS '备用字段2';
   COMMENT ON COLUMN T_GKHS_SZYTHWXX.BYZD3 
   IS '备用字段3';
   COMMENT ON COLUMN T_GKHS_SZYTHWXX.BYZD4 
   IS '备用字段4';
   
   
   CREATE TABLE T_GKHS_BZHWAQSYD 
 (  
  SBDBH VARCHAR2(18) NOT NULL , 
  CBBH VARCHAR2(20),
  ZWCM VARCHAR2(20),
  YWCM VARCHAR2(40),
  HC VARCHAR2(40),
  NWMBZ VARCHAR2(1),
  BWDM VARCHAR2(7),
  WGBH VARCHAR2(10),
  ZZL NUMBER(16,3),
  KSZYSJ TIMESTAMP (0) , 
  JSZYSJ TIMESTAMP (0), 
  SBDWBH VARCHAR2(15), 
  SBDWMC VARCHAR2(100), 
  LZBZ VARCHAR2(1),
  ZQYSMCZW VARCHAR2(160),
  SBRQ TIMESTAMP (0) ,
  SHRQ TIMESTAMP (0) ,
  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) 
   ) ;
   ALTER TABLE T_GKHS_BZHWAQSYD ADD CONSTRAINT T_GKHS_BZHWAQSYD_PK PRIMARY KEY(SBDBH);
  COMMENT ON TABLE T_GKHS_BZHWAQSYD
   IS '包装货物安全申报单';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.SBDBH
   IS '申报单编号， 主键';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.CBBH
   IS '船舶编号，国轮：A+初次登记号外轮：B+IMO编号 ，港澳：C+牌簿号';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.ZWCM 
   IS '中文船名';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.YWCM 
   IS '英文船名';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.HC 
   IS '航次';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.NWMBZ
   IS '内外贸标志 0：内贸1：外贸';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.BWDM
   IS '泊位代码';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.WGBH
   IS '危规编号危规字典使用约定：
		内贸、包装: 国内危规
		外贸、包装: 国际危规
		固体散装: BC规则
		散装液体: 散装液化气、散装油类、液体化学品';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.ZZL
   IS '总重量（吨）';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.KSZYSJ 
   IS '开始作业时间';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.JSZYSJ
   IS '结束作业时间';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.SBDWBH 
   IS '申报单位编号';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.SBDWMC 
   IS '申报单位名称';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.LZBZ 
   IS '受理审核结果 A:待受理；0:待审(通过受理)；1:审核通过(同意进出港)；2:审核不通过(不同意进出港)；
      B:退回申报人(不予受理)；C:待检查处理；D:进一步提供资料(受理)；F:进一步提供资料(审核)；
	  G:待确认；H:确认通过(仅散装固体A、C组)；I:确认不通过(仅散装固体A、C组)；';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.ZQYSMCZW 
   IS '危险货物品名';
	COMMENT ON COLUMN T_GKHS_BZHWAQSYD.SBRQ 
   IS '申报日期';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.SHRQ
   IS '审核日期';
    COMMENT ON COLUMN T_GKHS_BZHWAQSYD.ADD_DATE 
   IS '添加日期';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.SYNC_DATE 
   IS '同步日期'; 
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.SYNC_SIGN 
   IS '同步状态';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.SYNC_DESC
   IS '同步地市';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.BYZD1 
   IS '备用字段1';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.BYZD2 
   IS '备用字段2';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.BYZD3 
   IS '备用字段3';
   COMMENT ON COLUMN T_GKHS_BZHWAQSYD.BYZD4 
   IS '备用字段4';
   
	CREATE TABLE T_GKHS_BZHWSYDZJ 
 (  
  ID VARCHAR2(40) NOT NULL,
  SBDBH VARCHAR2(18) NOT NULL , 
  JZXBH VARCHAR2(100),
  ZL NUMBER(16,2),
  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) 
   ) ;
   ALTER TABLE T_GKHS_BZHWSYDZJ ADD CONSTRAINT T_GKHS_BZHWSYDZJ_PK PRIMARY KEY(ID);
   COMMENT ON TABLE T_GKHS_BZHWSYDZJ 
   IS '包装货物安全适运申报单组件信息';
   COMMENT ON COLUMN T_GKHS_BZHWSYDZJ.ID
   IS '主键';
   COMMENT ON COLUMN T_GKHS_BZHWSYDZJ.SBDBH
   IS '申报单编号';
   COMMENT ON COLUMN T_GKHS_BZHWSYDZJ.JZXBH
   IS '成组件编号';
   COMMENT ON COLUMN T_GKHS_BZHWSYDZJ.ZL
   IS '重量';
   COMMENT ON COLUMN T_GKHS_BZHWSYDZJ.ADD_DATE 
   IS '添加日期';
   COMMENT ON COLUMN T_GKHS_BZHWSYDZJ.SYNC_DATE 
   IS '同步日期'; 
   COMMENT ON COLUMN T_GKHS_BZHWSYDZJ.SYNC_SIGN 
   IS '同步状态';
   COMMENT ON COLUMN T_GKHS_BZHWSYDZJ.SYNC_DESC
   IS '同步地市';
   COMMENT ON COLUMN T_GKHS_BZHWSYDZJ.BYZD1 
   IS '备用字段1';
   COMMENT ON COLUMN T_GKHS_BZHWSYDZJ.BYZD2 
   IS '备用字段2';
   COMMENT ON COLUMN T_GKHS_BZHWSYDZJ.BYZD3 
   IS '备用字段3';
   COMMENT ON COLUMN T_GKHS_BZHWSYDZJ.BYZD4 
   IS '备用字段4';
   
   
   CREATE TABLE T_GKHS_SZGTAQSYD 
 (  
  SBDBH VARCHAR2(18) NOT NULL , 
  CBBH VARCHAR2(20),
  ZWCM VARCHAR2(20),
  YWCM VARCHAR2(40),
  HC VARCHAR2(40),
  NWMBZ VARCHAR2(1),
  BWDM VARCHAR2(7),
  WGBH VARCHAR2(10),
  ZZL NUMBER(16,3),
  KSZYSJ TIMESTAMP (0) , 
  JSZYSJ TIMESTAMP (0), 
  SBDWBH VARCHAR2(15), 
  SBDWMC VARCHAR2(100), 
  LZBZ VARCHAR2(1),
  ZQYSMCZW VARCHAR2(160),
  SBRQ TIMESTAMP (0) ,
  SHRQ TIMESTAMP (0) ,
  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) 
   ) ;
   ALTER TABLE T_GKHS_SZGTAQSYD ADD CONSTRAINT T_GKHS_SZGTAQSYD_PK PRIMARY KEY(SBDBH);
  COMMENT ON TABLE T_GKHS_SZGTAQSYD
   IS '散装固体安全适运单';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.SBDBH
   IS '申报单编号，主键';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.CBBH
   IS '船舶编号，国轮：A+初次登记号外轮：B+IMO编号 ，港澳：C+牌簿号';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.ZWCM 
   IS '中文船名';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.YWCM 
   IS '英文船名';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.HC 
   IS '航次';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.NWMBZ
   IS '内外贸标志 0：内贸1：外贸';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.BWDM
   IS '泊位代码';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.WGBH
   IS '危规编号危规字典使用约定：
		内贸、包装: 国内危规
		外贸、包装: 国际危规
		固体散装: BC规则
		散装液体: 散装液化气、散装油类、液体化学品';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.ZZL
   IS '总重量（吨）';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.KSZYSJ 
   IS '开始作业时间';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.JSZYSJ
   IS '结束作业时间';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.SBDWBH 
   IS '申报单位编号';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.SBDWMC 
   IS '申报单位名称';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.LZBZ 
   IS '受理审核结果 A:待受理；0:待审(通过受理)；1:审核通过(同意进出港)；2:审核不通过(不同意进出港)；
      B:退回申报人(不予受理)；C:待检查处理；D:进一步提供资料(受理)；F:进一步提供资料(审核)；
	  G:待确认；H:确认通过(仅散装固体A、C组)；I:确认不通过(仅散装固体A、C组)；';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.ZQYSMCZW 
   IS '危险货物品名';
	COMMENT ON COLUMN T_GKHS_SZGTAQSYD.SBRQ 
   IS '申报日期';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.SHRQ
   IS '审核日期';
    COMMENT ON COLUMN T_GKHS_SZGTAQSYD.ADD_DATE 
   IS '添加日期';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.SYNC_DATE 
   IS '同步日期'; 
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.SYNC_SIGN 
   IS '同步状态';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.SYNC_DESC
   IS '同步地市';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.BYZD1 
   IS '备用字段1';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.BYZD2 
   IS '备用字段2';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.BYZD3 
   IS '备用字段3';
   COMMENT ON COLUMN T_GKHS_SZGTAQSYD.BYZD4 
   IS '备用字段4';
   
   
   CREATE TABLE T_GKHS_SZYTAQSYD 
 (  
  SBDBH VARCHAR2(18) NOT NULL , 
  CBBH VARCHAR2(20),
  ZWCM VARCHAR2(20),
  YWCM VARCHAR2(40),
  HC VARCHAR2(40),
  NWMBZ VARCHAR2(1),
  BWDM VARCHAR2(7),
  WGBH VARCHAR2(10),
  ZZL NUMBER(16,3),
  KSZYSJ TIMESTAMP (0) , 
  JSZYSJ TIMESTAMP (0), 
  SBDWBH VARCHAR2(15), 
  SBDWMC VARCHAR2(100), 
  LZBZ VARCHAR2(1),
  ZQYSMCZW VARCHAR2(160),
  SBRQ TIMESTAMP (0) ,
  SHRQ TIMESTAMP (0) ,
  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) 
   ) ;
   ALTER TABLE T_GKHS_SZYTAQSYD ADD CONSTRAINT T_GKHS_SZYTAQSYD_PK PRIMARY KEY(SBDBH);
  COMMENT ON TABLE T_GKHS_SZYTAQSYD
   IS '散装液体安全适运单';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.SBDBH
   IS '申报单编号，主键';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.CBBH
   IS '船舶编号，国轮：A+初次登记号外轮：B+IMO编号 ，港澳：C+牌簿号';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.ZWCM 
   IS '中文船名';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.YWCM 
   IS '英文船名';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.HC 
   IS '航次';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.NWMBZ
   IS '内外贸标志 0：内贸1：外贸';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.BWDM
   IS '泊位代码';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.WGBH
   IS '危规编号危规字典使用约定：
		内贸、包装: 国内危规
		外贸、包装: 国际危规
		固体散装: BC规则
		散装液体: 散装液化气、散装油类、液体化学品';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.ZZL
   IS '总重量（吨）';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.KSZYSJ 
   IS '开始作业时间';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.JSZYSJ
   IS '结束作业时间';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.SBDWBH 
   IS '申报单位编号';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.SBDWMC 
   IS '申报单位名称';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.LZBZ 
   IS '受理审核结果 A:待受理；0:待审(通过受理)；1:审核通过(同意进出港)；2:审核不通过(不同意进出港)；
      B:退回申报人(不予受理)；C:待检查处理；D:进一步提供资料(受理)；F:进一步提供资料(审核)；
	  G:待确认；H:确认通过(仅散装固体A、C组)；I:确认不通过(仅散装固体A、C组)；';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.ZQYSMCZW 
   IS '危险货物品名';
	COMMENT ON COLUMN T_GKHS_SZYTAQSYD.SBRQ 
   IS '申报日期';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.SHRQ
   IS '审核日期';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.ADD_DATE 
   IS '添加日期';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.SYNC_DATE 
   IS '同步日期'; 
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.SYNC_SIGN 
   IS '同步状态';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.SYNC_DESC
   IS '同步地市';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.BYZD1 
   IS '备用字段1';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.BYZD2 
   IS '备用字段2';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.BYZD3 
   IS '备用字段3';
   COMMENT ON COLUMN T_GKHS_SZYTAQSYD.BYZD4 
   IS '备用字段4';
   
  
   ALTER TABLE ZTZD_GKML ADD SZD NUMBER ;
   COMMENT ON COLUMN ZTZD_GKML.SZD
   IS '港口所在地市';
   

   
 --海事港口表增加所在地字段
   ALTER TABLE ZTZD_GKML ADD SZD NUMBER ;
   COMMENT ON COLUMN ZTZD_GKML.SZD
   IS '港口所在地市';
 --更新海事港口表的所在地字段
update ZTZD_GKML set SZD=90011 where GKDM='323403';
update ZTZD_GKML set SZD=90011 where GKDM='325181';
update ZTZD_GKML set SZD=90011 where GKDM='323401';
update ZTZD_GKML set SZD=90011 where GKDM='323389';
update ZTZD_GKML set SZD=90011 where GKDM='323393';
update ZTZD_GKML set SZD=90012 where GKDM='325693';
update ZTZD_GKML set SZD=90012 where GKDM='323431';
update ZTZD_GKML set SZD=90012 where GKDM='325647';
update ZTZD_GKML set SZD=90012 where GKDM='325225';
update ZTZD_GKML set SZD=90012 where GKDM='325215';
update ZTZD_GKML set SZD=90012 where GKDM='323443';
update ZTZD_GKML set SZD=90013 where GKDM='325289';
update ZTZD_GKML set SZD=90013 where GKDM='325285';
update ZTZD_GKML set SZD=90013 where GKDM='325291';
update ZTZD_GKML set SZD=90013 where GKDM='325549';
update ZTZD_GKML set SZD=90013 where GKDM='320128';
update ZTZD_GKML set SZD=90014 where GKDM='324911';
update ZTZD_GKML set SZD=90014 where GKDM='324907';
update ZTZD_GKML set SZD=90014 where GKDM='324853';
update ZTZD_GKML set SZD=90014 where GKDM='323385';
update ZTZD_GKML set SZD=90015 where GKDM='323435';
update ZTZD_GKML set SZD=90015 where GKDM='325437';
update ZTZD_GKML set SZD=90015 where GKDM='325483';
update ZTZD_GKML set SZD=90015 where GKDM='440242';
update ZTZD_GKML set SZD=90015 where GKDM='325415';
update ZTZD_GKML set SZD=90015 where GKDM='440314';
update ZTZD_GKML set SZD=90015 where GKDM='325409';
update ZTZD_GKML set SZD=90015 where GKDM='323451';
update ZTZD_GKML set SZD=90015 where GKDM='325507';
update ZTZD_GKML set SZD=90016 where GKDM='325209';
update ZTZD_GKML set SZD=90016 where GKDM='325205';
update ZTZD_GKML set SZD=90016 where GKDM='325773';
update ZTZD_GKML set SZD=90016 where GKDM='323423';
update ZTZD_GKML set SZD=90017 where GKDM='325179';
update ZTZD_GKML set SZD=90017 where GKDM='325157';
update ZTZD_GKML set SZD=90017 where GKDM='325169';
update ZTZD_GKML set SZD=90017 where GKDM='325171';
update ZTZD_GKML set SZD=90017 where GKDM='323391';
update ZTZD_GKML set SZD=90017 where GKDM='323395';
update ZTZD_GKML set SZD=90018 where GKDM='323409';
update ZTZD_GKML set SZD=90018 where GKDM='323411';
update ZTZD_GKML set SZD=90018 where GKDM='323405';
update ZTZD_GKML set SZD=90018 where GKDM='325397';
update ZTZD_GKML set SZD=90018 where GKDM='325407';
update ZTZD_GKML set SZD=90019 where GKDM='320134';
update ZTZD_GKML set SZD=90019 where GKDM='325319';
update ZTZD_GKML set SZD=90019 where GKDM='325333';
update ZTZD_GKML set SZD=90019 where GKDM='325335';
update ZTZD_GKML set SZD=90019 where GKDM='325307';
update ZTZD_GKML set SZD=90019 where GKDM='325309';
update ZTZD_GKML set SZD=90019 where GKDM='325317';
update ZTZD_GKML set SZD=90019 where GKDM='325345';
update ZTZD_GKML set SZD=90019 where GKDM='320132';
update ZTZD_GKML set SZD=90019 where GKDM='325359';
update ZTZD_GKML set SZD=90020 where GKDM='325131';
update ZTZD_GKML set SZD=90020 where GKDM='325133';
update ZTZD_GKML set SZD=90020 where GKDM='325287';
update ZTZD_GKML set SZD=90020 where GKDM='325129';
update ZTZD_GKML set SZD=90020 where GKDM='325123';
update ZTZD_GKML set SZD=90020 where GKDM='325125';
update ZTZD_GKML set SZD=90020 where GKDM='325127';
update ZTZD_GKML set SZD=90021 where GKDM='325779';
update ZTZD_GKML set SZD=90021 where GKDM='325739';
update ZTZD_GKML set SZD=90021 where GKDM='325191';
update ZTZD_GKML set SZD=90021 where GKDM='323407';
update ZTZD_GKML set SZD=90022 where GKDM='322221';
update ZTZD_GKML set SZD=90022 where GKDM='325143';
update ZTZD_GKML set SZD=90023 where GKDM='322237';
update ZTZD_GKML set SZD=90023 where GKDM='322241';
update ZTZD_GKML set SZD=90023 where GKDM='359395';
update ZTZD_GKML set SZD=90023 where GKDM='325293';
update ZTZD_GKML set SZD=90023 where GKDM='325145';
update ZTZD_GKML set SZD=90023 where GKDM='322229';