/* ================================================================================ 档案代号:pjw_file 档案名称:poc取得方式 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table pjw_file ( pjw01 varchar2(10) NOT NULL, /*方式编号 */ pjw02 varchar2(80), /*说明 */ pjw03 varchar2(1), /*类型 */ pjw04 number(10), /*起始值 */ pjw05 number(10), /*上限值 */ pjwacti varchar2(1), /*资料有效码 */ pjwdate date, /*最近修改日 */ pjwgrup varchar2(10), /*资料所有部门 */ pjwmodu varchar2(10), /*资料修改者 */ pjwuser varchar2(10) /*资料所有者 */ ); create unique index pjw_pk on pjw_file (pjw01); alter table pjw_file add constraint pjw_pk primary key (pjw01) enable validate; grant select on pjw_file to public; grant index on pjw_file to public; grant update on pjw_file to public; grant delete on pjw_file to public; grant insert on pjw_file to public; |