CREATE TABLE audio_segment (
    id             CHAR(36) NOT NULL COMMENT '主键，存放UUID字符',
    parent_id      CHAR(36) NULL COMMENT '音频管理ID/父级ID',
    segment_url    VARCHAR(500) NULL COMMENT '音频分段访问URL',
    segment_text   TEXT NULL COMMENT '分段对应文本内容',
    owner_phone    VARCHAR(30) NULL COMMENT '所属人电话',
    owner_id       CHAR(36) NULL COMMENT '所属人ID',
    duration      int NULL COMMENT '时长',
    created_at     TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    updated_at     TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    PRIMARY KEY (id),
    KEY idx_audio_segment_parent_id (parent_id)
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COMMENT = '音频分段信息表';



