/* ================================================================================ 档案代号:apr_file 档案名称:AAP-帐款类别档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table apr_file ( apr01 varchar2(10) NOT NULL, /*帐款类别编号 */ /* */ /* */ apr02 varchar2(80), /*类别名称 */ /* */ /* */ apracti varchar2(1), /*资料有效码 */ apruser varchar2(10), /*资料所有者 */ aprgrup varchar2(10), /*资料所有群 */ aprmodu varchar2(10), /*资料更改者 */ aprdate date /*最近修改日 */ ); create unique index apr_pk on apr_file (apr01); alter table apr_file add constraint apr_pk primary key (apr01) enable validate; grant select on apr_file to public; grant index on apr_file to public; grant update on apr_file to public; grant delete on apr_file to public; grant insert on apr_file to public; |