# Database Schema

package evm_stockist {
    entity auto_deploy_product {
        entity_id : char(36) {UUID}
        ----
        reference_id : char(36) {UUID v5}
        ----
        order_detail_id : bigint <<FK>>
        stock_activity: enum(restock,new_stock,unprocessed)
        pvs_id: char(36) <<FK>>
        ----
        qty_order : int
        pva_active_before : tinyint(1) (nullable)
        pva_active_after : tinyint(1) (nullable)
        status : enum(pending_new_stock,pending_restock,failed,unprocess,success)
        ---
        log_error : text (nullable)
        ---
        created_at: timestamp
        created_by: varchar
        updated_at: timestamp (nullable)
        updated_by: varchar (nullable)
    }    
}