jsgkj/gkjsjy/trunk/WebContent/static/sql/oracle/table/2.2.GkjsTableCreate.sql

--表如下：
--GK_BASIC_JSJY_GKJS_JSJDFJ
--GK_BASIC_JSJY_GKJS_TZJH
--GK_BASIC_JSJY_GKJS_XMXXGL
--GK_BASIC_JSJY_GKJS_XMYJHXX
--GK_BASIC_JSJY_GKJS_XMXXGLFB
--共5张表

--建设进度附件表
 create table GK_BASIC_JSJY_GKJS_JSJDFJ
(
  id               VARCHAR2(40) not null,
  xmid             VARCHAR2(40),
  wjh              VARCHAR2(40),
  fbsj             TIMESTAMP(6),
  fbdw             VARCHAR2(100),
  fjid             VARCHAR2(20),
  szd              NUMBER,
  create_date_time TIMESTAMP(0),
  update_date_time TIMESTAMP(0),
  record_status    NUMBER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  wjlb             VARCHAR2(40)
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_GKJS_JSJDFJ
  is '建设进度附件表';
comment on column GK_BASIC_JSJY_GKJS_JSJDFJ.id
  is '唯一标识';
comment on column GK_BASIC_JSJY_GKJS_JSJDFJ.xmid
  is '项目id';
comment on column GK_BASIC_JSJY_GKJS_JSJDFJ.wjh
  is '文件号';
comment on column GK_BASIC_JSJY_GKJS_JSJDFJ.fbsj
  is '发布时间';
comment on column GK_BASIC_JSJY_GKJS_JSJDFJ.fbdw
  is '发布单位';
comment on column GK_BASIC_JSJY_GKJS_JSJDFJ.fjid
  is '附件id';
comment on column GK_BASIC_JSJY_GKJS_JSJDFJ.szd
  is '所在地';
comment on column GK_BASIC_JSJY_GKJS_JSJDFJ.wjlb
  is '文件类别';
alter table GK_BASIC_JSJY_GKJS_JSJDFJ
  add primary key (ID);

  --投资计划
create table GK_BASIC_JSJY_GKJS_TZJH
(
  id               VARCHAR2(40) not null,
  xmid             VARCHAR2(40),
  xmlb             VARCHAR2(40),
  ndjhtz           NUMBER,
  create_user      VARCHAR2(40),
  szd              VARCHAR2(40),
  update_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  jhnd             VARCHAR2(20),
  record_status    NUMBER,
  xmmc             VARCHAR2(40),
  xmfbid   varchar2(40)
)TABLESPACE "GK_BASIC"
;
comment on column GK_BASIC_JSJY_GKJS_TZJH.id
  is 'ID';
comment on column GK_BASIC_JSJY_GKJS_TZJH.xmid
  is '项目ID';
comment on column GK_BASIC_JSJY_GKJS_TZJH.xmlb
  is '项目类别（计划外，十一五，十三五）';
comment on column GK_BASIC_JSJY_GKJS_TZJH.ndjhtz
  is '年度计划投资';
comment on column GK_BASIC_JSJY_GKJS_TZJH.create_user
  is '创建人';
comment on column GK_BASIC_JSJY_GKJS_TZJH.szd
  is '所在地';
comment on column GK_BASIC_JSJY_GKJS_TZJH.update_user
  is '修改人';
comment on column GK_BASIC_JSJY_GKJS_TZJH.create_date_time
  is '创建时间';
comment on column GK_BASIC_JSJY_GKJS_TZJH.update_date_time
  is '修改时间';
comment on column GK_BASIC_JSJY_GKJS_TZJH.jhnd
  is '计划年度';
comment on column GK_BASIC_JSJY_GKJS_TZJH.record_status
  is '数据状态';
comment on column GK_BASIC_JSJY_GKJS_TZJH.xmmc
  is '项目名称';
alter table GK_BASIC_JSJY_GKJS_TZJH
  add primary key (ID);
--项目信息管理
create table GK_BASIC_JSJY_GKJS_XMXXGL
(
  id               VARCHAR2(40) not null,
  xmmc             VARCHAR2(200),
  xmfr             VARCHAR2(40),
  jsdd             NVARCHAR2(500),
  xmssdw           VARCHAR2(40),
  tzlx             VARCHAR2(20),
  ztz              NUMBER,
  xmhzjb           VARCHAR2(20),
  axspjb           VARCHAR2(20),
  axcd             NUMBER,
  bwdj             NUMBER,
  bwhz             VARCHAR2(40),
  tgnl             VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  mtwzzb           VARCHAR2(40),
  create_date_time TIMESTAMP(0),
  update_date_time TIMESTAMP(0),
  record_status    NUMBER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NUMBER,
  xmlx             VARCHAR2(40),
  jyrid            VARCHAR2(40)
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_GKJS_XMXXGL
  is '项目建设管理';
comment on column GK_BASIC_JSJY_GKJS_XMXXGL.id
  is '唯一标识';
comment on column GK_BASIC_JSJY_GKJS_XMXXGL.xmmc
  is '项目名称';
comment on column GK_BASIC_JSJY_GKJS_XMXXGL.xmfr
  is '项目法人';
comment on column GK_BASIC_JSJY_GKJS_XMXXGL.jsdd
  is '建设地点';
comment on column GK_BASIC_JSJY_GKJS_XMXXGL.xmssdw
  is '项目所属单位';
comment on column GK_BASIC_JSJY_GKJS_XMXXGL.tzlx
  is '投资类型（政府投资/企业投资）';
comment on column GK_BASIC_JSJY_GKJS_XMXXGL.ztz
  is '总投资（万元）';
comment on column GK_BASIC_JSJY_GKJS_XMXXGL.xmhzjb
  is '项目核准级别(国/省/市)';
comment on column GK_BASIC_JSJY_GKJS_XMXXGL.axspjb
  is '岸线审批级别（部/省/市/无）';
comment on column GK_BASIC_JSJY_GKJS_XMXXGL.axcd
  is '岸线长度';
comment on column GK_BASIC_JSJY_GKJS_XMXXGL.bwdj
  is '泊位吨级';
comment on column GK_BASIC_JSJY_GKJS_XMXXGL.bwhz
  is '泊位货种';
comment on column GK_BASIC_JSJY_GKJS_XMXXGL.tgnl
  is '通过能力';
comment on column GK_BASIC_JSJY_GKJS_XMXXGL.szgk
  is '所在港口';
comment on column GK_BASIC_JSJY_GKJS_XMXXGL.szgq
  is '所在港区';
comment on column GK_BASIC_JSJY_GKJS_XMXXGL.mtwzzb
  is '码头位置坐标';
comment on column GK_BASIC_JSJY_GKJS_XMXXGL.szd
  is '所在地';
comment on column GK_BASIC_JSJY_GKJS_XMXXGL.xmlx
  is '项目类型';
  comment on column GK_BASIC_JSJY_GKJS_XMXXGL.jyrid
  is '经营人id';
alter table GK_BASIC_JSJY_GKJS_XMXXGL
  add primary key (ID);

--项目月计划信息
create table GK_BASIC_JSJY_GKJS_XMYJHXX
(
  id               VARCHAR2(40) not null,
  xmid             VARCHAR2(40),
  nd               VARCHAR2(10),
  yf               VARCHAR2(10),
  ydjhtz           NUMBER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  create_date_time TIMESTAMP(6),
  update_date_time TIMESTAMP(6),
  record_status    NUMBER,
  sjwctze          NUMBER,
  dqxxjd           VARCHAR2(40),
  xxjdwcqkfx       NVARCHAR2(100),
  szd              VARCHAR2(40)
)TABLESPACE "GK_BASIC"
;
comment on column GK_BASIC_JSJY_GKJS_XMYJHXX.id
  is 'ID';
comment on column GK_BASIC_JSJY_GKJS_XMYJHXX.xmid
  is '项目ID';
comment on column GK_BASIC_JSJY_GKJS_XMYJHXX.nd
  is '年度';
comment on column GK_BASIC_JSJY_GKJS_XMYJHXX.yf
  is '月份';
  comment on column GK_BASIC_JSJY_GKJS_XMYJHXX.sjwctze
  is '实际投资额';
comment on column GK_BASIC_JSJY_GKJS_XMYJHXX.dqxxjd
  is '当前形象进度';
comment on column GK_BASIC_JSJY_GKJS_XMYJHXX.xxjdwcqkfx
  is '形象进度完成情况分析';
comment on column GK_BASIC_JSJY_GKJS_XMYJHXX.szd
  is '所在地';
comment on column GK_BASIC_JSJY_GKJS_XMYJHXX.ydjhtz
  is '月度计划投资';
  alter table GK_BASIC_JSJY_GKJS_XMYJHXX
  add primary key (ID);

 create table GK_BASIC_JSJY_GKJS_XMXXGLFB
(
  id               VARCHAR2(40),
  xmmc             VARCHAR2(200),
  xmfr             VARCHAR2(40),
  jsdd             NVARCHAR2(500),
  xmssdw           VARCHAR2(40),
  tzlx             VARCHAR2(20),
  ztz              NUMBER,
  xmhzjb           VARCHAR2(20),
  axspjb           VARCHAR2(20),
  axcd             NUMBER,
  bwdj             NUMBER,
  bwhz             VARCHAR2(40),
  tgnl             VARCHAR2(40),
  szgk             VARCHAR2(40),
  szgq             VARCHAR2(40),
  mtwzzb           VARCHAR2(40),
  create_date_time TIMESTAMP(0),
  update_date_time TIMESTAMP(0),
  record_status    NUMBER,
  create_user      VARCHAR2(40),
  update_user      VARCHAR2(40),
  szd              NUMBER,
  xmlx             VARCHAR2(40),
  jyrid            VARCHAR2(40),
  lcid             VARCHAR2(40),
  xmid             VARCHAR2(40),
  sortno           VARCHAR2(40),
    yj              NVARCHAR2(400)
)TABLESPACE "GK_BASIC"
;
comment on table GK_BASIC_JSJY_GKJS_XMXXGLFB
  is '项目信息管理副本表';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.id
  is '唯一标识';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.xmmc
  is '项目名称';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.xmfr
  is '项目法人';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.jsdd
  is '建设地点';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.xmssdw
  is '项目所属单位';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.tzlx
  is '投资类型（政府投资/企业投资）';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.ztz
  is '总投资（万元）';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.xmhzjb
  is '项目核准级别(国/省/市)';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.axspjb
  is '岸线审批级别（部/省/市/无）';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.axcd
  is '岸线长度';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.bwdj
  is '泊位吨级';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.bwhz
  is '泊位货种';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.tgnl
  is '通过能力';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.szgk
  is '所在港口';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.szgq
  is '所在港区';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.mtwzzb
  is '码头位置坐标';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.szd
  is '所在地';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.xmlx
  is '项目类型';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.jyrid
  is '经营人ID';
comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.lcid
  is '流程id';
  comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.xmid
  is '项目id';
  comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.sortno
  is '排序号';
    comment on column GK_BASIC_JSJY_GKJS_XMXXGLFB.yj
  is '意见';

    alter table GK_BASIC_JSJY_GKJS_XMXXGLFB
  add primary key (ID);