/* ================================================================================ 档案代号:oar_file 档案名称:多角贸易营运中心编号发票/税别设定 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table oar_file ( oar01 varchar2(2) NOT NULL, /*流程代码 */ oar02 varchar2(10) NOT NULL, /*营运中心编号 */ oar03 varchar2(1), /*发票别 */ oar04 varchar2(4) /*发票税别 */ ); create unique index oar_pk on oar_file (oar01,oar02); alter table oar_file add constraint oar_pk primary key (oar01,oar02) enable validate; grant select on oar_file to public; grant index on oar_file to public; grant update on oar_file to public; grant delete on oar_file to public; grant insert on oar_file to public; |