Apm Database Design
============
The APM database uses an open source PostgreSQL database, and the recommended version is 12.3.
                                    
- apppackage: Store application package information, such as app_pkg_id, app_pkg_path and tenant_id.
```
    create table apppackage (
        id varchar(255) not null,
        app_pkg_id  varchar(255) not null,
        app_pkg_name varchar(255) not null,
        app_pkg_version varchar(255) not null,
        app_pkg_path varchar(255) not null,
        app_provider varchar(200),
        app_pkg_desc varchar(500),
        app_pkg_affinity varchar(200),
        app_icon_url varchar(255),
        app_id varchar(255) not null,
        tenant_id varchar(255) not null,
        local_file_path varchar(2000),
        created_time timestamp default current_timestamp,
        modified_time timestamp default current_timestamp,
        primary key (id)
    );
```
- apppackagehost: Store application package distribution information, such as app_pkg_id, distribution_status
, tenant_id.
```
    create table apppackagehost (
        id INT GENERATED BY DEFAULT AS IDENTITY,
        pkg_host_key varchar(255) not null,
        host_ip varchar(255) not null,
        app_pkg_id varchar(255) not null,
        distribution_status varchar(200) not null,
        tenant_id varchar(200) not null,
        error varchar(2000),
        primary key (id)
    );
```
- apmtenant: Store tenant information, such as tenant.
```
    create table apmtenant (
        tenant  varchar(255) not null,
        primary key (tenant)
    );
```