/* ================================================================================ 档案代号:fir_file 档案名称:设备检查记录单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table fir_file ( fir01 varchar2(16) NOT NULL, /*检查单号 */ fir02 number(5) NOT NULL, /*序号 */ fir03 varchar2(4), /*项目 */ fir04 varchar2(1), /*项目判定 */ firud01 varchar2(255), /*自订栏位-Textedit */ firud02 varchar2(40), /*自订栏位-文字 */ firud03 varchar2(40), /*自订栏位-文字 */ firud04 varchar2(40), /*自订栏位-文字 */ firud05 varchar2(40), /*自订栏位-文字 */ firud06 varchar2(40), /*自订栏位-文字 */ firud07 number(15,3), /*自订栏位-数值 */ firud08 number(15,3), /*自订栏位-数值 */ firud09 number(15,3), /*自订栏位-数值 */ firud10 number(10), /*自订栏位-整数 */ firud11 number(10), /*自订栏位-整数 */ firud12 number(10), /*自订栏位-整数 */ firud13 date, /*自订栏位-日期 */ firud14 date, /*自订栏位-日期 */ firud15 date /*自订栏位-日期 */ ); create unique index fir_pk on fir_file (fir01,fir02); alter table fir_file add constraint fir_pk primary key (fir01,fir02) enable validate; grant select on fir_file to public; grant index on fir_file to public; grant update on fir_file to public; grant delete on fir_file to public; grant insert on fir_file to public; |