/* ================================================================================ 档案代号:gir_file 档案名称:现金流量群组表 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table gir_file ( gir01 varchar2(6) NOT NULL, /*群组代码 */ gir02 varchar2(40), /*说明 */ gir03 varchar2(1), /*变动分类 */ /*变动分类 1.营业 2.投资 3.理财 */ gir04 varchar2(1), /*合并否 */ /*合并否(Y/N) */ gir05 number(5) /*行序 */ ); create unique index gir_pk on gir_file (gir01); alter table gir_file add constraint gir_pk primary key (gir01) enable validate; grant select on gir_file to public; grant index on gir_file to public; grant update on gir_file to public; grant delete on gir_file to public; grant insert on gir_file to public; |