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`