/* ================================================================================ 档案代号:wsb_file 档案名称:EasyFlow 整合资料单身档 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table wsb_file ( wsb01 varchar2(20) NOT NULL, /*程式代号 */ wsb02 varchar2(1) NOT NULL, /*栏位性质 */ /*正确值 1/2 */ /*1:单头栏位 */ /*2:单身栏位 */ wsb03 varchar2(30) NOT NULL, /*栏位名称 */ wsb04 varchar2(20) /*参照栏位 */ ); create unique index wsb_pk on wsb_file (wsb01,wsb02,wsb03); alter table wsb_file add constraint wsb_pk primary key (wsb01,wsb02,wsb03) enable validate; grant select on wsb_file to public; grant index on wsb_file to public; grant update on wsb_file to public; grant delete on wsb_file to public; grant insert on wsb_file to public; |