CREATE TABLE t_compare_report_field_template (
|
template_id BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,
|
template_name VARCHAR(100) NOT NULL,
|
template_type VARCHAR(30) NOT NULL DEFAULT 'compare',
|
fields_json JSON NOT NULL,
|
creator_id BIGINT NOT NULL,
|
creator_name VARCHAR(64) NOT NULL,
|
created_at_utc DATETIME(3) NOT NULL,
|
updated_at_utc DATETIME(3) NOT NULL,
|
UNIQUE KEY uk_compare_field_template_name (template_type, template_name)
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='对比报表字段模板';
|
