1

Tables (11)

api_keys

  • id — BINARY(16) — Primary key — NOT NULL
  • user_id — BINARY(16) — Foreign key → users.id — NOT NULL — FK → 유저.id
  • key_hash — CHAR(64) — NOT NULL — SHA-256 해시만 저장
  • scopes — JSON — NOT NULL — 예: "inference:read","models:write"
  • expires_at — DATETIME — 없으면 무기한
  • is_revoked — BOOLEAN — NOT NULL — 관리자 강제 비활성화
  • last_used_at — DATETIME
  • created_at — DATETIME — NOT NULL
  • INDEX — `idx_api_key_user`
  • INDEX — `idx_api_key_created`

audit_logs

  • id — BINARY(16) — Primary key — NOT NULL
  • actor_user_id — BINARY(16) — Foreign key → users.id — FK → 유저.id (시스템 이벤트는 NULL)
  • action — VARCHAR(64) — NOT NULL
  • entity — VARCHAR(64) — NOT NULL
  • entity_id — BINARY(16)
  • details — JSON
  • ip — VARCHAR(45)
  • created_at — DATETIME — NOT NULL
  • INDEX — `idx_감사_created`
  • INDEX — `idx_감사_actor_created`
  • INDEX — `idx_감사_action_created`

datasets

  • id — BINARY(16) — Primary key — NOT NULL
  • uploaded_by — BINARY(16) — Foreign key → users.id — NOT NULL — FK → 유저.id
  • name — VARCHAR(128) — NOT NULL
  • version — VARCHAR(64) — NOT NULL
  • description — TEXT
  • s3_uri — VARCHAR(512) — NOT NULL
  • file_type — VARCHAR(32)
  • checksum — VARCHAR(64)
  • size_bytes — BIGINT
  • rows_count — BIGINT
  • tags — JSON
  • source — VARCHAR(128)
  • status — ENUM('draft', 'ready', 'deprecated') — NOT NULL
  • is_public — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — `idx_데이터셋_uploader`
  • INDEX — `idx_데이터셋_status`

feedback

  • id — BINARY(16) — Primary key — NOT NULL
  • user_id — BINARY(16) — Foreign key → users.id — NOT NULL — FK → 유저.id
  • prediction_id — BINARY(16) — Foreign key → predictions.id — NOT NULL — FK → 예측결과.id
  • label — JSON — 정답/보정 데이터
  • rating — TINYINT — 1~5 등급
  • comment — TEXT
  • created_at — DATETIME — NOT NULL
  • INDEX — `idx_피드백_user_created`
  • INDEX — `idx_피드백_prediction`

inference_requests

  • id — BINARY(16) — Primary key — NOT NULL
  • model_id — BINARY(16) — Foreign key → models.id — FK → model 관리.id
  • user_id — BINARY(16) — Foreign key → users.id — FK → 유저.id
  • request_payload — JSON
  • trace_id — CHAR(36) — NOT NULL
  • ip — VARCHAR(45)
  • status_code — INT — NOT NULL
  • latency_ms — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • INDEX — `idx_요청_created`
  • INDEX — `idx_요청_user_created`

models

  • id — BINARY(16) — Primary key — NOT NULL
  • created_by — BINARY(16) — Foreign key → users.id — NOT NULL — FK → 유저.id
  • name — VARCHAR(128) — NOT NULL
  • version — VARCHAR(64) — NOT NULL
  • s3_uri — VARCHAR(512) — NOT NULL
  • checksum — VARCHAR(64)
  • framework — VARCHAR(64) — 예: "pytorch","tf","onnx"
  • runtime — VARCHAR(64) — 예: "cuda12.2","cpu","triton"
  • tags — JSON
  • status — ENUM('active', 'inactive') — NOT NULL
  • is_active — BOOLEAN
  • activated_at — DATETIME
  • deprecated_atDATETIME — NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — `idx_model_creator`
  • INDEX — `idx_model_status`

predictions

  • id — BINARY(16) — Primary key — NOT NULL
  • request_id — BINARY(16) — Foreign key → inference_requests.id — NOT NULL — FK → 요청 로그.id (UNIQUE)
  • model_id — BINARY(16) — Foreign key → models.id — NOT NULL — FK → model 관리.id
  • output — JSON
  • confidence — DECIMAL(5, 4)
  • created_at — DATETIME — NOT NULL
  • INDEX — `idx_예측_model_created`

preproc_jobs

  • id — BINARY(16) — Primary key — NOT NULL
  • dataset_id — BINARY(16) — Foreign key → datasets.id — NOT NULL — FK → 데이터셋.id
  • created_by — BINARY(16) — Foreign key → users.id — NOT NULL — FK → 유저.id
  • status — ENUM('queued', 'running', 'succeeded', 'failed') — NOT NULL
  • started_at — DATETIME — NOT NULL
  • finished_at — DATETIME
  • error_message — TEXT
  • created_at — DATETIME — NOT NULL
  • INDEX — `idx_preproc_dataset`
  • INDEX — `idx_preproc_status`

refresh_tokens

  • id — BINARY(16) — Primary key — NOT NULL
  • user_id — BINARY(16) — Foreign key → users.id — NOT NULL — UUID_TO_BIN(uuid, TRUE) 권장
  • family_id — UUID
  • Field2 — VARCHAR(255)
  • Field3 — VARCHAR(255)
  • Field4 — VARCHAR(255)
  • Field5 — VARCHAR(255)
  • Field6 — VARCHAR(255)

session

  • id — BINARY(16) — Primary key — NOT NULL
  • user_id — BINARY(16) — Foreign key → users.id — NOT NULL — FK → 유저.id
  • jti — CHAR(36) — NOT NULL — JWT ID (UNIQUE)
  • ip_address — VARCHAR(45)
  • user_agent — VARCHAR(255)
  • expires_at — DATETIME — NOT NULL
  • revoked_at — DATETIME
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — `idx_session_user`
  • INDEX — `idx_session_expires`
  • INDEX — `idx_session_revoked`

users

  • id — BINARY(16) — Primary key — NOT NULL — UUID_TO_BIN(uuid, TRUE) 권장
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • phone_number — VARCHAR(20) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • role — ENUM('admin', 'manager', 'user') — NOT NULL
  • is_active — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • INDEX — `idx_유저_created`