/*
================================================================================
档案代号:bzm_file
档案名称:保税机器设备报废/除帐单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bzm_file
(
bzm01       varchar2(16) NOT NULL,   /*报废/除帐单号                          */
bzm02       number(5) NOT NULL,      /*项次                                   */
bzm03       varchar2(20),            /*机器设备编号                           */
bzm04       number(5),               /*序号                                   */
bzm05       number(15,3),            /*报废/除帐数量                          */
bzm06       varchar2(255),           /*备注                                   */
bzm07       varchar2(1),             /*No Use                                 */
bzm08       varchar2(1),             /*No Use                                 */
bzm09       varchar2(1),             /*No Use                                 */
bzm10       varchar2(1),             /*No Use                                 */
bzmud01     varchar2(255),           /*自订栏位-Textedit                      */
bzmud02     varchar2(40),            /*自订栏位-文字                          */
bzmud03     varchar2(40),            /*自订栏位-文字                          */
bzmud04     varchar2(40),            /*自订栏位-文字                          */
bzmud05     varchar2(40),            /*自订栏位-文字                          */
bzmud06     varchar2(40),            /*自订栏位-文字                          */
bzmud07     number(15,3),            /*自订栏位-数值                          */
bzmud08     number(15,3),            /*自订栏位-数值                          */
bzmud09     number(15,3),            /*自订栏位-数值                          */
bzmud10     number(10),              /*自订栏位-整数                          */
bzmud11     number(10),              /*自订栏位-整数                          */
bzmud12     number(10),              /*自订栏位-整数                          */
bzmud13     date,                    /*自订栏位-日期                          */
bzmud14     date,                    /*自订栏位-日期                          */
bzmud15     date                     /*自订栏位-日期                          */
);

create unique index bzm_pk on bzm_file (bzm01,bzm02);
alter table bzm_file add  constraint bzm_pk primary key  (bzm01,bzm02) enable validate;
grant select on bzm_file to public;
grant index on bzm_file to public;
grant update on bzm_file to public;
grant delete on bzm_file to public;
grant insert on bzm_file to public;