/*
================================================================================
档案代号:bze_file
档案名称:保税机器设备盘点底稿单头档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table bze_file
(
bze01       varchar2(10) NOT NULL,   /*盘点编号                               */
bze02       date,                    /*盘点日期                               */
bze03       varchar2(255),           /*备注                                   */
bze04       number(5),               /*盘点年度                               */
bze05       varchar2(10),            /*确认人                                 */
bze06       date,                    /*确认日期                               */
bze07       varchar2(1),             /*确认码                                 */
                                     /*(Y/N/X)                                */
bze08       varchar2(1),             /*No Use                                 */
bze09       varchar2(1),             /*No Use                                 */
bze10       varchar2(1),             /*No Use                                 */
bzeacti     varchar2(1),             /*资料有效码                             */
bzeuser     varchar2(10),            /*资料所有者                             */
bzegrup     varchar2(10),            /*资料所有部门                           */
bzemodu     varchar2(10),            /*资料修改者                             */
bzedate     date                     /*最近修改日                             */
);

create unique index bze_pk on bze_file (bze01);
alter table bze_file add  constraint bze_pk primary key  (bze01) enable validate;
grant select on bze_file to public;
grant index on bze_file to public;
grant update on bze_file to public;
grant delete on bze_file to public;
grant insert on bze_file to public;