/* ================================================================================ 档案代号:fiu_file 档案名称:设备保养周期档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table fiu_file ( fiu01 varchar2(2) NOT NULL, /*保养周期编号 */ fiu02 varchar2(80), /*说明 */ fiuacti varchar2(1), /*资料有效码 */ fiuuser varchar2(10), /*资料所有者 */ fiugrup varchar2(10), /*资料所有部门 */ fiumodu varchar2(10), /*最后修改人员 */ fiudate date /*最后修改日期 */ ); create unique index fiu_pk on fiu_file (fiu01); alter table fiu_file add constraint fiu_pk primary key (fiu01) enable validate; grant select on fiu_file to public; grant index on fiu_file to public; grant update on fiu_file to public; grant delete on fiu_file to public; grant insert on fiu_file to public; |