mssql.sql
1 2 CREATE TABLE alembic_version ( 3 version_num VARCHAR(32) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 4 CONSTRAINT alembic_version_pkc PRIMARY KEY (version_num) 5 ) 6 7 8 CREATE TABLE budget_policies ( 9 budget_policy_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 10 budget_unit VARCHAR(32) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 11 budget_amount FLOAT NOT NULL, 12 duration_unit VARCHAR(32) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 13 duration_value INTEGER NOT NULL, 14 target_scope VARCHAR(32) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 15 budget_action VARCHAR(32) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 16 created_by VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 17 created_at BIGINT NOT NULL, 18 last_updated_by VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 19 last_updated_at BIGINT NOT NULL, 20 workspace VARCHAR(63) COLLATE "SQL_Latin1_General_CP1_CI_AS" DEFAULT ('default') NOT NULL, 21 CONSTRAINT budget_policies_pk PRIMARY KEY (budget_policy_id) 22 ) 23 24 25 CREATE TABLE entity_associations ( 26 association_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 27 source_type VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 28 source_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 29 destination_type VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 30 destination_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 31 created_time BIGINT, 32 CONSTRAINT entity_associations_pk PRIMARY KEY (source_type, source_id, destination_type, destination_id) 33 ) 34 35 36 CREATE TABLE evaluation_datasets ( 37 dataset_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 38 name VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 39 schema VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 40 profile VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 41 digest VARCHAR(64) COLLATE "SQL_Latin1_General_CP1_CI_AS", 42 created_time BIGINT, 43 last_update_time BIGINT, 44 created_by VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 45 last_updated_by VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 46 workspace VARCHAR(63) COLLATE "SQL_Latin1_General_CP1_CI_AS" DEFAULT ('default') NOT NULL, 47 CONSTRAINT evaluation_datasets_pk PRIMARY KEY (dataset_id) 48 ) 49 50 51 CREATE TABLE experiments ( 52 experiment_id INTEGER GENERATED BY DEFAULT AS IDENTITY (INCREMENT BY 1 START WITH 1), 53 name VARCHAR(256) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 54 artifact_location VARCHAR(256) COLLATE "SQL_Latin1_General_CP1_CI_AS", 55 lifecycle_stage VARCHAR(32) COLLATE "SQL_Latin1_General_CP1_CI_AS", 56 creation_time BIGINT, 57 last_update_time BIGINT, 58 workspace VARCHAR(63) COLLATE "SQL_Latin1_General_CP1_CI_AS" DEFAULT ('default') NOT NULL, 59 CONSTRAINT experiment_pk PRIMARY KEY (experiment_id), 60 CONSTRAINT uq_experiments_workspace_name UNIQUE (workspace, name) 61 ) 62 63 64 CREATE TABLE input_tags ( 65 input_uuid VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 66 name VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 67 value VARCHAR(500) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 68 CONSTRAINT input_tags_pk PRIMARY KEY (input_uuid, name) 69 ) 70 71 72 CREATE TABLE inputs ( 73 input_uuid VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 74 source_type VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 75 source_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 76 destination_type VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 77 destination_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 78 step BIGINT DEFAULT ('0') NOT NULL, 79 CONSTRAINT inputs_pk PRIMARY KEY (source_type, source_id, destination_type, destination_id) 80 ) 81 82 83 CREATE TABLE jobs ( 84 id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 85 creation_time BIGINT NOT NULL, 86 job_name VARCHAR(500) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 87 params VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 88 timeout FLOAT, 89 status INTEGER NOT NULL, 90 result VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 91 retry_count INTEGER NOT NULL, 92 last_update_time BIGINT NOT NULL, 93 workspace VARCHAR(63) COLLATE "SQL_Latin1_General_CP1_CI_AS" DEFAULT ('default') NOT NULL, 94 status_details NVARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 95 CONSTRAINT jobs_pk PRIMARY KEY (id) 96 ) 97 98 99 CREATE TABLE registered_models ( 100 name VARCHAR(256) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 101 creation_time BIGINT, 102 last_updated_time BIGINT, 103 description VARCHAR(5000) COLLATE "SQL_Latin1_General_CP1_CI_AS", 104 workspace VARCHAR(63) COLLATE "SQL_Latin1_General_CP1_CI_AS" DEFAULT ('default') NOT NULL, 105 CONSTRAINT registered_model_pk PRIMARY KEY (workspace, name) 106 ) 107 108 109 CREATE TABLE secrets ( 110 secret_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 111 secret_name VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 112 encrypted_value VARBINARY NOT NULL, 113 wrapped_dek VARBINARY NOT NULL, 114 kek_version INTEGER NOT NULL, 115 masked_value VARCHAR(500) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 116 provider VARCHAR(64) COLLATE "SQL_Latin1_General_CP1_CI_AS", 117 auth_config VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 118 description VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 119 created_by VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 120 created_at BIGINT NOT NULL, 121 last_updated_by VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 122 last_updated_at BIGINT NOT NULL, 123 workspace VARCHAR(63) COLLATE "SQL_Latin1_General_CP1_CI_AS" DEFAULT ('default') NOT NULL, 124 CONSTRAINT secrets_pk PRIMARY KEY (secret_id), 125 CONSTRAINT uq_secrets_workspace_secret_name UNIQUE (workspace, secret_name) 126 ) 127 128 129 CREATE TABLE webhooks ( 130 webhook_id VARCHAR(256) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 131 name VARCHAR(256) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 132 description VARCHAR(1000) COLLATE "SQL_Latin1_General_CP1_CI_AS", 133 url VARCHAR(500) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 134 status VARCHAR(20) COLLATE "SQL_Latin1_General_CP1_CI_AS" DEFAULT ('ACTIVE') NOT NULL, 135 secret VARCHAR(1000) COLLATE "SQL_Latin1_General_CP1_CI_AS", 136 creation_timestamp BIGINT, 137 last_updated_timestamp BIGINT, 138 deleted_timestamp BIGINT, 139 workspace VARCHAR(63) COLLATE "SQL_Latin1_General_CP1_CI_AS" DEFAULT ('default') NOT NULL, 140 CONSTRAINT webhook_pk PRIMARY KEY (webhook_id) 141 ) 142 143 144 CREATE TABLE workspaces ( 145 name VARCHAR(63) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 146 description VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 147 default_artifact_root VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 148 CONSTRAINT workspaces_pk PRIMARY KEY (name) 149 ) 150 151 152 CREATE TABLE datasets ( 153 dataset_uuid VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 154 experiment_id INTEGER NOT NULL, 155 name VARCHAR(500) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 156 digest VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 157 dataset_source_type VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 158 dataset_source VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 159 dataset_schema VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 160 dataset_profile VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 161 CONSTRAINT dataset_pk PRIMARY KEY (experiment_id, name, digest), 162 CONSTRAINT fk_datasets_experiment_id_experiments FOREIGN KEY(experiment_id) REFERENCES experiments (experiment_id) ON DELETE CASCADE 163 ) 164 165 166 CREATE TABLE endpoints ( 167 endpoint_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 168 name VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 169 created_by VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 170 created_at BIGINT NOT NULL, 171 last_updated_by VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 172 last_updated_at BIGINT NOT NULL, 173 routing_strategy VARCHAR(64) COLLATE "SQL_Latin1_General_CP1_CI_AS", 174 fallback_config_json VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 175 experiment_id INTEGER, 176 usage_tracking BIT DEFAULT ('0') NOT NULL, 177 workspace VARCHAR(63) COLLATE "SQL_Latin1_General_CP1_CI_AS" DEFAULT ('default') NOT NULL, 178 CONSTRAINT endpoints_pk PRIMARY KEY (endpoint_id), 179 CONSTRAINT fk_endpoints_experiment_id FOREIGN KEY(experiment_id) REFERENCES experiments (experiment_id) ON DELETE SET NULL, 180 CONSTRAINT uq_endpoints_workspace_name UNIQUE (workspace, name) 181 ) 182 183 184 CREATE TABLE evaluation_dataset_records ( 185 dataset_record_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 186 dataset_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 187 inputs NVARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 188 expectations NVARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 189 tags NVARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 190 source NVARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 191 source_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS", 192 source_type VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 193 created_time BIGINT, 194 last_update_time BIGINT, 195 created_by VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 196 last_updated_by VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 197 input_hash VARCHAR(64) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 198 outputs NVARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 199 CONSTRAINT evaluation_dataset_records_pk PRIMARY KEY (dataset_record_id), 200 CONSTRAINT fk_evaluation_dataset_records_dataset_id FOREIGN KEY(dataset_id) REFERENCES evaluation_datasets (dataset_id) ON DELETE CASCADE 201 ) 202 203 204 CREATE TABLE evaluation_dataset_tags ( 205 dataset_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 206 key VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 207 value VARCHAR(5000) COLLATE "SQL_Latin1_General_CP1_CI_AS", 208 CONSTRAINT evaluation_dataset_tags_pk PRIMARY KEY (dataset_id, key), 209 CONSTRAINT fk_evaluation_dataset_tags_dataset_id FOREIGN KEY(dataset_id) REFERENCES evaluation_datasets (dataset_id) ON DELETE CASCADE 210 ) 211 212 213 CREATE TABLE experiment_tags ( 214 key VARCHAR(250) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 215 value VARCHAR(5000) COLLATE "SQL_Latin1_General_CP1_CI_AS", 216 experiment_id INTEGER NOT NULL, 217 CONSTRAINT experiment_tag_pk PRIMARY KEY (key, experiment_id), 218 CONSTRAINT "FK__experimen__exper__628FA481" FOREIGN KEY(experiment_id) REFERENCES experiments (experiment_id) 219 ) 220 221 222 CREATE TABLE logged_models ( 223 model_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 224 experiment_id INTEGER NOT NULL, 225 name VARCHAR(500) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 226 artifact_location VARCHAR(1000) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 227 creation_timestamp_ms BIGINT NOT NULL, 228 last_updated_timestamp_ms BIGINT NOT NULL, 229 status INTEGER NOT NULL, 230 lifecycle_stage VARCHAR(32) COLLATE "SQL_Latin1_General_CP1_CI_AS", 231 model_type VARCHAR(500) COLLATE "SQL_Latin1_General_CP1_CI_AS", 232 source_run_id VARCHAR(32) COLLATE "SQL_Latin1_General_CP1_CI_AS", 233 status_message VARCHAR(1000) COLLATE "SQL_Latin1_General_CP1_CI_AS", 234 CONSTRAINT logged_models_pk PRIMARY KEY (model_id), 235 CONSTRAINT fk_logged_models_experiment_id FOREIGN KEY(experiment_id) REFERENCES experiments (experiment_id) ON DELETE CASCADE 236 ) 237 238 239 CREATE TABLE model_definitions ( 240 model_definition_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 241 name VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 242 secret_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS", 243 provider VARCHAR(64) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 244 model_name VARCHAR(256) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 245 created_by VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 246 created_at BIGINT NOT NULL, 247 last_updated_by VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 248 last_updated_at BIGINT NOT NULL, 249 workspace VARCHAR(63) COLLATE "SQL_Latin1_General_CP1_CI_AS" DEFAULT ('default') NOT NULL, 250 CONSTRAINT model_definitions_pk PRIMARY KEY (model_definition_id), 251 CONSTRAINT fk_model_definitions_secret_id FOREIGN KEY(secret_id) REFERENCES secrets (secret_id) ON DELETE SET NULL, 252 CONSTRAINT uq_model_definitions_workspace_name UNIQUE (workspace, name) 253 ) 254 255 256 CREATE TABLE model_versions ( 257 name VARCHAR(256) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 258 version INTEGER NOT NULL, 259 creation_time BIGINT, 260 last_updated_time BIGINT, 261 description VARCHAR(5000) COLLATE "SQL_Latin1_General_CP1_CI_AS", 262 user_id VARCHAR(256) COLLATE "SQL_Latin1_General_CP1_CI_AS", 263 current_stage VARCHAR(20) COLLATE "SQL_Latin1_General_CP1_CI_AS", 264 source VARCHAR(500) COLLATE "SQL_Latin1_General_CP1_CI_AS", 265 run_id VARCHAR(32) COLLATE "SQL_Latin1_General_CP1_CI_AS", 266 status VARCHAR(20) COLLATE "SQL_Latin1_General_CP1_CI_AS", 267 status_message VARCHAR(500) COLLATE "SQL_Latin1_General_CP1_CI_AS", 268 run_link VARCHAR(500) COLLATE "SQL_Latin1_General_CP1_CI_AS", 269 storage_location VARCHAR(500) COLLATE "SQL_Latin1_General_CP1_CI_AS", 270 workspace VARCHAR(63) COLLATE "SQL_Latin1_General_CP1_CI_AS" DEFAULT ('default') NOT NULL, 271 CONSTRAINT model_version_pk PRIMARY KEY (workspace, name, version), 272 CONSTRAINT fk_model_versions_registered_models FOREIGN KEY(workspace, name) REFERENCES registered_models (workspace, name) ON UPDATE CASCADE 273 ) 274 275 276 CREATE TABLE registered_model_aliases ( 277 alias VARCHAR(256) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 278 version INTEGER NOT NULL, 279 name VARCHAR(256) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 280 workspace VARCHAR(63) COLLATE "SQL_Latin1_General_CP1_CI_AS" DEFAULT ('default') NOT NULL, 281 CONSTRAINT registered_model_alias_pk PRIMARY KEY (workspace, name, alias), 282 CONSTRAINT fk_registered_model_aliases_registered_models FOREIGN KEY(workspace, name) REFERENCES registered_models (workspace, name) ON DELETE CASCADE ON UPDATE CASCADE 283 ) 284 285 286 CREATE TABLE registered_model_tags ( 287 key VARCHAR(250) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 288 value VARCHAR(5000) COLLATE "SQL_Latin1_General_CP1_CI_AS", 289 name VARCHAR(256) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 290 workspace VARCHAR(63) COLLATE "SQL_Latin1_General_CP1_CI_AS" DEFAULT ('default') NOT NULL, 291 CONSTRAINT registered_model_tag_pk PRIMARY KEY (workspace, key, name), 292 CONSTRAINT fk_registered_model_tags_registered_models FOREIGN KEY(workspace, name) REFERENCES registered_models (workspace, name) ON UPDATE CASCADE 293 ) 294 295 296 CREATE TABLE runs ( 297 run_uuid VARCHAR(32) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 298 name VARCHAR(250) COLLATE "SQL_Latin1_General_CP1_CI_AS", 299 source_type VARCHAR(20) COLLATE "SQL_Latin1_General_CP1_CI_AS", 300 source_name VARCHAR(500) COLLATE "SQL_Latin1_General_CP1_CI_AS", 301 entry_point_name VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS", 302 user_id VARCHAR(256) COLLATE "SQL_Latin1_General_CP1_CI_AS", 303 status VARCHAR(9) COLLATE "SQL_Latin1_General_CP1_CI_AS", 304 start_time BIGINT, 305 end_time BIGINT, 306 source_version VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS", 307 lifecycle_stage VARCHAR(20) COLLATE "SQL_Latin1_General_CP1_CI_AS", 308 artifact_uri VARCHAR(200) COLLATE "SQL_Latin1_General_CP1_CI_AS", 309 experiment_id INTEGER, 310 deleted_time BIGINT, 311 CONSTRAINT run_pk PRIMARY KEY (run_uuid), 312 CONSTRAINT "FK__runs__experiment__5165187F" FOREIGN KEY(experiment_id) REFERENCES experiments (experiment_id) 313 ) 314 315 316 CREATE TABLE scorers ( 317 experiment_id INTEGER NOT NULL, 318 scorer_name VARCHAR(256) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 319 scorer_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 320 CONSTRAINT scorer_pk PRIMARY KEY (scorer_id), 321 CONSTRAINT fk_scorers_experiment_id FOREIGN KEY(experiment_id) REFERENCES experiments (experiment_id) ON DELETE CASCADE 322 ) 323 324 325 CREATE TABLE trace_info ( 326 request_id VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 327 experiment_id INTEGER NOT NULL, 328 timestamp_ms BIGINT NOT NULL, 329 execution_time_ms BIGINT, 330 status VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 331 client_request_id VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS", 332 request_preview VARCHAR(1000) COLLATE "SQL_Latin1_General_CP1_CI_AS", 333 response_preview VARCHAR(1000) COLLATE "SQL_Latin1_General_CP1_CI_AS", 334 CONSTRAINT trace_info_pk PRIMARY KEY (request_id), 335 CONSTRAINT fk_trace_info_experiment_id FOREIGN KEY(experiment_id) REFERENCES experiments (experiment_id) 336 ) 337 338 339 CREATE TABLE webhook_events ( 340 webhook_id VARCHAR(256) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 341 entity VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 342 action VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 343 CONSTRAINT webhook_event_pk PRIMARY KEY (webhook_id, entity, action), 344 CONSTRAINT "FK__webhook_e__webho__2645B050" FOREIGN KEY(webhook_id) REFERENCES webhooks (webhook_id) ON DELETE CASCADE 345 ) 346 347 348 CREATE TABLE assessments ( 349 assessment_id VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 350 trace_id VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 351 name VARCHAR(250) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 352 assessment_type VARCHAR(20) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 353 value VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 354 error VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 355 created_timestamp BIGINT NOT NULL, 356 last_updated_timestamp BIGINT NOT NULL, 357 source_type VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 358 source_id VARCHAR(250) COLLATE "SQL_Latin1_General_CP1_CI_AS", 359 run_id VARCHAR(32) COLLATE "SQL_Latin1_General_CP1_CI_AS", 360 span_id VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS", 361 rationale VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 362 overrides VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS", 363 valid BIT NOT NULL, 364 assessment_metadata VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 365 CONSTRAINT assessments_pk PRIMARY KEY (assessment_id), 366 CONSTRAINT fk_assessments_trace_id FOREIGN KEY(trace_id) REFERENCES trace_info (request_id) ON DELETE CASCADE 367 ) 368 369 370 CREATE TABLE endpoint_bindings ( 371 endpoint_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 372 resource_type VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 373 resource_id VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 374 created_at BIGINT NOT NULL, 375 created_by VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 376 last_updated_at BIGINT NOT NULL, 377 last_updated_by VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 378 display_name VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 379 CONSTRAINT endpoint_bindings_pk PRIMARY KEY (endpoint_id, resource_type, resource_id), 380 CONSTRAINT fk_endpoint_bindings_endpoint_id FOREIGN KEY(endpoint_id) REFERENCES endpoints (endpoint_id) ON DELETE CASCADE 381 ) 382 383 384 CREATE TABLE endpoint_model_mappings ( 385 mapping_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 386 endpoint_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 387 model_definition_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 388 weight FLOAT NOT NULL, 389 created_by VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 390 created_at BIGINT NOT NULL, 391 linkage_type VARCHAR(64) COLLATE "SQL_Latin1_General_CP1_CI_AS" DEFAULT ('PRIMARY') NOT NULL, 392 fallback_order INTEGER, 393 CONSTRAINT endpoint_model_mappings_pk PRIMARY KEY (mapping_id), 394 CONSTRAINT fk_endpoint_model_mappings_endpoint_id FOREIGN KEY(endpoint_id) REFERENCES endpoints (endpoint_id) ON DELETE CASCADE, 395 CONSTRAINT fk_endpoint_model_mappings_model_definition_id FOREIGN KEY(model_definition_id) REFERENCES model_definitions (model_definition_id) 396 ) 397 398 399 CREATE TABLE endpoint_tags ( 400 key VARCHAR(250) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 401 value VARCHAR(5000) COLLATE "SQL_Latin1_General_CP1_CI_AS", 402 endpoint_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 403 CONSTRAINT endpoint_tag_pk PRIMARY KEY (key, endpoint_id), 404 CONSTRAINT fk_endpoint_tags_endpoint_id FOREIGN KEY(endpoint_id) REFERENCES endpoints (endpoint_id) ON DELETE CASCADE 405 ) 406 407 408 CREATE TABLE guardrails ( 409 guardrail_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 410 name VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 411 scorer_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 412 scorer_version INTEGER NOT NULL, 413 stage VARCHAR(32) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 414 action VARCHAR(32) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 415 action_endpoint_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS", 416 created_by VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 417 created_at BIGINT NOT NULL, 418 last_updated_by VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 419 last_updated_at BIGINT NOT NULL, 420 workspace VARCHAR(63) COLLATE "SQL_Latin1_General_CP1_CI_AS" DEFAULT ('default') NOT NULL, 421 CONSTRAINT guardrails_pk PRIMARY KEY (guardrail_id), 422 CONSTRAINT fk_guardrails_scorer_version FOREIGN KEY(scorer_id, scorer_version) REFERENCES scorer_versions (scorer_id, scorer_version), 423 CONSTRAINT fk_guardrails_action_endpoint_id FOREIGN KEY(action_endpoint_id) REFERENCES endpoints (endpoint_id) ON DELETE SET NULL 424 ) 425 426 427 CREATE TABLE guardrail_configs ( 428 endpoint_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 429 guardrail_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 430 execution_order INTEGER, 431 created_by VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 432 created_at BIGINT NOT NULL, 433 workspace VARCHAR(63) COLLATE "SQL_Latin1_General_CP1_CI_AS" DEFAULT ('default') NOT NULL, 434 CONSTRAINT guardrail_configs_pk PRIMARY KEY (endpoint_id, guardrail_id), 435 CONSTRAINT fk_guardrail_configs_endpoint_id FOREIGN KEY(endpoint_id) REFERENCES endpoints (endpoint_id) ON DELETE CASCADE, 436 CONSTRAINT fk_guardrail_configs_guardrail_id FOREIGN KEY(guardrail_id) REFERENCES guardrails (guardrail_id) ON DELETE CASCADE 437 ) 438 439 440 CREATE TABLE issues ( 441 issue_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 442 experiment_id INTEGER NOT NULL, 443 name VARCHAR(250) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 444 description VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 445 status VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 446 severity VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS", 447 root_causes VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 448 source_run_id VARCHAR(32) COLLATE "SQL_Latin1_General_CP1_CI_AS", 449 categories VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 450 created_timestamp BIGINT NOT NULL, 451 last_updated_timestamp BIGINT NOT NULL, 452 created_by VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS", 453 CONSTRAINT issues_pk PRIMARY KEY (issue_id), 454 CONSTRAINT fk_issues_experiment_id FOREIGN KEY(experiment_id) REFERENCES experiments (experiment_id) ON DELETE CASCADE, 455 CONSTRAINT fk_issues_source_run_id FOREIGN KEY(source_run_id) REFERENCES runs (run_uuid) ON DELETE SET NULL 456 ) 457 458 459 CREATE TABLE latest_metrics ( 460 key VARCHAR(250) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 461 value FLOAT NOT NULL, 462 timestamp BIGINT, 463 step BIGINT NOT NULL, 464 is_nan BIT NOT NULL, 465 run_uuid VARCHAR(32) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 466 CONSTRAINT latest_metric_pk PRIMARY KEY (key, run_uuid), 467 CONSTRAINT "FK__latest_me__run_u__656C112C" FOREIGN KEY(run_uuid) REFERENCES runs (run_uuid) 468 ) 469 470 471 CREATE TABLE logged_model_metrics ( 472 model_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 473 metric_name VARCHAR(500) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 474 metric_timestamp_ms BIGINT NOT NULL, 475 metric_step BIGINT NOT NULL, 476 metric_value FLOAT, 477 experiment_id INTEGER NOT NULL, 478 run_id VARCHAR(32) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 479 dataset_uuid VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS", 480 dataset_name VARCHAR(500) COLLATE "SQL_Latin1_General_CP1_CI_AS", 481 dataset_digest VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS", 482 CONSTRAINT logged_model_metrics_pk PRIMARY KEY (model_id, metric_name, metric_timestamp_ms, metric_step, run_id), 483 CONSTRAINT fk_logged_model_metrics_experiment_id FOREIGN KEY(experiment_id) REFERENCES experiments (experiment_id), 484 CONSTRAINT fk_logged_model_metrics_model_id FOREIGN KEY(model_id) REFERENCES logged_models (model_id) ON DELETE CASCADE, 485 CONSTRAINT fk_logged_model_metrics_run_id FOREIGN KEY(run_id) REFERENCES runs (run_uuid) ON DELETE CASCADE 486 ) 487 488 489 CREATE TABLE logged_model_params ( 490 model_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 491 experiment_id INTEGER NOT NULL, 492 param_key VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 493 param_value VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 494 CONSTRAINT logged_model_params_pk PRIMARY KEY (model_id, param_key), 495 CONSTRAINT fk_logged_model_params_experiment_id FOREIGN KEY(experiment_id) REFERENCES experiments (experiment_id), 496 CONSTRAINT fk_logged_model_params_model_id FOREIGN KEY(model_id) REFERENCES logged_models (model_id) ON DELETE CASCADE 497 ) 498 499 500 CREATE TABLE logged_model_tags ( 501 model_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 502 experiment_id INTEGER NOT NULL, 503 tag_key VARCHAR(255) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 504 tag_value VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 505 CONSTRAINT logged_model_tags_pk PRIMARY KEY (model_id, tag_key), 506 CONSTRAINT fk_logged_model_tags_experiment_id FOREIGN KEY(experiment_id) REFERENCES experiments (experiment_id), 507 CONSTRAINT fk_logged_model_tags_model_id FOREIGN KEY(model_id) REFERENCES logged_models (model_id) ON DELETE CASCADE 508 ) 509 510 511 CREATE TABLE metrics ( 512 key VARCHAR(250) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 513 value FLOAT NOT NULL, 514 timestamp BIGINT NOT NULL, 515 run_uuid VARCHAR(32) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 516 step BIGINT DEFAULT ('0') NOT NULL, 517 is_nan BIT DEFAULT ('0') NOT NULL, 518 CONSTRAINT metric_pk PRIMARY KEY (key, timestamp, step, run_uuid, value, is_nan), 519 CONSTRAINT "FK__metrics__run_uui__571DF1D5" FOREIGN KEY(run_uuid) REFERENCES runs (run_uuid) 520 ) 521 522 523 CREATE TABLE model_version_tags ( 524 key VARCHAR(250) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 525 value VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 526 name VARCHAR(256) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 527 version INTEGER NOT NULL, 528 workspace VARCHAR(63) COLLATE "SQL_Latin1_General_CP1_CI_AS" DEFAULT ('default') NOT NULL, 529 CONSTRAINT model_version_tag_pk PRIMARY KEY (workspace, key, name, version), 530 CONSTRAINT fk_model_version_tags_model_versions FOREIGN KEY(workspace, name, version) REFERENCES model_versions (workspace, name, version) ON UPDATE CASCADE 531 ) 532 533 534 CREATE TABLE online_scoring_configs ( 535 online_scoring_config_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 536 scorer_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 537 sample_rate FLOAT NOT NULL, 538 experiment_id INTEGER NOT NULL, 539 filter_string VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 540 CONSTRAINT online_scoring_config_pk PRIMARY KEY (online_scoring_config_id), 541 CONSTRAINT fk_online_scoring_configs_experiment_id FOREIGN KEY(experiment_id) REFERENCES experiments (experiment_id), 542 CONSTRAINT fk_online_scoring_configs_scorer_id FOREIGN KEY(scorer_id) REFERENCES scorers (scorer_id) ON DELETE CASCADE 543 ) 544 545 546 CREATE TABLE params ( 547 key VARCHAR(250) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 548 value VARCHAR(8000) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 549 run_uuid VARCHAR(32) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 550 CONSTRAINT param_pk PRIMARY KEY (key, run_uuid), 551 CONSTRAINT "FK__params__run_uuid__59FA5E80" FOREIGN KEY(run_uuid) REFERENCES runs (run_uuid) 552 ) 553 554 555 CREATE TABLE scorer_versions ( 556 scorer_id VARCHAR(36) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 557 scorer_version INTEGER NOT NULL, 558 serialized_scorer VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 559 creation_time BIGINT, 560 CONSTRAINT scorer_version_pk PRIMARY KEY (scorer_id, scorer_version), 561 CONSTRAINT fk_scorer_versions_scorer_id FOREIGN KEY(scorer_id) REFERENCES scorers (scorer_id) ON DELETE CASCADE 562 ) 563 564 565 CREATE TABLE spans ( 566 trace_id VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 567 experiment_id INTEGER NOT NULL, 568 span_id VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 569 parent_span_id VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS", 570 name VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 571 type VARCHAR(500) COLLATE "SQL_Latin1_General_CP1_CI_AS", 572 status VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 573 start_time_unix_nano BIGINT NOT NULL, 574 end_time_unix_nano BIGINT, 575 duration_ns BIGINT GENERATED ALWAYS AS (([end_time_unix_nano]-[start_time_unix_nano])) STORED, 576 content VARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 577 dimension_attributes NVARCHAR COLLATE "SQL_Latin1_General_CP1_CI_AS", 578 CONSTRAINT spans_pk PRIMARY KEY (trace_id, span_id), 579 CONSTRAINT fk_spans_experiment_id FOREIGN KEY(experiment_id) REFERENCES experiments (experiment_id), 580 CONSTRAINT fk_spans_trace_id FOREIGN KEY(trace_id) REFERENCES trace_info (request_id) ON DELETE CASCADE 581 ) 582 583 584 CREATE TABLE tags ( 585 key VARCHAR(250) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 586 value VARCHAR(8000) COLLATE "SQL_Latin1_General_CP1_CI_AS", 587 run_uuid VARCHAR(32) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 588 CONSTRAINT tag_pk PRIMARY KEY (key, run_uuid), 589 CONSTRAINT "FK__tags__run_uuid__5441852A" FOREIGN KEY(run_uuid) REFERENCES runs (run_uuid) 590 ) 591 592 593 CREATE TABLE trace_metrics ( 594 request_id VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 595 key VARCHAR(250) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 596 value FLOAT, 597 CONSTRAINT trace_metrics_pk PRIMARY KEY (request_id, key), 598 CONSTRAINT fk_trace_metrics_request_id FOREIGN KEY(request_id) REFERENCES trace_info (request_id) ON DELETE CASCADE 599 ) 600 601 602 CREATE TABLE trace_request_metadata ( 603 key VARCHAR(250) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 604 value VARCHAR(8000) COLLATE "SQL_Latin1_General_CP1_CI_AS", 605 request_id VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 606 CONSTRAINT trace_request_metadata_pk PRIMARY KEY (key, request_id), 607 CONSTRAINT fk_trace_request_metadata_request_id FOREIGN KEY(request_id) REFERENCES trace_info (request_id) ON DELETE CASCADE 608 ) 609 610 611 CREATE TABLE trace_tags ( 612 key VARCHAR(250) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 613 value VARCHAR(8000) COLLATE "SQL_Latin1_General_CP1_CI_AS", 614 request_id VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 615 CONSTRAINT trace_tag_pk PRIMARY KEY (key, request_id), 616 CONSTRAINT fk_trace_tags_request_id FOREIGN KEY(request_id) REFERENCES trace_info (request_id) ON DELETE CASCADE 617 ) 618 619 620 CREATE TABLE span_metrics ( 621 trace_id VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 622 span_id VARCHAR(50) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 623 key VARCHAR(250) COLLATE "SQL_Latin1_General_CP1_CI_AS" NOT NULL, 624 value FLOAT, 625 CONSTRAINT span_metrics_pk PRIMARY KEY (trace_id, span_id, key), 626 CONSTRAINT fk_span_metrics_span FOREIGN KEY(trace_id, span_id) REFERENCES spans (trace_id, span_id) ON DELETE CASCADE 627 )