/* ================================================================================ 档案代号:cao_file 档案名称: 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cao_file ( cao01 varchar2(40) DEFAULT '' NOT NULL, /*料号*/ cao02 date, /*日期 */ cao03 number(15,3) /*数量 */ ); create unique index cao_pk on cao_file (cao01); alter table cao_file add constraint cao_pk primary key (cao01) enable validate; grant select on cao_file to public; grant index on cao_file to public; grant update on cao_file to public; grant delete on cao_file to public; grant insert on cao_file to public; |