/* ================================================================================ 档案代号:abd_file 档案名称:部门层级资料 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table abd_file ( abd01 varchar2(10) NOT NULL, /*部门编号 */ abd02 varchar2(10) NOT NULL, /*部门编号 */ abd03 varchar2(1), /*No Use */ abd04 varchar2(1), /*No Use */ abd05 varchar2(1), /*No Use */ abd06 varchar2(1), /*No Use */ abdacti varchar2(1), /*资料有效码 */ abduser varchar2(10), /*资料所有者 */ abdgrup varchar2(10), /*资料所有部门 */ abdmodu varchar2(10), /*资料修改者 */ abddate date /*最近修改日 */ ); create unique index abd_pk on abd_file (abd01,abd02); alter table abd_file add constraint abd_pk primary key (abd01,abd02) enable validate; grant select on abd_file to public; grant index on abd_file to public; grant update on abd_file to public; grant delete on abd_file to public; grant insert on abd_file to public; |