/*
================================================================================
档案代号:fck_file
档案名称:固定资产投资抵减享用年度档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fck_file
(
fck01       varchar2(16) NOT NULL,   /*申请编号                               */
fck02       number(5) NOT NULL,      /*项次                                   */
fck04       number(20,6),            /*抵减金额                               */
fck05       number(5) NOT NULL,      /*享用年度                               */
fckconf     varchar2(1)              /*确认码                                 */
);

create unique index fck_pk on fck_file (fck01,fck02,fck05);
alter table fck_file add  constraint fck_pk primary key  (fck01,fck02,fck05) enable validate;
grant select on fck_file to public;
grant index on fck_file to public;
grant update on fck_file to public;
grant delete on fck_file to public;
grant insert on fck_file to public;