jsgkj/gkjsjy/trunk/WebContent/static/sql/oracle/table/2.4.GgfwTableCreate.sql

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