/* ================================================================================ 档案代号:dmb_file 档案名称:版本代码档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table dmb_file ( dmb01 varchar2(6) NOT NULL, /*版本代码 */ dmb02 varchar2(80), /*版本说明 */ dmbacti varchar2(1), /*资料有效码 */ dmbuser varchar2(10), /*资料所有者 */ dmbgrup varchar2(10), /*资料所有群 */ dmbmodu varchar2(10), /*资料更改者 */ dmbdate date /*最近修改日 */ ); create unique index dmb_pk on dmb_file (dmb01); alter table dmb_file add constraint dmb_pk primary key (dmb01) enable validate; grant select on dmb_file to public; grant index on dmb_file to public; grant update on dmb_file to public; grant delete on dmb_file to public; grant insert on dmb_file to public; |