/* ================================================================================ 档案代号:fiq_file 档案名称:设备检查记录单头档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table fiq_file ( fiq00 varchar2(1), /*资料来源 */ /*1:仪表 2:手动 */ fiq01 varchar2(16) NOT NULL, /*检查单号 */ fiq02 varchar2(20), /*设备编号 */ fiq03 date, /*检查日期 */ fiq04 varchar2(5), /*检查时间 */ fiq05 date, /*完成日期 */ fiq06 varchar2(5), /*完成时间 */ fiq07 varchar2(10), /*检查员 */ fiq08 varchar2(10), /*厂商编号 */ fiq09 varchar2(300), /*问题描述 */ fiq11 varchar2(1), /*No Use */ fiq12 varchar2(1), /*No Use */ fiqconf varchar2(1), /*资料确认码 */ fiqacti varchar2(1), /*资料有效码 */ fiquser varchar2(10), /*资料所有者 */ fiqgrup varchar2(10), /*资料所有部门 */ fiqmodu varchar2(10), /*最后修改人员 */ fiqdate date, /*最后修改日期 */ fiqud01 varchar2(255), /*自订栏位-Textedit */ fiqud02 varchar2(40), /*自订栏位-文字 */ fiqud03 varchar2(40), /*自订栏位-文字 */ fiqud04 varchar2(40), /*自订栏位-文字 */ fiqud05 varchar2(40), /*自订栏位-文字 */ fiqud06 varchar2(40), /*自订栏位-文字 */ fiqud07 number(15,3), /*自订栏位-数值 */ fiqud08 number(15,3), /*自订栏位-数值 */ fiqud09 number(15,3), /*自订栏位-数值 */ fiqud10 number(10), /*自订栏位-整数 */ fiqud11 number(10), /*自订栏位-整数 */ fiqud12 number(10), /*自订栏位-整数 */ fiqud13 date, /*自订栏位-日期 */ fiqud14 date, /*自订栏位-日期 */ fiqud15 date /*自订栏位-日期 */ ); create unique index fiq_pk on fiq_file (fiq01); alter table fiq_file add constraint fiq_pk primary key (fiq01) enable validate; grant select on fiq_file to public; grant index on fiq_file to public; grant update on fiq_file to public; grant delete on fiq_file to public; grant insert on fiq_file to public; |