← All writing

tutorials

Basic Restful Web Service - Repo

· KM

Let’s develop POS for Gas Station

mobile first, wireless print, invoice generate

let’s create mobile app, offline first, jetpack compose ? or flutter ?

flutter


erDiagram
    BUSINESS {
        int id PK
        string name
    }
    
    BRANCH {
        int id PK
        int business_id FK
        string name
    }
    
    PUMP {
        int id PK
        int branch_id FK
    }
    
    INVOICE {
        int id PK
        int pump_id FK
        float total_amount
        float discount_amount
        float net_amount
        float received
        float change
        string payment_type
    }
    
    ITEM {
        int id PK
        int invoice_id FK
        int gas_type_id FK
        float volume_in_liters
        float amount
        float price
    }
    
    GAS_TYPE {
        int id PK
        string name
        float derived_price
    }
    
    PRICE_HISTORY {
        int id PK
        int gas_type_id FK
        datetime date_time
        float price
    }

    %% Relationships
    BUSINESS ||--o{ BRANCH : "has"
    BRANCH ||--o{ PUMP : "has"
    PUMP ||--o{ INVOICE : "has"
    INVOICE ||--o{ ITEM : "has"
    GAS_TYPE ||--o{ ITEM : "has"
    GAS_TYPE ||--o{ PRICE_HISTORY : "has"