/* ================================================================================ 档案代号:git_file 档案名称:人工输入金额档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table git_file ( git01 varchar2(6) NOT NULL, /*群组代码 */ git02 varchar2(24) NOT NULL, /*科目编号 */ git03 varchar2(16) NOT NULL, /*编号 */ git06 number(5) NOT NULL, /*年度 */ git07 number(5) NOT NULL, /*期别 */ git04 varchar2(80), /*说明 */ git05 number(20,6), /*人工输入金额 */ git00 varchar2(5) NOT NULL /*帐别 */ ); create unique index git_pk on git_file (git06,git07,git00,git01,git02,git03); alter table git_file add constraint git_pk primary key (git06,git07,git00,git01,git02,git03) enable validate; grant select on git_file to public; grant index on git_file to public; grant update on git_file to public; grant delete on git_file to public; grant insert on git_file to public; |