/* ================================================================================ 档案代号:aca_file 档案名称:常用及分摊传票类别单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table aca_file ( aca01 varchar2(6) NOT NULL, /*类别编号 */ aca02 varchar2(80), /*类别名称 */ aca03 number(5), /*产生顺序 */ acaacti varchar2(1), /*资料有效码 */ /*系统维护 */ acauser varchar2(10), /*资料所有者 */ /*系统维护 */ acagrup varchar2(10), /*资料所有群 */ /*系统维护 */ acamodu varchar2(10), /*资料更改者 */ /*系统维护 */ acadate date /*最近修改日 */ /*系统维护 */ ); create unique index aca_pk on aca_file (aca01); alter table aca_file add constraint aca_pk primary key (aca01) enable validate; grant select on aca_file to public; grant index on aca_file to public; grant update on aca_file to public; grant delete on aca_file to public; grant insert on aca_file to public; |