/* ================================================================================ 档案代号:jce_file 档案名称:不纳入计算成本库维护作业 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table jce_file ( jce01 varchar2(10) NOT NULL, /*成本库别 */ jce02 varchar2(10) NOT NULL, /*仓库编号 */ jce03 varchar2(1), /*NO USE */ jce04 varchar2(1), /*No Use */ jce05 varchar2(1), /*No Use */ jceacti varchar2(1), /*资料有效码 */ jceuser varchar2(10), /*资料所有者 */ jcegrup varchar2(10), /*资料所有部门 */ jcemodu varchar2(10), /*资料修改者 */ jcedate date /*最近修改日 */ ); create unique index jce_pk on jce_file (jce01,jce02); alter table jce_file add constraint jce_pk primary key (jce01,jce02) enable validate; grant select on jce_file to public; grant index on jce_file to public; grant update on jce_file to public; grant delete on jce_file to public; grant insert on jce_file to public; |