/*
================================================================================
档案代号:oao_file
档案名称:单据备注档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table oao_file
(
oao01       varchar2(16) NOT NULL,   /*单据单号                               */
oao03       number(5) NOT NULL,      /*项次                                   */
                                     /*项次 (0 表示整张备注,123...表示单身备注)*/
oao04       number(5) NOT NULL,      /*行序                                   */
oao05       varchar2(1) NOT NULL,    /*列印码                                 */
                                     /*列印码(1.列印于前 2.列印于后 0.内部参考)*/
oao06       varchar2(255)            /*备注                                   */
                                     /*备注 (单身备注且列印于后, 限制char(30))*/
);

create unique index oao_pk on oao_file (oao01,oao03,oao05,oao04);
alter table oao_file add  constraint oao_pk primary key  (oao01,oao03,oao05,oao04) enable validate;
grant select on oao_file to public;
grant index on oao_file to public;
grant update on oao_file to public;
grant delete on oao_file to public;
grant insert on oao_file to public;