/* ================================================================================ 档案代号:oqe_file 档案名称:估价单资料备注说明档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table oqe_file ( oqe01 varchar2(16) NOT NULL, /*估价单代号 */ oqe02 number(5) NOT NULL, /*估价单代号项次 */ /*单头的编号为:0 */ oqe03 number(5) NOT NULL, /*行序 */ oqe04 varchar2(255) /*说明 */ ); create unique index oqe_pk on oqe_file (oqe01,oqe02,oqe03); alter table oqe_file add constraint oqe_pk primary key (oqe01,oqe02,oqe03) enable validate; grant select on oqe_file to public; grant index on oqe_file to public; grant update on oqe_file to public; grant delete on oqe_file to public; grant insert on oqe_file to public; |