CREATE TABLE def_ml_models (
model_id VARCHAR(36) NOT NULL,
model_name VARCHAR(255) NOT NULL,
version VARCHAR(50) NOT NULL,
package VARCHAR(255) NOT NULL,
Module VARCHAR(255),
model_type VARCHAR(100),
model_binary LONGBLOB NOT NULL,
encoder_binary LONGBLOB,
metadata_json JSON,
feature_names JSON,
training_metrics JSON,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
created_by VARCHAR(255),
is_active BOOLEAN DEFAULT FALSE,
PRIMARY KEY (model_id, package),
UNIQUE KEY unique_name_version (model_name, version, package),
INDEX idx_model_name (model_name, package),
INDEX idx_model_active (model_name, is_active, package),
INDEX idx_created_at (created_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};