/* ================================================================================ 档案代号: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; |