128 lines
5.6 KiB
SQL
128 lines
5.6 KiB
SQL
USE model_operations;
|
|
|
|
CREATE TABLE IF NOT EXISTS ops_model_categories (
|
|
category_code VARCHAR(32) NOT NULL COMMENT 'std/bai/big/afd',
|
|
category_name VARCHAR(100) NOT NULL,
|
|
sort_order SMALLINT NOT NULL DEFAULT 0,
|
|
status VARCHAR(16) NOT NULL DEFAULT 'active' COMMENT 'active/inactive',
|
|
created_at DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
|
|
updated_at DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3)
|
|
ON UPDATE CURRENT_TIMESTAMP(3),
|
|
is_deleted TINYINT(1) NOT NULL DEFAULT 0,
|
|
deleted_at DATETIME(3) NULL,
|
|
PRIMARY KEY (category_code),
|
|
KEY idx_ops_categories_status (status, sort_order)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
COMMENT='固定模型大类字典，由运维模块维护';
|
|
|
|
CREATE TABLE IF NOT EXISTS ops_banks (
|
|
bank_id CHAR(26) NOT NULL,
|
|
workspace_id CHAR(26) NOT NULL COMMENT '逻辑引用 model_platform.workspaces',
|
|
bank_code VARCHAR(64) NOT NULL,
|
|
bank_name VARCHAR(150) NOT NULL,
|
|
is_wuji_bank TINYINT(1) NOT NULL DEFAULT 0,
|
|
bank_status VARCHAR(16) NOT NULL DEFAULT 'active' COMMENT 'active/inactive',
|
|
source_system VARCHAR(64) NOT NULL DEFAULT 'model_platform',
|
|
source_bank_ref VARCHAR(128) NULL,
|
|
source_updated_at DATETIME(3) NULL,
|
|
created_at DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
|
|
updated_at DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3)
|
|
ON UPDATE CURRENT_TIMESTAMP(3),
|
|
is_deleted TINYINT(1) NOT NULL DEFAULT 0,
|
|
deleted_at DATETIME(3) NULL,
|
|
PRIMARY KEY (bank_id),
|
|
UNIQUE KEY uk_ops_banks_code (workspace_id, bank_code),
|
|
UNIQUE KEY uk_ops_banks_source (
|
|
workspace_id, source_system, source_bank_ref
|
|
),
|
|
KEY idx_ops_banks_workspace_status (
|
|
workspace_id, bank_status, is_deleted
|
|
)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
COMMENT='银行主数据；模型平台可受控直写';
|
|
|
|
CREATE TABLE IF NOT EXISTS ops_model_instances (
|
|
model_instance_id CHAR(26) NOT NULL,
|
|
workspace_id CHAR(26) NOT NULL COMMENT '逻辑引用 model_platform.workspaces',
|
|
bank_id CHAR(26) NOT NULL COMMENT '逻辑引用 ops_banks',
|
|
category_code VARCHAR(32) NOT NULL COMMENT '逻辑引用 ops_model_categories',
|
|
model_id VARCHAR(128) NOT NULL COMMENT '工作空间内全局唯一业务模型ID',
|
|
model_name VARCHAR(200) NOT NULL,
|
|
model_status VARCHAR(24) NOT NULL DEFAULT 'normal'
|
|
COMMENT 'normal/escort/escort_finished/offline',
|
|
current_version_id CHAR(26) NULL COMMENT '逻辑引用 ops_model_versions',
|
|
is_common_model TINYINT(1) NOT NULL DEFAULT 0,
|
|
common_source_model_id CHAR(26) NULL
|
|
COMMENT '复用时逻辑引用通用模型实例',
|
|
common_model_name VARCHAR(200) NULL,
|
|
source_system VARCHAR(64) NOT NULL DEFAULT 'model_platform',
|
|
source_model_ref VARCHAR(128) NULL,
|
|
source_updated_at DATETIME(3) NULL,
|
|
created_at DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
|
|
updated_at DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3)
|
|
ON UPDATE CURRENT_TIMESTAMP(3),
|
|
is_deleted TINYINT(1) NOT NULL DEFAULT 0,
|
|
deleted_at DATETIME(3) NULL,
|
|
PRIMARY KEY (model_instance_id),
|
|
UNIQUE KEY uk_ops_models_business_id (workspace_id, model_id),
|
|
UNIQUE KEY uk_ops_models_source (
|
|
workspace_id, source_system, source_model_ref
|
|
),
|
|
KEY fk_ops_models_bank (bank_id),
|
|
KEY fk_ops_models_current_version (current_version_id),
|
|
KEY fk_ops_models_common_source (common_source_model_id),
|
|
KEY idx_ops_models_filters (
|
|
workspace_id, category_code, model_status, is_deleted
|
|
)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
COMMENT='业务模型实例；模型平台可受控直写';
|
|
|
|
CREATE TABLE IF NOT EXISTS ops_model_versions (
|
|
model_version_id CHAR(26) NOT NULL,
|
|
workspace_id CHAR(26) NOT NULL COMMENT '逻辑引用 model_platform.workspaces',
|
|
model_instance_id CHAR(26) NOT NULL COMMENT '逻辑引用 ops_model_instances',
|
|
version_label VARCHAR(64) NOT NULL COMMENT '例如 v2.3',
|
|
version_status VARCHAR(24) NOT NULL DEFAULT 'active'
|
|
COMMENT 'draft/escort/active/offline',
|
|
platform_versions_id CHAR(26) NULL
|
|
COMMENT '可选逻辑引用 model_platform.versions',
|
|
developer_user_id CHAR(26) NULL COMMENT '逻辑引用 model_platform.users',
|
|
developer_display_name VARCHAR(100) NULL COMMENT '历史展示快照',
|
|
development_date DATE NULL,
|
|
iteration_start_date DATE NULL,
|
|
last_iteration_date DATE NULL,
|
|
iteration_reason VARCHAR(1000) NULL,
|
|
escort_start_date DATE NULL,
|
|
escort_end_date DATE NULL,
|
|
online_date DATE NULL,
|
|
offline_date DATE NULL,
|
|
development_ks DECIMAL(12,8) NULL COMMENT '0-1比率',
|
|
development_psi DECIMAL(12,8) NULL COMMENT '0-1比率',
|
|
max_lift DECIMAL(12,8) NULL,
|
|
scoring_logic_storage_object_id CHAR(26) NULL
|
|
COMMENT '逻辑引用 model_platform.storage_objects',
|
|
source_system VARCHAR(64) NOT NULL DEFAULT 'model_platform',
|
|
source_version_ref VARCHAR(128) NULL,
|
|
source_updated_at DATETIME(3) NULL,
|
|
created_at DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
|
|
updated_at DATETIME(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3)
|
|
ON UPDATE CURRENT_TIMESTAMP(3),
|
|
is_deleted TINYINT(1) NOT NULL DEFAULT 0,
|
|
deleted_at DATETIME(3) NULL,
|
|
PRIMARY KEY (model_version_id),
|
|
UNIQUE KEY uk_ops_model_versions_label (
|
|
model_instance_id, version_label
|
|
),
|
|
UNIQUE KEY uk_ops_model_versions_source (
|
|
workspace_id, source_system, source_version_ref
|
|
),
|
|
KEY fk_ops_model_versions_model (model_instance_id),
|
|
KEY fk_ops_model_versions_platform_version (platform_versions_id),
|
|
KEY fk_ops_model_versions_developer (developer_user_id),
|
|
KEY idx_ops_model_versions_lifecycle (
|
|
workspace_id, version_status, online_date, offline_date
|
|
)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
|
|
COMMENT='模型版本与生命周期；模型平台可受控直写';
|
|
|