/*
================================================================================
档案代号:fcg_file
档案名称:固定资产解除设定单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fcg_file
(
fcg01       varchar2(30) NOT NULL,   /*解除文号                               */
fcg02       number(5) NOT NULL,      /*项次                                   */
fcg03       varchar2(10),            /*财产编号                               */
fcg031      varchar2(4),             /*附号                                   */
fcg04       varchar2(16),            /*申请编号                               */
fcg041      number(5),               /*申请项次                               */
fcg05       number(20,6),            /*抵押金额                               */
fcg06       date,                    /*清偿日期                               */
fcg07       varchar2(4)              /*解除原因                               */
);

create unique index fcg_pk on fcg_file (fcg01,fcg02);
alter table fcg_file add  constraint fcg_pk primary key  (fcg01,fcg02) enable validate;
grant select on fcg_file to public;
grant index on fcg_file to public;
grant update on fcg_file to public;
grant delete on fcg_file to public;
grant insert on fcg_file to public;