/* ================================================================================ 档案代号:aww_file 档案名称:部门归属档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table aww_file ( aww01 number(5) NOT NULL, /*年度 */ aww02 varchar2(1) NOT NULL, /*部门分类别 */ /*部门分类别 ( 1/2 ==> aglr991/aglr992 )*/ aww03 varchar2(10) NOT NULL, /*归属部门 */ aww04 varchar2(10) NOT NULL, /*明细部门 */ awwacti varchar2(1), /*资料有效码 */ awwuser varchar2(10), /*资料所有者 */ /*系统维护 */ awwgrup varchar2(10), /*资料所有群 */ /*系统维护 */ awwmodu varchar2(10), /*资料更改者 */ /*系统维护 */ awwdate date /*最近修改日 */ /*系统维护 */ ); create unique index aww_pk on aww_file (aww01,aww02,aww03,aww04); alter table aww_file add constraint aww_pk primary key (aww01,aww02,aww03,aww04) enable validate; grant select on aww_file to public; grant index on aww_file to public; grant update on aww_file to public; grant delete on aww_file to public; grant insert on aww_file to public; |