argmax_mini_erd

Tables (9)

dataset_versions

  • id — BIGSERIAL
  • dataset_id — BIGINT — Foreign key → datasets.id — NOT NULL
  • version_number — INTEGER — NOT NULL
  • original_filename — VARCHAR(255) — NOT NULL
  • file_type — VARCHAR(10) — NOT NULL
  • file_size_bytes — BIGINT — NOT NULL
  • storage_path — VARCHAR(500) — NOT NULL
  • schema_json — JSONB
  • row_count — BIGINT
  • change_summary — TEXT
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

datasets

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • status — VARCHAR(20) — NOT NULL
  • current_version_id — BIGINT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

inference_requests

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • model_version_id — BIGINT — Foreign key → model_versions.id — NOT NULL
  • input_json — JSONB — NOT NULL
  • output_json — JSONB
  • status — VARCHAR(20) — NOT NULL
  • error_message — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

model_io_schemas

  • id — BIGSERIAL
  • model_version_id — BIGINT — Foreign key → model_versions.id — NOT NULL
  • input_schema — JSONB — NOT NULL
  • output_schema — JSONB — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

model_metrics

  • id — BIGSERIAL
  • model_version_id — BIGINT — Foreign key → model_versions.id — NOT NULL
  • metric_name — VARCHAR(100) — NOT NULL
  • metric_value — DOUBLE — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

model_versions

  • id — BIGSERIAL
  • model_id — BIGINT — Foreign key → models.id — NOT NULL
  • created_by_job_id — BIGINT — Foreign key → training_jobs.id — NOT NULL
  • version_number — INTEGER — NOT NULL
  • model_file_path — VARCHAR(500) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

models

  • id — BIGSERIAL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • status — VARCHAR(20) — NOT NULL
  • current_version_id — BIGINT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

training_jobs

  • id — BIGSERIAL
  • dataset_version_id — BIGINT — Foreign key → dataset_versions.id — NOT NULL
  • requested_by — BIGINT — Foreign key → users.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • gpu_type — VARCHAR(100)
  • gpu_count — INTEGER
  • hyperparameters_json — JSONB
  • started_at — TIMESTAMP
  • completed_at — TIMESTAMP
  • error_message — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • id — BIGSERIAL
  • email — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — VARCHAR(30) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL