/*
================================================================================
档案代号: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;