/* ================================================================================ 档案代号:fii_file 档案名称:设备系列型号资料单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table fii_file ( fii01 varchar2(30) NOT NULL, /*系列号 */ fii02 varchar2(30) NOT NULL, /*型号 */ fii03 varchar2(300), /*安全说明 */ fii04 varchar2(1), /*No Use */ fii05 varchar2(1), /*No Use */ fii06 varchar2(1), /*No Use */ fii07 varchar2(1), /*No Use */ fii08 varchar2(1), /*No Use */ fii09 varchar2(1), /*No Use */ fii10 varchar2(1), /*No Use */ fiiacti varchar2(1), /*资料有效码 */ fiiuser varchar2(10), /*资料所有者 */ fiigrup varchar2(10), /*资料所有部门 */ fiimodu varchar2(10), /*最后修改人员 */ fiidate date /*最后修改日期 */ ); create unique index fii_pk on fii_file (fii01,fii02); alter table fii_file add constraint fii_pk primary key (fii01,fii02) enable validate; grant select on fii_file to public; grant index on fii_file to public; grant update on fii_file to public; grant delete on fii_file to public; grant insert on fii_file to public; |