/* ================================================================================ 档案代号:nqb_file 档案名称:营运中心周转金设定 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table nqb_file ( nqb01 varchar2(10) NOT NULL, /*营运中心 */ nqb02 date NOT NULL, /*日期 */ nqb03 number(20,6), /*周转金额 */ nqbacti varchar2(1), /*资料有效码 */ nqbuser varchar2(10), /*资料所有者 */ nqbgrup varchar2(10), /*资料所有群 */ nqbmodu varchar2(10), /*资料更改者 */ nqbdate date /*最近修改日 */ ); create unique index nqb_pk on nqb_file (nqb01,nqb02); alter table nqb_file add constraint nqb_pk primary key (nqb01,nqb02) enable validate; grant select on nqb_file to public; grant index on nqb_file to public; grant update on nqb_file to public; grant delete on nqb_file to public; grant insert on nqb_file to public; |