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)
);