--表如下: --GK_OPERATION_JSJY_GGFWXX_FB --GK_OPERATION_JSJY_GGFWXX_TZGG --GK_OPERATION_JSJY_HXHBGL --共3张表 --通知公告发布 create table GK_OPERATION_JSJY_GGFWXX_FB ( id VARCHAR2(40) not null, create_user VARCHAR2(40), update_user VARCHAR2(40), create_date_time TIMESTAMP(6), update_date_time TIMESTAMP(6), record_status NUMBER, ggid VARCHAR2(40), senduser VARCHAR2(40), ggr NVARCHAR2(1000), fblx CHAR(1), szd VARCHAR2(40) )TABLESPACE "GK_OPERATION" ; comment on column GK_OPERATION_JSJY_GGFWXX_FB.id is 'ID'; comment on column GK_OPERATION_JSJY_GGFWXX_FB.create_user is '创建人'; comment on column GK_OPERATION_JSJY_GGFWXX_FB.update_user is '修改人'; comment on column GK_OPERATION_JSJY_GGFWXX_FB.create_date_time is '创建时间'; comment on column GK_OPERATION_JSJY_GGFWXX_FB.update_date_time is '修改时间'; comment on column GK_OPERATION_JSJY_GGFWXX_FB.record_status is '数据状态'; comment on column GK_OPERATION_JSJY_GGFWXX_FB.ggid is '公告ID'; comment on column GK_OPERATION_JSJY_GGFWXX_FB.senduser is '发布人'; comment on column GK_OPERATION_JSJY_GGFWXX_FB.ggr is '能看到公告的人'; comment on column GK_OPERATION_JSJY_GGFWXX_FB.fblx is '发布类型,0全部,1个人'; comment on column GK_OPERATION_JSJY_GGFWXX_FB.szd is '所在地'; alter table GK_OPERATION_JSJY_GGFWXX_FB add constraint GK_OPERATION_JSJY_GGFWXX_F_PK primary key (ID); --通知公告 create table GK_OPERATION_JSJY_GGFWXX_TZGG ( id VARCHAR2(40) not null, create_user VARCHAR2(40), update_user VARCHAR2(40), create_date_time TIMESTAMP(6), update_date_time TIMESTAMP(6), record_status NUMBER, bt VARCHAR2(100), fjid VARCHAR2(40), nr NVARCHAR2(1000), istop NVARCHAR2(20), send_status NVARCHAR2(20), senduser VARCHAR2(40), szd VARCHAR2(40) )TABLESPACE "GK_OPERATION" ; comment on column GK_OPERATION_JSJY_GGFWXX_TZGG.id is 'ID'; comment on column GK_OPERATION_JSJY_GGFWXX_TZGG.create_user is '创建人'; comment on column GK_OPERATION_JSJY_GGFWXX_TZGG.update_user is '修改人'; comment on column GK_OPERATION_JSJY_GGFWXX_TZGG.create_date_time is '创建时间'; comment on column GK_OPERATION_JSJY_GGFWXX_TZGG.update_date_time is '修改时间'; comment on column GK_OPERATION_JSJY_GGFWXX_TZGG.record_status is '数据状态'; comment on column GK_OPERATION_JSJY_GGFWXX_TZGG.bt is '标题'; comment on column GK_OPERATION_JSJY_GGFWXX_TZGG.fjid is '附件'; comment on column GK_OPERATION_JSJY_GGFWXX_TZGG.nr is '内容'; comment on column GK_OPERATION_JSJY_GGFWXX_TZGG.istop is '是否置顶,0否,1是'; comment on column GK_OPERATION_JSJY_GGFWXX_TZGG.send_status is '是否发布,0否,1是'; comment on column GK_OPERATION_JSJY_GGFWXX_TZGG.senduser is '公告发起人'; comment on column GK_OPERATION_JSJY_GGFWXX_TZGG.szd is '所在地'; alter table GK_OPERATION_JSJY_GGFWXX_TZGG add constraint GK_OPERATION_JSJY_GGFWXX_T_PK primary key (ID); --航线航班管理 create table GK_OPERATION_JSJY_HXHBGL ( id VARCHAR2(40) not null, create_user VARCHAR2(40), update_user VARCHAR2(40), create_date_time TIMESTAMP(6), update_date_time TIMESTAMP(6), record_status NUMBER, szd VARCHAR2(40), ssjyr VARCHAR2(40), nmjzxttl NUMBER, wmjzxttl NUMBER, yyhxts NUMBER, yyhxhbs NUMBER, yyhxbz NVARCHAR2(200), jyhxts NUMBER, jyhxhbs NUMBER, jyhxbz NVARCHAR2(200), nzxts NUMBER, nzxhbs NUMBER, nzxbz NVARCHAR2(200), nmhxts NUMBER, nmhxhbs NUMBER, nmhxbz NVARCHAR2(200), szgk VARCHAR2(40), szgq VARCHAR2(40), ssgkglbm VARCHAR2(40) )TABLESPACE "GK_OPERATION" ; comment on column GK_OPERATION_JSJY_HXHBGL.id is 'ID'; comment on column GK_OPERATION_JSJY_HXHBGL.create_user is '创建人'; comment on column GK_OPERATION_JSJY_HXHBGL.update_user is '修改人'; comment on column GK_OPERATION_JSJY_HXHBGL.create_date_time is '创建时间'; comment on column GK_OPERATION_JSJY_HXHBGL.update_date_time is '修改时间'; comment on column GK_OPERATION_JSJY_HXHBGL.record_status is '数据状态'; comment on column GK_OPERATION_JSJY_HXHBGL.szd is '所在地'; comment on column GK_OPERATION_JSJY_HXHBGL.ssjyr is '所属经营人'; comment on column GK_OPERATION_JSJY_HXHBGL.nmjzxttl is '内贸集装箱吞吐量 TEU'; comment on column GK_OPERATION_JSJY_HXHBGL.wmjzxttl is '外贸集装箱吞吐量 TEU'; comment on column GK_OPERATION_JSJY_HXHBGL.yyhxts is '远洋航线条数'; comment on column GK_OPERATION_JSJY_HXHBGL.yyhxhbs is '远洋航线航班数'; comment on column GK_OPERATION_JSJY_HXHBGL.yyhxbz is '远洋航线备注'; comment on column GK_OPERATION_JSJY_HXHBGL.jyhxts is '近洋航线条数'; comment on column GK_OPERATION_JSJY_HXHBGL.jyhxhbs is '近洋航线航班数'; comment on column GK_OPERATION_JSJY_HXHBGL.jyhxbz is '近洋航线备注'; comment on column GK_OPERATION_JSJY_HXHBGL.nzxts is '内支线条数'; comment on column GK_OPERATION_JSJY_HXHBGL.nzxhbs is '内支线航班数'; comment on column GK_OPERATION_JSJY_HXHBGL.nzxbz is '内支线备注'; comment on column GK_OPERATION_JSJY_HXHBGL.nmhxts is '内贸航线条数'; comment on column GK_OPERATION_JSJY_HXHBGL.nmhxhbs is '内贸航线航班数'; comment on column GK_OPERATION_JSJY_HXHBGL.nmhxbz is '内贸航线备注'; comment on column GK_OPERATION_JSJY_HXHBGL.szgk is '所在港口'; comment on column GK_OPERATION_JSJY_HXHBGL.szgq is '所在港区'; comment on column GK_OPERATION_JSJY_HXHBGL.ssgkglbm is '所属港口管理部门'; alter table GK_OPERATION_JSJY_HXHBGL add constraint GK_OPERATION_JSJY_HXHBGL primary key (ID);