/*
================================================================================
档案代号:fdc_file
档案名称:保险单身档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table fdc_file
(
fdc01       varchar2(16) NOT NULL,   /*保单编号                               */
fdc02       number(5) NOT NULL,      /*序号                                   */
fdc03       varchar2(10),            /*财产编号                               */
fdc032      varchar2(4),             /*附号                                   */
fdc04       number(5),               /*标的序号                               */
fdc05       varchar2(10),            /*折旧部门                               */
fdc06       number(20,6),            /*未折余额                               */
fdc07       number(20,6),            /*保险金额                               */
fdc08       number(9,4),             /*保险费率                               */
fdc09       number(20,6),            /*保险费                                 */
fdc10       number(20,6),            /*预付保险费                             */
fdc11       number(20,6),            /*已摊保费                               */
fdc12       varchar2(80),            /*中文名称                               */
fdc13       varchar2(1)              /*No Use                                 */
);

create        index fdc_02 on fdc_file (fdc03,fdc032);
create unique index fdc_pk on fdc_file (fdc01,fdc02);
alter table fdc_file add  constraint fdc_pk primary key  (fdc01,fdc02) enable validate;
grant select on fdc_file to public;
grant index on fdc_file to public;
grant update on fdc_file to public;
grant delete on fdc_file to public;
grant insert on fdc_file to public;