/* ================================================================================ 档案代号:aga_file 档案名称:属性群组资料主档 档案目的:记录多属性料件机制中定义的属性群组资料 上游档案: 下游档案: ============.========================.========================================== */ create table aga_file ( aga01 varchar2(10) NOT NULL, /*属性群组代码 */ aga02 varchar2(80) NOT NULL, /*描述说明 */ agaacti varchar2(1), /*资料有效码 */ agauser varchar2(10), /*资料所有者 */ agagrup varchar2(10), /*资料所有群 */ agamodu varchar2(10), /*资料更改者 */ agadate date /*最近修改日 */ ); create unique index aga_pk on aga_file (aga01); alter table aga_file add constraint aga_pk primary key (aga01) enable validate; grant select on aga_file to public; grant index on aga_file to public; grant update on aga_file to public; grant delete on aga_file to public; grant insert on aga_file to public; |