/* ================================================================================ 档案代号:cxk_file 档案名称:转拨单价档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table cxk_file ( cxk01 varchar2(40) NOT NULL, /*料号 */ cxk02 varchar2(120), /*品名 */ cxk03 varchar2(120), /*规格 */ cxk04 number(20,6), /*转拨单价 */ cxk05 date /*建立日期 */ ); create unique index cxk_pk on cxk_file (cxk01); alter table cxk_file add constraint cxk_pk primary key (cxk01) enable validate; grant select on cxk_file to public; grant index on cxk_file to public; grant update on cxk_file to public; grant delete on cxk_file to public; grant insert on cxk_file to public; |