/* ================================================================================ 档案代号:npr_file 档案名称:子系统各期统计开帐 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table npr_file ( npr00 varchar2(24) NOT NULL, /*科目编号 */ npr01 varchar2(10) NOT NULL, /*对象 */ npr02 varchar2(40) NOT NULL, /*对象简称 */ npr03 varchar2(10) NOT NULL, /*部门 */ npr04 number(5) NOT NULL, /*年度 */ npr05 number(5) NOT NULL, /*期别 */ npr06f number(20,6), /*原币金额 */ npr06 number(20,6), /*本币金额 */ npr07f number(20,6), /*原币金额 */ npr07 number(20,6), /*本币金额 */ npr08 varchar2(10) NOT NULL, /*营运中心编号 */ npr09 varchar2(5) NOT NULL, /*帐别 */ npr10 varchar2(1) NOT NULL, /*来源 */ npr11 varchar2(4) NOT NULL /*币别 */ ); create index npr_02 on npr_file (npr01,npr02); create unique index npr_pk on npr_file (npr08,npr09,npr00,npr10,npr01,npr02,npr03,npr11,npr04,npr05); alter table npr_file add constraint npr_pk primary key (npr08,npr09,npr00,npr10,npr01,npr02,npr03,npr11,npr04,npr05) enable validate; grant select on npr_file to public; grant index on npr_file to public; grant update on npr_file to public; grant delete on npr_file to public; grant insert on npr_file to public; |