linkis-dist/package/db/linkis_ddl_pg.sql (1,036 lines of code) (raw):

/* * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed with * this work for additional information regarding copyright ownership. * The ASF licenses this file to You under the Apache License, Version 2.0 * (the "License"); you may not use this file except in compliance with * the License. You may obtain a copy of the License at * * http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to in writing, software * distributed under the License is distributed on an "AS IS" BASIS, * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. * See the License for the specific language governing permissions and * limitations under the License. */ -- Non-unique indexes are named according to "idx_fieldname[_fieldname]". For example idx_age_name -- The unique index is named according to "uniq_field name[_field name]". For example uniq_age_name -- It is recommended to include all field names for composite indexes, and the long field names can be abbreviated. For example idx_age_name_add -- The index name should not exceed 50 characters, and the name should be lowercase -- -- 非唯一索引按照“idx_字段名称[_字段名称]”进用行命名。例如idx_age_name -- 唯一索引按照“uniq_字段名称[_字段名称]”进用行命名。例如uniq_age_name -- 组合索引建议包含所有字段名,过长的字段名可以采用缩写形式。例如idx_age_name_add -- 索引名尽量不超过50个字符,命名应该使用小写 DROP TABLE IF EXISTS "linkis_ps_configuration_config_key"; CREATE TABLE linkis_ps_configuration_config_key ( id bigserial NOT NULL, "key" varchar(50) NULL, description varchar(200) NULL, "name" varchar(50) NULL, default_value varchar(200) NULL, validate_type varchar(50) NULL, validate_range varchar(50) NULL, engine_conn_type varchar(50) NULL, is_hidden bool NULL, is_advanced bool NULL, "level" int2 NULL, "treeName" varchar(20) NULL, boundary_type int2 NOT NULL DEFAULT 0, en_description varchar(200) NULL, en_name varchar(100) NULL, "en_treeName" varchar(100) NULL, template_required bool NULL, CONSTRAINT linkis_configuration_config_key_pkey PRIMARY KEY (id) ); COMMENT ON COLUMN "linkis_ps_configuration_config_key"."key" IS 'Set key, e.g. spark.executor.instances'; COMMENT ON COLUMN "linkis_ps_configuration_config_key"."engine_conn_type" IS 'engine type,such as spark,hive etc'; COMMENT ON COLUMN "linkis_ps_configuration_config_key"."default_value" IS 'Adopted when user does not set key'; COMMENT ON COLUMN "linkis_ps_configuration_config_key"."validate_type" IS 'Validate type, one of the following: None, NumInterval, FloatInterval, Include, Regex, OPF, Custom Rules'; COMMENT ON COLUMN "linkis_ps_configuration_config_key"."validate_range" IS 'Validate range'; COMMENT ON COLUMN "linkis_ps_configuration_config_key"."is_hidden" IS 'Whether it is hidden from user. If set to 1(true), then user cannot modify, however, it could still be used in back-end'; COMMENT ON COLUMN "linkis_ps_configuration_config_key"."is_advanced" IS 'Whether it is an advanced parameter. If set to 1(true), parameters would be displayed only when user choose to do so'; COMMENT ON COLUMN "linkis_ps_configuration_config_key"."level" IS 'Basis for displaying sorting in the front-end. Higher the level is, higher the rank the parameter gets'; COMMENT ON COLUMN "linkis_ps_configuration_config_key"."treeName" IS 'Reserved field, representing the subdirectory of engineType'; COMMENT ON COLUMN "linkis_ps_configuration_config_key"."treeName" IS 'english description'; COMMENT ON COLUMN "linkis_ps_configuration_config_key"."treeName" IS 'english name'; COMMENT ON COLUMN "linkis_ps_configuration_config_key"."treeName" IS 'english treeName'; CREATE UNIQUE INDEX uniq_key_ectype ON linkis_ps_configuration_config_key USING btree ("key","engine_conn_type"); DROP TABLE IF EXISTS "linkis_ps_configuration_key_engine_relation"; CREATE TABLE linkis_ps_configuration_key_engine_relation ( id bigserial NOT NULL, config_key_id int4 NOT NULL, engine_type_label_id int4 NOT NULL, CONSTRAINT linkis_ps_configuration_key_engine_relation_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_ckid_etlid ON linkis_ps_configuration_key_engine_relation USING btree (config_key_id, engine_type_label_id); COMMENT ON COLUMN "linkis_ps_configuration_key_engine_relation"."config_key_id" IS 'config key id'; COMMENT ON COLUMN "linkis_ps_configuration_key_engine_relation"."engine_type_label_id" IS 'engine label id'; DROP TABLE IF EXISTS "linkis_ps_configuration_config_value"; CREATE TABLE linkis_ps_configuration_config_value ( id bigserial NOT NULL, config_key_id int4 NULL, config_value varchar(500) NULL, config_label_id int8 NULL, update_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_configuration_config_value_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_ckid_clid ON linkis_ps_configuration_config_value USING btree (config_key_id, config_label_id); DROP TABLE IF EXISTS "linkis_ps_configuration_category"; CREATE TABLE linkis_ps_configuration_category ( id bigserial NOT NULL, label_id int4 NOT NULL, "level" int4 NOT NULL, description varchar(200) NULL, tag varchar(200) NULL, update_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_configuration_category_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_label_id_cc ON linkis_ps_configuration_category USING btree (label_id); DROP TABLE IF EXISTS linkis_ps_configuration_template_config_key; CREATE TABLE linkis_ps_configuration_template_config_key ( id BIGINT PRIMARY KEY NOT NULL, template_name VARCHAR(200) NOT NULL, template_uuid VARCHAR(36) NOT NULL, key_id BIGINT NOT NULL, config_value VARCHAR(200) NULL DEFAULT NULL, max_value VARCHAR(50) NULL DEFAULT NULL, min_value VARCHAR(50) NULL DEFAULT NULL, validate_range VARCHAR(50) NULL DEFAULT NULL, is_valid VARCHAR(2) DEFAULT 'Y', create_by VARCHAR(50) NOT NULL, create_time TIMESTAMP WITHOUT TIME ZONE DEFAULT NOW(), update_by VARCHAR(50) NULL DEFAULT NULL, update_time TIMESTAMP WITHOUT TIME ZONE DEFAULT NOW() ); DROP TABLE IF EXISTS linkis_ps_configuration_key_limit_for_user; CREATE TABLE IF NOT EXISTS linkis_ps_configuration_key_limit_for_user ( id bigint NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1), user_name varchar(50) NOT NULL, combined_label_value varchar(128) NOT NULL, key_id bigint NOT NULL, config_value varchar(200) NULL DEFAULT NULL, max_value varchar(50) NULL DEFAULT NULL, min_value varchar(50) NULL DEFAULT NULL, latest_update_template_uuid varchar(36) NOT NULL, is_valid varchar(2) DEFAULT 'Y', create_by varchar(50) NOT NULL, create_time timestamp without time zone DEFAULT now(), update_by varchar(50) NULL DEFAULT NULL, update_time timestamp without time zone DEFAULT now() ); DROP TABLE IF EXISTS linkis_ps_configutation_lm_across_cluster_rule; CREATE TABLE IF NOT EXISTS linkis_ps_configutation_lm_across_cluster_rule ( rule_id bigserial NOT NULL, cluster_name varchar(32) NOT NULL, creator varchar(32) NOT NULL, username varchar(32) NOT NULL, create_time TIMESTAMP NOT NULL DEFAULT NOW(), create_by varchar(32) NOT NULL, update_time TIMESTAMP NOT NULL DEFAULT NOW(), update_by varchar(32), rules TEXT NOT NULL, is_valid varchar(1) DEFAULT'N' ); DROP TABLE IF EXISTS "linkis_ps_job_history_group_history"; CREATE TABLE linkis_ps_job_history_group_history ( id bigserial NOT NULL, job_req_id varchar(64) NULL, submit_user varchar(50) NULL, execute_user varchar(50) NULL, "source" text NULL, labels text NULL, params text NULL, progress varchar(32) NULL, status varchar(50) NULL, log_path varchar(200) NULL, error_code int4 NULL, error_desc varchar(1000) NULL, created_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, updated_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, instances varchar(250) NULL, metrics text NULL, engine_type varchar(32) NULL, execution_code text NULL, result_location varchar(500) NULL, observe_info varchar(500) NULL, CONSTRAINT linkis_ps_job_history_group_history_pkey PRIMARY KEY (id) ); CREATE INDEX idx_created_time ON linkis_ps_job_history_group_history USING btree (created_time); CREATE INDEX idx_submit_user ON linkis_ps_job_history_group_history USING btree (submit_user); COMMENT ON COLUMN "linkis_ps_job_history_group_history"."id" IS 'Primary Key, auto increment'; COMMENT ON COLUMN "linkis_ps_job_history_group_history"."job_req_id" IS 'job execId'; COMMENT ON COLUMN "linkis_ps_job_history_group_history"."submit_user" IS 'who submitted this Job'; COMMENT ON COLUMN "linkis_ps_job_history_group_history"."execute_user" IS 'who actually executed this Job'; COMMENT ON COLUMN "linkis_ps_job_history_group_history"."source" IS 'job source'; COMMENT ON COLUMN "linkis_ps_job_history_group_history"."labels" IS 'job labels'; COMMENT ON COLUMN "linkis_ps_job_history_group_history"."params" IS 'job labels'; COMMENT ON COLUMN "linkis_ps_job_history_group_history"."progress" IS 'Job execution progress'; COMMENT ON COLUMN "linkis_ps_job_history_group_history"."status" IS 'Script execution status, must be one of the following: Inited, WaitForRetry, Scheduled, Running, Succeed, Failed, Cancelled, Timeout'; COMMENT ON COLUMN "linkis_ps_job_history_group_history"."log_path" IS 'File path of the job log'; COMMENT ON COLUMN "linkis_ps_job_history_group_history"."error_code" IS 'Error code. Generated when the execution of the script fails'; COMMENT ON COLUMN "linkis_ps_job_history_group_history"."error_desc" IS 'Execution description. Generated when the execution of script fails'; COMMENT ON COLUMN "linkis_ps_job_history_group_history"."created_time" IS 'Creation time'; COMMENT ON COLUMN "linkis_ps_job_history_group_history"."updated_time" IS 'Update time'; COMMENT ON COLUMN "linkis_ps_job_history_group_history"."instances" IS 'Entrance instances'; COMMENT ON COLUMN "linkis_ps_job_history_group_history"."metrics" IS 'Job Metrics'; COMMENT ON COLUMN "linkis_ps_job_history_group_history"."engine_type" IS 'Engine type'; COMMENT ON COLUMN "linkis_ps_job_history_group_history"."execution_code" IS 'Job origin code or code path'; COMMENT ON COLUMN "linkis_ps_job_history_group_history"."observe_info" IS 'The notification information configuration of this job'; DROP TABLE IF EXISTS "linkis_ps_job_history_detail"; CREATE TABLE linkis_ps_job_history_detail ( id bigserial NOT NULL, job_history_id int8 NOT NULL, result_location varchar(500) NULL, execution_content text NULL, result_array_size int4 NULL DEFAULT 0, job_group_info text NULL, created_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, updated_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, status varchar(32) NULL, priority int4 NULL DEFAULT 0, CONSTRAINT linkis_ps_job_history_detail_pkey PRIMARY KEY (id) ); COMMENT ON COLUMN "linkis_ps_job_history_detail"."id" IS 'Primary Key, auto increment'; COMMENT ON COLUMN "linkis_ps_job_history_detail"."job_history_id" IS 'ID of JobHistory'; COMMENT ON COLUMN "linkis_ps_job_history_detail"."result_location" IS 'File path of the resultsets'; COMMENT ON COLUMN "linkis_ps_job_history_detail"."execution_content" IS 'The script code or other execution content executed by this Job'; COMMENT ON COLUMN "linkis_ps_job_history_detail"."result_array_size" IS 'size of result array'; COMMENT ON COLUMN "linkis_ps_job_history_detail"."job_group_info" IS 'Job group info/path'; COMMENT ON COLUMN "linkis_ps_job_history_detail"."created_time" IS 'Creation time'; COMMENT ON COLUMN "linkis_ps_job_history_detail"."updated_time" IS 'Update time'; COMMENT ON COLUMN "linkis_ps_job_history_detail"."status" IS 'status'; COMMENT ON COLUMN "linkis_ps_job_history_detail"."priority" IS 'order of subjob'; DROP TABLE IF EXISTS "linkis_ps_common_lock"; CREATE TABLE linkis_ps_common_lock ( id bigserial NOT NULL, lock_object varchar(255) NULL, locker varchar(255) NOT NULL, time_out text NULL, update_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_ps_common_lock_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_lock_object ON linkis_ps_common_lock USING btree (lock_object); DROP TABLE IF EXISTS "linkis_ps_udf_manager"; CREATE TABLE linkis_ps_udf_manager ( id bigserial NOT NULL, user_name varchar(20) NULL, update_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_udf_manager_pkey PRIMARY KEY (id) ); DROP TABLE IF EXISTS "linkis_ps_udf_shared_group"; CREATE TABLE linkis_ps_udf_shared_group ( id bigserial NOT NULL, udf_id int8 NOT NULL, shared_group varchar(50) NOT NULL, update_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_udf_shared_group_pkey PRIMARY KEY (id) ); DROP TABLE IF EXISTS "linkis_ps_udf_shared_info"; CREATE TABLE linkis_ps_udf_shared_info ( id bigserial NOT NULL, udf_id int8 NOT NULL, user_name varchar(50) NOT NULL, update_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_ps_udf_shared_info_pkey PRIMARY KEY (id) ); DROP TABLE IF EXISTS "linkis_ps_udf_tree"; CREATE TABLE linkis_ps_udf_tree ( id bigserial NOT NULL, parent int8 NOT NULL, "name" varchar(100) NULL, user_name varchar(50) NOT NULL, description varchar(255) NULL, create_time timestamp(6) NOT NULL, update_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, category varchar(50) NULL, CONSTRAINT linkis_udf_tree_pkey PRIMARY KEY (id) ); COMMENT ON COLUMN "linkis_ps_udf_tree"."name" IS 'Category name of the function. It would be displayed in the front-end'; COMMENT ON COLUMN "linkis_ps_udf_tree"."category" IS 'Used to distinguish between udf and function'; CREATE UNIQUE INDEX uniq_parent_name_uname_category ON linkis_ps_udf_tree USING btree (parent,name,user_name,category); DROP TABLE IF EXISTS "linkis_ps_udf_user_load"; CREATE TABLE linkis_ps_udf_user_load ( id bigserial NOT NULL, udf_id int4 NOT NULL, user_name varchar(50) NOT NULL, update_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_ps_udf_user_load_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_uid_uname ON linkis_ps_udf_user_load USING btree (udf_id, user_name); DROP TABLE IF EXISTS "linkis_ps_udf_baseinfo"; CREATE TABLE linkis_ps_udf_baseinfo ( id bigserial NOT NULL, create_user varchar(50) NOT NULL, udf_name varchar(255) NOT NULL, udf_type int4 NULL DEFAULT 0, tree_id int8 NOT NULL, create_time timestamptz(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, update_time timestamptz(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "sys" varchar(255) NOT NULL DEFAULT 'ide', cluster_name varchar(255) NOT NULL, is_expire bool NULL, is_shared bool NULL, CONSTRAINT linkis_ps_udf_baseinfo_pkey PRIMARY KEY (id) ); DROP TABLE IF EXISTS "linkis_ps_udf_version"; CREATE TABLE linkis_ps_udf_version ( id bigserial NOT NULL, udf_id int8 NOT NULL, "path" varchar(255) NOT NULL, bml_resource_id varchar(50) NOT NULL, bml_resource_version varchar(20) NOT NULL, is_published bool NULL, register_format varchar(255) NULL, use_format varchar(255) NULL, description varchar(255) NOT NULL, create_time timestamptz(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, update_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, md5 varchar(100) NULL, CONSTRAINT linkis_ps_udf_version_pkey PRIMARY KEY (id) ); DROP TABLE IF EXISTS "linkis_ps_variable_key_user"; CREATE TABLE linkis_ps_variable_key_user ( id bigserial NOT NULL, application_id int8 NULL, key_id int8 NULL, user_name varchar(50) NULL, value varchar(200) NULL, CONSTRAINT linkis_var_key_user_pkey PRIMARY KEY (id) ); CREATE INDEX idx_aid_vku ON linkis_ps_variable_key_user USING btree (application_id); CREATE UNIQUE INDEX uniq_aid_kid_uname ON linkis_ps_variable_key_user USING btree (application_id, key_id, user_name); CREATE INDEX idx_key_id ON linkis_ps_variable_key_user USING btree (key_id); COMMENT ON COLUMN "linkis_ps_variable_key_user"."application_id" IS 'Reserved word'; COMMENT ON COLUMN "linkis_ps_variable_key_user"."value" IS 'Value of the global variable'; DROP TABLE IF EXISTS "linkis_ps_variable_key"; CREATE TABLE linkis_ps_variable_key ( id bigserial NOT NULL, "key" varchar(50) NULL, description varchar(200) NULL, "name" varchar(50) NULL, application_id int8 NULL, default_value varchar(200) NULL, value_type varchar(50) NULL, value_regex varchar(100) NULL, CONSTRAINT linkis_var_key_pkey PRIMARY KEY (id) ); CREATE INDEX idx_aid_vk ON linkis_ps_variable_key USING btree (application_id); COMMENT ON COLUMN "linkis_ps_variable_key"."key" IS 'Key of the global variable'; COMMENT ON COLUMN "linkis_ps_variable_key"."description" IS 'Reserved word'; COMMENT ON COLUMN "linkis_ps_variable_key"."name" IS 'Reserved word'; COMMENT ON COLUMN "linkis_ps_variable_key"."application_id" IS 'Reserved word'; COMMENT ON COLUMN "linkis_ps_variable_key"."default_value" IS 'Reserved word'; COMMENT ON COLUMN "linkis_ps_variable_key"."value_type" IS 'Reserved word'; COMMENT ON COLUMN "linkis_ps_variable_key"."value_regex" IS 'Reserved word'; DROP TABLE IF EXISTS "linkis_ps_datasource_access"; CREATE TABLE linkis_ps_datasource_access ( id bigserial NOT NULL, table_id int8 NOT NULL, visitor varchar(16) NOT NULL, fields varchar(255) NULL, application_id int4 NOT NULL, access_time timestamp(6) NOT NULL, CONSTRAINT linkis_mdq_access_pkey PRIMARY KEY (id) ); DROP TABLE IF EXISTS "linkis_ps_datasource_field"; CREATE TABLE linkis_ps_datasource_field ( id bigserial NOT NULL, table_id int8 NOT NULL, "name" varchar(64) NOT NULL, alias varchar(64) NULL, "type" varchar(64) NOT NULL, "comment" varchar(255) NULL, express varchar(255) NULL, "rule" varchar(128) NULL, is_partition_field bool NOT NULL, is_primary bool NOT NULL, length int4 NULL, mode_info varchar(128) NULL, CONSTRAINT linkis_mdq_field_pkey PRIMARY KEY (id) ); DROP TABLE IF EXISTS "linkis_ps_datasource_import"; CREATE TABLE linkis_ps_datasource_import ( id bigserial NOT NULL, table_id int8 NOT NULL, import_type int4 NOT NULL, args varchar(255) NOT NULL, CONSTRAINT linkis_mdq_import_pkey PRIMARY KEY (id) ); DROP TABLE IF EXISTS "linkis_ps_datasource_lineage"; CREATE TABLE linkis_ps_datasource_lineage ( id bigserial NOT NULL, table_id int8 NULL, source_table varchar(64) NULL, update_time timestamp(6) NULL, CONSTRAINT linkis_mdq_lineage_pkey PRIMARY KEY (id) ); DROP TABLE IF EXISTS "linkis_ps_datasource_table"; CREATE TABLE linkis_ps_datasource_table ( id bigserial NOT NULL, "database" varchar(64) NOT NULL, "name" varchar(64) NOT NULL, alias varchar(64) NULL, creator varchar(16) NOT NULL, "comment" varchar(255) NULL, create_time timestamp(6) NOT NULL, product_name varchar(64) NULL, project_name varchar(255) NULL, "usage" varchar(128) NULL, lifecycle int4 NOT NULL, use_way int4 NOT NULL, is_import bool NOT NULL, model_level int4 NOT NULL, is_external_use bool NOT NULL, is_partition_table bool NOT NULL, is_available bool NOT NULL, CONSTRAINT linkis_mdq_table_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_db_name ON linkis_ps_datasource_table USING btree (database, name); DROP TABLE IF EXISTS "linkis_ps_datasource_table_info"; CREATE TABLE linkis_ps_datasource_table_info ( id bigserial NOT NULL, table_id int8 NOT NULL, table_last_update_time timestamp(6) NOT NULL, row_num int8 NOT NULL, file_num int4 NOT NULL, table_size varchar(32) NOT NULL, partitions_num int4 NOT NULL, update_time timestamp(6) NOT NULL, field_num int4 NOT NULL, CONSTRAINT linkis_mdq_table_info_pkey PRIMARY KEY (id) ); DROP TABLE IF EXISTS "linkis_ps_cs_context_map"; CREATE TABLE linkis_ps_cs_context_map ( id serial4 NOT NULL, "key" varchar(128) NULL, context_scope varchar(32) NULL, context_type varchar(32) NULL, props text NULL, value text NULL, context_id int4 NULL, keywords varchar(255) NULL, update_time timestamptz(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamptz(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, access_time timestamptz(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_cs_context_map_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_key_cid_ctype ON linkis_ps_cs_context_map USING btree (key, context_id, context_type); CREATE INDEX idx_keywords ON linkis_ps_cs_context_map USING btree (keywords); DROP TABLE IF EXISTS "linkis_ps_cs_context_map_listener"; CREATE TABLE linkis_ps_cs_context_map_listener ( id serial4 NOT NULL, listener_source varchar(255) NULL, key_id int4 NULL, update_time timestamptz(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamptz(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, access_time timestamptz(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_cs_context_map_listener_pkey PRIMARY KEY (id) ); DROP TABLE IF EXISTS "linkis_ps_cs_context_history"; CREATE TABLE linkis_ps_cs_context_history ( id serial4 NOT NULL, context_id int4 NULL, "source" text NULL, context_type varchar(32) NULL, history_json text NULL, keyword varchar(255) NULL, update_time timestamptz(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamptz(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, access_time timestamptz(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_cs_context_history_pkey PRIMARY KEY (id) ); CREATE INDEX idx_keyword ON linkis_ps_cs_context_history USING btree (keyword); DROP TABLE IF EXISTS "linkis_ps_cs_context_id"; CREATE TABLE linkis_ps_cs_context_id ( id serial4 NOT NULL, "user" varchar(32) NULL, application varchar(32) NULL, "source" varchar(255) NULL, expire_type varchar(32) NULL, expire_time timestamp(6) NULL, "instance" varchar(128) NULL, backup_instance varchar(255) NULL, update_time timestamptz(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamptz(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, access_time timestamptz(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_cs_context_id_pkey PRIMARY KEY (id) ); CREATE INDEX idx_backup_instance ON linkis_ps_cs_context_id USING btree (backup_instance); CREATE INDEX idx_instance ON linkis_ps_cs_context_id USING btree (instance); CREATE INDEX idx_instance_bin ON linkis_ps_cs_context_id USING btree (instance, backup_instance); DROP TABLE IF EXISTS "linkis_ps_cs_context_listener"; CREATE TABLE linkis_ps_cs_context_listener ( id serial4 NOT NULL, listener_source varchar(255) NULL, context_id int4 NULL, update_time timestamptz(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamptz(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, access_time timestamptz(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_cs_context_listener_pkey PRIMARY KEY (id) ); DROP TABLE IF EXISTS "linkis_ps_bml_resources"; CREATE TABLE linkis_ps_bml_resources ( id bigserial NOT NULL, resource_id varchar(50) NOT NULL, is_private bool NULL DEFAULT false, resource_header int2 NULL DEFAULT 0, downloaded_file_name varchar(200) NULL, sys varchar(100) NOT NULL, create_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "owner" varchar(200) NOT NULL, is_expire bool NULL DEFAULT false, expire_type varchar(50) NULL, expire_time varchar(50) NULL, max_version int4 NULL DEFAULT 10, update_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, updator varchar(50) NULL, enable_flag bool NOT NULL DEFAULT true, CONSTRAINT linkis_resources_pkey PRIMARY KEY (id) ); COMMENT ON COLUMN "linkis_ps_bml_resources"."id" IS '主键'; COMMENT ON COLUMN "linkis_ps_bml_resources"."resource_id" IS '资源id,资源的uuid'; COMMENT ON COLUMN "linkis_ps_bml_resources"."is_private" IS '资源是否私有,0表示私有,1表示公开'; COMMENT ON COLUMN "linkis_ps_bml_resources"."resource_header" IS '分类,0表示未分类,1表示已分类'; COMMENT ON COLUMN "linkis_ps_bml_resources"."downloaded_file_name" IS '下载时的文件名'; COMMENT ON COLUMN "linkis_ps_bml_resources"."sys" IS '所属系统'; COMMENT ON COLUMN "linkis_ps_bml_resources"."create_time" IS '创建时间'; COMMENT ON COLUMN "linkis_ps_bml_resources"."owner" IS '资源所属者'; COMMENT ON COLUMN "linkis_ps_bml_resources"."is_expire" IS '是否过期,0表示不过期,1表示过期'; COMMENT ON COLUMN "linkis_ps_bml_resources"."expire_type" IS '过期类型,date指到指定日期过期,TIME指时间'; COMMENT ON COLUMN "linkis_ps_bml_resources"."expire_time" IS '过期时间,默认一天'; COMMENT ON COLUMN "linkis_ps_bml_resources"."max_version" IS '默认为10,指保留最新的10个版本'; COMMENT ON COLUMN "linkis_ps_bml_resources"."update_time" IS '更新时间'; COMMENT ON COLUMN "linkis_ps_bml_resources"."updator" IS '更新者'; COMMENT ON COLUMN "linkis_ps_bml_resources"."enable_flag" IS '状态,1:正常,0:冻结'; CREATE UNIQUE INDEX uniq_rid_eflag ON linkis_ps_bml_resources USING btree (resource_id, enable_flag); DROP TABLE IF EXISTS "linkis_ps_bml_resources_version"; CREATE TABLE linkis_ps_bml_resources_version ( id bigserial NOT NULL, resource_id varchar(50) NOT NULL, file_md5 varchar(32) NOT NULL, "version" varchar(20) NOT NULL, "size" int4 NOT NULL, start_byte numeric(20) NOT NULL DEFAULT 0, end_byte numeric(20) NOT NULL DEFAULT 0, resource varchar(2000) NOT NULL, description varchar(2000) NULL, start_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, end_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, client_ip varchar(200) NOT NULL, updator varchar(50) NULL, enable_flag bool NOT NULL DEFAULT true, CONSTRAINT linkis_resources_version_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_rid_version ON linkis_ps_bml_resources_version USING btree (resource_id, version); COMMENT ON COLUMN "linkis_ps_bml_resources_version"."id" IS '主键'; COMMENT ON COLUMN "linkis_ps_bml_resources_version"."resource_id" IS '资源id,资源的uuid'; COMMENT ON COLUMN "linkis_ps_bml_resources_version"."file_md5" IS '文件的md5摘要'; COMMENT ON COLUMN "linkis_ps_bml_resources_version"."version" IS '资源版本(v 加上 五位数字)'; COMMENT ON COLUMN "linkis_ps_bml_resources_version"."size" IS '文件大小'; COMMENT ON COLUMN "linkis_ps_bml_resources_version"."resource" IS '资源内容(文件信息 包括 路径和文件名)'; COMMENT ON COLUMN "linkis_ps_bml_resources_version"."description" IS '描述'; COMMENT ON COLUMN "linkis_ps_bml_resources_version"."start_time" IS '开始时间'; COMMENT ON COLUMN "linkis_ps_bml_resources_version"."end_time" IS '结束时间'; COMMENT ON COLUMN "linkis_ps_bml_resources_version"."client_ip" IS '客户端ip'; COMMENT ON COLUMN "linkis_ps_bml_resources_version"."updator" IS '修改者'; COMMENT ON COLUMN "linkis_ps_bml_resources_version"."enable_flag" IS '状态,1:正常,0:冻结'; DROP TABLE IF EXISTS "linkis_ps_bml_resources_permission"; CREATE TABLE linkis_ps_bml_resources_permission ( id bigserial NOT NULL, resource_id varchar(50) NOT NULL, "permission" varchar(10) NOT NULL, create_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "system" varchar(50) DEFAULT 'dss', update_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, updator varchar(50) NOT NULL, CONSTRAINT linkis_resources_permission_pkey PRIMARY KEY (id) ); COMMENT ON COLUMN "linkis_ps_bml_resources_permission"."id" IS '主键'; COMMENT ON COLUMN "linkis_ps_bml_resources_permission"."resource_id" IS '资源id,资源的uuid'; COMMENT ON COLUMN "linkis_ps_bml_resources_permission"."permission" IS '权限代码'; COMMENT ON COLUMN "linkis_ps_bml_resources_permission"."create_time" IS '创建时间'; COMMENT ON COLUMN "linkis_ps_bml_resources_permission"."system" IS '创建者'; COMMENT ON COLUMN "linkis_ps_bml_resources_permission"."update_time" IS '更新时间'; COMMENT ON COLUMN "linkis_ps_bml_resources_permission"."updator" IS '更新者'; DROP TABLE IF EXISTS "linkis_ps_resources_download_history"; CREATE TABLE linkis_ps_resources_download_history ( id bigserial NOT NULL, start_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, end_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, client_ip varchar(200) NOT NULL, state int2 NOT NULL, resource_id varchar(50) NOT NULL, "version" varchar(20) NOT NULL, downloader varchar(50) NOT NULL, CONSTRAINT linkis_resources_download_history_pkey PRIMARY KEY (id) ); COMMENT ON COLUMN "linkis_ps_resources_download_history"."id" IS '主键'; COMMENT ON COLUMN "linkis_ps_resources_download_history"."start_time" IS '开始时间'; COMMENT ON COLUMN "linkis_ps_resources_download_history"."end_time" IS '结束时间'; COMMENT ON COLUMN "linkis_ps_resources_download_history"."client_ip" IS '客户端ip'; COMMENT ON COLUMN "linkis_ps_resources_download_history"."state" IS '下载状态,0下载成功,1下载失败'; COMMENT ON COLUMN "linkis_ps_resources_download_history"."downloader" IS '下载者'; DROP TABLE IF EXISTS "linkis_ps_bml_resources_task"; CREATE TABLE linkis_ps_bml_resources_task ( id bigserial NOT NULL, resource_id varchar(50) NULL, "version" varchar(20) NULL, operation varchar(20) NOT NULL, state varchar(20) NOT NULL DEFAULT 'Schduled'::character varying, submit_user varchar(20) NOT NULL, "system" varchar(20) NULL DEFAULT 'dss'::character varying, "instance" varchar(128) NOT NULL, client_ip varchar(50) NULL, extra_params text NULL, err_msg varchar(2000) NULL, start_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, end_time timestamp(6) NULL, last_update_time timestamp(6) NOT NULL, CONSTRAINT linkis_resources_task_pkey PRIMARY KEY (id) ); COMMENT ON COLUMN "linkis_ps_bml_resources_task"."resource_id" IS '资源id,资源的uuid'; COMMENT ON COLUMN "linkis_ps_bml_resources_task"."version" IS '当前操作的资源版本号'; COMMENT ON COLUMN "linkis_ps_bml_resources_task"."operation" IS '操作类型.upload = 0, update = 1'; COMMENT ON COLUMN "linkis_ps_bml_resources_task"."state" IS '任务当前状态:Schduled, Running, Succeed, Failed,Cancelled'; COMMENT ON COLUMN "linkis_ps_bml_resources_task"."submit_user" IS '任务提交用户名'; COMMENT ON COLUMN "linkis_ps_bml_resources_task"."system" IS '子系统名 wtss'; COMMENT ON COLUMN "linkis_ps_bml_resources_task"."instance" IS '物料库实例'; COMMENT ON COLUMN "linkis_ps_bml_resources_task"."client_ip" IS '请求IP'; COMMENT ON COLUMN "linkis_ps_bml_resources_task"."extra_params" IS '额外关键信息.如批量删除的资源IDs及versions,删除资源下的所有versions'; COMMENT ON COLUMN "linkis_ps_bml_resources_task"."err_msg" IS '任务失败信息.e.getMessage'; COMMENT ON COLUMN "linkis_ps_bml_resources_task"."start_time" IS '开始时间'; COMMENT ON COLUMN "linkis_ps_bml_resources_task"."end_time" IS '结束时间'; COMMENT ON COLUMN "linkis_ps_bml_resources_task"."last_update_time" IS '最后更新时间'; DROP TABLE IF EXISTS "linkis_ps_bml_project"; CREATE TABLE linkis_ps_bml_project ( id bigserial NOT NULL, "name" varchar(128) NULL, "system" varchar(64) NOT NULL DEFAULT 'dss'::character varying, "source" varchar(1024) NULL, description varchar(1024) NULL, creator varchar(128) NOT NULL, enabled int2 NULL DEFAULT 1, create_time timestamp(6) NULL DEFAULT now(), CONSTRAINT linkis_bml_project_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_name_bp ON linkis_ps_bml_project USING btree (name); DROP TABLE IF EXISTS "linkis_ps_bml_project_user"; CREATE TABLE linkis_ps_bml_project_user ( id bigserial NOT NULL, project_id int4 NOT NULL, username varchar(64) NULL, priv int4 NOT NULL, creator varchar(128) NOT NULL, create_time timestamp(6) NULL DEFAULT now(), expire_time timestamp(6) NULL, CONSTRAINT linkis_bml_project_user_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_name_pid ON linkis_ps_bml_project_user USING btree (username, project_id); DROP TABLE IF EXISTS "linkis_ps_bml_project_resource"; CREATE TABLE linkis_ps_bml_project_resource ( id serial4 NOT NULL, project_id int4 NOT NULL, resource_id varchar(128) NULL, CONSTRAINT linkis_bml_project_resource_pkey PRIMARY KEY (id) ); DROP TABLE IF EXISTS "linkis_ps_instance_label"; CREATE TABLE linkis_ps_instance_label ( id bigserial NOT NULL, label_key varchar(32) NOT NULL, label_value varchar(255) NOT NULL, label_feature varchar(16) NOT NULL, label_value_size int4 NOT NULL, update_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_instance_label_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_lk_lv_il ON linkis_ps_instance_label USING btree (label_key, label_value); COMMENT ON COLUMN "linkis_ps_instance_label"."label_key" IS 'string key'; COMMENT ON COLUMN "linkis_ps_instance_label"."label_value" IS 'string value'; COMMENT ON COLUMN "linkis_ps_instance_label"."label_feature" IS 'store the feature of label, but it may be redundant'; COMMENT ON COLUMN "linkis_ps_instance_label"."label_value_size" IS 'size of key -> value map'; COMMENT ON COLUMN "linkis_ps_instance_label"."update_time" IS 'update unix timestamp'; COMMENT ON COLUMN "linkis_ps_instance_label"."create_time" IS 'update unix timestamp'; DROP TABLE IF EXISTS "linkis_ps_instance_label_value_relation"; CREATE TABLE linkis_ps_instance_label_value_relation ( id bigserial NOT NULL, label_value_key varchar(255) NOT NULL, label_value_content varchar(255) NULL, label_id int4 NULL, update_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_ps_instance_label_value_relation_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_lvk_lid_ilvr ON linkis_ps_instance_label_value_relation USING btree (label_value_key, label_id); COMMENT ON COLUMN "linkis_ps_instance_label_value_relation"."label_value_key" IS 'value key'; COMMENT ON COLUMN "linkis_ps_instance_label_value_relation"."label_value_content" IS 'value content'; COMMENT ON COLUMN "linkis_ps_instance_label_value_relation"."label_id" IS 'id reference linkis_ps_instance_label -> id'; COMMENT ON COLUMN "linkis_ps_instance_label_value_relation"."update_time" IS 'update unix timestamp'; COMMENT ON COLUMN "linkis_ps_instance_label_value_relation"."create_time" IS 'create unix timestamp'; DROP TABLE IF EXISTS "linkis_ps_instance_label_relation"; CREATE TABLE linkis_ps_instance_label_relation ( id bigserial NOT NULL, label_id int4 NULL, service_instance varchar(128) NOT NULL, update_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_instance_label_relation_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_lid_instance ON linkis_ps_instance_label_relation USING btree (label_id, service_instance); COMMENT ON COLUMN "linkis_ps_instance_label_relation"."label_id" IS 'id reference linkis_ps_instance_label -> id'; COMMENT ON COLUMN "linkis_ps_instance_label_relation"."service_instance" IS 'structure like ${host|machine}:${port}'; COMMENT ON COLUMN "linkis_ps_instance_label_relation"."update_time" IS 'update unix timestamp'; COMMENT ON COLUMN "linkis_ps_instance_label_relation"."create_time" IS 'create unix timestamp'; DROP TABLE IF EXISTS "linkis_ps_instance_info"; CREATE TABLE linkis_ps_instance_info ( id bigserial NOT NULL, "instance" varchar(128) NULL, "name" varchar(128) NULL, update_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_instance_info_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_instance_ii ON linkis_ps_instance_info USING btree (instance); COMMENT ON COLUMN "linkis_ps_instance_info"."instance" IS 'structure like ${host|machine}:${port}'; COMMENT ON COLUMN "linkis_ps_instance_info"."name" IS 'equal application name in registry'; COMMENT ON COLUMN "linkis_ps_instance_info"."update_time" IS 'update unix timestamp'; COMMENT ON COLUMN "linkis_ps_instance_info"."create_time" IS 'create unix timestamp'; DROP TABLE IF EXISTS "linkis_ps_error_code"; CREATE TABLE linkis_ps_error_code ( id bigserial NOT NULL, error_code varchar(50) NOT NULL, error_desc varchar(1024) NOT NULL, error_regex varchar(1024) NULL, error_type int4 NULL DEFAULT 0, CONSTRAINT linkis_ps_error_code_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX idx_error_regex ON linkis_ps_error_code USING btree (error_regex); DROP TABLE IF EXISTS "linkis_cg_manager_service_instance"; CREATE TABLE linkis_cg_manager_service_instance ( id serial4 NOT NULL, "instance" varchar(128) NULL, "name" varchar(32) NULL, "owner" varchar(32) NULL, mark varchar(32) NULL, identifier varchar(32) NULL, ticketId varchar(255) NULL DEFAULT NULL, mapping_host varchar(128) NULL DEFAULT NULL, mapping_ports varchar(128) NULL DEFAULT NULL, update_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, updator varchar(32) NULL, creator varchar(32) NULL, CONSTRAINT linkis_manager_service_instance_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_instance_msi ON linkis_cg_manager_service_instance USING btree (instance); DROP TABLE IF EXISTS "linkis_cg_manager_linkis_resources"; CREATE TABLE linkis_cg_manager_linkis_resources ( id serial4 NOT NULL, max_resource varchar(1020) NULL, min_resource varchar(1020) NULL, used_resource varchar(1020) NULL, left_resource varchar(1020) NULL, expected_resource varchar(1020) NULL, locked_resource varchar(1020) NULL, "resourceType" varchar(255) NULL, "ticketId" varchar(255) NULL, update_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, updator varchar(255) NULL, creator varchar(255) NULL, CONSTRAINT linkis_manager_linkis_resources_pkey PRIMARY KEY (id) ); DROP TABLE IF EXISTS "linkis_cg_manager_lock"; CREATE TABLE linkis_cg_manager_lock ( id serial4 NOT NULL, lock_object varchar(255) NULL, time_out text NULL, update_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_manager_lock_pkey PRIMARY KEY (id) ); DROP TABLE IF EXISTS "linkis_cg_rm_external_resource_provider"; CREATE TABLE linkis_cg_rm_external_resource_provider ( id serial4 NOT NULL, resource_type varchar(32) NOT NULL, "name" varchar(32) NOT NULL, labels varchar(32) NULL, config text NOT NULL, CONSTRAINT linkis_external_resource_provider_pkey PRIMARY KEY (id) ); DROP TABLE IF EXISTS "linkis_cg_manager_engine_em"; CREATE TABLE linkis_cg_manager_engine_em ( id serial4 NOT NULL, engine_instance varchar(128) NULL, em_instance varchar(128) NULL, update_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_manager_engine_em_pkey PRIMARY KEY (id) ); DROP TABLE IF EXISTS "linkis_cg_manager_label"; CREATE TABLE linkis_cg_manager_label ( id serial4 NOT NULL, label_key varchar(50) NOT NULL, label_value varchar(255) NOT NULL, label_feature varchar(16) NOT NULL, label_value_size int4 NOT NULL, update_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_manager_label_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_lk_lv_ml ON linkis_cg_manager_label USING btree (label_key, label_value); DROP TABLE IF EXISTS "linkis_cg_manager_label_value_relation"; CREATE TABLE linkis_cg_manager_label_value_relation ( id serial4 NOT NULL, label_value_key varchar(255) NOT NULL, label_value_content varchar(255) NULL, label_id int4 NULL, update_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_cg_manager_label_value_relation_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_lvk_lid_mlvr ON linkis_cg_manager_label_value_relation USING btree (label_value_key, label_id); DROP TABLE IF EXISTS "linkis_cg_manager_label_resource"; CREATE TABLE linkis_cg_manager_label_resource ( id serial4 NOT NULL, label_id int4 NULL, resource_id int4 NULL, update_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_manager_label_resource_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_label_id_mlr ON linkis_cg_manager_label_resource USING btree (label_id); DROP TABLE IF EXISTS "linkis_cg_ec_resource_info_record"; CREATE TABLE linkis_cg_ec_resource_info_record ( id serial4 NOT NULL, label_value varchar(255) NOT NULL, create_user varchar(128) NOT NULL, service_instance varchar(128) NULL, ecm_instance varchar(128) NULL, ticket_id varchar(100) NOT NULL, status varchar(50) DEFAULT NULL, log_dir_suffix varchar(128) NULL, request_times int4 NULL, request_resource varchar(1020) NULL, used_times int4 NULL, used_resource varchar(1020) NULL, metrics TEXT NULL, release_times int4 NULL, released_resource varchar(1020) NULL, release_time timestamp(6) NULL, used_time timestamp(6) NULL, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_cg_ec_resource_info_record_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_tid_lv ON linkis_cg_ec_resource_info_record USING btree (ticket_id, label_value); CREATE INDEX idx_ticket_id ON linkis_cg_ec_resource_info_record USING btree (ticket_id); COMMENT ON COLUMN "linkis_cg_ec_resource_info_record"."label_value" IS 'ec labels stringValue'; COMMENT ON COLUMN "linkis_cg_ec_resource_info_record"."create_user" IS 'ec create user'; COMMENT ON COLUMN "linkis_cg_ec_resource_info_record"."service_instance" IS 'ec instance info'; COMMENT ON COLUMN "linkis_cg_ec_resource_info_record"."ecm_instance" IS 'ecm instance info'; COMMENT ON COLUMN "linkis_cg_ec_resource_info_record"."ticket_id" IS 'ec ticket id'; COMMENT ON COLUMN "linkis_cg_ec_resource_info_record"."status" IS 'EC status: Starting,Unlock,Locked,Idle,Busy,Running,ShuttingDown,Failed,Success'; COMMENT ON COLUMN "linkis_cg_ec_resource_info_record"."log_dir_suffix" IS 'log path'; COMMENT ON COLUMN "linkis_cg_ec_resource_info_record"."request_times" IS 'resource request times'; COMMENT ON COLUMN "linkis_cg_ec_resource_info_record"."request_resource" IS 'request resource'; COMMENT ON COLUMN "linkis_cg_ec_resource_info_record"."used_times" IS 'resource used time'; COMMENT ON COLUMN "linkis_cg_ec_resource_info_record"."used_resource" IS 'used resource'; COMMENT ON COLUMN "linkis_cg_ec_resource_info_record"."metrics" IS 'ec metrics'; COMMENT ON COLUMN "linkis_cg_ec_resource_info_record"."release_times" IS 'resource request times'; COMMENT ON COLUMN "linkis_cg_ec_resource_info_record"."released_resource" IS 'request resource'; COMMENT ON COLUMN "linkis_cg_ec_resource_info_record"."release_time" IS 'resource used time'; COMMENT ON COLUMN "linkis_cg_ec_resource_info_record"."used_time" IS 'used time'; COMMENT ON COLUMN "linkis_cg_ec_resource_info_record"."create_time" IS 'create time'; DROP TABLE IF EXISTS "linkis_cg_manager_label_service_instance"; CREATE TABLE linkis_cg_manager_label_service_instance ( id serial4 NOT NULL, label_id int4 NULL, service_instance varchar(128) NULL, update_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_manager_label_service_instance_pkey PRIMARY KEY (id) ); CREATE INDEX idx_lid_instance ON linkis_cg_manager_label_service_instance USING btree (label_id,service_instance); DROP TABLE IF EXISTS "linkis_cg_manager_label_user"; CREATE TABLE linkis_cg_manager_label_user ( id serial4 NOT NULL, username varchar(255) NULL, label_id int4 NULL, update_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_manager_label_user_pkey PRIMARY KEY (id) ); DROP TABLE IF EXISTS "linkis_cg_manager_metrics_history"; CREATE TABLE linkis_cg_manager_metrics_history ( id serial4 NOT NULL, instance_status int4 NULL, overload varchar(255) NULL, heartbeat_msg varchar(255) NULL, healthy_status int4 NULL, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, creator varchar(255) NULL, "ticketID" varchar(255) NULL, "serviceName" varchar(255) NULL, "instance" varchar(255) NULL, CONSTRAINT linkis_cg_manager_metrics_history_pkey PRIMARY KEY (id) ); DROP TABLE IF EXISTS "linkis_cg_manager_service_instance_metrics"; CREATE TABLE linkis_cg_manager_service_instance_metrics ( "instance" varchar(128) NOT NULL, instance_status int4 NULL, overload varchar(255) NULL, heartbeat_msg text NULL, healthy_status varchar(255) NULL, update_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, description varchar(256) NULL, CONSTRAINT linkis_manager_service_instance_metrics_pkey PRIMARY KEY (instance) ); DROP TABLE IF EXISTS "linkis_cg_engine_conn_plugin_bml_resources"; CREATE TABLE linkis_cg_engine_conn_plugin_bml_resources ( id bigserial NOT NULL, engine_conn_type varchar(100) NOT NULL, "version" varchar(100) NULL, file_name varchar(255) NULL, file_size int8 NOT NULL DEFAULT 0, last_modified int8 NULL, bml_resource_id varchar(100) NOT NULL, bml_resource_version varchar(200) NOT NULL, create_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, last_update_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_engine_conn_plugin_bml_resources_pkey PRIMARY KEY (id) ); COMMENT ON COLUMN "linkis_cg_engine_conn_plugin_bml_resources"."id" IS '主键'; COMMENT ON COLUMN "linkis_cg_engine_conn_plugin_bml_resources"."engine_conn_type" IS 'Engine type'; COMMENT ON COLUMN "linkis_cg_engine_conn_plugin_bml_resources"."version" IS 'version'; COMMENT ON COLUMN "linkis_cg_engine_conn_plugin_bml_resources"."file_name" IS 'file name'; COMMENT ON COLUMN "linkis_cg_engine_conn_plugin_bml_resources"."file_size" IS 'file size'; COMMENT ON COLUMN "linkis_cg_engine_conn_plugin_bml_resources"."last_modified" IS 'File update time'; COMMENT ON COLUMN "linkis_cg_engine_conn_plugin_bml_resources"."bml_resource_id" IS 'Owning system'; COMMENT ON COLUMN "linkis_cg_engine_conn_plugin_bml_resources"."bml_resource_version" IS 'Resource owner'; COMMENT ON COLUMN "linkis_cg_engine_conn_plugin_bml_resources"."create_time" IS 'created time'; COMMENT ON COLUMN "linkis_cg_engine_conn_plugin_bml_resources"."last_update_time" IS 'update time'; DROP TABLE IF EXISTS "linkis_ps_dm_datasource"; CREATE TABLE linkis_ps_dm_datasource ( id bigserial NOT NULL, datasource_name varchar(255) NOT NULL, "datasource_desc" varchar(255) NULL, datasource_type_id int8 NOT NULL, create_identify varchar(255) NULL, create_system varchar(255) NULL, "parameter" varchar(1024) NULL, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, modify_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, create_user varchar(255) NULL, modify_user varchar(255) NULL, labels varchar(255) NULL, version_id int8 NULL, expire boolean DEFAULT '0', published_version_id int8 NULL, CONSTRAINT linkis_ps_dm_datasource_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_datasource_name ON linkis_ps_dm_datasource USING btree (datasource_name); DROP TABLE IF EXISTS "linkis_ps_dm_datasource_env"; CREATE TABLE linkis_ps_dm_datasource_env ( id bigserial NOT NULL, env_name varchar(32) NOT NULL, "env_desc" varchar(255) NULL, datasource_type_id int8 NOT NULL, "parameter" varchar(1024) NULL, create_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, create_user varchar(255) NULL, modify_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, modify_user varchar(255) NULL, CONSTRAINT linkis_ps_dm_datasource_env_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_name_dtid ON linkis_ps_dm_datasource_env USING btree (env_name,datasource_type_id); CREATE UNIQUE INDEX uniq_env_name ON linkis_ps_dm_datasource_env USING btree (env_name); DROP TABLE IF EXISTS "linkis_ps_dm_datasource_type"; CREATE TABLE linkis_ps_dm_datasource_type ( id bigserial NOT NULL, "name" varchar(32) NOT NULL, description varchar(255) NULL, "option" varchar(32) NULL, "classifier" varchar(32) NOT NULL, "icon" varchar(255) NULL, layers int4 NOT NULL, description_en varchar(255) NULL, option_en varchar(32) NULL, classifier_en varchar(32) NULL, CONSTRAINT linkis_ps_dm_datasource_type_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_name_ddt ON linkis_ps_dm_datasource_type USING btree (name); COMMENT ON COLUMN "linkis_ps_dm_datasource_type"."description_en" IS 'english description'; COMMENT ON COLUMN "linkis_ps_dm_datasource_type"."option_en" IS 'english option'; COMMENT ON COLUMN "linkis_ps_dm_datasource_type"."classifier_en" IS 'english classifier'; DROP TABLE IF EXISTS "linkis_ps_dm_datasource_type_key"; CREATE TABLE linkis_ps_dm_datasource_type_key ( id bigserial NOT NULL, data_source_type_id int8 NOT NULL, "key" varchar(32) NOT NULL, "name" varchar(32) NOT NULL, "name_en" varchar(32) NOT NULL, default_value varchar(50) NULL, value_type varchar(50) NOT NULL, "scope" varchar(50) NULL, "require" boolean DEFAULT '0', description varchar(200) NULL, description_en varchar(200) NULL, value_regex varchar(200) NULL, ref_id int8 NULL, "ref_value" varchar(50) NULL, "data_source" varchar(200) NULL, update_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, create_time timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT linkis_ps_dm_datasource_type_key_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_dstid_key ON linkis_ps_dm_datasource_type_key USING btree (data_source_type_id,"key"); DROP TABLE IF EXISTS "linkis_ps_dm_datasource_version"; CREATE TABLE linkis_ps_dm_datasource_version ( version_id bigserial NOT NULL, datasource_id int8 NOT NULL, "parameter" varchar(2048) NULL, "comment" varchar(255) NULL, create_time timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP, create_user varchar(255) NULL, CONSTRAINT linkis_ps_dm_datasource_version_pkey PRIMARY KEY (version_id,datasource_id) ); CREATE UNIQUE INDEX uniq_vid_did ON linkis_ps_dm_datasource_version USING btree (version_id,"datasource_id"); DROP TABLE IF EXISTS "linkis_mg_gateway_auth_token"; CREATE TABLE linkis_mg_gateway_auth_token ( id bigserial NOT NULL, "token_name" varchar(128) NOT NULL, legal_users text NULL, legal_hosts text NULL, "business_owner" varchar(32) NULL, create_time timestamp(6) NULL, update_time timestamp(6) NULL, elapse_day int8 NULL, update_by varchar(32) NULL, CONSTRAINT linkis_mg_gateway_auth_token_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_token_name ON linkis_mg_gateway_auth_token USING btree (token_name); DROP TABLE IF EXISTS "linkis_cg_tenant_label_config"; CREATE TABLE "linkis_cg_tenant_label_config" ( "id" bigserial NOT NULL, "user" varchar(50) NOT NULL, "creator" varchar(50) NOT NULL, "tenant_value" varchar(128) NOT NULL, "create_time" timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "update_time" timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "desc" varchar(100) NOT NULL, "bussiness_user" varchar(50) NOT NULL, CONSTRAINT linkis_cg_tenant_label_config_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_user_creator_tlc ON linkis_cg_tenant_label_config USING btree ("user",creator); DROP TABLE IF EXISTS "linkis_cg_user_ip_config"; CREATE TABLE "linkis_cg_user_ip_config" ( "id" bigserial NOT NULL, "user" varchar(50) NOT NULL, "creator" varchar(50) NOT NULL, "ip_list" text NOT NULL, "create_time" timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "update_time" timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP, "desc" varchar(100) NOT NULL, "bussiness_user" varchar(50) NOT NULL, CONSTRAINT linkis_cg_user_ip_config_pkey PRIMARY KEY (id) ); CREATE UNIQUE INDEX uniq_user_creator_uic ON linkis_cg_user_ip_config USING btree ("user",creator); DROP TABLE IF EXISTS linkis_org_user; CREATE TABLE linkis_org_user ( cluster_code varchar(16) COMMENT 'cluster code', user_type varchar(64) COMMENT 'user type', user_name varchar(128) PRIMARY KEY COMMENT 'username', org_id varchar(16) COMMENT 'org id', org_name varchar(64) COMMENT 'org name', queue_name varchar(64) COMMENT 'yarn queue name', db_name varchar(64) COMMENT 'default db name', interface_user varchar(64) COMMENT 'interface user', is_union_analyse varchar(64) COMMENT 'is union analyse', create_time varchar(64) COMMENT 'create time', user_itsm_no varchar(64) COMMENT 'user itsm no' ) COMMENT ON TABLE linkis_org_user IS 'user org info';