/* ================================================================================ 档案代号:wsr_file 档案名称: 档案目的: 上游档案: 下游档案: ============.========================.========================================== */ create table wsr_file ( wsr01 varchar2(40) DEFAULT '' NOT NULL, /*服务代码*/ wsr02 varchar2(1) DEFAULT '' NOT NULL, /*存取模式*/ wsr03 varchar2(80) DEFAULT '' NOT NULL, /*服务说明*/ wsr04 varchar2(40) DEFAULT '' NOT NULL, /*对应 erp 函式名称*/ wsracti varchar2(1), /*资料有效码 */ wsrdate date, /*最后异动日期 */ wsrgrup varchar2(6), /*资料所有群 */ wsrmodu varchar2(10), /*资料更改者 */ wsruser varchar2(10) /*资料所有者 */ ); create unique index wsr_pk on wsr_file (wsr01,wsr02); alter table wsr_file add constraint wsr_pk primary key (wsr01,wsr02) enable validate; grant select on wsr_file to public; grant index on wsr_file to public; grant update on wsr_file to public; grant delete on wsr_file to public; grant insert on wsr_file to public; |