CREATE TABLE def_dataset (
name VARCHAR(50) NOT NULL,
package VARCHAR(255) NOT NULL,
Module VARCHAR(255),
description TEXT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (name, package)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};
CREATE TABLE def_featuresets (
name VARCHAR(255) NOT NULL,
package VARCHAR(255) NOT NULL,
Module VARCHAR(255),
sample_guid VARCHAR(255) NOT NULL,
features_json JSON NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (name, package, sample_guid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};
CREATE TABLE def_featurestore (
feature_name VARCHAR(255) NOT NULL,
package VARCHAR(255) NOT NULL,
Module VARCHAR(255),
original_feature VARCHAR(255),
feature_type VARCHAR(50) NOT NULL,
computation_logic TEXT,
ConstantsTables VARCHAR(255),
description TEXT,
provenance TEXT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (feature_name, package)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};
CREATE TABLE def_model_evaluation (
model_name VARCHAR(191) NOT NULL,
dataset_name VARCHAR(191) NOT NULL,
package VARCHAR(191) NOT NULL,
Module VARCHAR(255),
evaluation_metrics_json JSON NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (model_name, dataset_name, package)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE={collation};