/* ================================================================================ 档案代号:msm_file 档案名称:备料指定送货地点档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table msm_file ( msm01 varchar2(40) NOT NULL, /*料号 */ msm02 varchar2(10) NOT NULL, /*地址代号 */ msm03 varchar2(10) NOT NULL, /*仓库代号 */ msm04 varchar2(20), /*储位 */ msm05 varchar2(24), /*批号 */ msm06 varchar2(10) NOT NULL, /*生产部门 */ msm07 varchar2(255) /*备注 */ ); create unique index msm_pk on msm_file (msm01,msm06); alter table msm_file add constraint msm_pk primary key (msm01,msm06) enable validate; grant select on msm_file to public; grant index on msm_file to public; grant update on msm_file to public; grant delete on msm_file to public; grant insert on msm_file to public; |