
    create table WEBINTERFACE (
        "UUID" raw(16),
        "NAME" varchar2(100 char),
        "ACTIVE" number(5,0),
        "URL" varchar2(200 char),
        "API_KEY" varchar2(40 char),
        "GET_IMPLEMENTATION" varchar2(200 char),
        "GET_ENTITY" raw(16),
        "POST_IMPLEMENTATION" varchar2(200 char),
        "POST_ENTITY" raw(16),
        "PUT_IMPLEMENTATION" varchar2(200 char),
        "PUT_ENTITY" raw(16),
        "DELETE_IMPLEMENTATION" varchar2(200 char),
        "DELETE_ENTITY" raw(16),
        "CREATED_ON" date,
        "MODIFIED_ON" date,
        "RWDU" number(5,0),
        "CREATED_BY" varchar2(20 char),
        "MODIFIED_BY" varchar2(20 char),
        "OWN_LIC" varchar2(4 char),
        "OPC" varchar2(8 char),
        "OWNER" number(5,0),
        "GROUP" number(5,0),
        "ANY" number(5,0),
        "WEBHASH" raw(16),
        "LOGLEVEL" number(10,0)
    );

    alter table WEBINTERFACE add constraint PID590DT590 primary key ("UUID");

    alter table WEBINTERFACE MODIFY ("UUID" DEFAULT SYS_GUID());

    alter table WEBINTERFACE 
        add constraint DT590UUID_NOT_NULL check("UUID" is not null);

    alter table WEBINTERFACE MODIFY ("ACTIVE" DEFAULT 0);

    alter table WEBINTERFACE MODIFY ("CREATED_ON" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));

    alter table WEBINTERFACE MODIFY ("MODIFIED_ON" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));

    alter table WEBINTERFACE MODIFY ("RWDU" DEFAULT 0);

    alter table WEBINTERFACE MODIFY ("OWNER" DEFAULT 0);

    alter table WEBINTERFACE MODIFY ("GROUP" DEFAULT 0);

    alter table WEBINTERFACE MODIFY ("ANY" DEFAULT 0);

    alter table WEBINTERFACE MODIFY ("LOGLEVEL" DEFAULT 0);

    create table WEBATTRPARA (
        "UUID" raw(16),
        "WEB_ATTRIBUTE" raw(16),
        "NAME" varchar2(100 char),
        "VALUE" varchar2(1000 char),
        "POSITION" number(5,0),
        "CREATED_ON" date,
        "MODIFIED_ON" date,
        "RWDU" number(5,0),
        "CREATED_BY" varchar2(20 char),
        "MODIFIED_BY" varchar2(20 char),
        "OWN_LIC" varchar2(4 char),
        "OPC" varchar2(8 char),
        "OWNER" number(5,0),
        "GROUP" number(5,0),
        "ANY" number(5,0)
    );

    alter table WEBATTRPARA add constraint PID591DT591 primary key ("UUID");

    alter table WEBATTRPARA MODIFY ("UUID" DEFAULT SYS_GUID());

    alter table WEBATTRPARA 
        add constraint DT591UUID_NOT_NULL check("UUID" is not null);

    alter table WEBATTRPARA MODIFY ("POSITION" DEFAULT 0);

    alter table WEBATTRPARA MODIFY ("CREATED_ON" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));

    alter table WEBATTRPARA MODIFY ("MODIFIED_ON" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));

    alter table WEBATTRPARA MODIFY ("RWDU" DEFAULT 0);

    alter table WEBATTRPARA MODIFY ("OWNER" DEFAULT 0);

    alter table WEBATTRPARA MODIFY ("GROUP" DEFAULT 0);

    alter table WEBATTRPARA MODIFY ("ANY" DEFAULT 0);

    create table WEBENTITY (
        "UUID" raw(16),
        "DATATABLE" varchar2(4 char),
        "NAME" varchar2(400 char),
        "CREATED_ON" date,
        "MODIFIED_ON" date,
        "RWDU" number(5,0),
        "CREATED_BY" varchar2(20 char),
        "MODIFIED_BY" varchar2(20 char),
        "OWN_LIC" varchar2(4 char),
        "OPC" varchar2(8 char),
        "OWNER" number(5,0),
        "GROUP" number(5,0),
        "ANY" number(5,0)
    );

    alter table WEBENTITY add constraint PID592DT592 primary key ("UUID");

    alter table WEBENTITY 
        add constraint FKWEBENTITYID415 
        foreign key ("DATATABLE") 
        references DT415        
        on delete cascade
        deferrable
        novalidate;
    alter table WEBENTITY enable validate constraint FKWEBENTITYID415;

    create index IDX_WEBENTITYID415 on WEBENTITY ("DATATABLE");

    alter table WEBENTITY MODIFY ("UUID" DEFAULT SYS_GUID());

    alter table WEBENTITY 
        add constraint DT592UUID_NOT_NULL check("UUID" is not null);

    alter table WEBENTITY 
        add constraint DT592DATATABLE_NOT_NULL check("DATATABLE" is not null);

    alter table WEBENTITY MODIFY ("CREATED_ON" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));

    alter table WEBENTITY MODIFY ("MODIFIED_ON" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));

    alter table WEBENTITY MODIFY ("RWDU" DEFAULT 0);

    alter table WEBENTITY MODIFY ("OWNER" DEFAULT 0);

    alter table WEBENTITY MODIFY ("GROUP" DEFAULT 0);

    alter table WEBENTITY MODIFY ("ANY" DEFAULT 0);

    create table WEBATTRIBUTE (
        "UUID" raw(16),
        "WEB_ENTITY" raw(16),
        "DATAITEM" varchar2(6 char),
        "MANDATORY" number(5,0),
        "NAME" varchar2(80 char),
        "TRANSFORMER" varchar2(120 char),
        "CREATED_ON" date,
        "MODIFIED_ON" date,
        "RWDU" number(5,0),
        "CREATED_BY" varchar2(20 char),
        "MODIFIED_BY" varchar2(20 char),
        "OWN_LIC" varchar2(4 char),
        "OPC" varchar2(8 char),
        "OWNER" number(5,0),
        "GROUP" number(5,0),
        "ANY" number(5,0)
    );

    alter table WEBATTRIBUTE add constraint PID593DT593 primary key ("UUID");

    alter table WEBATTRIBUTE 
        add constraint FKWEBATTRIBUTEID592 
        foreign key ("WEB_ENTITY") 
        references WEBENTITY        
        on delete cascade
        deferrable
        novalidate;
    alter table WEBATTRIBUTE enable validate constraint FKWEBATTRIBUTEID592;

    create index IDX_WEBATTRIBUTEID592 on WEBATTRIBUTE ("WEB_ENTITY");

    alter table WEBATTRIBUTE MODIFY ("UUID" DEFAULT SYS_GUID());

    alter table WEBATTRIBUTE 
        add constraint DT593UUID_NOT_NULL check("UUID" is not null);

    alter table WEBATTRIBUTE 
        add constraint DT593WEB_ENTITY_NOT_NULL check("WEB_ENTITY" is not null);

    alter table WEBATTRIBUTE MODIFY ("MANDATORY" DEFAULT 0);

    alter table WEBATTRIBUTE MODIFY ("CREATED_ON" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));

    alter table WEBATTRIBUTE MODIFY ("MODIFIED_ON" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));

    alter table WEBATTRIBUTE MODIFY ("RWDU" DEFAULT 0);

    alter table WEBATTRIBUTE MODIFY ("OWNER" DEFAULT 0);

    alter table WEBATTRIBUTE MODIFY ("GROUP" DEFAULT 0);

    alter table WEBATTRIBUTE MODIFY ("ANY" DEFAULT 0);

    create table WEBPARAMETER (
        "UUID" raw(16),
        "WEB_INTERFACE" raw(16),
        "NAME" varchar2(80 char),
        "APPLY_TO" varchar2(6 char),
        "FILTER_TYPE" number(10,0),
        "CREATED_ON" date,
        "MODIFIED_ON" date,
        "RWDU" number(5,0),
        "CREATED_BY" varchar2(20 char),
        "MODIFIED_BY" varchar2(20 char),
        "OWN_LIC" varchar2(4 char),
        "OPC" varchar2(8 char),
        "OWNER" number(5,0),
        "GROUP" number(5,0),
        "ANY" number(5,0),
        "POSITION" number(5,0)
    );

    alter table WEBPARAMETER add constraint PID594DT594 primary key ("UUID");

    alter table WEBPARAMETER 
        add constraint FKWEBPARAMETERID590 
        foreign key ("WEB_INTERFACE") 
        references WEBINTERFACE        
        on delete cascade
        deferrable
        novalidate;
    alter table WEBPARAMETER enable validate constraint FKWEBPARAMETERID590;

    create index IDX_WEBPARAMETERID590 on WEBPARAMETER ("WEB_INTERFACE");

    alter table WEBPARAMETER MODIFY ("UUID" DEFAULT SYS_GUID());

    alter table WEBPARAMETER 
        add constraint DT594UUID_NOT_NULL check("UUID" is not null);

    alter table WEBPARAMETER 
        add constraint DT594WEB_INTERFACE_NOT_NULL check("WEB_INTERFACE" is not null);

    alter table WEBPARAMETER MODIFY ("FILTER_TYPE" DEFAULT 0);

    alter table WEBPARAMETER MODIFY ("CREATED_ON" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));

    alter table WEBPARAMETER MODIFY ("MODIFIED_ON" DEFAULT TO_DATE('01.01.1970','DD.MM.YYYY'));

    alter table WEBPARAMETER MODIFY ("RWDU" DEFAULT 0);

    alter table WEBPARAMETER MODIFY ("OWNER" DEFAULT 0);

    alter table WEBPARAMETER MODIFY ("GROUP" DEFAULT 0);

    alter table WEBPARAMETER MODIFY ("ANY" DEFAULT 0);

    alter table WEBPARAMETER MODIFY ("POSITION" DEFAULT 0);

    create table WEBREQUEST (
        "UUID" raw(16),
        "WEB_INTERFACE" raw(16),
        "TIMESTAMP" varchar2(20 char),
        "SUCCESS" number(5,0),
        "DURATION" number(10,0),
        "METHOD" varchar2(20 char)
    );

    alter table WEBREQUEST add constraint PID595DT595 primary key ("UUID");

    alter table WEBREQUEST 
        add constraint FKWEBREQUESTID590 
        foreign key ("WEB_INTERFACE") 
        references WEBINTERFACE        
        on delete cascade
        deferrable
        novalidate;
    alter table WEBREQUEST enable validate constraint FKWEBREQUESTID590;

    create index IDX_WEBREQUESTID590 on WEBREQUEST ("WEB_INTERFACE");

    alter table WEBREQUEST MODIFY ("UUID" DEFAULT SYS_GUID());

    alter table WEBREQUEST 
        add constraint DT595UUID_NOT_NULL check("UUID" is not null);

    alter table WEBREQUEST MODIFY ("SUCCESS" DEFAULT 0);

    alter table WEBREQUEST MODIFY ("DURATION" DEFAULT 0);

    create table WEBLOGGING (
        "UUID" raw(16),
        "REQUEST" raw(16),
        "TEXT" varchar2(4000 char),
        "LOGLEVEL" number(10,0),
        "TIMESTAMP" varchar2(20 char),
        "POSITION" number(10,0)
    );

    alter table WEBLOGGING add constraint PID596DT596 primary key ("UUID");

    alter table WEBLOGGING 
        add constraint FKWEBLOGGINGID595 
        foreign key ("REQUEST") 
        references WEBREQUEST        
        on delete cascade
        deferrable
        novalidate;
    alter table WEBLOGGING enable validate constraint FKWEBLOGGINGID595;

    create index IDX_WEBLOGGINGID595 on WEBLOGGING ("REQUEST");

    alter table WEBLOGGING MODIFY ("UUID" DEFAULT SYS_GUID());

    alter table WEBLOGGING 
        add constraint DT596UUID_NOT_NULL check("UUID" is not null);

    alter table WEBLOGGING MODIFY ("LOGLEVEL" DEFAULT 0);

    alter table WEBLOGGING MODIFY ("POSITION" DEFAULT 0);
