/* ================================================================================ 档案代号:nnb_file 档案名称:融资贷款备注 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table nnb_file ( nnb01 varchar2(16) NOT NULL, /*相关单号 */ nnb02 varchar2(1) NOT NULL, /*资料性质 */ /*1:短期融资 */ /*2:中长期贷款 */ nnb03 number(5) NOT NULL, /*行序 */ nnb04 varchar2(255) /*说明 */ ); create unique index nnb_pk on nnb_file (nnb01,nnb02,nnb03); alter table nnb_file add constraint nnb_pk primary key (nnb01,nnb02,nnb03) enable validate; grant select on nnb_file to public; grant index on nnb_file to public; grant update on nnb_file to public; grant delete on nnb_file to public; grant insert on nnb_file to public; |