/* ================================================================================ 档案代号:iml_file 档案名称:料件成本项目结构资料 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table iml_file ( iml01 varchar2(40) NOT NULL, /*料件编号 */ iml02 varchar2(10) NOT NULL, /*成本项目 */ iml031 number(20,6), /*标准成本 */ iml032 number(20,6), /*现时成本 */ iml033 number(20,6) /*预设成本 */ ); create unique index iml_pk on iml_file (iml01,iml02); alter table iml_file add constraint iml_pk primary key (iml01,iml02) enable validate; grant select on iml_file to public; grant index on iml_file to public; grant update on iml_file to public; grant delete on iml_file to public; grant insert on iml_file to public; |