/* ================================================================================ 档案代号:sgg_file 档案名称:留置原因档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table sgg_file ( sgg01 varchar2(4) NOT NULL, /*留置原因编号 */ sgg02 varchar2(80), /*留置原因 */ sggacti varchar2(1), /*资料有效码 */ sgguser varchar2(10), /*资料所有者 */ sgggrup varchar2(10), /*资料所有群 */ sggmodu varchar2(10), /*资料更改者 */ sggdate date /*最近修改日 */ ); create unique index sgg_pk on sgg_file (sgg01); alter table sgg_file add constraint sgg_pk primary key (sgg01) enable validate; grant select on sgg_file to public; grant index on sgg_file to public; grant update on sgg_file to public; grant delete on sgg_file to public; grant insert on sgg_file to public; |