25 lines
1.0 KiB
SQL
25 lines
1.0 KiB
SQL
-- =====================================================================================
|
||
-- Schema: 系统配置表
|
||
-- 位置：docs/sql/10_schema/admin/ml_system_configs_v1.sql
|
||
-- 对象类型：TABLE
|
||
-- 版本：v1
|
||
-- 说明：统一存储系统、应用、维护等模块的 Key-Value 配置项
|
||
-- =====================================================================================
|
||
|
||
CREATE TABLE IF NOT EXISTS public.ml_system_configs (
|
||
id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
|
||
config_key TEXT UNIQUE NOT NULL,
|
||
config_value JSONB NOT NULL DEFAULT '{}'::jsonb,
|
||
description TEXT,
|
||
created_at TIMESTAMPTZ NOT NULL DEFAULT now(),
|
||
updated_at TIMESTAMPTZ NOT NULL DEFAULT now()
|
||
);
|
||
|
||
-- 索引
|
||
CREATE INDEX IF NOT EXISTS idx_system_configs_key ON public.ml_system_configs (config_key);
|
||
|
||
-- 注释
|
||
COMMENT ON TABLE public.ml_system_configs IS '系统全局配置表';
|
||
COMMENT ON COLUMN public.ml_system_configs.config_key IS '配置唯一标识键';
|
||
COMMENT ON COLUMN public.ml_system_configs.config_value IS '配置内容 (JSONB)';
|