/* ================================================================================ 档案代号:apo_file 档案名称:AAP-留置原因档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table apo_file ( apo01 varchar2(4) NOT NULL, /*留置原因编号 */ apo02 varchar2(80), /*留置原因 */ apoacti varchar2(1), /*资料有效码 */ apouser varchar2(10), /*资料所有者 */ apogrup varchar2(10), /*资料所有群 */ apomodu varchar2(10), /*资料更改者 */ apodate date /*最近修改日 */ ); create unique index apo_pk on apo_file (apo01); alter table apo_file add constraint apo_pk primary key (apo01) enable validate; grant select on apo_file to public; grant index on apo_file to public; grant update on apo_file to public; grant delete on apo_file to public; grant insert on apo_file to public; |