/* ================================================================================ 档案代号:pmy_file 档案名称:厂商分类代码档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pmy_file ( pmy01 varchar2(10) NOT NULL, /*厂商分类代码 */ pmy02 varchar2(80), /*厂商分类说明 */ pmy03 varchar2(1), /*No Use */ pmy04 varchar2(1), /*No Use */ pmy05 varchar2(1), /*No Use */ pmy06 varchar2(1), /*No Use */ pmy07 varchar2(1), /*No Use */ pmy08 varchar2(1), /*No Use */ pmy09 varchar2(1), /*No Use */ pmy10 varchar2(1), /*No Use */ pmyacti varchar2(1), /*资料有效码 */ pmyuser varchar2(10), /*资料所有者 */ pmygrup varchar2(10), /*资料所有部门 */ pmymodu varchar2(10), /*资料修改者 */ pmydate date /*最近修改日 */ ); create unique index pmy_pk on pmy_file (pmy01); alter table pmy_file add constraint pmy_pk primary key (pmy01) enable validate; grant select on pmy_file to public; grant index on pmy_file to public; grant update on pmy_file to public; grant delete on pmy_file to public; grant insert on pmy_file to public; |