/* ================================================================================ 档案代号:bmj_file 档案名称:料件/制造商承认资料维护 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table bmj_file ( bmj01 varchar2(40) NOT NULL, /*料件编号 */ bmj02 varchar2(10) NOT NULL, /*制造商 */ bmj03 varchar2(10) NOT NULL, /*供应商 */ bmj04 varchar2(40), /*厂商料号 */ bmj05 varchar2(10), /*送样编号 */ bmj06 date, /*送样日期 */ bmj07 varchar2(10), /*送样人 */ bmj08 varchar2(1), /*承认状态 */ bmj09 varchar2(4), /*No Use */ bmj10 varchar2(10), /*承认文号 */ bmj11 date, /*承认日期 */ bmj12 varchar2(255), /*备注 */ bmj13 varchar2(1), /*No Use */ bmj14 varchar2(1), /*No Use */ bmj15 varchar2(1), /*No Use */ bmj99 varchar2(18), /*No Use */ bmjacti varchar2(1), /*资料有效码 */ bmjuser varchar2(10), /*资料所有者 */ bmjgrup varchar2(10), /*资料所有部门 */ bmjmodu varchar2(10), /*资料修改者 */ bmjdate date /*最近修改日 */ ); create unique index bmj_pk on bmj_file (bmj01,bmj02,bmj03); alter table bmj_file add constraint bmj_pk primary key (bmj01,bmj02,bmj03) enable validate; grant select on bmj_file to public; grant index on bmj_file to public; grant update on bmj_file to public; grant delete on bmj_file to public; grant insert on bmj_file to public; |