ML Service

Project Structure

app/
├── entities/
├── repositories/
└── services/

• entities - core entities used in all layers of application
• repositories - schema and database logic
• services - business logic

DB Schema

---
title: DB Schema
---
erDiagram
    users {
        serial id PK
        string username
        string email
        string password_hash
        string role
        decimal balance
        timestamp updated_at
        timestamp created_at
    }

    models {
        serial id PK
        string name
        string description
        decimal cost
        jsonb input_data_schema
        timestamp updated_at
        timestamp created_at
    }

    model_runs {
        serial id PK
        int user_id FK
        int model_id FK
        decimal cost
        string status
        jsonb input_data
        jsonb result
        timestamp created_at
    }

    transactions {
        serial id PK
        int user_id FK
        decimal amount
        string status
        timestamp created_at
    }

    users ||--o{ model_runs : "makes"
    users ||--o{ transactions : "has"
    models ||--o{ model_runs : "used in"

Loading