/*
================================================================================
档案代号:cmi_file
档案名称:人工/制费收集维护档
档案目的:
上游档案:
下游档案:
============.========================.==========================================
*/
create table cmi_file
(
cmi01       number(5) NOT NULL,      /*年度                                   */
cmi02       number(5) NOT NULL,      /*月份                                   */
cmi03       varchar2(10) NOT NULL,   /*成本中心                               */
cmi04       varchar2(1) NOT NULL,    /*类别                                   */
                                     /*类别 1.人工  2.制费                    */
cmi05       varchar2(24) NOT NULL,   /*科目编号                               */
cmi06       varchar2(10) NOT NULL,   /*部门                                   */
cmi07       varchar2(80),            /*科目名称 /说明                         */
cmi08       number(20,6),            /*当期余额                               */
cmi09       varchar2(1),             /*No Use                                 */
cmi10       varchar2(1),             /*No Use                                 */
cmiacti     varchar2(1),             /*资料有效码                             */
                                     /*系统维护                               */
cmiuser     varchar2(10),            /*资料所有者                             */
                                     /*系统维护                               */
cmigrup     varchar2(10),            /*资料所有群                             */
                                     /*系统维护                               */
cmimodu     varchar2(10),            /*资料更改者                             */
                                     /*系统维护                               */
cmidate     date,                    /*最近修改日                             */
                                     /*系统维护                               */
cmi051      varchar2(24)             /*科目代号二                             */
);

create unique index cmi_pk on cmi_file (cmi01,cmi02,cmi03,cmi04,cmi05,cmi06);
alter table cmi_file add  constraint cmi_pk primary key  (cmi01,cmi02,cmi03,cmi04,cmi05,cmi06) enable 
validate;
grant select on cmi_file to public;
grant index on cmi_file to public;
grant update on cmi_file to public;
grant delete on cmi_file to public;
grant insert on cmi_file to public;