/* ================================================================================ 档案代号:hjb_file 档案名称:TIPTOP GP函式功能动态记录表 档案目的:系统函式功能动态记录 上游档案: 下游档案: ============.========================.========================================== */ create table hjb_file ( hjb01 varchar2(20) NOT NULL, /*档案名称 */ hjb02 varchar2(80) NOT NULL, /*函式名称 */ hjb03 varchar2(1), /*重要性代码 */ hjb04 varchar2(255), /*功能描述 */ hjb05 varchar2(255), /*传入值 */ hjb06 varchar2(255), /*传回值 */ hjb07 varchar2(255), /*使用范例 */ hjb08 varchar2(255), /*备注说明 */ hjbmodu date, /*hjbmodu */ hjbuser varchar2(10) /*hjbuser */ ); create unique index hjb_pk on hjb_file (hjb01,hjb02); alter table hjb_file add constraint hjb_pk primary key (hjb01,hjb02) enable validate; grant select on hjb_file to public; grant index on hjb_file to public; grant update on hjb_file to public; grant delete on hjb_file to public; grant insert on hjb_file to public; |