Appo Database Design

The APPO database uses an open source PostgreSQL database, and the recommended version is 12.3.

• appinstanceinfo: Store app instance information, such as app_instance_id, applcm_host and tenant.

    create table appinstanceinfo (
       app_instance_id  varchar(64) not null,
        app_package_id varchar(64) not null,
        app_id varchar(64) not null,
        tenant varchar(64) not null,
        app_name varchar(128) not null,
        app_descriptor varchar(256) not null,
        mec_host varchar(15) not null,
        applcm_host varchar(15),
        operational_status varchar(128) not null,
        operation_info varchar(256),
        create_time timestamp default current_timestamp,
        update_time timestamp default current_timestamp,
        primary key (app_instance_id)
    );

• appotenant: Store tenant information, such as tenant.

    create table appotenant (
        tenant  varchar(255) not null,
        primary key (tenant)
    );