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