/* ================================================================================ 档案代号:nnq_file 档案名称:合约借款额度摘要档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table nnq_file ( nnq01 varchar2(10) NOT NULL, /*合约号码 */ nnq02 number(5) NOT NULL, /*项次 */ nnq03 number(5) NOT NULL, /*行序 */ nnq04 varchar2(255), /*限制条款 */ nnq05 varchar2(255) /*摘要性质 */ ); create unique index nnq_pk on nnq_file (nnq01,nnq02,nnq03); alter table nnq_file add constraint nnq_pk primary key (nnq01,nnq02,nnq03) enable validate; grant select on nnq_file to public; grant index on nnq_file to public; grant update on nnq_file to public; grant delete on nnq_file to public; grant insert on nnq_file to public; |