/* ================================================================================ 档案代号:she_file 档案名称:工单序号档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table she_file ( she01 varchar2(16) NOT NULL, /*工单编号 */ she02 varchar2(15) NOT NULL /*序号 */ ); create unique index she_pk on she_file (she01,she02); alter table she_file add constraint she_pk primary key (she01,she02) enable validate; grant select on she_file to public; grant index on she_file to public; grant update on she_file to public; grant delete on she_file to public; grant insert on she_file to public; |