/* ================================================================================ 档案代号:ayb_file 档案名称:股东权益分类对应会计科目档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table ayb_file ( ayb01 varchar2(10) NOT NULL, /*分类代码 */ ayb02 varchar2(24) NOT NULL, /*会计科目 */ ayb03 varchar2(1), /*no use */ ayb04 varchar2(255) /*no use */ ); create unique index ayb_pk on ayb_file (ayb01,ayb02); alter table ayb_file add constraint ayb_pk primary key (ayb01,ayb02) enable validate; grant select on ayb_file to public; grant index on ayb_file to public; grant update on ayb_file to public; grant delete on ayb_file to public; grant insert on ayb_file to public; |