tilda

Tables (11)

audit_logs

  • id — UUID
  • user_id — UUID — NOT NULL
  • action — VARCHAR(100) — NOT NULL
  • entity_type — VARCHAR(50) — NOT NULL — Type
  • entity_id — UUID — NOT NULL
  • details — JSONB — Additional
  • ip_address — INET
  • user_agent — TEXT
  • created_at — TIMESTAMP

data_processing_jobs

  • id — UUID
  • dataset_id — UUID — NOT NULL
  • job_type — VARCHAR(50) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • input_path — VARCHAR(500)
  • output_path — VARCHAR(500)
  • error_message — TEXT
  • started_at — TIMESTAMP
  • completed_at — TIMESTAMP
  • created_at — TIMESTAMP

datasets

  • id — UUID
  • user_id — UUID — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • file_path — VARCHAR(500) — NOT NULL
  • file_size_bytes — BIGINT — NOT NULL
  • file_type — VARCHAR(50) — NOT NULL
  • row_count — INTEGER
  • column_count — INTEGER
  • schema_info — JSONB — JSON
  • status — VARCHAR(50) — NOT NULL — Processing
  • version — INTEGER
  • parent_dataset_id — UUID — Reference
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

gpu_allocations

  • id — UUID
  • training_job_id — UUID — NOT NULL
  • gpu_type — VARCHAR(50) — NOT NULL
  • gpu_count — INTEGER — NOT NULL
  • node_name — VARCHAR(255) — NOT NULL
  • status — VARCHAR(50) — NOT NULL — Allocation
  • allocated_at — TIMESTAMP
  • released_at — TIMESTAMP

inference_requests

  • id — UUID
  • model_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • request_type — VARCHAR(50) — NOT NULL
  • input_data — JSONB — NOT NULL — Input
  • output_data — JSONB — Prediction
  • status — VARCHAR(50) — NOT NULL
  • latency_ms — INTEGER — Inference
  • error_message — TEXT
  • created_at — TIMESTAMP
  • completed_at — TIMESTAMP

model_deployments

  • id — UUID
  • model_id — UUID — NOT NULL
  • deployment_name — VARCHAR(255) — NOT NULL
  • endpoint_url — VARCHAR(500) — Public
  • deployment_type — VARCHAR(50) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • replica_count — INTEGER
  • cpu_request — VARCHAR(50)
  • memory_request — VARCHAR(50)
  • gpu_request — INTEGER
  • auto_scaling_enabled — BOOLEAN — Enable
  • min_replicas — INTEGER
  • max_replicas — INTEGER
  • target_cpu_utilization — INTEGER
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

model_versions

  • id — UUID
  • model_id — UUID — NOT NULL
  • version_number — VARCHAR(50) — NOT NULL
  • stage — VARCHAR(50)
  • model_path — VARCHAR(500)
  • metrics — JSONB
  • tags — JSONB
  • promoted_at — TIMESTAMP — Timestamp
  • created_at — TIMESTAMP
  • UNIQUE(model_id, — version_number)

models

  • id — UUID
  • user_id — UUID — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • model_type — VARCHAR(100) — NOT NULL
  • algorithm — VARCHAR(100)
  • status — VARCHAR(50) — NOT NULL
  • version — VARCHAR(50) — NOT NULL
  • parent_model_id — UUID
  • model_path — VARCHAR(500)
  • config — JSONB — Model
  • metrics — JSONB — Performance
  • input_schema — JSONB — JSON
  • output_schema — JSONB — JSON
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP — Soft
  • restored_at — TIMESTAMP

organizations

  • id — UUID
  • name — VARCHAR(255) — NOT NULL
  • tier — VARCHAR(50)
  • max_storage_gb — INTEGER — Maximum
  • max_gpu_hours — INTEGER — Maximum
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

training_jobs

  • id — UUID
  • model_id — UUID — NOT NULL
  • dataset_id — UUID — NOT NULL
  • user_id — UUID — NOT NULL
  • job_type — VARCHAR(50) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • priority — INTEGER — Job
  • gpu_type — VARCHAR(50) — Requested
  • gpu_count — INTEGER
  • estimated_duration_hours — DECIMAL(10, 2)
  • actual_duration_hours — DECIMAL(10, 2)
  • pod_name — VARCHAR(255) — Kubernetes
  • node_name — VARCHAR(255)
  • error_message — TEXT
  • config — JSONB
  • metrics — JSONB — Real-time
  • started_at — TIMESTAMP
  • completed_at — TIMESTAMP
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

users

  • id — UUID
  • email — VARCHAR(255) — NOT NULL
  • username — VARCHAR(100) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • user_type — VARCHAR(50) — NOT NULL
  • organization_id — UUID
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP — Soft