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