/mysig_inv_mgt

Mysig Inventory Management Application

Primary LanguagePython

Mysig Inventory Management Application

Overview

A CRUD application to track inventory information and location.

stateDiagram-v2
  [*] --> Backend
  [*] --> Frontend
  Frontend --> Search
  Frontend --> Add: /add
  Search --> Results
  state Results {
    View
    Edit 
    Delete
  }
Loading

Backend

The backend uses axum to facilitate GraphQL queries against a Postgres database via SeaORM. The current schema corresponds to the following diagram.

erDiagram
  KEYWORD {
    uuid id PK
    string keyword PK
  }
  BIN {
    uuid id PK
    string bin_name PK
  }
  COLOR {
    uuid id PK
    string color PK
    string accent
  }
  SIZE {
    uuid id PK
    float height PK
    float width PK
  }
  MATERIAL {
    uuid id PK
    string material PK
  }
  IMG {
    uuid id PK
    string img_file PK
  }
  QUANTITY {
    uuid id PK
    int count PK
  }
Loading

Migrations