/* ================================================================================ 档案代号:bmi_file 档案名称:机种代号维护档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table bmi_file ( bmi01 varchar2(5) NOT NULL, /*机种代码 */ bmi02 varchar2(80), /*机种说明 */ bmiacti varchar2(1), /*资料有效码 */ bmiuser varchar2(10), /*资料所有者 */ bmigrup varchar2(10), /*资料所有部门 */ bmimodu varchar2(10), /*资料修改者 */ bmidate date /*最近修改日 */ ); create unique index bmi_pk on bmi_file (bmi01); alter table bmi_file add constraint bmi_pk primary key (bmi01) enable validate; grant select on bmi_file to public; grant index on bmi_file to public; grant update on bmi_file to public; grant delete on bmi_file to public; grant insert on bmi_file to public; |