/* ================================================================================ 档案代号:fbm_file 档案名称:固定资产存放位置异动单(单身) 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table fbm_file ( fbm01 varchar2(16) NOT NULL, /*单号 */ fbm02 number(5) NOT NULL, /*项次 */ fbm03 varchar2(10), /*财产编号 */ fbm031 varchar2(4), /*附号 */ fbm04 varchar2(10), /*保管人 */ fbm05 varchar2(10), /*保管部门 */ fbm06 varchar2(10), /*放置地点 */ fbmud01 varchar2(255), /*自订栏位-Textedit */ fbmud02 varchar2(40), /*自订栏位-文字 */ fbmud03 varchar2(40), /*自订栏位-文字 */ fbmud04 varchar2(40), /*自订栏位-文字 */ fbmud05 varchar2(40), /*自订栏位-文字 */ fbmud06 varchar2(40), /*自订栏位-文字 */ fbmud07 number(15,3), /*自订栏位-数值 */ fbmud08 number(15,3), /*自订栏位-数值 */ fbmud09 number(15,3), /*自订栏位-数值 */ fbmud10 number(10), /*自订栏位-整数 */ fbmud11 number(10), /*自订栏位-整数 */ fbmud12 number(10), /*自订栏位-整数 */ fbmud13 date, /*自订栏位-日期 */ fbmud14 date, /*自订栏位-日期 */ fbmud15 date /*自订栏位-日期 */ ); create unique index fbm_02 on fbm_file (fbm01,fbm03,fbm031); create unique index fbm_pk on fbm_file (fbm01,fbm02); alter table fbm_file add constraint fbm_pk primary key (fbm01,fbm02) enable validate; grant select on fbm_file to public; grant index on fbm_file to public; grant update on fbm_file to public; grant delete on fbm_file to public; grant insert on fbm_file to public; |