/* ================================================================================ 档案代号:fai_file 档案名称:常用摘要名称档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table fai_file ( fai01 varchar2(4) NOT NULL, /*常用摘要编号 */ fai02 varchar2(80), /*常用摘要 */ faiacti varchar2(1), /*资料有效码 */ faiuser varchar2(10), /*资料所有者 */ faigrup varchar2(10), /*资料所有群 */ faimodu varchar2(10), /*资料更改者 */ faidate date /*最近修改日 */ ); create unique index fai_pk on fai_file (fai01); alter table fai_file add constraint fai_pk primary key (fai01) enable validate; grant select on fai_file to public; grant index on fai_file to public; grant update on fai_file to public; grant delete on fai_file to public; grant insert on fai_file to public; |