/* ================================================================================ 档案代号:bnj_file 档案名称:委外工单年度结存档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table bnj_file ( bnj01 varchar2(16) NOT NULL, /*工单号码 */ bnj02 number(15,3) NOT NULL /*生产数量-结存入库量 */ ); create unique index bnj_pk on bnj_file (bnj01); alter table bnj_file add constraint bnj_pk primary key (bnj01) enable validate; grant select on bnj_file to public; grant index on bnj_file to public; grant update on bnj_file to public; grant delete on bnj_file to public; grant insert on bnj_file to public; |