Developer DataBase Design v1.5¶
The Developer database uses open-source PostgreSQL databases with the recommended version of 12.2. PostgreSQL is an open source object-relational database server (ORDBMS), released under a flexible BSD license. Learn more about PostgreSQL here.
tbl_plugin Store plug-in information uploaded by the developer, such as name, satisfaction degree, plugin save path, etc.
CREATE TABLE IF NOT EXISTS tbl_plugin (
pluginid varchar(255) NOT NULL, --Plugin ID
pluginname varchar(255) NOT NULL, --Plugin name
introduction varchar(500) NULL, --Introduction to the plugin
satisfaction float4 NOT NULL, --Satisfaction (rating)
codelanguage varchar(255) NOT NULL, --The programming language represented by the plugin
plugintype int4 NOT NULL, --Plugin type (1: plugin 2: sdk)
version varchar(255) NOT NULL, --Plugin version
downloadcount int4 NOT NULL, --download times
logofile varchar(500) NOT NULL, --Saved path of the plugin icon
pluginfile varchar(500) NOT NULL, --Save path of the plugin
userid varchar(255) NOT NULL, --ID of the user who uploaded the plugin
uploadtime timestamptz(6) NOT NULL, --Upload time
username varchar(255) NOT NULL, --The name of the user who uploaded the plugin
pluginsize int4 NOT NULL, --Plugin size (bytes)
apifile varchar(500) NOT NULL, --Saved path of the plugin API file
scorecount int4 NOT NULL, --Number of ratings for the plugin
pluginfilehashcode varchar(50) DEFAULT NULL --Plugin hash value, verification file
CONSTRAINT tbl_plugin_pkey PRIMARY KEY (pluginid)
);
tbl_downloadrecord Store plugin download records. One plugin corresponds to multiple download records.
CREATE TABLE IF NOT EXISTS tbl_downloadrecord (
recordid varchar(255) NOT NULL, --Download record ID
pluginid varchar(255) NOT NULL, --Plugin ID (corresponding to pluginid in tbl_plugin)
downloaduserid varchar(255) NOT NULL, --Download user ID
downloadusername varchar(255) NOT NULL, --Download user name
score float4 NOT NULL, --Rating score (1-5)
scoretype int4 NOT NULL, --Rating type
downloadtime timestamptz(0) NOT NULL, --Download time
CONSTRAINT tbl_downloadrecord_pkey PRIMARY KEY (recordid)
);
tbl_container_image stores the container image information generated when the developer uploads the container image package on the developer platform
CREATE TABLE IF NOT EXISTS tbl_container_image (
image_id varchar(255) NOT NULL, --image ID
image_name varchar(255) NOT NULL, --image name
image_version varchar(255) NOT NULL, --image version
user_id varchar(255) NOT NULL, --the author id of upload container image
user_name varchar(255) NOT NULL, --the author name of upload container image
upload_time timestamptz(0) DEFAULT NULL, --upload image time
create_time timestamptz(0) DEFAULT NULL, --create db record time
image_status varchar(255) DEFAULT NULL, --image status
image_type varchar(255) DEFAULT NULL, --image type(private or public)
image_path text DEFAULT NULL, --image info(xxxx:xxx)
file_name varchar(255) DEFAULT NULL, --image type(private or public)
CONSTRAINT tbl_container_image_uniqueName UNIQUE (image_name,image_version,user_name),
CONSTRAINT tbl_container_image_pkey PRIMARY KEY (image_id)
);
tbl_app_project_capability When the developer creates a new container application project, he selects the platform capability (this table is an association table between projects and capabilities)
CREATE TABLE IF NOT EXISTS tbl_app_project_capability (
project_id varchar(50) NOT NULL, --project_id
capability_id varchar(50) NOT NULL, --capability id
CONSTRAINT tbl_app_project_capability_pkey PRIMARY KEY (project_id,capability_id)
);
tbl_openmep_capability Store the information of all the capabilities provided by the platform when the developer builds the application project on the developer platform.
CREATE TABLE IF NOT EXISTS tbl_capability_group (
id varchar(50) NOT NULL, --group id
name varchar(255) DEFAULT NULL, --capability group zh name
name_en varchar(255) DEFAULT NULL, --capability group en name
type varchar(20) DEFAULT NULL, --capability group type(openmep or openmep_eco)
description text DEFAULT NULL, --capability group desc
description_en text DEFAULT NULL, --capability group en desc
icon_file_id varchar(50) DEFAULT NULL, --group icon
author varchar(50) DEFAULT NULL, --the author of create group
update_time bigint NOT NULL DEFAULT 0, --update db record time
create_time bigint NOT NULL DEFAULT 0, --create db record time
CONSTRAINT tbl_capability_group_pkey PRIMARY KEY (id)
);
tbl_openmep_capability Store the information of all the capabilities provided by the platform when the developer builds the application project on the developer platform.
CREATE TABLE IF NOT EXISTS tbl_capability (
id varchar(50) NOT NULL, --capability id
name varchar(100) DEFAULT NULL, --capability zh name
name_en varchar(100) DEFAULT NULL, --capability en name
version varchar(100) DEFAULT NULL, --capability version
description text DEFAULT NULL, --capability desc
description_en text DEFAULT NULL, --capability en desc
provider varchar(100) DEFAULT NULL, --capability provider
api_file_id varchar(255) DEFAULT NULL, --capability api file
guide_file_id varchar(255) DEFAULT NULL, --capability guide file
guide_file_id_en varchar(255) DEFAULT NULL, --capability guide file(en version)
upload_time varchar(50) NOT NULL, --create capability time
host varchar(50) DEFAULT NULL, --registered service name
port int4 DEFAULT NULL, --service port
protocol varchar(20) DEFAULT NULL, --http,https
app_id varchar(255) DEFAULT NULL, --id posted to appstore
package_id varchar(255) DEFAULT NULL, --the packageId published to the appstore
user_id varchar(255) DEFAULT NULL, --the author id of create this capability
select_count integer NOT NULL DEFAULT 0, --the number of select this capability
icon_file_id varchar(50) DEFAULT NULL, --capability icon file
author varchar(50) DEFAULT NULL, --the author name of create this capability
experience_url text DEFAULT NULL, --the access url of capability
CONSTRAINT tbl_capability_pkey PRIMARY KEY (id)
);
tbl_mep_host 存储开发者在开发者平台对自构建的应用项目进行部署测试时,可供选择的服务器(测试沙箱)信息
CREATE TABLE IF NOT EXISTS tbl_mep_host (
host_id varchar(50) NOT NULL, --Server id
name varchar(100) DEFAULT NULL, --server name
lcm_ip varchar(20) DEFAULT NULL, --lcm IP address
lcm_protocol varchar(20) DEFAULT NULL, --lcm protocol
lcm_port int4 DEFAULT '-1', --lcm port
architecture varchar(100) DEFAULT NULL, --architecture
status varchar(20) DEFAULT NULL, --status
mec_host_ip varchar(20) DEFAULT NULL, --mec host address
vim_type varchar(255) DEFAULT NULL, --Operating system name
mec_host_user_name varchar(50) DEFAULT NULL, --User name required to log in to the host
mec_host_password varchar(50) DEFAULT NULL, --Password required to log in to the host
mec_host_port int4 DEFAULT 22, --The exposed connection port of the server deploying the edge application
user_id varchar(50) DEFAULT NULL, --UserId
config_file_id varchar(50) DEFAULT NULL, --config file id
net_work_parameter text DEFAULT NULL, --sandbox parameter
resource text DEFAULT NULL --Sandbox hardware information
address varchar(255) DEFAULT NULL, --address
);
tbl_uploaded_file Store the icon, image, api and other file information uploaded by the developer when deploying and testing the self-built application project on the developer platform
CREATE TABLE IF NOT EXISTS tbl_uploaded_file (
file_id varchar(50) NOT NULL, --File ID
file_name varchar(255) DEFAULT NULL, --file name
is_temp bool DEFAULT NULL, --Is it a temporary file
user_id varchar(50) DEFAULT NULL, --ID of the user who uploaded the file
upload_date timestamptz(6) DEFAULT NULL, --Upload time
file_path varchar(255) DEFAULT NULL, --file path
CONSTRAINT tbl_uploaded_file_pkey PRIMARY KEY ( file_id )
);
tbl_host_log Record the deployment log of the app project on the edge node.
CREATE TABLE IF NOT EXISTS tbl_host_log (
log_id varchar(50) NOT NULL, --Log ID
host_ip varchar(50) NOT NULL, --host IP
user_name varchar(50) DEFAULT NULL, --username
user_id varchar(50) DEFAULT NULL, --User ID
project_id varchar(50) DEFAULT NULL, --Project ID
project_name varchar(50) DEFAULT NULL, --project name
app_instances_id varchar(50) DEFAULT NULL, --The instance ID of the app project
deploy_time varchar(50) DEFAULT NULL, --Project deployment time
status varchar(50) DEFAULT NULL, --host status
operation varchar(50) DEFAULT NULL, --operating
host_id varchar(50) DEFAULT NULL --host ID
);
tbl_api_emulator Platform ability to call the simulator
CREATE TABLE IF NOT EXISTS tbl_api_emulator (
id varchar(50) NOT NULL, --id
user_id varchar(50) NOT NULL, --host IP
host_id varchar(50) NOT NULL, --username
port int4 NOT NULL, --port
workload_id varchar(50) NOT NULL, --work load id
create_time varchar(50) NOT NULL, --create tine
);
tbl_app_traffic_rule Traffic rule configuration
CREATE TABLE IF NOT EXISTS tbl_app_traffic_rule (
app_id varchar(255) NOT NULL, --application id
traffic_rule_id varchar(255) NOT NULL, --primary key
action varchar(255) DEFAULT NULL, --action
priority int4 DEFAULT NULL, --priority
filter_type varchar(255) DEFAULT NULL, --filter type
traffic_filter text DEFAULT NULL, --traffic filter
dst_interface text DEFAULT NULL, -- dst interface
CONSTRAINT tbl_app_traffic_rule_unique_id_traffic_rule UNIQUE (app_id,traffic_rule_id)
);
tbl_app_dns_rule Diversion rule configuration
CREATE TABLE IF NOT EXISTS tbl_app_dns_rule (
app_id varchar(255) NOT NULL, --application id
dns_rule_id varchar(255) NOT NULL, --primary key
domain_name varchar(255) DEFAULT NULL, --domain name
ip_address_type varchar(255) DEFAULT NULL, --ip type
ip_address varchar(255) DEFAULT NULL, --ip
ttl varchar(255) DEFAULT NULL, --ttl
CONSTRAINT tbl_app_dns_rule_unique_id_dns_rule UNIQUE (app_id,dns_rule_id)
);
tbl_app_service_produced Capability release configuration
CREATE TABLE IF NOT EXISTS tbl_app_service_produced (
app_id varchar(50) NOT NULL, --application id
app_service_produced_id varchar(50) NOT NULL, --primary key
one_level_name varchar(100) NOT NULL, --one level capability name
one_level_name_en varchar(100) NOT NULL, --one level english capability name
two_level_name varchar(100) NOT NULL, --two level capability name
description varchar(500) NOT NULL, --two level english capability name
api_file_id varchar(50) NOT NULL, --api file
guide_file_id varchar(50) NOT NULL, --guide file
icon_file_id varchar(50) NOT NULL, --icon file
service_name varchar(50) NOT NULL, --service name
internal_port int4 NOT NULL, --service port
version varchar(30) NOT NULL, --service version
protocol varchar(30) NOT NULL, --service protocol
author varchar(50) NOT NULL, --create author
experience_url varchar(500) DEFAULT NULL,--service experience url
dns_rule_id_list text DEFAULT NULL, --dns list
traffic_rule_id_list text DEFAULT NULL, --traffic list
CONSTRAINT tbl_app_service_produced_unique_id_name UNIQUE (app_id,service_name)
);
tbl_app_service_required Service dependent configuration
CREATE TABLE IF NOT EXISTS tbl_app_service_required (
app_id varchar(255) NOT NULL, --application id
id varchar(255) NOT NULL, --primary key
one_level_name varchar(255) NOT NULL, --one level capability name
one_level_name_en varchar(255) NOT NULL, --one level english capability name
two_level_name varchar(255) NOT NULL, --two level capability name
two_level_name_en varchar(255) NOT NULL, --two level english capability name
ser_name varchar(255) NOT NULL, --service name
version varchar(255) DEFAULT NULL, --service version
requested_permissions bool DEFAULT NULL, --need permission
ser_app_id varchar(255) DEFAULT NULL, --service application id
package_id varchar(255) DEFAULT NULL, -- package id
CONSTRAINT tbl_app_service_required_unique_id_name UNIQUE (app_id,ser_name)
);
tbl_app_certificate Authentication configuration
CREATE TABLE IF NOT EXISTS tbl_app_certificate (
app_id varchar(255) NOT NULL, --application id
ak text DEFAULT NULL, --ak
sk text DEFAULT NULL, --sk
CONSTRAINT tbl_app_certificate_pkey PRIMARY KEY (app_id)
);
tbl_application project(Incubation application)Configuration
CREATE TABLE IF NOT EXISTS tbl_application (
id varchar(255) NOT NULL, --application id
name varchar(255) NOT NULL, --application name
description varchar(255) DEFAULT NULL, --description
version varchar(255) NOT NULL, --version
provider varchar(255) NOT NULL, --application provider
architecture varchar(255) DEFAULT NULL, --application architecture
app_class varchar(255) DEFAULT NULL, --application class
type varchar(255) DEFAULT NULL, --application type
industry varchar(255) DEFAULT NULL, --industry
icon_file_id varchar(255) DEFAULT NULL, --icon file
guide_file_id varchar(255) DEFAULT NULL, --guide file
app_create_type varchar(255) DEFAULT NULL, --create type
create_time timestamptz(6) DEFAULT NULL, --create time
status varchar(255) DEFAULT NULL, --application status
user_id varchar(255) DEFAULT NULL, --user id
user_name varchar(255) DEFAULT NULL, --user name
mep_host_id varchar(255) DEFAULT NULL, --selected sandbox
CONSTRAINT tbl_application_unique_name_version UNIQUE (name,version),
CONSTRAINT tbl_application_pkey PRIMARY KEY (id)
);
tbl_container_helm_chart Record application deployment files
CREATE TABLE IF NOT EXISTS tbl_container_helm_chart (
id varchar(255) NOT NULL, --primary key
app_id varchar(255) NOT NULL, --application id
name varchar(255) DEFAULT NULL, --generate tgz name
helm_chart_file_id text DEFAULT NULL, --upload file name
create_time timestamptz(6) DEFAULT NULL, --create time
helm_chart_file_list text DEFAULT NULL, --file list of tgz file
CONSTRAINT tbl_container_helm_chart_pkey PRIMARY KEY (id)
);
tbl_vm 虚机配置
CREATE TABLE IF NOT EXISTS tbl_vm (
id varchar(255) NOT NULL, --vm id
app_id varchar(255) DEFAULT NULL, --application id
name varchar(255) NOT NULL, --vm name
flavor_id varchar(255) DEFAULT NULL, --vm flavor id
image_id int4 DEFAULT NULL, --vm image
target_image_id int4 DEFAULT NULL, --vm target image
user_data text DEFAULT NULL, --user data
status varchar(255) DEFAULT NULL, --vm status
area_zone varchar(255) DEFAULT NULL, --deploy zone
flavor_extra_specs text DEFAULT NULL, -- flavor param
CONSTRAINT tbl_vm_pkey PRIMARY KEY (id)
);
tbl_network 虚机网络配置
CREATE TABLE IF NOT EXISTS tbl_network (
id varchar(255) NOT NULL, --primary key
app_id varchar(255) DEFAULT NULL, --application id
name varchar(255) NOT NULL, --net name
description varchar(255) DEFAULT NULL, --net description
CONSTRAINT tbl_network_pkey PRIMARY KEY (id)
);
tbl_vm_port 虚机端口配置
CREATE TABLE IF NOT EXISTS tbl_vm_port (
id varchar(255) NOT NULL, --primary key
vm_id varchar(255) DEFAULT NULL, --vm id
name varchar(255) DEFAULT NULL, --port name
description varchar(255) DEFAULT NULL, --port description
network_name varchar(255) DEFAULT NULL, --net name
CONSTRAINT tbl_vm_port_pkey PRIMARY KEY (id)
);
tbl_vm_certificate 虚机证书配置
CREATE TABLE IF NOT EXISTS tbl_vm_certificate (
vm_id varchar(255) DEFAULT NULL, --vm id
certificate_type varchar(255) NOT NULL, --vm certificate
pwd_certificate text DEFAULT NULL, --password certificate
key_pair_certificate text DEFAULT NULL, --key-valye certificate
CONSTRAINT tbl_vm_certificate_pkey PRIMARY KEY (vm_id)
);
tbl_vm_flavor 虚机规格配置
CREATE TABLE IF NOT EXISTS tbl_vm_flavor (
id varchar(255) NOT NULL, --primary key
name varchar(255) NOT NULL, --flavor name
description varchar(255) DEFAULT NULL, --description
architecture varchar(255) DEFAULT NULL, --architecture
cpu text DEFAULT NULL, --cpu param
memory varchar(255) DEFAULT NULL, --memory param
system_disk_size int4 DEFAULT NULL, --system disk size
data_disk_size int4 DEFAULT NULL, --data disk size
gpu_extra_info text DEFAULT NULL, --gpu info
other_extra_info text DEFAULT NULL, --other info
CONSTRAINT tbl_vm_flavor_pkey PRIMARY KEY (id)
);
tbl_vm_image 虚机镜像管理
CREATE TABLE IF NOT EXISTS tbl_vm_image (
id SERIAL, --primary key
name varchar(255) NOT NULL, --image name
visible_type varchar(255) DEFAULT NULL, --visible type
os_type varchar(255) DEFAULT NULL, --os type
os_version varchar(255) DEFAULT NULL, --os version
os_bit_type varchar(255) DEFAULT NULL, --os bit
system_disk_size int4 DEFAULT NULL, --system disk size
image_file_name varchar(255) DEFAULT NULL, --image file name
image_format varchar(255) DEFAULT NULL, --image format
down_load_url varchar(255) DEFAULT NULL, --download url
file_md5 varchar(255) DEFAULT NULL, --file md5
image_size bigint DEFAULT NULL, --image size
image_slim_status varchar(50) DEFAULT NULL, --image slim size
status varchar(255) DEFAULT NULL, --image status
create_time timestamptz(6) DEFAULT NULL, --create time
modify_time timestamptz(6) DEFAULT NULL, --modify time
upload_time timestamptz(6) DEFAULT NULL, --upload time
user_id varchar(255) DEFAULT NULL, --user id
user_name varchar(255) DEFAULT NULL, --user name
file_identifier varchar(128) DEFAULT NULL, --file identifier
error_type varchar(32) DEFAULT NULL, --error type
CONSTRAINT tbl_vm_image_uniqueName UNIQUE (name,user_id),
CONSTRAINT tbl_vm_image_pkey PRIMARY KEY (id)
);
tbl_vm_instantiate_info Virtual machine instantiation information table
CREATE TABLE IF NOT EXISTS tbl_vm_instantiate_info (
vm_id varchar(255) NOT NULL, --vm id
operation_id varchar(255) DEFAULT NULL, --opreation(after launch vm) id
app_package_id varchar(255) DEFAULT NULL, --vm package id
distributed_mec_host varchar(255) DEFAULT NULL, --selected sandbox
mepm_package_id varchar(255) DEFAULT NULL, --mepm package id
app_instance_id varchar(255) DEFAULT NULL, --app package instance
vm_instance_id varchar(255) DEFAULT NULL, --vm instance
status varchar(255) DEFAULT NULL, --vm status
vnc_url varchar(255) DEFAULT NULL, --vm vnc url
log text DEFAULT NULL, --deploy log
instantiate_time timestamptz(6) DEFAULT NULL, --instantiate time
CONSTRAINT tbl_vm_instantiate_info_pkey PRIMARY KEY (vm_id)
);
tbl_vm_port_instantiate_info Virtual port instantiation information table
CREATE TABLE IF NOT EXISTS tbl_vm_port_instantiate_info (
vm_id varchar(255) NOT NULL, --vm id
network_name varchar(255) NOT NULL, --net name
ip_address varchar(255) DEFAULT NULL, --ip
CONSTRAINT tbl_vm_port_instantiate_info_unique_id_name UNIQUE (vm_id,network_name)
);
tbl_vm_image_export_info Record virtual machine image export information
CREATE TABLE IF NOT EXISTS tbl_vm_image_export_info (
vm_id varchar(255) NOT NULL, --vm id
operation_id varchar(255) DEFAULT NULL, --operation id
image_instance_id varchar(255) DEFAULT NULL, --image instance id
name varchar(255) DEFAULT NULL, --image name
image_file_name varchar(255) DEFAULT NULL, --image file
format varchar(255) DEFAULT NULL, --image format
download_url varchar(255) DEFAULT NULL, --image download url
check_sum varchar(255) DEFAULT NULL, --image sum
image_size varchar(255) DEFAULT NULL, --image size
status varchar(255) DEFAULT NULL, --image status
log text DEFAULT NULL, --image log
create_time timestamptz(6) DEFAULT NULL, --create time
CONSTRAINT tbl_vm_image_export_info_pkey PRIMARY KEY (vm_id)
);
tbl_container_app_instantiate_info Container application instantiation information table
CREATE TABLE IF NOT EXISTS tbl_container_app_instantiate_info (
app_id varchar(255) NOT NULL, --application id
operation_id varchar(255) NOT NULL, --operation id
app_package_id varchar(255) DEFAULT NULL, --app pkg
distributed_mec_host varchar(255) DEFAULT NULL, --selected sandbox
mepm_package_id varchar(255) DEFAULT NULL, --mepm package
app_instance_id varchar(255) DEFAULT NULL, --app instance
status varchar(255) DEFAULT NULL, --deploy status
log text DEFAULT NULL, --deploy log
instantiate_time timestamptz(6) DEFAULT NULL, --instantiate time
CONSTRAINT tbl_container_instantiate_info_unique_id_name UNIQUE (pod_name,name)
);
tbl_k8s_pod_instantiate_info Container application deploymentpodInstantiated information
CREATE TABLE IF NOT EXISTS tbl_k8s_pod_instantiate_info (
name varchar(255) NOT NULL, --pod name
app_id varchar(255) NOT NULL, --application id
pod_status varchar(255) DEFAULT NULL, --pod status
events_info text DEFAULT NULL, --pod instantiate info
CONSTRAINT tbl_k8s_pod_instantiate_info_unique_id_name UNIQUE (app_id,name)
);
tbl_container_instantiate_info Container instantiation information
CREATE TABLE IF NOT EXISTS tbl_container_instantiate_info (
name varchar(255) NOT NULL, --container name
pod_name varchar(255) NOT NULL, --container pod name
cpu_usage varchar(255) DEFAULT NULL, --cpu usage percent
mem_usage varchar(255) DEFAULT NULL, --memory usage percent
disk_usage varchar(255) DEFAULT NULL, --disk usage percent
CONSTRAINT tbl_container_instantiate_info_unique_id_name UNIQUE (pod_name,name)
);
tbl_k8s_service_instantiate_info Container application deploymentServiceInstantiated information
CREATE TABLE IF NOT EXISTS tbl_k8s_service_instantiate_info (
name varchar(255) NOT NULL, --service name
app_id varchar(255) NOT NULL, --application id
type varchar(255) DEFAULT NULL, --service type
CONSTRAINT tbl_k8s_service_instantiate_info_pkey PRIMARY KEY (name)
);
tbl_k8s_service_port_instantiate_info Container application deploymentServicePort instantiation information
CREATE TABLE IF NOT EXISTS tbl_k8s_service_port_instantiate_info (
port varchar(255) NOT NULL, --svc port
service_name varchar(255) NOT NULL, --svc name
target_port varchar(255) DEFAULT NULL, --svc target port
node_port varchar(255) DEFAULT NULL, --svc node port
CONSTRAINT tbl_k8s_service_port_instantiate_info_pkey PRIMARY KEY (service_name)
);
tbl_operation_status Application deployment operation information table
CREATE TABLE IF NOT EXISTS tbl_operation_status (
id varchar(255) NOT NULL, --operation id
user_name varchar(255) NOT NULL, --operation author
object_type varchar(255) DEFAULT NULL, --operate object type
object_id varchar(255) DEFAULT NULL, --operate object id
object_name varchar(255) DEFAULT NULL, --operate object name
operation_name varchar(255) DEFAULT NULL, --operation name
progress int4 DEFAULT NULL, --operate progress
status varchar(255) DEFAULT NULL, --status
error_msg text DEFAULT NULL, --error msg
create_time timestamptz(6) DEFAULT NULL, --create time
update_time timestamptz(6) DEFAULT NULL, --update time
CONSTRAINT tbl_operation_status_pkey PRIMARY KEY (id)
);
tbl_action_status Application deploymentactionInformation Sheet
CREATE TABLE IF NOT EXISTS tbl_action_status (
id varchar(255) NOT NULL, --primary key
operation_id varchar(255) NOT NULL, --operation id
object_type varchar(255) DEFAULT NULL, --operate object type
object_id varchar(255) DEFAULT NULL, --operate object id
action_name varchar(255) DEFAULT NULL, --action name
progress int4 DEFAULT NULL, --action progress
status varchar(255) DEFAULT NULL, --action status
error_msg text DEFAULT NULL, --err msg
status_log text DEFAULT NULL, --action status log
update_time timestamptz(6) DEFAULT NULL, --update time
CONSTRAINT tbl_action_status_pkey PRIMARY KEY (id)
);
tbl_app_package Generated application package information
CREATE TABLE IF NOT EXISTS tbl_app_package (
id varchar(255) NOT NULL, --pkg id
app_id varchar(255) NOT NULL, --application id
package_file_name varchar(255) DEFAULT NULL, --package file name
package_file_path varchar(500) DEFAULT NULL, --package file path
CONSTRAINT tbl_app_package_pkey PRIMARY KEY (id)
);
tbl_atp_test_task Application package test certification information table
CREATE TABLE IF NOT EXISTS tbl_atp_test_task (
id varchar(255) NOT NULL, --task id
app_id varchar(255) NOT NULL, --application id
app_name varchar(255) DEFAULT NULL, --application name
status varchar(255) DEFAULT NULL, --task status
create_time varchar(255) DEFAULT NULL, --create time
CONSTRAINT tbl_atp_test_task_pkey PRIMARY KEY (id)
);
tbl_profile profileInformation Sheet
CREATE TABLE IF NOT EXISTS tbl_profile (
id varchar(255) NOT NULL, --primary key
name varchar(255) NOT NULL, --profile name
description varchar(255) DEFAULT NULL, --description
description_en varchar(255) DEFAULT NULL, --english description
file_path varchar(255) NOT NULL, --profile file path
deploy_file_path text NOT NULL, --deploy file path
config_file_path varchar(255) DEFAULT NULL, --config file path
seq varchar(255) NOT NULL, --sequence
create_time timestamptz(6) NOT NULL, --create time
type varchar(255) NOT NULL, --type
industry varchar(255) NOT NULL, --industry
topo_file_path varchar(255) DEFAULT NULL, --topo file path
CONSTRAINT tbl_profile_pkey PRIMARY KEY (id)
);
tbl_app_script Application package script file table
CREATE TABLE IF NOT EXISTS tbl_app_script (
id varchar(255) NOT NULL, --primary key
app_id varchar(255) NOT NULL, --application id
name varchar(255) DEFAULT NULL, --script file name
script_file_id text DEFAULT NULL, --script file id
create_time timestamptz(6) NOT NULL, --create time
CONSTRAINT tbl_app_script_pkey PRIMARY KEY (id)
);
tbl_released_package fromAppstoreSynchronized application package information
CREATE TABLE IF NOT EXISTS tbl_released_package (
id varchar(50) NOT NULL, --primary key
app_store_app_id varchar(50) NOT NULL, --app id from appstore
app_store_package_id varchar(50) NOT NULL, --pkg id from appstore
name varchar(255) NOT NULL, --pkg name
version varchar(255) NOT NULL, --pkg version
provider varchar(255) NOT NULL, --provider
industry varchar(255) NOT NULL, --industry
type varchar(255) NOT NULL, --type
architecture varchar(255) NOT NULL, --app architecture
short_desc varchar(255) NOT NULL, --description
synchronize_date timestamptz(6) NOT NULL, --synchronize date
user_id varchar(50) NOT NULL, --user id
user_name varchar(255) NOT NULL, --user name
test_task_id varchar(50) NOT NULL, --test task id from appstore
CONSTRAINT tbl_released_package_pkey PRIMARY KEY ("id")
);