/*
================================================================================
档案代号: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;