/*
================================================================================
档案代号:azv_file
档案名称:料件承认修改记录
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table azv_file
(
azv01       varchar2(40),            /*料件编号                               */
azv02       varchar2(10),            /*制造商                                 */
azv03       varchar2(10),            /*供应商                                 */
azv04       varchar2(10),            /*承认文号                               */
azv05       date,                    /*承认日期                               */
azv06       varchar2(1),             /*承认状态                               */
                                     /*承认状态 0.已送样 1.测试中 2.会签中 3.已*/
                                     /*承认                                   */
azv07       varchar2(10),            /*异动人员                               */
azv08       date,                    /*异动日期                               */
azv09       varchar2(10),            /*异动时间                               */
azv10       varchar2(255)            /*说明                                   */
);

create        index azv_01 on azv_file (azv01,azv02,azv07);
create        index azv_02 on azv_file (azv09);
grant select on azv_file to public;
grant index on azv_file to public;
grant update on azv_file to public;
grant delete on azv_file to public;
grant insert on azv_file to public;