Developer DataBase Design ============ Developer数据库使用了开源的PostgreSQL数据库，推荐版本为12.2。**PostgreSQL** 是开源的对象-关系数据库服务器(ORDBMS)，在灵活的BSD许可证下发行。进一步了解PostgreSQL可以点击[这里](https://www.runoob.com/postgresql/postgresql-tutorial.html)。 - **tbl_plugin** 存储开发者上传的插件信息，如名字、满意度、插件保存路径等 ``` 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** 存储插件的下载记录，一个插件对应对应多条下载记录 ``` 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_app_project** 存储开发者在开发者平台自构建的应用项目的信息 ``` CREATE TABLE IF NOT EXISTS tbl_app_project ( id varchar(50) NOT NULL, --Project ID name varchar(100) NOT NULL, --project name provider varchar(100) NOT NULL, --provider platform varchar(100) NOT NULL, --Project structure industries varchar(100) NOT NULL, --Project Industry type varchar(50) NOT NULL, --Project type (video/security/game, etc.) description text DEFAULT NULL, --project description status varchar(20) NOT NULL, --Project status (tested, medium deployment) user_id varchar(50) NOT NULL, --ID of the user who created the project create_date timestamptz(6) DEFAULT NULL, --Creation time last_test_id varchar(50) DEFAULT NULL, --ID of the last test version varchar(50) DEFAULT NULL, --Project version capabilities text DEFAULT NULL, --The ability of the project (the ability checked when creating the project) project_type varchar(10) DEFAULT NULL, --Project type (new/migrated) icon_file_id varchar(50) DEFAULT NULL, --ID of the project icon file open_capability_id varchar(50) DEFAULT NULL, --Ability ID provided by the developer platform itself and shared by other developers deploy_platform varchar(100) DEFAULT NULL, --Deployment method: virtual machine, container deployment CONSTRAINT tbl_app_project_pkey PRIMARY KEY ( id ) ); ``` - **tbl_project_image** 存储开发者在开发者平台对自构建的应用项目进行部署测试时，开发者上传或者填写的镜像信息，一个项目的可以利用不同的镜像构建多次 ``` CREATE TABLE IF NOT EXISTS tbl_project_image ( id varchar(255) NOT NULL, --image ID image_info text DEFAULT NULL, --Store image information project_id varchar(255) DEFAULT NULL, --Project ID (corresponding to the id in tbl_app_project) helm_chart_file_id varchar(255) DEFAULT NULL, --id of uoloaded deploy yaml CONSTRAINT tbl_project_image_pkey PRIMARY KEY ( id ) ); ``` - **tbl_container_image** 存储开发者在开发者平台上传容器镜像包时，生成的容器镜像信息 ``` 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** 开发者新建容器应用项目时，选择平台能力（此表是项目和能力之间的关联表） ``` 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_capability_group** 开发者新建容器应用项目时，选择平台能力（能力分类表） ``` 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_capability** 开发者新建容器应用项目时，选择平台能力（能力详情表） ``` 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_project_test_config** 存储开发者在开发者平台对自构建的应用项目进行部署测试的配置信息，包括镜像、服务器等，一个项目可以多次配置测试项进行部署测试 ``` CREATE TABLE IF NOT EXISTS tbl_project_test_config ( test_id varchar(50) NOT NULL, --Test configuration ID project_id varchar(50) NOT NULL, --Project ID (corresponding to the id in tbl_app_project) agent_config text DEFAULT NULL, --MEP AGENT configuration item image_file_id varchar(255) NOT NULL, --Image file ID app_api_file_id varchar(50) DEFAULT NULL, --Project API document ID deploy_file_id varchar(50) DEFAULT NULL, --Deployment file ID private_host bool DEFAULT FALSE, --Whether the node is private platform varchar(100) DEFAULT NULL, --Deployment method access_url varchar(200) DEFAULT NULL, --Project accessible URl error_log text DEFAULT NULL, --Project deployment test failed log deploy_date timestamptz(6) DEFAULT NULL, --Project deployment time hosts varchar(255) DEFAULT NULL, --Server information selected for project deployment app_instance_id varchar(50) DEFAULT NULL, --The project deployment is successfully uploaded to the instance ID generated by the app store work_load_id varchar(255) DEFAULT NULL, --Deploy the project to applcm pods text DEFAULT NULL, --Deploy pods information deploy_status varchar(255) DEFAULT NULL, --Deployment status stage_status varchar(255) DEFAULT NULL, --Deployment steps lcm_token varchar(1000) DEFAULT NULL, --lcm token package_id varchar(255) DEFAULT NULL, --Generated csar package ID CONSTRAINT tbl_project_test_config_pkey PRIMARY KEY ( test_id ) ); ``` - **tbl_service_host** 存储开发者在开发者平台对自构建的应用项目进行部署测试时，可供选择的服务器信息 ``` CREATE TABLE IF NOT EXISTS tbl_service_host ( host_id varchar(50) NOT NULL, --Server id user_id varchar(50) DEFAULT NULL， --UserId name varchar(100) DEFAULT NULL, --server nickname address varchar(255) DEFAULT NULL, --address architecture varchar(100) DEFAULT NULL, --Architecture status varchar(20) DEFAULT NULL, --status protocol varchar(20) DEFAULT NULL, --protocol lcm_ip varchar(20) DEFAULT NULL, --IP address mec_host varchar(20) DEFAULT NULL, --mec host address os varchar(255) DEFAULT NULL, --Operating system name port_range_min int DEFAULT '-1', --Port minimum port_range_max int DEFAULT '-1', --Maximum port port int4 DEFAULT '-1', --Port value user_name varchar(50) DEFAULT NULL, --User name required to log in to the host password varchar(50) DEFAULT NULL, --Password required to log in to the host vnc_port int4 DEFAULT 22, --The exposed connection port of the server deploying the edge application parameter text DEFAULT NULL, --sandbox parameter delete bool DEFAULT NULL, --delete or not resource text DEFAULT NULL --Sandbox hardware information ); ``` - **tbl_uploaded_file** 存储开发者在开发者平台对自构建的应用项目进行部署测试时，上传的图标、镜像、api等文件信息 ``` 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_helm_template_yaml** 存储开发者在开发者平台对自构建的应用项目进行部署测试时，上传的Helm yaml文件信息(目前版本通过yaml部署)，一个项目可以通过不同的yaml文件进行多次部署测试 ``` CREATE TABLE IF NOT EXISTS tbl_helm_template_yaml ( file_id varchar(50) NOT NULL, --File ID file_name varchar(255) DEFAULT NULL, --file name user_id varchar(50) DEFAULT NULL, --ID of the user who uploaded the file project_id varchar(50) DEFAULT NULL, --Project ID (corresponding to the id in tbl_app_project) content text DEFAULT NULL, --document content upload_time_stamp bigint DEFAULT NULL, --Upload time config_type varchar(50) DEFAULT NULL, --Distinguish the deployment type (deployment file/visual configuration) CONSTRAINT tbl_helm_template_yaml_pkey PRIMARY KEY ( file_id ) ); ``` - **tbl_host_log** 记录app项目在边缘节点上部署的日志 ``` 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_release_config** 存储应用发布对应的配置信息 ``` CREATE TABLE IF NOT EXISTS tbl_release_config ( release_id varchar(255) NOT NULL, --Application release id project_id varchar(255) NOT NULL, --Project id guide_file_id varchar(255) DEFAULT NULL, --Guidance document ID appinstance_id varchar(255) DEFAULT NULL, --Instantiated ID capabilities_detail text DEFAULT NULL, --Application configuration information atp_test text DEFAULT NULL, --atp test result test_status varchar(255) DEFAULT NULL, --Test status create_time timestamptz(0) NOT NULL DEFAULT NULL,--Creation time CONSTRAINT tbl_release_config_pkey PRIMARY KEY (release_id) ); ``` - **tbl_vm_regulation** 虚机规则，虚机属性说明（虚机部署时提供选择） ``` CREATE TABLE IF NOT EXISTS tbl_vm_regulation ( regulation_id SERIAL, --Rule id architecture varchar(50) DEFAULT NULL, --Virtual machine architecture name_zh varchar(50) NOT NULL DEFAULT NULL, --Chinese name of the virtual machine name_en varchar(50) NOT NULL DEFAULT NULL, --English name of virtual machine scene_zh varchar(255) DEFAULT NULL, --Virtual machine usage scenarios scene_en varchar(255) DEFAULT NULL, --English description of virtual machine usage scenarios memory int4 DEFAULT NULL, --Virtual Memory cpu int4 DEFAULT NULL, --Virtual machine cpu system_disk int4 DEFAULT NULL, --Virtual machine system disk size data_disk int4 DEFAULT NULL, --Virtual machine data disk size gpu varchar(50) DEFAULT NULL, --Virtual machine gpu other_ability varchar(255) DEFAULT NULL --Other capabilities of the virtual machine ); ``` - **tbl_vm_network** 虚机网络配置 ``` CREATE TABLE IF NOT EXISTS tbl_vm_network ( network_type varchar(50) DEFAULT NULL, --Network Type description_zh varchar(255) DEFAULT NULL, --Network Chinese description description_en varchar(255) DEFAULT NULL, --English description of the network network_name varchar(50) DEFAULT NULL --Network name ); ``` - **tbl_vm_system** 虚机系统属性说明 ``` CREATE TABLE IF NOT EXISTS tbl_vm_system ( system_id SERIAL, --System id system_name varchar(128) DEFAULT NULL, --system vm name type varchar(50) DEFAULT NULL, --System type operate_system varchar(50) DEFAULT NULL, --system name version varchar(50) NOT NULL DEFAULT NULL, --system version system_bit varchar(50) DEFAULT NULL, --System size system_disk int4 DEFAULT NULL --System disk description user_id varchar(50) DEFAULT NULL, --author id or create db record user_name varchar(50) DEFAULT NULL, --author name or create db record create_time timestamptz(6) DEFAULT NULL, --create time modify_time timestamptz(6) DEFAULT NULL, --update time system_format varchar(50) DEFAULT NULL, --vm image format system_size bigint DEFAULT NULL, --vm image size system_slim varchar(50) DEFAULT NULL, --vm image size then slim upload_time timestamptz(6) DEFAULT NULL, --vm image upload time system_path varchar(128) DEFAULT NULL, --uploaded vm image path file_name varchar(128) DEFAULT NULL, --uploaded vm image file name file_md5 varchar(128) DEFAULT NULL, --uploaded vm image file md5 value status varchar(50) DEFAULT NULL, --vm image status file_identifier varchar(128) DEFAULT NULL, --uploaded vm image file identifier error_type varchar(32) DEFAULT NULL, -- the type when upload vm image fail CONSTRAINT tbl_vm_system_uniqueName UNIQUE (system_name,user_id), CONSTRAINT tbl_vm_system_pkey PRIMARY KEY (system_id) ); ``` - **tbl_project_vm_create_config** app项目虚机部署，创建虚机的配置说明 ``` CREATE TABLE IF NOT EXISTS tbl_project_vm_create_config ( vm_id varchar(255) NOT NULL DEFAULT NULL, --Virtual machine id project_id varchar(50) DEFAULT NULL, --Project id vm_name varchar(50) DEFAULT NULL, --Virtual machine name host varchar(512) DEFAULT NULL, --Virtual machine host description status varchar(50) DEFAULT NULL, --Virtual machine state stage_status varchar(500) DEFAULT NULL, --Virtual machine deployment step status lcm_token varchar(1024) DEFAULT NULL, --lcm token vm_info varchar(512) DEFAULT NULL, --Virtual machine information app_instance_id varchar(50) DEFAULT NULL, --The id of the deployed app instance package_id varchar(100) DEFAULT NULL, --Deploy the generated csar package id create_time timestamptz(6) DEFAULT NULL, --Creation time log text DEFAULT NULL, --Operation log CONSTRAINT tbl_project_vm_create_config_pkey PRIMARY KEY ( vm_id ) ); ``` - **tbl_project_vm_image_config** app项目虚机部署，镜像配置说明 ``` CREATE TABLE IF NOT EXISTS tbl_project_vm_image_config ( vm_id varchar(255) NOT NULL DEFAULT NULL, --Virtual machine id image_id varchar(50) DEFAULT NULL, --Mirror id project_id varchar(50) DEFAULT NULL, --Project id vm_name varchar(50) NOT NULL DEFAULT NULL, --Virtual machine name image_name varchar(50) DEFAULT NULL, --Mirror name app_instance_id varchar(50) DEFAULT NULL, --Instance id host_ip varchar(50) DEFAULT NULL, --Host ip sum_chunk_num varchar(50) DEFAULT NULL, --Number of mirrored blocks chunk_size varchar(50) DEFAULT NULL, --Mirror block size stage_status varchar(500) DEFAULT NULL, --Deployment status status varchar(512) DEFAULT NULL, --status lcm_token varchar(1024) DEFAULT NULL, --lcm token create_time timestamptz(6) DEFAULT NULL, --Creation time log text DEFAULT NULL, --Log CONSTRAINT tbl_project_vm_image_config_pkey PRIMARY KEY ( vm_id ) ); ``` - **tbl_vm_user_data** app项目虚机部署，存储的部署用户的信息 ``` CREATE TABLE IF NOT EXISTS tbl_vm_user_data ( operate_system varchar(50) DEFAULT NULL, --vm system type flavor_extra_specs text DEFAULT NULL, --user config flavor is_temp bool DEFAULT NULL, --Determine whether the user is a temporary configuration contents text DEFAULT NULL, --user config content params text DEFAULT NULL, --user config param CONSTRAINT tbl_vm_user_data_pkey PRIMARY KEY ( operate_system ) ); ``` - **tbl_project_vm_package_config** app项目虚机部署，生成虚机包所需的配置信息 ``` CREATE TABLE IF NOT EXISTS tbl_project_vm_package_config ( id varchar(50) DEFAULT NULL, --id project_id varchar(50) DEFAULT NULL, --project id vm_regulation_desc text DEFAULT NULL, --Rule information required to generate sequel package vm_system_desc text DEFAULT NULL, --vm image config info vm_network_desc text DEFAULT NULL, --vm network config info vm_user_data text DEFAULT NULL, --user config vm_name varchar(500) DEFAULT NULL, --vm name ak text DEFAULT NULL, --user config param sk text DEFAULT NULL, --user config param app_instance_id varchar(50) DEFAULT NULL, --instance id of generate vm pkg create_time timestamptz(6) DEFAULT NULL, --create time CONSTRAINT tbl_project_vm_package__uniqueProjectId UNIQUE (project_id), CONSTRAINT tbl_project_vm_package_config_pkey PRIMARY KEY (id) ); ```