/* ================================================================================ 档案代号:ooc_file 档案名称:科目类别目档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ooc_file ( ooc01 varchar2(1) NOT NULL, /*科目类别 */ ooc02 varchar2(80), /*科目类别说明 */ ooc03 varchar2(24), /*科目编号 */ ooc04 varchar2(24) /*第二科目编码 */ ); create unique index ooc_pk on ooc_file (ooc01); alter table ooc_file add constraint ooc_pk primary key (ooc01) enable validate; grant select on ooc_file to public; grant index on ooc_file to public; grant update on ooc_file to public; grant delete on ooc_file to public; grant insert on ooc_file to public; |