----------------------------------------------------- -- 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';