/*
================================================================================
档案代号:ttc_file
档案名称:成品生产数量档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table ttc_file
(
ttc01       number(5) NOT NULL,      /*年度                                   */
ttc02       varchar2(10) NOT NULL,   /*产品分类                               */
ttc03       varchar2(40) NOT NULL,   /*成品料号                               */
ttc04       number(15,3)             /*生产数量                               */
);

create unique index ttc_pk on ttc_file (ttc01,ttc02,ttc03);
alter table ttc_file add  constraint ttc_pk primary key  (ttc01,ttc02,ttc03) enable validate;
grant select on ttc_file to public;
grant index on ttc_file to public;
grant update on ttc_file to public;
grant delete on ttc_file to public;
grant insert on ttc_file to public;