/* ================================================================================ 档案代号:fik_file 档案名称:设备停机记录档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table fik_file ( fik01 varchar2(20) NOT NULL, /*设备编号 */ fik02 date NOT NULL, /*停机日期 */ fik03 varchar2(5) NOT NULL, /*停机时间 */ fik04 date, /*开机日期 */ fik05 varchar2(5), /*开机时间 */ fik06 varchar2(255), /*备注 */ fikuser varchar2(10), /*资料所有者 */ fikgrup varchar2(10), /*资料所有部门 */ fikmodu varchar2(10), /*资料修改者 */ fikdate date /*最近修改日 */ ); create unique index fik_pk on fik_file (fik01,fik02,fik03); alter table fik_file add constraint fik_pk primary key (fik01,fik02,fik03) enable validate; grant select on fik_file to public; grant index on fik_file to public; grant update on fik_file to public; grant delete on fik_file to public; grant insert on fik_file to public; |