/*
================================================================================
档案代号:fam_file
档案名称:固定资产备注档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fam_file
(
fam00       varchar2(1) NOT NULL,    /*类别                                   */
                                     /*类别 0.底稿资料 1.基本资料 2.异动单据  */
fam01       varchar2(16) NOT NULL,   /*单据号码/财产编号                      */
fam02       number(5) NOT NULL,      /*项次                                   */
                                     /*项次 (0 表示整张备注,123...表示单身备注)*/
fam03       number(5) NOT NULL,      /*行序                                   */
fam04       varchar2(1),             /*列印码                                 */
                                     /*列印码(1.列印于前 2.列印于后 0.内部参考)*/
fam05       varchar2(255)            /*备注                                   */
);

create unique index fam_pk on fam_file (fam00,fam01,fam02,fam03);
alter table fam_file add  constraint fam_pk primary key  (fam00,fam01,fam02,fam03) enable validate;
grant select on fam_file to public;
grant index on fam_file to public;
grant update on fam_file to public;
grant delete on fam_file to public;
grant insert on fam_file to public;