SettingLib/SQL/ACASetting.sqlbook

-- SQLBook: Code
-- Active: 1751960213665@@192.1.2.61@5236@EQM_CESHI

#存储对比项的表格 tACACompareItems
#对比项的对比通道表 tACACompareItemRoad

#创建 tACACompareItems
-- 创建表
CREATE TABLE tACACompareItems
(
    ItemID INT PRIMARY KEY,
    ItemName VARCHAR(64) NOT NULL,
    ItemEnable BIT NOT NULL DEFAULT 1,
    RoadCount INT DEFAULT 0,
    SilentEnable BIT NOT NULL DEFAULT 0,
    SilentThreshold INT DEFAULT 0,
    SilentDuration INT DEFAULT 0,
    SilentSensitivity INT DEFAULT 0,
    OverloadEnable BIT NOT NULL DEFAULT 0,
    OverloadThreshold INT DEFAULT 0,
    OverloadDuration INT DEFAULT 0,
    OverloadSensitivity INT DEFAULT 0,
    PhaseEnable BIT NOT NULL DEFAULT 0,
    PhaseThreshold DOUBLE DEFAULT 0,
    PhaseDuration INT DEFAULT 0,
    PhaseSensitivity INT DEFAULT 0
);
-- 表注释
COMMENT ON TABLE tACACompareItems IS 'ACA对比项表';
-- 字段注释
COMMENT ON COLUMN tACACompareItems.ItemID IS '对比项ID';
COMMENT ON COLUMN tACACompareItems.ItemName IS '对比项名称';
COMMENT ON COLUMN tACACompareItems.ItemEnable IS '对比项是否启用';
COMMENT ON COLUMN tACACompareItems.RoadCount IS '对比通道数';
COMMENT ON COLUMN tACACompareItems.SilentEnable IS '是否启用静音';
COMMENT ON COLUMN tACACompareItems.SilentThreshold IS '静音阈值';
COMMENT ON COLUMN tACACompareItems.SilentDuration IS '静音持续时间';
COMMENT ON COLUMN tACACompareItems.SilentSensitivity IS '静音灵敏度';
COMMENT ON COLUMN tACACompareItems.OverloadEnable IS '是否启用过载';
COMMENT ON COLUMN tACACompareItems.OverloadThreshold IS '过载阈值';
COMMENT ON COLUMN tACACompareItems.OverloadDuration IS '过载持续时间';
COMMENT ON COLUMN tACACompareItems.OverloadSensitivity IS '过载灵敏度';
COMMENT ON COLUMN tACACompareItems.PhaseEnable IS '是否启用反相';
COMMENT ON COLUMN tACACompareItems.PhaseThreshold IS '反相阈值';
COMMENT ON COLUMN tACACompareItems.PhaseDuration IS '反相持续时间';
COMMENT ON COLUMN tACACompareItems.PhaseSensitivity IS '反相灵敏度';
-- 创建索引
-- CREATE INDEX idx_tACACompareItems_ItemName ON tACACompareItems (ItemName);

-- SQLBook: Code
#删除 tACACompareItems
DROP TABLE IF EXISTS "EQM_CESHI".tACACompareItems;
-- SQLBook: Code

#创建 tACACompareItemRoad
#这里设置了级联删除，当 tACACompareItems 表中的某个对比项被删除时，tACACompareItemRoad 中对应的通道也会被删除。
CREATE TABLE tACACompareItemRoad
(
    ItemID INT NOT NULL,
    RoadNum INT NOT NULL,
    RoadName VARCHAR(64) NOT NULL,
    RoadRecordEnable BIT NOT NULL DEFAULT 1,
    SoundCardNum INT NOT NULL DEFAULT 0,
    SoundCardID VARCHAR(64),
    SoundCardName VARCHAR(64),
    SoundCardRoadNum INT NOT NULL DEFAULT 0,
    ChannelID INT,
    ChannelName VARCHAR(64),
    PRIMARY KEY (ItemID, RoadNum),
    FOREIGN KEY (ItemID) REFERENCES tACACompareItems(ItemID)
        ON DELETE CASCADE
);

-- 表注释
COMMENT ON TABLE tACACompareItemRoad IS '对比项通道表';
-- 字段注释
COMMENT ON COLUMN tACACompareItemRoad.ItemID IS '对比项ID';
COMMENT ON COLUMN tACACompareItemRoad.RoadNum IS '通道编号，1是主通道，其他对比通道依次向后排';
COMMENT ON COLUMN tACACompareItemRoad.RoadName IS '通道名称';
COMMENT ON COLUMN tACACompareItemRoad.RoadRecordEnable IS '通道录音是否启用';
COMMENT ON COLUMN tACACompareItemRoad.SoundCardNum IS '声卡编号，在系统中的编号';
COMMENT ON COLUMN tACACompareItemRoad.SoundCardID IS '声卡ID，可以使用声卡ID来打开声卡';
COMMENT ON COLUMN tACACompareItemRoad.SoundCardName IS '声卡名称';
COMMENT ON COLUMN tACACompareItemRoad.SoundCardRoadNum IS '声卡通道编号，使用声卡编号和声卡通道编号开始录音';
COMMENT ON COLUMN tACACompareItemRoad.ChannelID IS '频道ID';
COMMENT ON COLUMN tACACompareItemRoad.ChannelName IS '频道名称';