191 lines (190 with data), 225.3 kB
SQLite format 3 @ H 7 5 I H .v ö .ūö 0
¶ ¶ H ]Default/home/amirdkb/Desktop/Neshan/Q3/mlruns/0active’N±’N±
õ õ
Default
š š %4465047574b1
š š % 4465047574b1
Æ Q -ĮÄp
Ā×®
§
d¶
;ž³Qn Eó{{ b11otablemodel_version_tagsmodel_version_tagsCREATE TABLE model_version_tags (
"key" VARCHAR(250) NOT NULL,
value VARCHAR(5000),
name VARCHAR(256) NOT NULL,
version INTEGER NOT NULL,
CONSTRAINT model_version_tag_pk PRIMARY KEY ("key", name, version),
FOREIGN KEY(name, version) REFERENCES model_versions (name, version) ON UPDATE cascade
)ytablerunsrunsCREATE TABLE "runs" (
run_uuid VARCHAR(32) NOT NULL,
name VARCHAR(250),
source_type VARCHAR(20),
source_name VARCHAR(500),
entry_point_name VARCHAR(50),
user_id VARCHAR(256),
status VARCHAR(9),
start_time BIGINT,
end_time BIGINT,
source_version VARCHAR(50),
lifecycle_stage VARCHAR(20),
artifact_uri VARCHAR(200),
experiment_id INTEGER, deleted_time BIGINT,
CONSTRAINT run_pk PRIMARY KEY (run_uuid),
CONSTRAINT runs_lifecycle_stage CHECK (lifecycle_stage IN ('active', 'deleted')),
CONSTRAINT source_type CHECK (source_type IN ('NOTEBOOK', 'JOB', 'LOCAL', 'UNKNOWN', 'PROJECT')),
FOREIGN KEY(experiment_id) REFERENCES experiments (experiment_id),
CHECK (status IN ('SCHEDULED', 'FAILED', 'FINISHED', 'RUNNING', 'KILLED'))
))++ tablealembic_versionalembic_versionCREATE TABLE alembic_version (
version_num VARCHAR(32) NOT NULL,
CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num)
)=Q+ indexsqlite_autoindex_alembic_version_1alembic_version
ų I]7 indexsqlite_autoindex_registered_model_tags_1registered_model_tags:77tableregistered_model_tagsregistered_model_tagsCREATE TABLE registered_model_tags (
"key" VARCHAR(250) NOT NULL,
value VARCHAR(5000),
name VARCHAR(256) NOT NULL,
CONSTRAINT registered_model_tag_pk PRIMARY KEY ("key", name),
FOREIGN KEY(name) REFERENCES registered_models (name) ON UPDATE cascade
)'; indexsqlite_autoindex_runs_1runsAU/ indexsqlite_autoindex_registered_models_1registered_models//7tableregistered_modelsregistered_modelsCREATE TABLE registered_models (
name VARCHAR(256) NOT NULL,
creation_time BIGINT,
last_updated_time BIGINT,
description VARCHAR(5000),
CONSTRAINT registered_model_pk PRIMARY KEY (name),
UNIQUE (name)
)'; indexsqlite_autoindex_tags_1tagsh3tabletagstagsCREATE TABLE "tags" (
"key" VARCHAR(250) NOT NULL,
value VARCHAR(5000),
run_uuid VARCHAR(32) NOT NULL,
CONSTRAINT tag_pk PRIMARY KEY ("key", run_uuid),
FOREIGN KEY(run_uuid) REFERENCES runs (run_uuid)
)=Q+ indexsqlite_autoindex_experiment_tags_1experiment_tags)++ tableexperiment_tagsexperiment_tagsCREATE TABLE experiment_tags (
"key" VARCHAR(250) NOT NULL,
value VARCHAR(5000),
experiment_id INTEGER NOT NULL,
CONSTRAINT experiment_tag_pk PRIMARY KEY ("key", experiment_id),
FOREIGN KEY(experiment_id) REFERENCES experiments (experiment_id)
)##
itableexperimentsexperimentsCREATE TABLE experiments (
experiment_id INTEGER NOT NULL,
name VARCHAR(256) NOT NULL,
artifact_location VARCHAR(256),
lifecycle_stage VARCHAR(32), creation_time BIGINT, last_update_time BIGINT,
CONSTRAINT experiment_pk PRIMARY KEY (experiment_id),
CONSTRAINT experiments_lifecycle_stage CHECK (lifecycle_stage IN ('active', 'deleted')),
UNIQUE (name)
)5I# indexsqlite_autoindex_experiments_1experiments
q
³
T UŽ”ÖEÄl
ÄO³³³³ J S}
į Ā Ā ;0Itabledatasetsdatasets"CREATE TABLE datasets (
dataset_uuid VARCHAR(36) NOT NULL,
experiment_id INTEGER NOT NULL,
name VARCHAR(500) NOT NULL,
digest VARCHAR(36) NOT NULL,
dataset_source_type VARCHAR(36) NOT NULL,
dataset_source TEXT NOT NULL,
dataset_schema TEXT,
dataset_profile TEXT,
CONSTRAINT dataset_pk PRIMARY KEY (experiment_id, name, digest),
FOREIGN KEY(experiment_id) REFERENCES experiments (experiment_id)
)© ū V*3sindexindex_tags_run_uuidtagsCREATE INDEX index_tags_run_uuid ON tags (run_uuid))G)indexindex_latest_metrics_run_uuidlatest_metricsCREATE INDEX index_latest_metrics_run_uuid ON latest_metrics (run_uuid)b(9indexindex_metrics_run_uuidmetrics CREATE INDEX index_metrics_run_uuid ON metrics (run_uuid) - -&A indexsqlite_autoindex_metrics_1metrics% tablemetricsmetricsCREATE TABLE "metrics" (
"key" VARCHAR(250) NOT NULL,
value FLOAT NOT NULL,
timestamp BIGINT NOT NULL,
run_uuid VARCHAR(32) NOT NULL,
step BIGINT DEFAULT '0' NOT NULL,
is_nan BOOLEAN DEFAULT '0' NOT NULL,
CONSTRAINT metric_pk PRIMARY KEY ("key", timestamp, step, run_uuid, value, is_nan),
FOREIGN KEY(run_uuid) REFERENCES runs (run_uuid),
CHECK (is_nan IN (0, 1))
);$O) indexsqlite_autoindex_latest_metrics_1latest_metricst#))
#tablelatest_metricslatest_metricsCREATE TABLE "latest_metrics" (
"key" VARCHAR(250) NOT NULL,
value FLOAT NOT NULL,
timestamp BIGINT,
step BIGINT NOT NULL,
is_nan BOOLEAN NOT NULL,
run_uuid VARCHAR(32) NOT NULL,
CONSTRAINT latest_metric_pk PRIMARY KEY ("key", run_uuid),
FOREIGN KEY(run_uuid) REFERENCES runs (run_uuid),
CHECK (is_nan IN (0, 1))
);"O) indexsqlite_autoindex_model_versions_1model_versions Ā (!))tablemodel_versionsmodel_versionsCREATE TABLE "model_versions" (
name VARCHAR(256) NOT NULL,
version INTEGER NOT NULL,
creation_time BIGINT,
last_updated_time BIGINT,
description VARCHAR(5000),
user_id VARCHAR(256),
current_stage VARCHAR(20),
source VARCHAR(500),
run_id VARCHAR(32),
status VARCHAR(20),
status_message VARCHAR(500),
run_link VARCHAR(500), storage_location VARCHAR(500),
CONSTRAINT model_version_pk PRIMARY KEY (name, version),
FOREIGN KEY(name) REFERENCES registered_models (name) ON UPDATE CASCADE
)C W1 indexsqlite_autoindex_model_version_tags_1model_version_tags.==
#tableregistered_model_aliasesregistered_model_aliases
CREATE TABLE registered_model_aliases (
alias VARCHAR(256) NOT NULL,
version INTEGER NOT NULL,
name VARCHAR(256) NOT NULL,
CONSTRAINT registered_model_alias_pk PRIMARY KEY (name, alias),
CONSTRAINT registered_model_alias_name_fkey FOREIGN KEY(name) REFERENCES registered_models (name) ON DELETE cascade ON UPDATE cascade
)O/c= indexsqlite_autoindex_registered_model_aliases_1registered_model_aliases `
'