/*
================================================================================
档案代号:hja_file
档案名称:Fourjs License使用数量记录表
档案目的:Fourjs License使用数量记录表
上游档案:
下游档案:
============.========================.==========================================
*/
create table hja_file
(
hja01       number(5) NOT NULL,      /*序号                                   */
hja02       date NOT NULL,           /*记录时间                               */
hja03       number(5),               /*runtime accepted                       */
hja04       number(5),               /*runtime rejected                       */
hja05       number(5),               /*runtime problem                        */
hja06       number(5),               /*compile accepted                       */
hja07       number(5),               /*compile rejected                       */
hja08       number(5),               /*compile problem                        */
hja09       number(5),               /*extension accepted                     */
hja10       number(5),               /*extension rejected                     */
hja11       number(5),               /*extension problem                      */
hja12       number(5),               /*end runtime                            */
hja13       number(5),               /*pid request                            */
hja14       number(5),               /*information                            */
hja15       number(5),               /*bad license                            */
hja16       number(5),               /*stop server                            */
hja17       number(5),               /*delect license                         */
hja18       number(5),               /*unknow                                 */
hja19       varchar2(255),           /*备注                                   */
hja20       number(5),               /*runtime occupied                       */
hja21       number(5),               /*runtime total                          */
hja22       number(5),               /*compile occupied                       */
hja23       number(5)                /*compile total                          */
);

create unique index hja_pk on hja_file (hja01);
alter table hja_file add  constraint hja_pk primary key  (hja01) enable validate;
grant select on hja_file to public;
grant index on hja_file to public;
grant update on hja_file to public;
grant delete on hja_file to public;
grant insert on hja_file to public;