---
# System prepended metadata

title: Database Schema

---

# Database Schema
```plantuml

package inv {
    entity product_variant_stock {
        id: char(36)  (not null)
        ---
        # reference_id: char(36)
        ---
        product_variant_id: char(36)   (null)
        product_variant_id_int: bigint (not null)
        stock_location_id: bigint (null)
        stock_on_hand: int(not null)
        stock_reserved: int(not null)
        stock_available:  int(not null)
        stock_location_id_int:  bigint (not null)
        ---
        created_at: timestamp (not null)
        created_by: bigint (null)
        updated_at: timestamp  (null)
        updated_by: bigint (null)
        deleted_at: timestamp  (null)
        ---
        product_id: char(36)   (null)
        product_id_int: bigint (null)
        product_variant_mapping_id: varchar(36) (null)
    }    
}


```