/*
================================================================================
档案代号: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;